I am trying to upload a CSV into Clay that only has 45 rows of data. I have removed all other rows. I keep getting this error saying there’s an issue on line 1804. How do I fix this?
The error referencing line 1804 in a 45-row CSV suggests hidden formatting issues or invisible characters in your file. Try these solutions: • Upload your CSV to a public Google Sheet, then download it again as a CSV and retry the upload • Remove any commas, colons, and semicolons from your CSV data • Ensure your file uses UTF-8 encoding with comma-separated values • Make sure your CSV filename is short These steps resolve common formatting problems that prevent successful uploads.
You're right! An unclosed quotation mark is a common cause of CSV parsing errors that can reference incorrect line numbers. Search your CSV file for any unmatched quotation marks (") and either: • Remove the quotation mark entirely if it's not needed • Add the closing quotation mark to properly close the field This formatting issue can cause the parser to misread your file structure, leading to the line 1804 error even in a 45-row file.
Thank you
Hey Muhammad S. I deleted all the ” marks n my entire sheet but still getting the issue. Any chance you’d be able to support as a freelance gig?
yes
i am free rn, so would just give you a favour
can you send me the sheet?
Since removing quotation marks didn't resolve the issue, try these additional solutions: • Upload your CSV to a public Google Sheet, then download it again as a CSV and retry the upload • Remove any commas, colons, and semicolons from your CSV data • Ensure your file uses UTF-8 encoding with comma-separated values • Make sure your CSV filename is short • Verify your file is within 72 columns and 50,000 rows These steps address hidden formatting problems and incorrect column separators that can cause parsing errors.
Hey there Reese thanks for reaching out, sorry for the delay here. How did things go? Let me know if theres anything else I can do here to assist.
There’s likely hidden data past row 45. Delete all extra rows in Sheets/Excel, re-save, and re-upload.