One way to create or edit a CSV database is using a text editor such as Notepad. There are a few general rules in creating a CSV file:

• Rule 1: Seperate fields with a single comma.
• Rule 2: You must put quotation marks around all fields that contain these elements: comma, quote, carriage-return.
• Rule 3: Fields with quotes in text must be changed to double-quotes.
• Rule 4: End each record with a single line break.

To create a table using Notepad:

1. Open Notepad.
2. On the first line type your fields separated by commas. View the list of supported fields. For example:
   

   path,code,name,caption,price,options

3. On the lines below, add a record for each item. Separate each record with a single line break.
4. Save the file. For example:
   

   path,code,name,options,price
   Shirts,F23,Polo Shirt,"Size S M L XL

   Color Marigold Taupe ""Sea Green""",22.95
   Pants,P12,Chinos,"Waist 32 34 36

   Inseam 30 32 34",34.95

5. Upload your CSV file in the Store Editor Database Upload area accessible by clicking the "Database Upload" button in the Store Editor Advanced mode (see instructions).

• When using a field that requires a full line break (such as multiple options), the entire field is opened and closed with quotations.
• A field that requires requires quotes (such as a multi-worded option) is double-quoted.
• Each record has the same number of commas as the first line.

Common mistakes:

• Missing fields within records. If you want to leave a field empty, remember to include the comma, or the remaining fields will be off by one.
• Extra line breaks at the end of the file. After the last field in the last record, you will want to add a single line break and save the file. Make sure there are no additional line breaks at the end of the file.

See Also

• Uploading Database Files in Store Editor
• Supported Fields for Database Uploads
• Creating a CSV file with Microsoft Excel