Spreadsheet Import Troubleshooting
Ian Remington avatar
Written by Ian Remington
Updated over a week ago

1. Ensure that there are no empty rows - To get a successful import, you should make the spreadsheet look as clean as possible, with a single header row on row 1, and the contact data starting on row 2. Any full blank row in your spreadsheet will be perceived as the end of the spreadsheet and any remaining information will not be imported.

2. Make sure that the document is saved as a .xls, .xlsx, or .csv file. This is a requirement in order to upload.

3. Ensure you do not have coloring or bordering on the spreadsheet itself. We typically recommend clearing all formats in Excel if you have previously used coloring or bordering.

4. Check your spreadsheet for errors. It's possible there are unverifiable fields within the spreadsheet you've created. To do so, navigate to Formulas | Error Checking (see below) to correct any cells that may contain an error. When complete, you'll want to run that check 1 last time to ensure there are no remaining errors prior to re-saving the document.

5. Make sure that your Spreadsheet does not begin with empty columns. This will throw off the field mapping process.

What's Next?

Did this answer your question?