A lot of companies have customer data they'd like to import into mHelpDesk. CSV (Comma Separated Value) is a common file format for importing this type of data, and is available from applications like Microsoft Excel, Google Sheets and QuickBooks. If you have a CSV file, you can import it into your mHelpDesk account with the steps below.

Before you import:
Your file should be in a "tab delimited" format (this is a type of CSV) with your customers' name in the left column. Also, the file should have the column headers provided below in the top row of the file. You should include all columns, even if they are blank.

  1. Customer Name
  2. Address1
  3. Address2
  4. City
  5. State
  6. Zip
  7. CountryCode
  8. PrimaryPhone
  9. SecondaryPhone
  10. Fax
  11. Email
  12. ContactFirstName
  13. ContactLastName
  14. Note
  15. CustomerType
  16. Source

Now that the CSV file is formatted for import, here's how you will add it to your mHelpDesk account.

  1. Login to the mHelpDesk web application > Settings > Customer Import (under "Other")   Note: you must be an admin to access this part of the application.

2. Click in the empty field, which will pull up your computer's files. Find the file you would like to import and click Select. After you have confirmed this is the right file, click Next.


3. On the Mapping Fields screen, check that the boxes have the correct information and click Save. This confirmation screen will appear when the import begins.(Screenshot C)


4. At this point the import will run in the background, and you can continue to use your account. A confirmation email will be sent to notify you when the import is complete.
5. Once you receive the confirmation email, refresh your mHelpDesk account and all of your customers from the import will now be in your account!

*Please note that there is an import limit of 3,000 customers per CSV file.*

Did this answer your question?