Forum Discussion
RRMX01
Mar 25, 2021Copper Contributor
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...
- Mar 25, 2021
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
Paul_HK_de_Jong
Mar 25, 2021Iron Contributor
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
Rasheed_Ahmed
Mar 26, 2024Copper Contributor
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
- MinhThien1699Mar 27, 2024Copper ContributorHi 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