Pulling Data from SharePoint List into Excel

Question

Hi,&nbsp;I have successfully pulled data from SharePoint List into excel using "Get Data from Online Sources" for further analytics. One issue I am running into is in regards to certain data types. It appears when certain columns of data where multiple choices can be returned for data in the column, it appears in excel as [List] instead of showing what might have actually been returned in the SharePoint List.&nbsp;Is there a way to correct this?

gmld_engineer · Answer

Also, I am seeing [Table] from when the choices for a column are being pulled in from another SharePoint list.

deleted · Answer

Hi&nbsp;GMLD_Engineer!I have created a picture for you which shows how I did it for myself and it worked perfectly fine. I hope you can also apply it on your side, please let me know if I was able to help you&nbsp;&nbsp;I noticed after, that there is a documentation which describes this process as well:https://support.microsoft.com/en-us/office/export-to-excel-from-sharepoint-or-lists-bfb2ea48-6118-4fa9-abb6-cced9424e5d9&nbsp;&nbsp;&nbsp;

gmld_engineer · Answer

Thank you!&nbsp;Deleted&nbsp;

Forum Discussion

Pulling Data from SharePoint List into Excel

Share

Resources