Troubleshooting CSV Import Issues with Delimiters in Excel

·

I'm trying to do a simple import CSV to a new workbook/table. Maybe i never noticed before, btu no matter whether i do delimiter chose of comma, colon, pipe or tab its not working right. my headers are off and the info is merging into columns together. its a normal csv file that i exported from google sheet.

3 comments

Clay
APP
·
·
For CSV import issues with mixed-up fields and headers, try these solutions: File Format Issues: ** Use UTF-8 encoded CSV files with comma-separated values for best results ** Remove commas, colons, and semicolons from your CSV data, as mixing separators can cause interpretation issues Quick Fix: Upload your data to a public Google Sheet, then download it again as a CSV and try importing once more File Requirements: ** Keep the CSV filename short ** Remove any "created at" or "updated at" columns * Ensure file is under 72 columns and 50,000 rows Clay supports CSVs with either commas or semicolons as separators, but mixing both in the same file creates parsing problems
Josh M.
·
·
it is from a google sheet export
Clay
APP
·
·
Since your CSV is from a Google Sheets export, the issue likely stems from mixed separators or formatting problems in the original data. Quick fixes: ** Remove commas, colons, and semicolons from your CSV data before importing ** Ensure your CSV uses UTF-8 encoding with comma-separated values ** Keep the filename short and remove any "created at" or "updated at" columns *Try this workaround: Upload your data to a public Google Sheet, download it again as a fresh CSV, then import that new file. Clay supports CSVs with either commas or semicolons as separators, but mixing both creates parsing problems.