The Alaunus Platform and Services often use .CSV files for exported data. A .CSV "comma-separated values" file is a very common and universally used text file that uses a comma to separate values. If when you open the file all data exists in one single column it's likely an issue with your default system formatting and can be simply resolved following the steps below.

Setting Windows Default List Separator

Microsoft Excel will use your system's default values which may not be formatted properly often because of language or regional differences. To resolve this permanently please set the default list separator by following these steps:

  1. Go to Start > Settings > Control Panel > Regional and Language Options

  2. Click Related Settings
  3. Click Additional settings...

  4. Change the List separator to a comma "," (without quotes)
  5. Click Apply and OK to save


How to Format Single Column .CSV Files

Formatting in Google Sheets

  1. In Google Drive, click New > File Upload
  2. Select the .CSV file
  3. Click Open
  4. Right-click the uploaded file
  5. Select Open With Google Sheets
  6. Above Row 1, click the letter for the column to split
  7. In the menu bar, click Data > Split text to columns
  8. In the separator menu that appears, select the appropriate punctuation separator
  9. In the menu bar, click File > Download As > Comma-separated values (.csv, current sheet)

Formatting in Microsoft Excel

  1. In the top toolbar, click File > New Workbook
  2. In the Data tab, click From Text
  3. In the pop-up window that appears, select the desired .CSV file
  4. Click Get Data
  5. In the Text Import Wizard, select the radio button next to Delimited
  6. Click Next
  7. Select the appropriate Delimiters
  8. Change the Text qualifier to {none}
  9. Click Finish
  10. In the Import Data box, click Ok