https://legacy.forums.gravityhelp.com/tags/excel Gravity Support Forums Tag: Excel - Recent Posts en-US Sun, 19 Apr 2026 16:33:08 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/excel-each-value-by-column#post-344725 Tue, 25 Jun 2013 21:10:06 +0000 emergems 344725@https://legacy.forums.gravityhelp.com/ <p>Hi, actually when we export to csv we can see in Excel that :<br /> column A1 = all the fields name separate by delimiter<br /> AND<br /> all message form for each line<br /> BUT<br /> it is possible to see it like thta :<br /> in the cell A1 we can read the field name 1 and in the cell A2 we can read the value for the cell A1. Ex: A1= what is your name? and cell A2 = David<br /> thank you to help me </p> https://legacy.forums.gravityhelp.com/topic/autoexport-to-email#post-302628 Wed, 05 Jun 2013 00:01:07 +0000 David Peralty 302628@https://legacy.forums.gravityhelp.com/ <p>It is not a built-in feature. It would require a developer to create this custom for you. </p> https://legacy.forums.gravityhelp.com/topic/autoexport-to-email#post-302124 Tue, 04 Jun 2013 20:34:13 +0000 alfit 302124@https://legacy.forums.gravityhelp.com/ <p>Is it possible to automate export to excel forms to be sent to a designated email address every time a form is submitted instead of having to export from WordPress? </p> https://legacy.forums.gravityhelp.com/topic/export-csv-or-excel#post-301676 Tue, 04 Jun 2013 14:20:24 +0000 David Peralty 301676@https://legacy.forums.gravityhelp.com/ <p>Forms -&gt; Import/Export -&gt; Export Entries </p> https://legacy.forums.gravityhelp.com/topic/export-csv-or-excel#post-301663 Tue, 04 Jun 2013 14:04:33 +0000 Andrew 301663@https://legacy.forums.gravityhelp.com/ <p>And where can i find this feature to export the entries of a form? Haven't found that yet. </p> https://legacy.forums.gravityhelp.com/topic/export-and-language#post-301203 Tue, 04 Jun 2013 09:55:22 +0000 David Peralty 301203@https://legacy.forums.gravityhelp.com/ <p>Hi there, we do support RTL languages and you can export form entries to CSV. All my best! </p> https://legacy.forums.gravityhelp.com/topic/export-and-language#post-300221 Tue, 04 Jun 2013 01:43:14 +0000 D_L_I 300221@https://legacy.forums.gravityhelp.com/ <p>I before I purchase the plugin I would like to check if it comes with RTL support and if it allows exporting the forms that were sent to Excel/CSV </p> https://legacy.forums.gravityhelp.com/topic/returns-in-textarea-causing-problems-in-csv-export#post-272918 Fri, 24 May 2013 07:12:36 +0000 post@smart-media.no 272918@https://legacy.forums.gravityhelp.com/ <p>Hi,<br /> You can remove the returns before the data is saved to the database with the following script:</p> <pre><code>add_filter(&quot;gform_save_field_value&quot;, &quot;save_field_value&quot;, 10, 4); function save_field_value($value, $lead, $field, $form){ $new_value = str_replace(array(&quot;\n&quot;, &quot;\t&quot;, &quot;\r&quot;), &#39;&#39;, $value); return $new_value; }</code></pre> <p>\n removes new lines<br /> \t removes tabs<br /> \r remove carriage returns </p> 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/returns-in-textarea-causing-problems-in-csv-export#post-254514 Wed, 15 May 2013 20:16:00 +0000 ScottSendraDesign 254514@https://legacy.forums.gravityhelp.com/ <p>I am having an issue when I import Gravity Forms csv forms into Excel. The form I created uses multiple textarea fields. If a return is entered into a textarea, i.e more than one paragraph is added, when I import the csv data into Excel, the return is interpreted as a line break. This messes up my columns quite a bit!</p> <p>Is there a way of filtering for returns and replacing or deleting them? Or a way of preventing certain characters from being allowed in a textarea field?</p> <p>Thank you! </p>