Forum Discussion
Solved
Import excel into existing list (with data already in it)
Hi, Is it possible to import data from an excel sheet into a SharePoint list that already contains data in it? Basically I just want to add to the list that's already in SharePoint without overw...
RRMX01 if you go to Edit in grid view on your list you can paste in data from an excel spreadsheet.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
If you need to import a lot of items then you may wish to import in chunks of 100 and wait for the changes to be synched before importing the next set. i.e. avoid inconsistent data. Paul
When i tried to import Excel file to a SharePoint List, it only have about 150 records in the lists. while the excel file which is imported to List is over 500 records.
Regards,
Rasheed Ahmed
- Hi there have you waited for the upload process completed ? , at the left of your list, while you upload data it will have a little circle turn around for each row of your data, it wil move downward, as long as the data upload it will move down to the end. If you try to refesh the page while this circle not moved to your final line, you will miss your data
Paul_HK_de_Jong I'm using Sharepoint online (office 365), when i edit my list in grid view i can paste 1 record at a time successfully but can't paste multiple records, any ideas? I don't have a quick edit icon only the edit in grid view icon. Thanks in advance
BeachBennsyou cannot paste multiple items in grid view if you have disabled item checkboxes. make sure it is enabled.
- In the edit in grid view screen just do a single click on the first column - don't click into it - and you should be ab le to paste in records, I do it regularly.
- ^THIS IS THE WAY^ I wasn't able to paste more than one, then I just did this and could paste 550 all at once. Note that if you are doing that many, it takes some time for it to sync up to the cloud after you Exit grid view. Mine took a few minutes.
