web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How do I insert data f...
Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by 6

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:
I have the same question (0)
  • SebS Profile Picture
    4,822 Super User 2026 Season 1 on at

    @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

     

     

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    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)  

     

  • KC-breeze Profile Picture
    6 on at

    Thank you this worked

  • KC-breeze Profile Picture
    6 on at

    Thank you this worked

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 414

#2
Valantis Profile Picture

Valantis 387

#3
timl Profile Picture

timl 344 Super User 2026 Season 1

Last 30 days Overall leaderboard