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?
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
0x0d values, which might be signalling end-of-line to Airtable’s parser.
I have just encountered this issue. Tried 3 times to upload but same error. I tried this though and it worked!
Go into the .csv file and sort it by another field column (so for instance, my data was in Post Code order but I re-sorted it by Organisation Name order, you could just sort it by any alternative column).
It loaded without issue once I did this.