So you can export a list to a spread sheet, but can you do the opposite? Preferably from an Excel sheet.
By importing an existing Excel Spreadsheet to create a new list, you can continue tracking the list data from where you left off in the Excel sheet. When you import an Excel file into a SharePoint List, the table headings are converted to headings of columns in the list, where other data is then added as list items.
This is possible using Power automate flow. You need to upload excel file to SharePoint/OneDrive, then you can read the excel rows using Power automate and then update SharePoint list items.
Go the the Create menu in sharepoint and upder Custom Lists, click Import Spreadsheet. Type the name of the list, browse to the spreadsheet and click Import.
You can also sync your spreadsheet and list on a continual basis by making a list on your spreadsheet and then publishing that to sharepoint.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With