This article contains troubleshooting information to help solve the most common problems with import files. Use the links below to jump to a specific problem:
Failed imports are often caused by field values in your CSV that contain special characters, such as commas or apostrophes. If your import fails, open the CSV file in Excel, search for the characters listed below, and implement the suggested change. Then, before trying to import the entire file again, do a test with only 2 or 3 records to make sure the formatting is correct.
In a CSV file, a comma represents the start of the next record. This means that if you have a comma within a field value, such as an asset name, the import thinks that the record ends at the comma.To fix this issue, remove the comma from the from the field value and then try re-importing 2 or 3 records to make sure the formatting is correct. Once you've imported those test records successfully, you can try again with the full file.