To connect Excel to a SharePoint list, you have three options. You can make a new list from an Excel table in SharePoint or Microsoft Lists, export a table from Excel with Export Table to SharePoint List, or build a Power Automate flow that copies rows across. Where it stops: the first two are one-time copies, and Microsoft says the export does not create a data connection, so later changes in Excel never reach the list. A flow can keep them in step, but it has row, size and timing limits someone has to watch. AI agents keep the sheet and the list matched and tell you what's off.
What it means to connect Excel to a SharePoint list
Most teams start in Excel. A tracker of clients, jobs or equipment grows until several people need it at once.
Then somebody moves it to a list in SharePoint, where each row has an owner, a status and a history.
Moving it is quick. Keeping it moved is the hard part. If anyone keeps updating the old workbook, or a report still runs from Excel, you now have two copies of the same data. So connecting Excel to a SharePoint list really means two things: getting the rows in once, and deciding how changes keep flowing after that.
Three ways to connect Excel to a SharePoint list
The first two are built in. The third is for changes that keep coming.
Make a list from Excel
- How it works
- In SharePoint, select Create, then List, then From Excel. You can also start from New list in the Microsoft Lists app. Upload the workbook, select the table, check the column types, and select Create. Table headings become columns and each row becomes a list item.
- Good for
- Moving a tracker into SharePoint once, so the team works in the list from then on.
- Where it breaks
- Microsoft's page says the table can have up to 5,000 rows, and the data has to be formatted as a table first. It is a copy. The page doesn't say the list stays linked to the file, and if you upload from your computer, the workbook is saved on the site where others can see it.
Export Table to SharePoint List
- How it works
- In Excel on your computer, click inside the table, then select Table Design, Export, Export Table to SharePoint List. Enter the site address and a list name, check the column types, and select Finish.
- Good for
- Someone who already has the table open in Excel and wants it on a site in a few clicks.
- Where it breaks
- Microsoft says exporting a table as a list does not create a data connection, so updates in Excel never reach the list. Formulas turn into plain values, and a column that mixes numbers and words becomes text.
A Power Automate flow
- How it works
- Power Automate's Excel Online (Business) connector reads and writes rows in a table stored in OneDrive or SharePoint. A flow can list the rows on a schedule and add or update items in the list.
- Good for
- Teams on Microsoft 365 with someone who can build and look after flows.
- Where it breaks
- Microsoft's own limits page says List rows returns 256 rows unless you turn on paging, files over 25 MB aren't supported, the file can stay locked for up to 6 minutes, and edits from people and flows at the same time can clash. Update a row only changes the first match.
Arkeo agents
- How it works
- Agents read the Excel workbook and the SharePoint list on your schedule, match rows by the column you use as the key, update the list, and flag rows that are blank, doubled or changed in both places.
- Good for
- Teams that still use both the sheet and the list, and need them to agree.
- Where it breaks
- A row changed in both places goes to its owner to decide, in one message.
How to connect Excel to a SharePoint list: five steps
These follow Microsoft's own guides. Open them for the screens.
- 1Turn the data into a table
In Excel, click in your data and select Format as Table on the Home tab. Give each column a clear heading. Both built-in ways need a table.
- 2
Make the list from Excel
In SharePoint, select Create, then List, then From Excel. Upload the file or use one from OneDrive, select the table, and select Next.
- 3
Check the column types
Before you select Create, look at each column. Dates should be dates and money should be currency. Fix them now, because it is harder once people start using the list.
- 4Or export from Excel instead
If you prefer to start from the workbook, click in the table and select Table Design, Export, Export Table to SharePoint List. Use the site address, not a page address.
- 5
Set how changes flow from now on
Settle on one home for the data. If the list is the home, retire the workbook. If Excel stays, build a flow with the Excel Online (Business) connector, and check its run history each week.
Where the Excel SharePoint list connection stops
Microsoft's own pages are plain about it. The built-in ways copy the data once. The work in the middle starts the next day.
There is no live link from Excel to the list. Microsoft's export page says exporting a table as a list does not create a data connection, and updates made in Excel after that will not show in the list. The other direction is only half better: when you export a list to Excel, Microsoft says the workbook has a one-way connection you refresh, and changes made in the Excel table are not sent back.
Size and shape cut it short. Making a list from Excel takes a table of up to 5,000 rows. The export turns formulas into values, so totals in the list are just numbers until someone rebuilds them.
Flows need looking after. The Excel connector reads 256 rows by default, can lock the file for up to 6 minutes, and Microsoft says people and flows writing to the same file at once can cause clashes and bad data. When formulas are heavy, a timeout and retry can add the same rows more than once.
People have asked for this for years. In Microsoft's Tech Community, a thread that began in 2016 asks how to update a SharePoint list from Excel without other software. One later post says no Power Automate flow they tried worked, and others point to outside sync products. So most teams end up with a person who copies the week's changes across and checks that nothing doubled. Excel automation covers the same gap inside Excel itself.
What agents do with the work in the middle
An agent reads the workbook and the list on your schedule, every day or every hour. It matches rows by your key column, like a client or job number, updates the list, and posts what changed. It finds blank fields, doubled rows and rows changed in both places, and sends those to the owner instead of guessing.
The same kind of agent can build a monthly client report in Excel from your numbers, so the report and the list come from the same rows.
For Excel with your other programs, see Excel integration.
The agents that do it
Each agent does one job from start to finish, in your own Excel and SharePoint. Your team talks to them in Slack or Teams.
The tracker is right when you open it.
- Pulls new deals, jobs and invoicesevery day
- Updates the rows in your trackersame day
- Flags rows no one has touchedevery Monday
No more decisions made on a broken formula.
- Checks shared workbooks for errors and blanksevery day
- Finds what broke and whenper sheet
- Tells the person who owns the fileright away
Days of building becomes a review.
- Reads the client fileper client
- Builds it from your templateper document
- Checks your wording word for wordevery time
Questions
Is my customers' information safe?
Yes. Agents work in your own Microsoft 365 and see only the files and lists their job needs. Customer details never go into public AI. Agents connect to AI through business-grade connections audited under SOC 2.
Can a SharePoint list update from Excel automatically?
Not with the built-in ways. Microsoft says exporting a table to a list does not create a data connection. To keep them in step you need a Power Automate flow, another sync product, or agents.
How many rows can I import from Excel to a SharePoint list?
Microsoft's page says a table can have up to 5,000 rows when you make a list from Excel.
Does a SharePoint list exported to Excel stay connected?
One way. Microsoft says the workbook has a one-way connection: select Refresh All on the Data tab to get the latest list. Changes made in Excel are not sent back to the list.
What does it cost?
You get the price on the call, along with the hours it saves your team.