How to import excel data into existing MS list?

Question

I need to import a list of data (Excel) into an existing MS list on SharePoint. The column headings in excel match the column headings in the list. I'm not seeing an option to import data, only export.

Answer 1

SharePoint and Microsoft Lists do not provide a built‑in command to import rows from Excel into an existing list while automatically matching columns. The supported Excel integration paths in the provided material are:

• Create a new list from an Excel spreadsheet (in SharePoint, Microsoft Lists, or Microsoft Teams).
• Export a table from Excel to SharePoint to create a new list.

These flows always create a new list; they do not append to an existing one.

To use Excel data with a list, the supported approach is:

1. Format the data as a table in Excel (with headers).
2. Create a new list from that Excel table (for example, from Microsoft Lists → New list → Create from Excel, or in Teams → Lists tab → From Excel).
3. Adjust column types in the new list as needed.

If the data must end up in a specific existing list, it must be moved there by other means (for example, manual copy/paste row by row or using tools/automation not covered in the provided material).

---

References:

• Create a list based on a spreadsheet
• Use a screen reader to create a list from the Microsoft Lists app
• Use a screen reader to create a list in a Microsoft Teams channel