Ninja Forms Submissions Export to Excel

Ninja Forms already has a built in CSV export. But in some cases CSV is a little bit tricky:

  • Non-latin characters are displayd wrong by Excel
  • Multi-line entries expand to two lines in Excel
  • Kommas in the input values split text to multiple columns

 

Export example

I created a few entries in the default contact form. PastedGraphic-1 When I export the values Excel pops up and wants to open the file. The result looks like this: PastedGraphic-2 After I use the “Text-to-Column” button it looks like this PastedGraphic-3 non-latin characters as well as multiline textareas make the result unreadable. Although it’s an Excel problem and not a CSV problem it is not user friendly and I can’t hand it out to my clients so I created a Ninja Forms extension to directly export data to Excel format.

view plugin…

5 thoughts on “Ninja Forms Submissions Export to Excel”

  1. Hi thanks.

    I have fic orginal plugin v2.9.28.

    Open classes/subs.php
    Line 202

    Replace
    $label_array[0][ $field_id ] = apply_filters( ‘nf_subs_csv_field_label’, $label, $field_id );

    By
    $label_array[0][ $field_id ] = mb_convert_encoding(apply_filters( ‘nf_subs_csv_field_label’, $label, $field_id ), “windows-1252”);

    Line 247

    Replace
    $value_array[ $x ][ $field_id ] = apply_filters( ‘nf_subs_csv_field_value’, $user_value, $field_id );

    By
    $value = apply_filters( ‘nf_subs_csv_field_value’, $user_value, $field_id );
    $value = mb_convert_encoding($value, “windows-1252”);

    $value_array[ $x ][ $field_id ] = $value;

    ++

  2. Hello,
    we have bought your plugin yesterday, but after installing it into our websites it is not working properly. After downloading the file from the submission xlsx the file cannot be be opened,excel writes there is problem with suffex and that is why the file cannot be opened.Please let us know what to do, we have allready tried it in different computers but it is still not working.Thank you very much in advance.Veronika Polehlová

    1. Hello, please try to open the Excel file in a text editor. Maybe there’s your PHP memory limit is to low and the file contains an error message.

  3. Hi, new version Fix – 2.9.30

    Open classes/subs.php
    Line 202

    Replace
    $label_array[0][ $field_id ] = apply_filters( ‘nf_subs_csv_field_label’, $label, $field_id );

    By
    $label_array[0][ $field_id ] = mb_convert_encoding(apply_filters( ‘nf_subs_csv_field_label’, $label, $field_id ), “windows-1252”);

    Line 247

    Replace
    $value_array[ $x ][ $field_id ] = apply_filters( ‘nf_subs_csv_field_value’, $user_value, $field_id );

    By
    $value = apply_filters( ‘nf_subs_csv_field_value’, $user_value, $field_id );
    $value = mb_convert_encoding($value, “windows-1252”);

    $value_array[ $x ][ $field_id ] = $value;

    Line 268

    Replace
    apply_filters( ‘nf_sub_csv_delimiter’, ‘,’ ),

    By
    apply_filters( ‘nf_sub_csv_delimiter’, ‘;’ ), // Fix , by ;

    Line 278

    Replace
    apply_filters( ‘nf_sub_csv_delimiter’, ‘,’ ),

    By
    apply_filters( ‘nf_sub_csv_delimiter’, ‘;’ ), // Fix , by ;

    ++

Leave a Reply

Your email address will not be published. Required fields are marked *