Importing Data in Excel from Dropbox

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?

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.

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

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

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.

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.

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:

Perhaps this info from the Microsoft site will help in this regard?

As mentioned previously, did you check if Excel refreshes the shared link, and if so, how frequently?

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

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.

The shared link is showing the updated file. I think the provlem is that dropbox loads the files via javascript and excel points to the previous file in history.

thaimike

@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!