Unanswered

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

(0) Share

Report

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

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report

Hi @Henry2Hudson ,

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

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Henry2Hudson 6 on at

Like (0)

Report

yes, I need to synchronize some data from local excel sheet to the SharePoint list.

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (1)

Report

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

Was this reply helpful? Yes No
Henry2Hudson 6 on at

Like (0)

Report

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.

Was this reply helpful? Yes No