XSN Viewer

How to export InfoPath form data to Excel

Put the data of many InfoPath forms in one Excel table: one row per form, one column per field.

Free, in your browser – nothing is uploaded

InfoPath forms are XML, so Excel can open them one at a time, but repeating tables, attachments and namespaces make the result hard to use – and doing it for hundreds of forms takes days.

With the XSN Viewer Windows app

  1. Download the forms of the library into a folder, together with their template (.xsn).
  2. In XSN Viewer, choose Convert folder and select the folder (or a ZIP file).
  3. Tick One table with all the data and start: you get a CSV file that Excel opens directly, with one row per form and one column per field, named as in the form.

Repeating fields – the rows of a repeating table – are collected in the same cell, separated by semicolons. Attachments appear with their file name and can be saved alongside.

For a single form, the Data tab of XSN Viewer shows all the fields in a table you can select and copy.

Frequently asked questions

Do I need the template to export the data?

No, but it helps: with the template, the columns get the labels used in the form instead of the internal field names.

Is the CSV safe to open in Excel?

Yes. Values that Excel could read as formulas are neutralised, so a form cannot run formulas on your PC.

XSN ViewerOpen InfoPath forms online for free. The Windows app for whole libraries is coming soon.

Other guides