Unanswered

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

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

SebS 4,584 Moderator on at

Like (1)

Report

@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

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
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)

Was this reply helpful? Yes No
KC-breeze 6 on at

Like (0)

Report

Thank you this worked

Was this reply helpful? Yes No
KC-breeze 6 on at

Like (0)

Report

Thank you this worked

Was this reply helpful? Yes No