XSN Rescue

How to export InfoPath form data to Excel

Updated 14 November 2026

Short answer: every InfoPath record is an .xml file. If you still have InfoPath Filler or Designer 2013, its export to Excel works for small batches. For whole libraries, especially with repeating tables, export the .xml files in bulk with a tool that reads the form template, so each record becomes a row and each repeating table its own sheet.

Why it matters now

InfoPath 2013 and InfoPath Forms Services in SharePoint Online reached end of support in July 2026 (MC616550). On SharePoint Server, existing forms still load but get no more fixes or security updates (Microsoft Q&A). The data is safe in the .xml files; reading it gets harder each year.

Option 1: InfoPath's own export

With InfoPath installed, select the forms and export them to Excel (Microsoft's guide). It works one batch at a time and needs the InfoPath client, which is no longer supported.

Option 2: promoted columns in SharePoint

If your form library promoted fields as columns, the library view can be exported to Excel. Only promoted fields come out, repeating tables usually don't, and in SharePoint Online the InfoPath parts may no longer work.

Option 3: bulk export the .xml records

Download the form library (records plus the template .xsn) to a folder. XSN Rescue matches every record to its template, uses the form's own labels as column headers, puts repeating tables on their own sheets, saves attachments as files and prints a PDF per record that looks like the form. It runs on your PC; nothing is uploaded. The first 25 records are free.

Employee namemy:employeeName
Amountmy:items/my:item/my:amountrepeating, own sheet

Tips

XSN Rescue is not affiliated with Microsoft. InfoPath, SharePoint and Excel are trademarks of Microsoft Corporation.