https://legacy.forums.gravityhelp.com/topic/changing-csv-delimiter Gravity Support Forums Topic: Changing CSV delimiter en-US Sun, 05 Apr 2026 05:56:44 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/changing-csv-delimiter#post-28598 Mon, 27 Jun 2011 15:35:58 +0000 Carl Hancock 28598@https://legacy.forums.gravityhelp.com/ <p>Currently there is no hook for this, but I have added it to our to do list for the next major feature release. </p> https://legacy.forums.gravityhelp.com/topic/changing-csv-delimiter#post-28562 Sun, 26 Jun 2011 13:35:50 +0000 Taeke 28562@https://legacy.forums.gravityhelp.com/ <p>Thanks Dennis! Would love to see a solution that's more solid with upgrades and all.. </p> https://legacy.forums.gravityhelp.com/topic/changing-csv-delimiter#post-27174 Tue, 07 Jun 2011 09:44:45 +0000 dennis@oatmeal.nl 27174@https://legacy.forums.gravityhelp.com/ <p>I just figured out a hack because I had the same problem.<br /> What I did is strip the newline out of the values and replace them with some spaces. It works for me with excel 2003.</p> <p>look for the file export.php in the folder gravityforms.</p> <p>arround line 492<br /> change:<br /> <pre><code>$lines .= &#39;&quot;&#39; . str_replace(&#39;&quot;&#39;, &#39;&quot;&quot;&#39;, $value) . &#39;&quot;,&#39;;</code></pre> <p>into:<br /> <pre><code>$strippedValue = preg_replace(&#39;/\r\n/&#39;, &#39; &#39;, $value) ; $lines .= &#39;&quot;&#39; . str_replace(&#39;&quot;&#39;, &#39;&quot;&quot;&#39;, $strippedValue) . &#39;&quot;,&#39;;</code></pre> <p>good luck </p> https://legacy.forums.gravityhelp.com/topic/changing-csv-delimiter#post-27169 Tue, 07 Jun 2011 05:55:22 +0000 Jukka Karvonen 27169@https://legacy.forums.gravityhelp.com/ <p>Is there any easy way to change CSV delimiter to semicolon instead of comma?</p> <p>When using locales where comma is used as a decimal separator, Excel does not import CSVs with multline text fields correctly. Instead of writing every line inside a single cell, Excel separates them to multiple cells and messes whole table structure. When using semicolon as a CSV delimiter, it works fine. </p>