A. Names must be separated into their own columns

If names are combined into a single column, the Text to Columns feature in Excel can easily help split the names into separate columns.

1. Highlight the Name Column > Click Data

2. Select Text to Columns 

3. Select Delimited > Comma  > Finish

Note** if the First Name is listed first, with no comma, select Space as the delimiter. 

B. Line Breaks (i.e. Carriage Returns) in a Cell

When importing, line breaks can literally break a CSV file. 

To rid a cell of line breaks, the formula =CLEAN(   can be used. In the example above, type =CLEAN(C4) and click Enter. 

This formula will need to be used throughout the entire column. So it'd be best to start this formula in Row 1 and drag the formula to the bottom of the column.

**Important - Once Column D is fully populated with the formula, Column C cannot yet be deleted. 

  1. Click File > Save As... to resave the file

  2. Close the file.

  3. Reopen the new file. Column C can now be deleted. 

C. Missing Column Headers & Blank Columns

  1. Your CSV file must use Row 1 for column headers. Missing column headers (highlighted in red) can result in columns being omitted from the import. 

  2. Blank columns (highlighted in green) will also result in columns being left out of the import. 

A column with no data, but with a header included, is A-OK!

Did this answer your question?