11,709 questions
Hi *anonymous user*Kumar-8699,
One way is to create a SharePoint list based on a spreadsheet.
Connection to sharepoint document
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 30%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Deepak Kumar
21
Reputation points
Hello ,
Is there a proper way to :
- Either import data from an excel sheet in sharepoint location ?
- Create a connection between an excel sheet in a sharepoint location ?
Thanks,
Deepak
Microsoft 365 and Office | SharePoint | For business | Windows
Accepted answer
-
T. Kujala 8,766 Reputation points2020-08-02T09:40:38.33+00:00 -
Deepak Kumar 21 Reputation points
2020-08-02T11:32:06.197+00:00 Thank you @T. Kujala .
I have a follow up questions if you can help me with.
- Will this list be updated when i make changes in the excel ?
- Also, i seem to miss out some entries from the excel which is imported from the sharepoint itself. I did sync them perfectly before creating a list based on excel sheet in the sharepoint. What am i missing here ?
-
T. Kujala 8,766 Reputation points
2020-08-02T12:06:31.91+00:00 Unfortunately, it doesn't update a list automatically.
Here you will find three different methods to import data from Excel to SharePoint.
3 ways to import Excel to SharePoint
If you want to update contents automatically to the SharePoint list, you may have to use a Power Automate feature.
Sign in to comment -
1 additional answer
Sort by: Most helpful
-
杨建宇 86 Reputation points MVP2021-02-20T07:16:54.957+00:00 Excel can connect SharePoint Online list so that you can try below link:
https://www.spguides.com/open-sharepoint-list-in-excel/
https://support.microsoft.com/en-us/office/import-data-from-external-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a?ui=en-us&rs=en-us&ad=us