You’re offline. This is a read only version of the page.
Share
ReportI have an excel sheet online that is updated every week.
Locally I have several Excel sheets that have to read this data and run all kinds of formulas on it.
Now I have a link in my local Excel sheet to a Sharepoint list that contains the data from the online excel (which has been imported into the sharepoint list).
In order to update the Excel weekly in the Sharepointlist, I made a Flow with Power automate, but this is so painfully slow that it is actually not worth the effort (it concerns 15K lines). The flow first removes all lines from the Sharepoint list and then reads the online (updated) Excel and puts all lines in the Sharepoint list.
Anyone have an idea or a good alternative within the MS suite?
Sure although I do not really know what they are using. It's a company that created a software tool and will partially be custom made. If I am right the Excel will be converted to CSV, after that the data will be imported in the database.
Thanks for your response, really appreciated.
Unfortunately at this stage we have to deal with the Excel. The online Excel is delivered by an External party and the local Excel is soomething we already have in place and is quite extensive. Parralel to this we are developing a completely new setup with database and everything but that will take some time to finish. SO for now we hope we can find a solution that will update the SharePoint list from Excel a bit quicker then is currently the case.
All the very best,
Bas
I don't say this harshly, but consider a different place to keep the data.
Excel is a calculator, and even though it can do a half-way decent job of it, it is not a data storage system.
So get that data stored in a different place, and staying in the MS Suite, the immediate options are:
In terms of ease of use, I would usually go for SharePoint, as it will be more understandable to more people. Plus, if you wish to setup input elsewhere and use Power Automate to add items (rows) to the list (sheet) then you have a lot more easily handled methods here.
Once you have your data in SharePoint suddenly life becomes so much easier with regard to retrieving and adding information to it.
Now, I can obviously see that you *have* this already ... so my question there is why not just have that as the main deal.
Then, whenever an item is added or modified on the SharePoint list, have a trigger on that, and update whatever needs updating.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
All responses (
Answers (
