Answered

How do I insert data from Excel into an existing SharePoint list

Like (0) Share

Report

Posted on 12 Mar 2023 12:17:08 by KC-breeze

I have an Excel spreadsheet with 257 records that I would like to add to an existing SharePoint list. I was using Internet Explorer to do this however Internet Explorer browser was shut down at my company.

What tool can I use to accomplish this task, and how can I use it? The only required fields are:

1. Title - Text Field

2. Accountable - Text Field

Categories:

Dataflows

Connecting to Data

General Questions

All responses (4)

Answers (1)

KC-breeze 6 on 13 Mar 2023 at 19:40:06

Like (0)

Report

Re: How do I insert data from Excel into an existing SharePoint list

Thank you this worked
KC-breeze 6 on 13 Mar 2023 at 19:39:50

Like (0)

Report

Re: How do I insert data from Excel into an existing SharePoint list

Thank you this worked
Verified answer

v-qiaqi@microsoft.com on 13 Mar 2023 at 04:56:58

Like (1)

Report
Re: How do I insert data from Excel into an existing SharePoint list

Hi @KC-breeze,

Since @SebS has provided a direction of Power Automate, I will post an idea for Power Apps。

1). Format your data of Excel to a table so that you can connect this Excel table.

Also create the needed columns in your sharepoint list to store the value from Excel.

2). Connect with your Excel file and sharepoint list.

3). Save your data of Excel to a collection.

Collect(collection1,tablename)

4). Format your collection data(If all your fields name in Excel and SP list are totally same, you can skip this format step):

Collect(collection2,RenameColumns(
ShowColumns(collection1,"field1","field2","field3"),
"field1","field11","field2","field22","field3","field33"))

5). Update your sharepoint list with this collection:

Collect(listname,collection2)
SebS 4,204 Moderator on 12 Mar 2023 at 16:14:36

Like (1)

Report

Re: How do I insert data from Excel into an existing SharePoint list

@KC-breeze

Simply use power Automate to do that.

Convert data in excel to a table if it's not in it already.

Then create a flow to pull data from the excel table and map it to the Sharepoint list and upload by creating items
what will be records in Sharepoint List

Here is a tutorial for you:

https://www.youtube.com/watch?v=uEZI_b1Gs-k