I had some troubles exporting form submissions in the past because of special character, German “Umlaute” and textareas fields with multiple lines of content.
All of this situations leaded to destroyed CSV files that couldn’t be opened in Excel because of shifted rows or columns.
NinjaForms Excel Export
I felt save now to deal with any kind of form submissions until I wanted to export data from a lottery form.
23 000 people submitted this form. I tried to export the submissions but I had no success.
Batch processing of form submissions
So I remembered Pippin Williamsons post about batch processing and extended the plugin to handle huge amounts of data by splitting into small chunks of 100 lines each.