PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Problem with CSV export and comma

  1. Hi,

    we're using Gravity Forms for a contest: users are asked to send a short text. Since in the short text that we receive there are many commas, when we export the CSV file, the commas in the short text are seen by XL as columns separators, so we get a very messy XL file. Is there any solution for this: as an example, is it possible to ask Gravity Forms to use a field separation different from the comma?

    Thanks for help


    Posted 4 years ago on Thursday January 12, 2012 | Permalink
  2. steph219

    Hi Paolo

    could you solve the issue with fields containing commas?

    I have the same problem when exporting a CSV file with entries.

    thanks for any hints

    Posted 4 years ago on Thursday January 26, 2012 | Permalink
  3. Hi Steph, No I have not. I'm still looking for a solution.
    Very strange that nobody has given support on this issue.
    I'm still in need of help on this.


    Posted 4 years ago on Friday January 27, 2012 | Permalink
  4. frc2

    There is a filter to change the field separator. Here is the code to replace the comma by a semicolon:

    add_filter( 'gform_export_separator', 'my_gform_export_separator', 10, 2);
    function my_gform_export_separator($separator, $formId) {
    return ";";

    Posted 4 years ago on Wednesday April 18, 2012 | Permalink


Support Tickets

Open A New Support Ticket
 Open A New Priority Support Ticket *

* Developer license holders only