Forum Discussion
Upload data from several excel to one SPO list
Hello. I need to upload data from several excel files to the one SPO list. Could someone advice hove to do this correctly and if this possibility exists?
Freenit It all depends on your data and some answers are already provided as well.
If you are concerned about accuracy then I will either go with
A] Power shell
B] Small Console Application
But if you can take risk with Accuracy then
A] Copy the data from different excels to diff. lists (hopefully some correlation will be their to makes tows unique) and then write a workflow or ms flow which triggers and copies that data from different list to a single list. Why I said the accuracy can be challenging if you have some conflicting data you need to handle carefully.
B] Manually coping with quick edit its painful and leads lot of errors.
Hope this helps.