How to Import and Export Customer Data

Importing customer data can save you time on manual data entry, and help you avoid data errors.

NOTE:
If you are looking to import or export customer credit card information to process, as in with the full card information, please reach out to us at help@helcim.com



To get started, first select Import / Export from the customer menu on the top right hand side of the screen.

Start importing and exporting customer data in Helcim

Now, select the menu item that matches the action you want to take and follow the steps.

Importing Customer Data

To import customer data into your Helcim Account click on Import / Export under Customers.

Next, select either Customers to import customer profiles or Credit Cards to import payment information.

Select the file type that you will be importing and click Next Select the file you want to import by clicking Browse.

Choosing import customer data type in Helcim

Sample File

If this is your first-time importing customer data into your Helcim Account, download the Sample File to see how the data needs to be formatted.upload file to import


Review the data that is going to be imported, and if everything is correct click Confirm, if you need to make any changes you can click BackReview customer data before importing to HelcimA confirmation message will confirm the data has been imported.success message

Exporting Customer Data

To export customer data from your Helcim Account click on Import / Export under Customers.

You can export your Customers to export the following details:

  • The Customer Code
  • Business Name
  • Contact Name
  • Billing Information
  • Shipping Information

Or Credit Cards to export:

  • The Customer Code
  • Customer Names
  • Date Created
  • Date Updated
  • Date Last Used
  • Expired - Yes or No
  • Last Four Digits of the Card Number
  • Card Token

Or Customer Card Count to export:

  • The Customer Code
  • Number of Cards on File

Click on the option you would like.

Exporting customer data from Helcim

Next, click on the export file type you want.

Select export customer data from Helcim


Confirm the email address is correct. This field is pre-filled with the email address for your account, you can edit it if needed. This is the address the report will be sent to.

Confirm email to export the customer data to from Helcim

Click on Export.

Click export to export customer data from Helcim


A CSV file will be emailed to the address you entered once the report is ready.

QuickBooks
If you are importing and exporting customer data to QuickBooks, please note that for the data to be properly read and understood by QuickBooks, you need to ensure that you import your data from QuickBooks to Helcim, then export your changes from Helcim to QuickBooks or QuickBooks will be unable to recognize the changes and additions to data. For example: A customer created in Helcim's Customer Manager cannot be exported into QuickBooks, but a customer created in QuickBooks can be exported into Helcim where you can then edit and update the customer information before exporting the customer profile back into QuickBooks.