We are aware of the issue with the badge emails resending to everyone, we apologise for the inconvenience - learn more here.
Forum Discussion
rehanabbasi
7 years agoExplorer | Level 3
Importing Data in Excel from Dropbox
I have an excel file on Dropbox. I want to import the data from this file to another excel file (which I want to share to others) via Get External Data - From Web feature. But whenever insert the link in the excel file for the Dropbox file, it opens a page but does not let me import the table from there.
Please help.
- JayDropbox StaffHi there, most likely this won’t work as expected, since the Excel files are online, how would this translate to a file when it’s synced to your local machine?However, if you’re willing to attempt this, you’ll need to create a shared link to the excel file, and then force the file to render in the browser using the raw=1 steps here.Then you can use that shared link as the import URL in the other Excel document.However, I can’t guarantee if this will work as expected, if at all.
- rehanabbasiExplorer | Level 3
I already tried raw=1 procedure but it tries to directly download the file instead of opening it and letting me select the table.
- JayDropbox Staff
If that’s the case, then it won’t be possible to import the Excel file into the other Excel file.
About Create, upload, and share
Find help to solve issues with creating, uploading, and sharing files and folders in Dropbox. Get support and advice from the Dropbox Community.
Need more support
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!