I am experiencing an issue when dowloading the CSV file containing submitted forms in ODK.
When users enter line breaks (new lines) in free text fields, these line breaks are exported as actual new lines in the CSV file. As a result, a single submission can be split across multiple rows in the CSV, which breaks the structure of the data and requires manual corrections afterward.
Using line breaks in free text fields is quite common among users (for readability, lists, paragraphs, etc.), so this behavior causes recurring data cleaning issues.
Is there a way to prevent line breaks entered in free text fields from being converted into new rows in the CSV export?
For example, could line breaks be escaped, replaced by a space, or otherwise handled so that each submission always remains on a single row in the main CSV?
Thank you in advance for your help, and please let me know if more details or examples would be useful.
Example in the screenshot. The person uses multiple line breaks and this create new lines.
