I would like to know how can I import 500 records (in an Excel file) to XML form library in SharePoint Online.
This XML form library was created with InfoPath 2013.
The form library is a library, we only can upload the files in the form library. We cannot import the records from the excel to the form library.
Then if you want to import the records from excel to SharePoint online, you could go to site contents->create a app “Import Spreadsheet”.
More reference: