Forum Discussion

GMLD_Engineer's avatar
GMLD_Engineer
Copper Contributor
Jan 09, 2023

Pulling Data from SharePoint List into Excel

Hi,   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...
excel
microsoft lists
SharePoint Lists
SharePoint Online
Deleted's avatar
Deleted
Jan 09, 2023

Hi 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 :smile:

 

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

 

 

 

  • GMLD_Engineer's avatar
    GMLD_Engineer
    Copper Contributor
    Jan 11, 2023

    Thank you! Deleted 

Resources