Import data from Excel to SharePoint Online list
Excel Import App enables you to import data from an Excel spreadsheet (in .xlsx, .xls or .csv format) into an existing SharePoint Online list. If you have a large Excel file with many worksheets inside, you can also import specific sheet into SharePoint Online list, one at a time.
Even better, Excel Import App allows users to import data to most built-in SharePoint column types.
Capability of Column mapping
With Column Mapping feature, you can configure how to import an Excel spreadsheet into a SharePoint Online list efficiently by mapping excel columns to SharePoint list columns.
Even better, Column Mapping is applied automatically if the Excel spreadsheet and the SharePoint Online list have the same column names; or, you can do the column mapping manually.
Skip or Update Duplicate Records
SharePoint Excel Import App gives you the option to skip or update duplicate records by specifying Key column.
You can skip duplicate records when you want to import only new records to SharePoint Online list; or, you can choose to update duplicate records when you want to keep existing list items updated as well from being imported.