How to manually import data from an Excel spreadsheet into a Sharepoint table?

Like (0) Share

Report

Posted on 18 Jun 2024 08:47:38 by Henry2Hudson

How to manually import data from an Excel spreadsheet into a Sharepoint table? Now I can use "recurrence" function to import items at scheduled times, but what I want is to manually import data when I need it.

All responses (4)

Answers (0)

Henry2Hudson 6 on 19 Jun 2024 at 00:59:21

Like (0)

Report

Re: How to manually import data from an Excel spreadsheet into a Sharepoint table?

Hi, @v-yetonggu-msft, Usually， the data collected in my SharePoint List comes from a Power App that I designed myself. However, currently my app does not have a feature to upload data in bulk, so I hope to use Power Automate to submit batch data from Excel to the Share Point list. This way, if there is occasional bulk data upload, it will be quicker.
v-yetonggu-msft on 18 Jun 2024 at 09:15:31

Like (1)

Report

Re: How to manually import data from an Excel spreadsheet into a Sharepoint table?

Hi @Henry2Hudson ,

Can you consider use flow to delete all the data in the SharePoint list and then re-importing the data in the excel table? This is the easiest way to do it.

Best Regards,

Sunshine Gu
Henry2Hudson 6 on 18 Jun 2024 at 08:54:05

Like (0)

Report

Re: How to manually import data from an Excel spreadsheet into a Sharepoint table?

yes, I need to synchronize some data from local excel sheet to the SharePoint list.
v-yetonggu-msft on 18 Jun 2024 at 08:51:24

Like (0)

Report

Re: How to manually import data from an Excel spreadsheet into a Sharepoint table?

Hi @Henry2Hudson ,

Do you want to add an item that exists in Excel Table but not in SharePoint List?

Best Regards,

Sunshine Gu