Unanswered

Bulk load data from Excel to SharePoint list

(0) Share

Report

Posted on by MalyMajo

Hi everyone,

I have a SharePoint list (containing only 1 column), which needs to be updated according to the values in an Excel file (currently contains 4000+ rows, will probably grow in time).

Is it possible to:

load data from Excel, which does not contain data stored in table?
Currently I always open the file, store all data in 'Table1' and save it to SharePoint.
Speed-up the load of data (step 'List rows present in a table') from current 16 seconds?
Speed-up the 'Send an HTTP request to SharePoint' loop from current 18 minutes?

Thanks,

Majo

All responses (2)

Answers (0)

MalyMajo 86 on at

Like (0)

Report

Re: Bulk load data from Excel to SharePoint list

I have changed the settings of apply to each as on the picture below, but I do not see any huge difference.
Current run took even longer, 32 minutes. Is there something else to be set?
mahoneypat 1,720 on at

Like (0)

Report

Re: Bulk load data from Excel to SharePoint list

You can't load data from Excel that isn't formatted as a table. Also, the loading of the data at 16s sounds pretty good. For the Apply to each, have you already increased the concurrency value in the Settings of the Apply to each action? That will help, if not.

Pat