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
iamhuman2414
Apr 17, 2022Copper Contributor
yyarin104 I'm new in Power Automate, would you be able to send some quick instructions on how to do this?? I have hundreds of thousands of records from Excel to import to a Sharepoint list. Thanks!
JenniferHatcher
Aug 24, 2022Copper Contributor
iamhuman2414 can I do the same with an Access database that didn't import everything over? I want to get the missing items without losing or messing with what's already there. Thanks in advance.
- BenHoffmannAug 25, 2022Copper ContributorYes, you can selectively link to specific SP lists from Access. You don't have to connect to all of the lists in your SP site. However, as mentioned in my previous reply, if an SP list contains a lookup column or a Person column, Access will bring in additional list references (as tables).