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

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
v-bacao-msft
Community Support
Community Support

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

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

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.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (2,055)