CSV import troubleshooting

How to troubleshoot issues with your CSV spreadsheet import file

Having trouble with your CSV file not importing correctly, or downloading the template? Here are a few things you can try yourself!

Basic CSV Troubleshooting

1. Check that your spreadsheet has been saved in CSV format (How do I convert my spreadsheet to CSV?).
2. The first line of your CSV should always contain the headers for each column so that the importer can read them. If you have a table name row, you'll want to remove this and save it in CSV format once again.
3. Make sure that your file has a maximum of 10,000 rows. If you need to import more rows than this, consider splitting your file up into several CSVs and importing them separately.
4. Check that each row contains data in the correct format as per the instructions for the particular importer you are using:

• How do I add products in bulk?
• How do I add materials in bulk?
• How do I add expenses in bulk?
• How can I update my products in bulk?
• How can I update my variations in bulk?
• How can I update my materials in bulk?

For all importers, ensure that all pricing and costs are represented as numbers only (i.e., no currency symbols) and that all required fields have data (i.e., are not left blank).

Having issues downloading the importing templates?

Try right-clicking the link and selecting "Save Link As" (or your browser’s equivalent) to save the file directly to your computer. Once saved, you can open it in Excel, Google Sheets, or another spreadsheet program. 

How can I see what rows are causing errors in the import?

If some rows in your import fail to process, you can view the details directly from the import summary page:

1. Navigate to your Imports page (How do I find my imports page?)
2. This will bring up a list of all imports. If an import has completed with a minor error caused by specific rows, the Complete symbol will appear with an orange with a tooltip next to it.

3. Hover your mouse over the tooltip to view details about which rows caused the error.

   

4. Open your CSV file, fix the rows indicated in the tooltip, and re-upload the corrected file to resolve the issue.

Need more help?

If you are still having no luck finding the cause of the issue, contact Craftybase support for help.