Help

Issue with CSV Export

Topic Labels: Data Importing & Exporting
1217 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Linna_Sim
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.

Jon_Stephenson
7 - App Architect
7 - App Architect

Invaluable tool for checking (and repairing) CSV files. https://csveasy.com/

Lulenka
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!

bibiczh
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: https://excel-exporter.com/dashboard/app

 

GavinA
8 - Airtable Astronomer
8 - Airtable Astronomer

csvgetter.com 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