We got this problem each time we make a Gravity form and the costumer need the data.
Replicating the problem is easy:
1. Just make a form that has various fields including one or more text fields.
2. Make the form 'live' on a webpage.
3. Now enter some data into the form from a few 'users'.
4. In the text input fields try to enter some multi line text with line breaks -as users often do.
5. Export the form data to a .csv file.
If you then try to import the data into an Excel then the user data without linebreaks will import ok into each column and create a new line for each user.
However whenever a text field got a linebreak within the "" then excel will start a new line and the data for that user gets split over one or more lines and put into the wrong columns.
There are no simple solution to fix this in Excel so the data remains completely useless for the costumer. You can try to fix it manually but this is very hard when the form got data from thousands of users.
One of our developers has made a routine to fix the .csv files.
But Gravity Forms need a build in solution if we should continue to use it - as costumers must be able to export and import into Excel them self.
A simple solution would be an option to export form data with linebreaks within "" converted into something like "</br>" or "*LB*" or "|" (maybe user specified) when exported. Then it can be imported into Excel correctly and you can then replace the code in Excel with something else.
Posted 6 years ago on Monday May 6, 2013 | Permalink