To successfully import CSV files, make sure that they adhere to these rules. Any errors will be automatically listed when you import or export a file:
Numerical data values with a leading zero (such as zip codes) must be formatted correctly for the spreadsheet application's requirements (most often, they require text).
Multi-line values are allowed.
The first row is the header row. It contains the names of the Content Type properties corresponding to the data in each column. The header may be any base property or any custom property defined for the Content Type. The headings must be the property field name, not the field label:
Title
Description
Path (if you are performing an update)
File name
First Publication Date
Expiration Date
Wrapper
Template
For all content types, the combination of the path and file name act as the unique identifier for each piece of content. Multiple records in an upload file that have the same path/ file name combination will be treated as duplicates.
The minimum required fields for every row for a Content Type based on Image or File are:
Title
Path (if you are performing an update)
File name
The minimum required fields for every row for a Content Type based on Web Page are:
Title
Path (if you are performing an update)
File name (if you are performing an update)
If your upload file does not contain a file name field, a file name will be auto-generated for all new items. If your file does contain a file name field, there must be a value for all items.
Columns that correspond to category-backed properties may contain multiple values separated by commas. For example, if the Content Type had a "state" property backed by a category of states, then the following would all be valid data entries:
New Jersey
New York
Connecticut
new-jersey
new-york
Connecticut
The cell may contain either the category label ("New Jersey") or the name ("new-jersey").
Ensure that the data is not corrupted.
Exported files with any errors should not be edited and then imported again.
You cannot upload more than 1000 items at one time.
If a field is not required, and the column for it is present but a field value is blank, the existing value will be overwritten with an empty string.
If a column is missing for a field, the existing values will be used for that field.
If there is no path column (required for updates), the importer will import the items into the Content Type's default folder (if one has been set).
Date fields should be in the format MM/DD/YYYY. Days and months can be single digits, but years must be in four digits.
If using Microsoft Excel to create your CSV files:
Do not use commas at the end of a row of data
To avoid this problem, make sure the last column in your spreadsheet has a value in every row.