InfoPath forms to Excel

Every filled-in InfoPath form is an .xml file sitting in a SharePoint form library. Drop them here, or a zip of them, and get one spreadsheet with a row per form and a column per field, ready for Excel, a SharePoint list or Power Apps.

How to get the forms out of SharePoint Two ways, no admin rights needed for either.

No forms handy? of three expense reports.

What you get

A CSV file that opens in Excel with one row per form. Each field becomes a column, named after the field (with its group in front when two fields share a name). Fields left empty stay empty, attached files are listed by size rather than dumped as code, and the first column says which file each row came from.

Repeating tables, like the lines of an expense report, are joined into one cell by default. Choose "one column per entry" if you'd rather have them spread across columns.

Up to 25 forms are free. For more, it's $49 once, for as many forms and libraries as you need, with a full refund within 30 days if it doesn't work for your forms.

Why this, and not just opening the XML in Excel?

Excel can open one InfoPath XML file at a time, and it nests repeating sections into extra rows, so a hundred forms turn into a hundred awkward imports. This takes the whole library at once, keeps one row per form, and gives every form the same columns even when some left fields out.

Where to next

How to get the forms out of SharePoint Two ways, no admin rights needed for either.

Microsoft Publisher, Word and PowerPoint are trademarks of Microsoft; PageMaker and InDesign of Adobe; Canva and Affinity of Canva. I'm not affiliated with any of them.