How to export InfoPath form data to Excel
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.
Tips
- Keep the original .xml files after exporting: they are the record of truth.
- Keep the .xsn template with them. Without it, field labels and the form layout are lost.
- Check one record's PDF against InfoPath while you still can.
XSN Rescue is not affiliated with Microsoft. InfoPath, SharePoint and Excel are trademarks of Microsoft Corporation.