You will create your product import file using a standard CSV Comma Seperated Value; this file format is a tabular data format that has fields separated by the comma character and quoted by the double quote character. file format with a header row. The basic rules for the file are:

1. The first row of the file will be a header line containing the field name for each column.

   1. Example ProductID, Description, URL, Thumb

2. Following the header row, each product will be on a separate line.

   1. Example 00040-kk, My description, and more, 00040-kk.html

3. Leading and trailing spaces adjacent to comma file separators are ignored

4. Each column is delimited by a comma.

5. Fields with embedded commas must be delimited with double-quote characters.

   1. In the example above, My description, and more  had to be delimited in double quotes because it had an embedded comma

6. Fields which contain double quote characters must be surrounded by double quotes, and the embedded double quotes must each be represented by a pair of consecutive double quotes.

   1. For Example: John "Da Man" Doe would convert to "John ""Da Man"" Doe"

7. Fields with leading or trailing spaces must be delimited with double quote characters.

   1. To preserve the leading and trailing spaces around the last name above: John ,"   Doe   ",...

8. Fields may always be delimited with double quotes

   1. It is always safe to delimit all non-numeric fields.

You can create the file using Excel or other spreadsheet applications and save it in a CSV format, or you can use a text editor such as Notepad to create the file manually.

A sample CSV File can be downloaded by clicking here. If Clicking does not work, please try to copy and paste the link into your browser.