The import file must be a comma delimited (.csv) file. A comma (“,”) will be used to separate each column. An excel file can easily be saved as a comma delimited (.csv) file by selecting the File >> Save As option and changing the Save As Type field to “CSV (Comma Delimited) (*.csv)”. If a carriage-return + line-feed character combination must be included as part of the data of a single column, the column’s data should be enclosed in double-quotes. The same is true if a comma must be included as part of the data of a column. If a double-quote character must be included as part of the data of a column, then it should be “escaped” by being immediately proceeded by another double-quote character. (e.g. "Hello world" would be encoded as ""Hello World"" if the double-quotes were required as part of the value for a field.)
The import file must follow the exact order as presented below; if this order is not exact the import will be unsuccessful. The import logic does not expect a header row. It will try to import the data in the first row. If an error occurs on any row, it will skip that row and process whatever rows it can. The import screen will display any errors that occur and will provide record counts.