1. Download the forms
Each submitted form is an .xml file in the form library. Two ways to get them all:
- Download from the library. Open the form library in SharePoint, switch to a view that shows all items (or use "All Documents"), select them all, and choose Download. SharePoint gives you a .zip when you select several.
- Sync with OneDrive. Choose Sync on the library and the .xml files appear in File Explorer, where you can select them all. This is easier for big libraries.
You want the .xml files, not the form template (template.xsn, in the library's Forms folder). The template is the blank form; the .xml files are the answers.
2. Turn them into a spreadsheet
Drop the .zip, or the .xml files, into the InfoPath to Excel converter. It reads every form in your browser and gives you one CSV with a row per form and a column per field. Repeating tables are kept, either joined in one cell or spread across columns.
3. Put the data somewhere that will last
- Open the CSV in Excel and save it as a workbook.
- Or create a SharePoint list from it (New, List, From CSV), which is where most InfoPath replacements built in Power Apps or Microsoft Lists keep their data.
- Keep the original .xml files too. They're plain text and stay readable for good.
Several kinds of form in one library?
If a library holds forms from more than one template, convert each template's forms separately. The converter tells you when it sees more than one template, since mixing them leaves lots of empty columns.