I need to know if there's a more efficient way of uploading data to my list on Sharepoint. I have a worksheet with an average of 100 rows and 106 columns, making a total of approximately 9,900 cells.
This is my current process to upload:
The longest parts of this process are waiting for the Sharepoint page to load, delete the data, and then waiting for Sharepoint to validate the data. And if it finds a value that it wasn't expecting, then that adds to the time, of course.
If that's the way it has to be, ok, I just want to make sure I'm not overlooking a better method. Any suggestions are welcome.
This is my current process to upload:
- I go to my list on Sharepoint, viewing it in edit mode.
- I select all rows and delete them.
- I then copy my new data from Excel and paste it into the now empty list on Sharepoint.
The longest parts of this process are waiting for the Sharepoint page to load, delete the data, and then waiting for Sharepoint to validate the data. And if it finds a value that it wasn't expecting, then that adds to the time, of course.
If that's the way it has to be, ok, I just want to make sure I'm not overlooking a better method. Any suggestions are welcome.