Comma separated file formats

Note: You must have Microsoft Excel installed on your computer to use this format.

Comma separated value (CSV) import files must use:

• One line per record.

• Unformatted numbers (for example, 10000).

  If you assign the number format to a cell or column, Excel strips numeric values of trailing zeros after the decimal, altering phase codes in your Excel update file. For example, a phase code 1100.100 will be stripped of its trailing zeros and appear as 1100.1 when Data Importer reads your update file. Data Importer treats this an invalid phase and rejects the record. To correct this problem in an existing price update file, reformat the existing file as text.

• A comma between values.