Learn how to make the most out of the Dropbox Community here 💙!

Forum Discussion

mielkew's avatar
mielkew
New member | Level 2
8 years ago

Power Query Data Source Dropbox (Excel File Saved in Dropbox), How to connect?

Hi Dropbox Support Team,   Is there any way I can use the excel file stored in my Dropbox folder as a data source for my power query? How this can be done? I saw some discussion online about it, bu...
API
Greg-DB's avatar
Greg-DB
Icon for Dropbox Staff rankDropbox Staff
8 years ago

I can't offer any insight on the Excel side of things, but you can use the Dropbox API to programmatically access file data in a connected account, using /2/files/download:

 

https://www.dropbox.com/developers/documentation/http/documentation#files-download

 

(There are also corresponding methods in the SDKs, if you're using one, which we do reccomend.)

 

Regarding the Excel part of this, perhaps someone else on the forum has some experience with that. Otherwise, you may want to try an Office/Excel forum.

About Dropbox API Support & Feedback

Node avatar for Dropbox API Support & Feedback
Find help with the Dropbox API from other developers.5,972 PostsLatest Activity: 14 hours ago
366 Following

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X or Facebook.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!