Guides

Fix the error you're stuck on

Short, practical answers to the import and file errors people run into most.

HubSpot import error: “Make sure each column with data has a header”
Why HubSpot rejects your contacts file with this message, and how to fix it in a few minutes.
Shopify CSV import: “Illegal quoting on line …”
What the Shopify “Illegal quoting” error means and how to repair the product CSV so it imports.
Phone numbers turn into dates or lose their leading zero in Sheets/Excel
Why spreadsheets change phone numbers on import or export, and how to keep them intact for your CRM.
Google Ads Customer Match: why most of your records don't match
Formatting problems that make Customer Match ignore rows, and how to prepare a cleaner upload.
“Excel cannot open the file because the file format or file extension is not valid”
What causes this Excel error, what you can try first, and how to recover the data if the file is damaged.