Adding bulk data to an existing sharepoint 365 list

%3CLINGO-SUB%20id%3D%22lingo-sub-2597506%22%20slang%3D%22en-US%22%3EAdding%20bulk%20data%20to%20an%20existing%20sharepoint%20365%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597506%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20add%20additional%20data%20to%20an%20sharepoint%20365%20list%20with%20existing%20data%2C%20how%20would%20I%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2597506%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597559%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20bulk%20data%20to%20an%20existing%20sharepoint%20365%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597559%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1117955%22%20target%3D%22_blank%22%3E%40JBTas%3C%2FA%3E%26nbsp%3B%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20have%20a%20couple%20of%20options%20which%20depend%20on%20the%20size%20your%20data%20(number%20of%20rows%20%26amp%3B%20number%20of%20columns).%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20If%20the%20size%20of%20your%20data%20is%20small%20%2C%20you%20can%20put%20the%20additional%20data%20into%20an%20excel%20sheet%20%2C%20copy%20the%20data%20%26amp%3B%20paste%20into%20Sharepoint%20List%20in%20the%20%3CSTRONG%3EGRID%20VIEW%20.%3C%2FSTRONG%3E%26nbsp%3B%22Edit%20grid%20view%22%20helps%20you%20to%20manipulate%20a%20sharepoint%20list%20just%20like%20an%20excel%20sheet.%3CBR%20%2F%3EThis%20is%20the%20easiest%20%26amp%3B%20quickest%20option.%3CBR%20%2F%3E2.%20If%20your%20data%20is%20considerably%20huge%20in%20terms%20of%20columns%20and%20rows%20%2C%20you%20can%20use%20POWER%20AUTOMATE%20to%20read%20data%20from%20excel%20sheet%20and%20upload%20it%20into%20SP%20list.%20This%20option%20requires%20you%20to%20be%20familiar%20with%20power%20automate%20and%20some%20basic%20programming%20skills.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3365028%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20bulk%20data%20to%20an%20existing%20sharepoint%20365%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3365028%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1097374%22%20target%3D%22_blank%22%3E%40Hegelmat%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20the%20edit%20allows%20you%20to%20edit%20what%20exists%20already.%20Unless%20if%20I%20am%20missing%20something%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to add additional data to an sharepoint 365 list with existing data, how would I do this?

3 Replies

Hi @JBTas ,

You have a couple of options which depend on the size your data (number of rows & number of columns).

1. If the size of your data is small , you can put the additional data into an excel sheet , copy the data & paste into Sharepoint List in the GRID VIEW . "Edit grid view" helps you to manipulate a sharepoint list just like an excel sheet.
This is the easiest & quickest option.
2. If your data is considerably huge in terms of columns and rows , you can use POWER AUTOMATE to read data from excel sheet and upload it into SP list. This option requires you to be familiar with power automate and some basic programming skills.

@Hegelmat 

Hi, the edit allows you to edit what exists already. Unless if I am missing something here.

@Abeldzvina yes you're missing the point of edit in grid view. Note, this is not the same as Edit. Edit in grid view is there whether a list has data or not and gives you a spreadsheet-like view of the list. It's not just for editing existing data, you can add new rows into it here as well and it is the fastest way to populate a list from Excel as @Hegelmat said.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)