I’m trying to export a blog post collection from WordPress to Webflow using the WP All Export plugin to generate a CSV file. However, whenever I try to upload the CSV, I find an error message, “Upload failed. Add a closing quotation mark to row 2, column 66.”
This is strange because I actually have +66 rows and only 2 columns, which suggests that the error message is referencing the columns incorrectly.
I also checked my CSV file using https://csvlint.io/validation/67aa04032e6e83391bc4e594 to scan for errors, and it reported over 4000 issues. All of these errors relate to missing quotation marks, but given the number of errors, I’m unsure how to proceed.
In order to find where the error(s) are, it might be easier to export your data as an XML file and then run it through something like Notepad ++. This can help identify errors, odd characters, etc.
The issue with the closing quotation mark probably means that Webflow does not recognise the end of your Row 2 in your CSV file.
You could also contact Webflow support for help, not sure how far they would go to help.
The error likely stems from improperly formatted CSV data, where some fields (especially those containing commas, quotation marks, or line breaks) aren’t enclosed in double quotes correctly. Since CSVLint detected thousands of issues, it’s possible that WP All Export isn’t structuring the export properly. First, open the CSV in a text editor or Google Sheets to check for inconsistencies in how text fields are wrapped in quotes. If the issue persists, try re-exporting the file from WP All Export with different delimiter settings (e.g., switching to semicolons instead of commas) or enabling the option to wrap all text fields in quotes. If Webflow still rejects the upload, use a tool like OpenRefine or a CSV repair tool to clean up the formatting before retrying.
Hi everyone! Thank you so much for your responses. Unfortunately, none of the solutions are working. Even in the “content” column, which contains rich text, I’m seeing odd characters and tags and wraps. I suspect that the plugin is not exporting the blog posts correctly, and as a result, Webflow isn’t recognizing even one column of rich text. Does anyone have an alternative plugin or export method to suggest? I also considered web scraping, but I’m unsure about the best course of action. Thank you!