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
I created a few entries in the default contact form. When I export the values Excel pops up and wants to open the file. The result looks like this: After I use the “Text-to-Column” button it looks like this 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.