CSV Import

  1. Open the CSV file in Excel
  2. The data will appear in the respective number of rows but all in one column
  3. Select the column in which the data appear (it will most likely be Column A)
  4. Open the data tab and select “Text To Columns”
  5. In the options Dialogue that opens up select the following:
    1. Under “Original Data Type” select “Delimited”
    2. Click Next
    3. Under delimiters, select “Comma”
    4. In the “Text Qualifier” dropdown select “{None}”
    5. Click Next
    6. Make sure “Column Data Format” is set to “General”
    7. Click Finish