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
Are you saving changes to the Dropbox file directly? Is your link to that file ‘live’ (meaning a shared link, and not simply a downloaded file)?
 
Likewise, how frequently does the second Excel sheet update itself to verify the info imported from the first sheet? Is it automatic, every minute or so, or do you need to have it check manually? This is more of an Excel setting though, instead of Dropbox.
rehanabbasi's avatar
rehanabbasi
Explorer | Level 3
8 years ago

@Jay

Yes, I'm updating the file in Dropbox directly and am using a shared link. Moreover, I've set the new excel file to import the data automatically. I've also tried importing the data manually but to no avail. :slight_frown:

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

      Jay

      I've set excel to refresh only when the file is being opened. It refreshes but I still get the old data.

      • Jay's avatar
        Jay
        Icon for Dropbox Community Moderator rankDropbox Community Moderator
        8 years ago
        Is the shared link on its own showing the most up-to-date changes, when viewing it directly from the site while not logged into your account?
         
        If so, then there might be an issue with how Excel is importing the link. Perhaps it’s loading a cached version of the file instead of grabbing the live version.
  • thaimike's avatar
    thaimike
    New member | Level 2
    7 years ago

    @rehanabbasi

    I have tried to import the excel from dropbox to another excel file, and facing the same problem of downloading the file instead of importing the data. I wonder if you can share your solution to this, thanks in advance!

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

      thaimike I have yet to find a solution to this problem. I have looked across various forums but couldn't find what I was looking for.

      • alexdroppingbox's avatar
        alexdroppingbox
        Helpful | Level 6
        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

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!