31:T7b8,## Adding cloud file references to notebooks

Once you are signed into your Observable account, adding a cloud file reference to a notebook is easy. If you don't already have an account, you can [**sign up for free**](https://observablehq.com). You can add any type of file you want to your notebook, including images, CSV files, and spreadsheets. Observable's standard library includes support for handling Microsoft Excel `.xlsx` files, allowing easy access to the individual sheets in the workbook, even to ranges of rows and columns. Follow these steps to import data from **Microsoft Office 365 Excel** or **Google Drive** into your notebook. 1. Open your existing notebook, or create a new one. 2. Open the [**Data pane**](https://observablehq.com/@observablehq/observable-release-notes#datapane) by clicking the paperclip icon on the right hand side of the page. 3. Open the **Cloud files** dialog by clicking on the `+` next to it. 4. Pick from the available cloud file providers 5. You will be prompted to sign in to Microsoft or Google and grant access to your OneDrive (Microsoft) or Google Drive (Google) files to Observable. - Be sure to sign in with the correct third-party account that has access to the desired files. (See [**OAuth permissions**](#storedOauth) for more information.) - *For Google*, please check the “See and download all your Google Drive files” check box. This is required to access your files, and bring the needed data into Observable. 7. Once you have connected, you will see a file picker; use it to navigate to your file. 8. Select the desired file. Once selected, one or more cells will be added to your notebook that demonstrates importing your file.
32:[{"id":"7136b4e239c10689fac962f250d8bd5f333fb226887fcc508f52a0013ef08d8f7b5100b6786281c8a4c497d4b2c8d2945441fa26cbfd6fcf749813de8eec53ea","href":"https://static.observableusercontent.com/files/7136b4e239c10689fac962f250d8bd5f333fb226887fcc508f52a0013ef08d8f7b5100b6786281c8a4c497d4b2c8d2945441fa26cbfd6fcf749813de8eec53ea","name":"Google cloud files.mp4","type":"video/mp4","lastModified":1636754092953.582,"size":512566},{"id":"497657dc0f19f0ca5112652298e1e400a7a8c18dff9919ddcb205714f81ba90a21d732c635f1ce423c449f04e5374f770f31e0d5b8369d0e8371f098a8b7a6e2","href":"https://static.observableusercontent.com/files/497657dc0f19f0ca5112652298e1e400a7a8c18dff9919ddcb205714f81ba90a21d732c635f1ce423c449f04e5374f770f31e0d5b8369d0e8371f098a8b7a6e2","name":"Google drive scopes.png","type":"image/png","lastModified":1636756400511.121,"size":188840},{"id":"a11b9f1bd195ecef81a3a02659c27e1637b073e626615488427191703fd88a3c2c19334aaebe68d77b8b2834647ef68c9965de64ce3d034dd0a1638ced4ccd00","href":"https://static.observableusercontent.com/files/a11b9f1bd195ecef81a3a02659c27e1637b073e626615488427191703fd88a3c2c19334aaebe68d77b8b2834647ef68c9965de64ce3d034dd0a1638ced4ccd00","name":"cloud_files.mp4","type":"video/mp4","lastModified":1632857230995.321,"size":1152123},{"id":"611e1d54a7fe24230653f1a84b23417702a344f1c81b77e1092e9a03cb89ccea844a3c57e0dff69b93ac02b59a3dffebffa005e5d31c4309ad78d28117b4e3c6","href":"https://static.observableusercontent.com/files/611e1d54a7fe24230653f1a84b23417702a344f1c81b77e1092e9a03cb89ccea844a3c57e0dff69b93ac02b59a3dffebffa005e5d31c4309ad78d28117b4e3c6","name":"Screen Shot 2021-09-28 at 3.11.36 PM.png","type":"image/png","lastModified":1632856340970.548,"size":90405},{"id":"1fefb6ffa85936890ef1dfa81c44511144eca2a6d4edb566cba0052ad10351acbab8615c105cfeb79d80918240adb7deaa03f2beb35d1b97a9213bde3d48d419","href":"https://static.observableusercontent.com/files/1fefb6ffa85936890ef1dfa81c44511144eca2a6d4edb566cba0052ad10351acbab8615c105cfeb79d80918240adb7deaa03f2beb35d1b97a9213bde3d48d419","name":"Screen Shot 2021-09-28 at 3.05.32 PM.png","type":"image/png","lastModified":1632856006787.245,"size":1007532}] 2f:{"title":"Cloud files","cells":[{"id":0,"value":"# Cloud files","pinned":false,"hidden":false,"mode":"md"},{"id":425,"value":"$${pro()}","pinned":false,"hidden":false,"mode":"md"},{"id":230,"value":"Observable is giving you a new way to access your data from the platform: *Cloud files*. Cloud files make it possible for your notebook to have a live reference to a file stored in the cloud.","pinned":false,"hidden":false,"mode":"md"},{"id":6,"value":"Importing data into a notebook is the starting point for analysis and visualization on Observable. Cloud files add another data source to the platform, so you can access your data directly and conveniently to start your data insights journey. \n","pinned":false,"hidden":false,"mode":"md"},{"id":146,"value":"- Every time your notebook is loaded, the contents of the cloud file are loaded into the notebook.\n- Unlike a file attachment, the cloud file reference is not static, but can be refreshed when (for example) a spreadsheet is updated.\n- To maintain clarity in the permissions model, viewers of the notebook are required to sign in to the cloud file provider to ensure they have the required permissions to view the cloud file data being accessed by the notebook.\n- You can still use all of the existing ways to access data ([File Attachments](https://observablehq.com/@observablehq/file-attachments), [Database Connectors](https://observablehq.com/@observablehq/databases), as well as notebook [Secrets](https://observablehq.com/@observablehq/secrets) for securely accessing data via private APIs).","pinned":false,"hidden":false,"mode":"md"},{"id":249,"value":"Currently, you can access cloud files in *Microsoft Office 365, Microsoft OneDrive* as well as *Google Drive*. Support for more cloud providers will be added over time, based on user requests.\n\n
","pinned":false,"hidden":false,"mode":"md"},{"id":198,"value":"

Connecting a Google Drive file to a notebook.

\n\n\n
","pinned":false,"hidden":false,"mode":"html"},{"id":17,"value":"$31","pinned":false,"hidden":false,"mode":"md"},{"id":55,"value":"## Retrieving fresh data\n\n Once added, the contents of the cloud file will be read each time the `FileAttachment()` function is executed in the notebook. This happens automatically when the notebook is loaded and the cell is initially executed. If you want to manually refresh the data, click the Play button (the blue triangle) on a cell containing the reference. This causes the cloud file to be re-read and its value in the notebook to be refreshed.\n\n Your data is kept secure because if the notebook is accessed by or shared with someone who lacks the necessary permissions, the `FileAttachment` function displays an error.\n\n
","pinned":false,"hidden":false,"mode":"md"},{"id":26,"value":"storedOauth = md `## OAuth permissions\nThe first time you use a notebook with cloud files, either as an editor or just a viewer, you will be prompted to sign in to the cloud service provider using an identity that has access to that file. When you do this, Observable will retrieve and store an OAuth token with the necessary scopes to read the file.\n\nProvider | Scopes\n-------- | ------\nMicrosoft 365 | openid, profile, User.Read, Files.Read.All\nGoogle | openid, userinfo.email, userinfo.profile, drive.readonly\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":162,"value":"Each viewer of a notebook uses their own OAuth token when accessing a cloud file, meaning that the stored token is only available to the current user, not to just anyone who can view the notebook.","pinned":false,"hidden":false,"mode":"md"},{"id":97,"value":"OAuth tokens are persistently stored so you won't be prompted each time you visit a notebook that requires them, only the first time. You can see the list of stored tokens for your account in your [Settings](https://observablehq.com/settings), where you also have the option of deleting them. If you delete your token, then you will simply be prompted again the next time you access a notebook that needs them.","pinned":false,"hidden":false,"mode":"md"},{"id":174,"value":"

\"Screen — Viewing OAuth tokens in Settings.

\n\n
","pinned":false,"hidden":false,"mode":"html"},{"id":43,"value":"## Removing a reference to a cloud file\n\nYou can remove references to cloud files in your notebook with the following steps: \n1. First, just delete the `FileAttachment` reference (or the whole cell) that refers to the cloud file.\n2. Then, go back to the **Cloud files** menu in the **Data pane** and remove the linked file using the three dots menu (...) next to the file.\n","pinned":false,"hidden":false,"mode":"md"},{"id":183,"value":"

\n \n

Managing cloud files in the Data pane.

\n\n
","pinned":false,"hidden":false,"mode":"html"},{"id":47,"value":"## Cloud files in public notebooks: not supported\n\nCloud files use the OAuth credential of the user who is viewing the notebook. This user must be signed into Observable. Therefore, *using cloud files in public notebooks is not supported*. \n\nYou can create a public notebook with the information from a cloud file if you first snapshot the cloud file to a regular file attachment. \n1. Download a version of the cloud file.\n2. Attach it to the notebook using the **File attachments** option in the **Data pane**.\n\nSee [File Attachments](https://observablehq.com/@observablehq/file-attachments) for more information.","pinned":false,"hidden":false,"mode":"md"},{"id":423,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":422,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":421,"value":"import {pro} from \"@observablehq/pro-tag\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}