cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to import excel data to sharepoint?

Please let me know which is the best forum to post this question, I'm sorry for the inconvenience, I don't know a better forum, but I do wish to later use this data on flow.

 

I have been trying to load the data of an excel file through:

In Internet Explorer: site > Settings icon > Add an app > Import Spreadsheet

http://sharepoint.handsontek.net/2018/01/03/fix-most-common-issues-with-sharepoint-import-spreadshee...

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_sharepoint-mso_win10/how-to-create-a-dro...

But unfortunately I get an unexpected error...

 

Here I found a suggestion on what to do:

https://answers.microsoft.com/en-us/msoffice/forum/all/import-from-spreadsheet-app-an-unexpected-err...

So I went ahead and made sure that the website is trusted and tried again, but still the same problem.

 Unexpected Error.png

I have also tried to load this data through excel export, explained here:

https://support.office.com/en-us/article/export-an-excel-table-to-sharepoint-974544f9-94bc-4aa8-9159...

WBS-List.pngWBS-List 2.png

 

Can't connect to server.png

 I got this error saying that: 

"Cannot connect to server at this time. Your list cannot be published"

I found a workaround on this website:

https://support.microsoft.com/en-us/help/838703/you-receive-a-cannot-connect-to-server-at-this-time-...

but this implies that I have to make the site public, but that is a big no no.

 

Are there any other ways to do this?

Any help would be appreatiated.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: How to import excel data to sharepoint?

I just realized that the website I was using was not correct. I was using the link to a specific folder on sharepoint, instead of just using the website link.

I was using

https://xxxxx.sharepoint.com/projects/16091/SiteAssets/Forms

 

instead of

https://xxxxx.sharepoint.com/projects/16091/

 

thanks everyone for the help.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: How to import excel data to sharepoint?

Hi @Anonymous,

 

If you want to import the data from the Excel table into the SharePoint list, you could use Get rows to get all the rows in the table, then configure Create item action to add the value of the corresponding field to the item.

This is the import operation of data that Flow can implement.

As for your mention of these problems, there is no way for me to rebuild here. It seems that there is no suitable method to solve it through Flow.

And the document I can find is almost the same as yours. I am afraid that I can't provide a suitable workaround to help you.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: How to import excel data to sharepoint?

Hi @v-bacao-msft

Thank you for your suggestion, it might be useful in the future.


@v-bacao-msft wrote:

Hi

If you want to import the data from the Excel table into the SharePoint list, you could use Get rows to get all the rows in the table, then configure Create item action to add the value of the corresponding field to the item.

 


 

I think I may be getting lost from my real objective and I apologize again for this not being the correct forum for this question. I have posted it on:

https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-import-excel-data-to-sharepoint/df0d07...

which is a more suitable forum.

 

Want I want to do is to be able to use the data from an excel file column in the drop down menu of a column on a sharepoint library, so that when the user is requested to fill this field, he has to choose from the options on the drop down menu.

This seemed to answer my question... https://answers.microsoft.com/en-us/msoffice/forum/msoffice_sharepoint-mso_win10/how-to-create-a-dro...

however, I still can't load the excel.

Later on i'll be applying some flows to the documents, but these will not change the WBS value.

WBS.png

 

WBS drop down.png

 

 

Anonymous
Not applicable

Re: How to import excel data to sharepoint?

I just realized that the website I was using was not correct. I was using the link to a specific folder on sharepoint, instead of just using the website link.

I was using

https://xxxxx.sharepoint.com/projects/16091/SiteAssets/Forms

 

instead of

https://xxxxx.sharepoint.com/projects/16091/

 

thanks everyone for the help.

View solution in original post

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,030)