Get access to free tutorials, exclusive content and more.

Export Your Ninja Forms Submission to an Excel Spreadsheet

You know you can always export your Ninja Forms submissions into a CSV for free. But if we’re being honest, CSV can sometimes be a lot to handle. What we really want and need is a simple Excel spreadsheet. That’s why in this article, we’ll cover how to export your Ninja Forms to an Excel spreadsheet.

How to get an Excel spreadsheet of your Ninja Forms submissions

Make sure you have the Excel Export add-on to see what’s going to be described next. Please note that the “ZipArchive” PHP module is required for this add-on to run. Please contact your host to ensure compatibility. You’ll also need a form that has some submissions already.

Go to your WordPress dashboard, then to the Ninja Forms menu > Excel Export submenu.

excel export submenu in ninja forms

There, you’ll see the Excel Export screen. You can select the form that you want to export, filter the submissions and the fields you want to include in the export, and select your Excel file type (.XLSX or .XLS).

ninja forms excel export screen

For a quick and simple export of all your submissions, just select the form you want to export, choose the file type you want, and click ‘Download Excel file’. That’s it!

What if I don’t want to export all the submissions?

If you deal with thousands of submissions, you may don’t want to export all of them. This can be done by filtering your submissions, adding one or more conditions to the filter.

You can filter your submissions by their submission date or by the data in the form fields.

selecting field to filter submission

There’s a lot that you can do with these conditions. You have =, !=, >=, >, <=, <, CONTAINS, LIKE, IS EMPTY, NOT EMPTY. You can add one or more conditions, and you can even combine them!

selecting conditions for the filter

For example, if you want to generate a weekly report for the week that has passed, then you need to add two conditions to the filter. One is ‘Submission date’ >= ‘2021-03-15’, and the other one is ‘Submission date’ <= ‘2021-03-19’.

two submission date conditions

Or, you can also export only the submissions that you get on a specific day or in a specific month.

Selecting the fields you want to export

The filtering doesn’t end there. If some of your fields are confidential and you only want to export some of them, you can do that also! Just check/uncheck the fields listed there.

selecting fields for excel export

Another customization that you can do is setting the order of your fields/your Excel columns. You only need to drag the fields in the order that you want, and that’s how you’ll get the order of the columns in your Excel export.

It’s easy to export your form submissions to Excel!

Did you get all the steps? Now you can process your form submissions easily as a spreadsheet on Excel. No more complex CSVs 😉

If you want to do it on other spreadsheet applications instead, check out our guides on how to connect Ninja Forms to Google Sheets and Airtable.

Let us know what else you want to do with Ninja Forms in the comments section below!