Troubleshooting issues while importing a CSV file

Avatar

By Jitta Rao

updated about 2 months ago

When importing records into Gist, you may encounter errors. You can  view the error details in the confirmation email to ensure that the import file was set up correctly. 

Listed below are the most common reasons why your CSV import didn't upload all of your contacts, along with recommended actions you can take to avoid these situations in the future.

Too Many Columns

Details: Your file is too large or has too many custom columns. Especially large files or having several fields can cause the importer to fail.

Resolution: break the file down into smaller, multiple files and removing any fields that you don't need.

Failed Validation (Invalid Email)

Details: the import file contained an email address that did not conform to the format of a typical email address (e.g., name@domain.com). The import will not create a record or update an existing record. 

Resolution: update your import file with the correct email value and re-import the file.

Could Not Parse Number

Details: the import file contained a value for a number property with non-numeric characters. The import can still create or update a record, but the number property will not contain a value.

Resolution: update your import file with the correct value and re-import, or update the property value in the affected record directly.

Could Not Parse Date

Details: the import file contained date values that did not match the format you selected during the import process. The import can still create or update a record, but the date property will not contain a value.

Resolution: update your import file with the correct value and reimport, or update the property value in the affected record directly.

Duplicate Row content

Details: the import file contained duplicate objects. The import will not create a new object.

Resolution: remove the duplicate in the import file and re-import.

Header and row sizes don’t match

Details: the import file contained data appears in a column without a header. The data under columns without headers will not be imported.

Resolution: ensure that the data in the column should be imported. If so, add an appropriate header to the import file and re-import.

Did this answer your question?