https://legacy.forums.gravityhelp.com/topic/problem-with-the-export-messages-in-cvs-format-french-languages-messages Gravity Support Forums Topic: Problem with the export messages in CSV format (french languages messages) en-US Sun, 19 Apr 2026 18:40:18 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/problem-with-the-export-messages-in-cvs-format-french-languages-messages#post-257719 Fri, 17 May 2013 10:11:23 +0000 ScottSendraDesign 257719@https://legacy.forums.gravityhelp.com/ <p>I am experiencing the same problem. When I export a .csv file that includes a "return" in a text field, Excel reads that as a new line. Is the official solution to this to not use the textarea field for user entry of paragraphs? </p> <p>My research into this problem suggests that the csv file should have "/n" for the returns. Is this not happening? Is there a way to filter out returns in the textarea fields beforre their are exported and replace them with another character?</p> <p>The form is located here:<br /> <a href="https://achievefoundation.org/support-us-category/fundraising/honor-your-teacher-3/" rel="nofollow">https://achievefoundation.org/support-us-category/fundraising/honor-your-teacher-3/</a> </p> https://legacy.forums.gravityhelp.com/topic/problem-with-the-export-messages-in-cvs-format-french-languages-messages#post-239714 Mon, 06 May 2013 08:07:27 +0000 Juhlsen 239714@https://legacy.forums.gravityhelp.com/ <p>We got this problem each time we make a Gravity form and the costumer need the data.<br /> Replicating the problem is easy:</p> <p>1. Just make a form that has various fields including one or more text fields.<br /> 2. Make the form 'live' on a webpage.<br /> 3. Now enter some data into the form from a few 'users'.<br /> 4. In the text input fields try to enter some multi line text with line breaks -as users often do.<br /> 5. Export the form data to a .csv file.</p> <p>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.</p> <p>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.</p> <p>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.</p> <p>One of our developers has made a routine to fix the .csv files.<br /> 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.</p> <p>A simple solution would be an option to export form data with linebreaks within "" converted into something like "&lt;/br&gt;" 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. </p> https://legacy.forums.gravityhelp.com/topic/problem-with-the-export-messages-in-cvs-format-french-languages-messages#post-201358 Mon, 08 Apr 2013 14:06:50 +0000 Chris Hajer 201358@https://legacy.forums.gravityhelp.com/ <p>@damdo74, can you explain what is happening to you exactly? Also, if you can post a sample of your exported CSV to pastebin.com or pastie.org, we will be happy to take a look. </p> https://legacy.forums.gravityhelp.com/topic/problem-with-the-export-messages-in-cvs-format-french-languages-messages#post-196268 Thu, 04 Apr 2013 04:19:52 +0000 damdo74 196268@https://legacy.forums.gravityhelp.com/ <p>Hello,<br /> still no solution regarding this .csv import issue ?<br /> Please help </p> https://legacy.forums.gravityhelp.com/topic/problem-with-the-export-messages-in-cvs-format-french-languages-messages#post-103600 Mon, 17 Dec 2012 16:00:37 +0000 Chris Hajer 103600@https://legacy.forums.gravityhelp.com/ <p>Do you have a suggestion for how Gravity Forms can better handle multiple lines of text input when exported in a CSV file? Maybe there is some way we can export the data differently. We're always open to suggestions for improvement. </p> https://legacy.forums.gravityhelp.com/topic/problem-with-the-export-messages-in-cvs-format-french-languages-messages#post-103541 Mon, 17 Dec 2012 13:09:47 +0000 nicomollet 103541@https://legacy.forums.gravityhelp.com/ <p>Well, I am disappointed.<br /> GravityForms should handle compatibilty itself.<br /> Microsoft Office is the leader, and I don't think my client will be pleased when I will tell him to install another program. They have their own macros/ apps running with Office. Using another program is a big let down.<br /> I will see if I can make it work, since I can't let my client with the broken exports. </p> https://legacy.forums.gravityhelp.com/topic/problem-with-the-export-messages-in-cvs-format-french-languages-messages#post-103540 Mon, 17 Dec 2012 13:04:32 +0000 Chris Hajer 103540@https://legacy.forums.gravityhelp.com/ <p>The textarea column text will be double quoted, but it appear that Excel treats new lines within a quoted field as new lines. This is on the part of Excel and how it interprets the field. As you saw, LibreOffice handles it fine.</p> <p>You may be able to perform some processing on the CSV before you try to open it in Excel, to convert the new lines to something that Excel can handle more easily. </p> https://legacy.forums.gravityhelp.com/topic/problem-with-the-export-messages-in-cvs-format-french-languages-messages#post-103413 Mon, 17 Dec 2012 07:47:26 +0000 nicomollet 103413@https://legacy.forums.gravityhelp.com/ <p>Hello<br /> Same problem here.</p> <p>My form has a textarea field.<br /> Each line break in this textarea makes a new row when I import the CSV in Microsoft Office 2007.</p> <p>I double click on the CSV file, select the first column (A). Then choose Data &gt; Text to Columns &gt; Delimited &gt; Delimiter : Comma &gt; Text delimiter : Double-quote.</p> <p>This same file opens in LibreOffice without any column problem. But since Microsoft Office is the most common software, I would expect exports to work well with it.</p> <p>I can send you the CSV file, so you can test it and find a solution please. The data is private, how can I do that? </p> https://legacy.forums.gravityhelp.com/topic/problem-with-the-export-messages-in-cvs-format-french-languages-messages#post-83185 Wed, 24 Oct 2012 07:05:10 +0000 Studio Deefuse 83185@https://legacy.forums.gravityhelp.com/ <p>:( </p> https://legacy.forums.gravityhelp.com/topic/problem-with-the-export-messages-in-cvs-format-french-languages-messages#post-83184 Wed, 24 Oct 2012 06:57:30 +0000 roopys 83184@https://legacy.forums.gravityhelp.com/ <p>For the moment, i still couldn't find a good way to solve this... </p>