https://legacy.forums.gravityhelp.com/topic/excel-2003-export Gravity Support Forums Topic: excel 2003 - export en-US Sun, 05 Apr 2026 16:35:40 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/excel-2003-export#post-25572 Mon, 16 May 2011 07:37:01 +0000 dennis@oatmeal.nl 25572@https://legacy.forums.gravityhelp.com/ <p>I figured out what the issue is but i don't have a solution yet.</p> <p>The trouble is caused with users putting in a return in a textarea field.<br /> Excel 2003, translates every return in a new column or row. </p> <p>is there a way to prevent users putting a return in the textarea field, or to filter the return when exporting? </p> https://legacy.forums.gravityhelp.com/topic/excel-2003-export#post-20609 Tue, 15 Mar 2011 11:46:36 +0000 Carl Hancock 20609@https://legacy.forums.gravityhelp.com/ <p>Can you send us an example of one of your csv files having this issue to <a href="mailto:carl@rocketgenius.com">carl@rocketgenius.com</a>?</p> <p>The entry export escapes the field values by wrapping them in double quotes. Excel should see these double quotes and know the values in between them are the field values, including commas. It shouldn't be treating the commas as field separators if they appear within double quotes.</p> <p>For example, our CSV generates data like this:</p> <p>"Test","Test","test@test.com","This is a test, of commas in paragraph, fields."</p> <p>Not like this:</p> <p>Test,Test,test@test.com,This is a test, of commas in paragraph, fields.</p> <p>So Excel should know anything within those double quotes (including commas) is the field value. </p> https://legacy.forums.gravityhelp.com/topic/excel-2003-export#post-20591 Tue, 15 Mar 2011 07:23:04 +0000 dennis@oatmeal.nl 20591@https://legacy.forums.gravityhelp.com/ <p>My contractor uses excel 2003 and uses closed desktop computers so we can't install a different version.</p> <p>i've created a form with a free text-field in it. Sometimes clients put a comma (or multiple) in this text field. </p> <p>When importing the entries in excel, excel thinks those comma's are for field separation and thus it messes up my data. Is there a way to export using semicolon or other format. </p>