Quoted Field is Malformed

I am trying to do the CSV Block import and I keep getting this error: “Trailing quote on quoted field is malformed.” I don’t have any " " in the data set. Any suggestions for what I might be missing?

1 Like

Just checking in to see if you ever found a solution to this issue, or if it’s still giving you problems. I don’t see any replies, and want to make sure your issue doesn’t go un-resolved.

I’ve run into occasional weird issues like this when trying to import a data set that contained non-alpha characters. In my case, the data — furnished by a client — imported correctly, but any attempts to search the resulting base or perform comparisons failed miserably. Even worse, when opened in any of the suite of word processors, text editors, and spreadsheets I typically keep on hand, the offending values were stripped out or rendered invisible. It wasn’t until I opened the file using a hexeditor — and at this point I don’t recall which one; irritatingly, the software download folder from that particular machine didn’t make the cross-country trip — that I could determine which lines from the CSV were corrupted.

If you haven’t been able to find a solution, I’d suggest finding a freeware hex editor and examining the source file. Look especially for embedded ASCII 0x0a, 0x0b, 0x0c, or 0x0d values, which might be signalling end-of-line to Airtable’s parser.

Edit: In looking back through old posts, I see from this the hex editor I used must have been Frhed.

Thank you for this info. I was having the same issue and was able to use the web based hex editor to find the issue with my file. https://hexed.it

1 Like

Thanks for the info and link – looks like a great site to have on-hand — especially when called upon to troubleshoot from someone else’s PC!