Common CSV File Requirements

The best way to create the CSV file is to export a file from CC-SG, and then use the exported CSV file as an example for creating your own. The export file contains comments at the top that describe each item in the file. The comments can be used as instructions for creating a file for importing.

It is recommended to create the import file in a spreadsheet program like Microsoft Excel. Enter each item in its own cell. When you save the file, choose CSV as the file type. This adds comma separators automatically at the end of each cell, organizing the data into columns separated by commas. You can create the CSV file in a text editor, but then you have to add commas manually after each item.

The first time you save the file in Excel, you must choose Save As and MAKE SURE to select CSV as the file type. After that, Excel will continue to save the file as CSV.

If you don't set the file type correctly, the file will corrupt and cannot be used to import.

• All import files must be in ASCII text only.
• The first column of each row must include the command ADD. The basic structure is Command, Tag, Attribute where ADD is the command.
• Column names are not supported. You can add comment lines above the rows of data as long as each line begins with the # symbol.
• To use the default value for a field, type in the value or leave the field blank.
• See Naming Conventions for details on CC-SG's rules for name lengths.
• If you create the CSV file in a text editor, rather than a spreadsheet program, you must use commas and double quotes differently. A value that contains a comma or double quote must be completely wrapped with double quotes. Each double quote character within the value must also be preceded by another double quote character.

  For example: