Issue with CSV Export

Topic Labels: Data Importing & Exporting
1599 5
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi there. Does any know how to prevent my csv data from breaking when I transfer it from a csv export to my spreadsheet?

Problem (CSV Export Bug): When I export the data, a piece of the notes column rolls over into a new row, resulting in additional rows that are unrelated to any record.

Thank you in advance! 

5 Replies 5

How are you opening/transferring it? Does your notes field have rich-text formatting enabled? If so, you might try disabling it or wrapping everything in quotes.

7 - App Architect
7 - App Architect

Invaluable tool for checking (and repairing) CSV files.

5 - Automation Enthusiast
5 - Automation Enthusiast

You can try running REGEX_REPLACE({field},"\n"," ") or if its stubborn like in my case REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE({Field},"\r"," "),"\n"," "),"\r\n"," "),"u2028"," "),"u2029"," "),"u0085"," "),"u00B6"," ")

This took care of most of the line breaks but there are still 2 stubborn line breaks I cannot beat HELP!

6 - Interface Innovator
6 - Interface Innovator

You can basically use the app "Excel-Exporter" to avoid troubles and to save time. They have a freemium version and a premium version with a 7 days free trial. 

Just in case:


8 - Airtable Astronomer
8 - Airtable Astronomer is a tool specifically designed for airtable export and automation. Its very easy to use, powerful and secure - and there are loads of help + advice docs. Let me know what you think