Need to see if your shared folder is taking up space on your dropbox đŸ‘šâ€đŸ’»? Find out how to check here.

Forum Discussion

rehanabbasi's avatar
rehanabbasi
Explorer | Level 3
8 years ago
Solved

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 li...
Microsoft Office
Share
Shared Links
Web
  • alexdroppingbox's avatar
    alexdroppingbox
    2 years ago

    As of 2024 this seems to work fine once you have used web query and got the data in you can rigt click refresh and it will pull the updated info from the dropbox CSV

Jay's avatar
Jay
Icon for Dropbox Community Moderator rankDropbox Community Moderator
8 years ago
Hi 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?
 
 
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.
  • rehanabbasi's avatar
    rehanabbasi
    Explorer | Level 3
    8 years ago

    @Jay

    I already tried raw=1 procedure but it tries to directly download the file instead of opening it and letting me select the table.

    • Jay's avatar
      Jay
      Icon for Dropbox Community Moderator rankDropbox Community Moderator
      8 years ago

      If that’s the case, then it won’t be possible to import the Excel file into the other Excel file.

      • rehanabbasi's avatar
        rehanabbasi
        Explorer | Level 3
        8 years ago

        After some it and trial, I was able to import the data but it is not updating in the new file when I make changes in the Dropbox 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.

The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.

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, Facebook or Instagram.

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!