Deepnote can fetch files from OneDrive, for example, Excel files that you collaborate on with your team. Follow these docs to create your own notebook to pull files from OneDrive, query data, and visualize it.
Click the "duplicate" button on the top right corner to do this. Once you've got the template in your Deepnote workspace, you can download files from OneDrive.
You need to create a public sharing link so Deepnote can download the file. Follow these instructions from Microsoft making sure that anyone with the link can at least view the file.
Change the variable
ONEDRIVE_SHARE_LINK in the notebook to link to the file you just made.
The template notebook has a function called
get_onedrive_download, which takes a share link and creates a URL that will download that file directly. You can use a library like
requests to fetch the file or pass it to
pandas to read a CSV or Excel file directly. In the below example, the shared file is an Excel file.
ONEDRIVE_SHARE_LINK = "https://1drv.ms/x/s!AjP7y6eiYDDSafV7BusEaDHrI0o?e=cL0Fqi"
df = pd.read_excel(get_onedrive_download(ONEDRIVE_SHARE_LINK))
When executing the code above, Deepnote will visualize the output dataframe, as we see in the example below.
Now that you're querying data, you can share it with your team. You can even turn your charts into a shareable dashboard.