QPRO TRAINING VIDEOS

Download an example of a Contact Import CSV file

Use these instructions to import a customer list provided in a “CSV” format. 

  1. The CSV file must be in the format found below in the Rules for CSV File section below. 
  2. Click File on the Menu bar, then select Import, then Contact (CSV)
  3. Browse to and select the CSV file that you need to import.

Rules for CSV File 

    1. Cell A1 must contain only the following text:  ~~Contact 
      That is two tilde characters, followed by the word Contact, with an uppercase letter C
    2. The first row is column headers. All columns must exist, only those marked with a ** are REQUIRED to have data.  Columns marked with * are HIGHLY RECOMMENDED to have data.
Column Column Headers Values
A** ~~Contact (This column will be for Last Name data) 50 characters
B* First Name 50 characters
C Street 1 50 characters
D Street 2 50 characters
E City 50 characters
F State 50 characters
G Zip 50 characters
H* Phone 50 characters
I Cell 50 characters
J Email 50 characters
K Notes 255 characters
  1. Required fields 

    Column A, Row 2 and beyond must contain data. i.e Last Name or Business Name 

  2. Invalid Characters
    Do not use the following characters in the CSV file ( ) ' * , " [ ]
    Parentheses, single-quote, asterisk, comma, double-quote, square brackets