CSV files have a few rules that need to be followed.


The first row is usually the labels, separated by commas, no spaces, ends with no punctuation.

There is a break return at the end of the first row. (Press Enter on your keyboard)


Each following row is the data,  separated by commas, no spaces, can end with a comma.

There is a break return after each row.


If you are having problems importing your contact list try the following solutions:


1.  Your original contact list has punctuation stored in a field where it should not be.


Solution:

Open your contact list in your email software (ex.Outlook) and search for fields with punctuation. 

If you want to keep the punctuation use quotes. "My, Data." 

Export the contact list again.


2.  Edit the exported CSV file.


To edit the CSV file you can use Notepad.


To use Notepad.

Right click on the CSV file, select Open With




Once you have your CSV file open in notepad

Select Format, turn Word Wrap OFF by removing the check mark.



Using the rules at the top of this page check for:

  • Unusual break returns.
  • Does the first row of information end with a comma?
  • Look for unusual characters or symbols


Below is a copy of a properly formatted CSV file that was exported from Gmail.


Things to notice:

Word wrap is turned off but there is still a limit in notepad and the first row is being wrapped in the middle of a word. Not a break return.

The broken word was "hobby" divided between hob - by.

This is why the second line starts with "by".

"Categories" is the last field in the first row of the Gmail export. There is a break return after Categories.


"My Contacts" is the last field in the Gmail export for each row of data. There is a break return after each row of data.


The break returns in red are shown for visual example only.



Related articles


What is a CSV