Forum Discussion

RRMX01's avatar
RRMX01
Copper Contributor
Mar 25, 2021
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...
Lists
microsoft lists
SharePoint Online
  • RobElliott's avatar
    RobElliott
    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's avatar
iamhuman2414
Copper Contributor
Apr 17, 2022

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!

Rache2195's avatar
Rache2195
Copper Contributor
Apr 21, 2022
iamhuman2414 this is a bit off topic, but do you find working with that many rows in a SP list is unwieldy? I have lists nearing 10k lines that are a pain to work with since only 5k lines will render at a time and that takes a while.
  • Jamie_Weller's avatar
    Jamie_Weller
    Copper Contributor
    Apr 21, 2022

    Rache2195 Totally agree! We generally try not to let our SP lists get that big. We try to export them out by years/quarters/months and save the export within the site (then delete the data from the list) so they can still reference the data but it doesn't slow their list down. We only had to keep one list that large because we were using a list with a PowerApp to while we had an application outage.

Resources