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

BenHoffmann's avatar
BenHoffmann
Copper Contributor
Apr 04, 2022
Pasting from Excel works for a few dozen rows, but gets very cumbersome with larger amounts of data. I have been able to insert larger data using Access, which can connect to the SharePoint list and allows you to write SQL-like insert queries.
yyarin104's avatar
yyarin104
Brass Contributor
Apr 04, 2022

BenHoffmann Have you tried with Power Automate? it should also be possible to do a for each loop

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Aug 25, 2022

    BenHoffmann yes it can be done with Power Automate, but depeding on the number of Excfel rows to import it might be quite slow.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

  • BenHoffmann's avatar
    BenHoffmann
    Copper Contributor
    Aug 25, 2022
    I've heard that it can be done in Power Automate. It may just depend whether you're more comfortable using PA's GUI to construct the transfer of data, or writing SQL in Access. I prefer the latter.
  • BenHoffmann's avatar
    BenHoffmann
    Copper Contributor
    Aug 25, 2022
    Yes, 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).
  • JenniferHatcher's avatar
    JenniferHatcher
    Copper Contributor
    Aug 24, 2022

    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. 

  • 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.

  • 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.
  • 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!

Resources