> ## Documentation Index > Fetch the complete documentation index at: https://anaconda.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # Datasets Anaconda Toolbox Excel add-in has reached [end of life](https://anaconda.com/docs/reference/policies-practices/software-version-support.md#end-of-life-eol) and is no longer supported. Cells using `=ANACONDA.CODE()` will stop working on April 30, 2027. Python in Excel's `=PY()` formulas are unaffected by this retirement. Dismiss banner Datasets enable you to securely upload and update datasets in Anaconda's cloud storage. You can then provide access to other users, as well as import your datasets to a separate workbook to continue your data analysis from any machine, anytime. > [!TIP] > > Want to dive deeper? [Sign in to Anaconda.com](https://auth.anaconda.com/ui/login?return_to=https://anaconda.com/app/) and explore our [Data Visualization with Python in Excel](https://learning.anaconda.com/courses/data-visualization-with-python-in-excel) course, available to Anaconda's paid subscribers. ## Understanding datasets Let's take a look at the different elements and tabs within Datasets. ![](https://mintcdn.com/anaconda-29683c67/r-i16GgDcvoHQ-Uq/images/excel/dataset_anatomy.png?fit=max\&auto=format\&n=r-i16GgDcvoHQ-Uq\&q=85\&s=63f3ec7dcf64dab6447406e3a63f1a14) **1. Cloud** Shows all projects and project contents **2. Connections** Displays datasets previously uploaded to or downloaded from Anaconda's cloud storage **3. New Project** Create a new project to store and share datasets (sheets and tables) **4. New Dataset** Create a new dataset and assign it to a project **5. Filters** Apply filters to efficiently locate data in your catalog **6. My Datasets** A collection of all your cloud projects and their nested datasets **7. User Datasets** Projects to which you have access, owned by other individuals **8. Organization Datasets** Projects to which you have access, owned by organizations **9. Status Icons** Indicates the [connection status](#understanding-status-icons) of your dataset ## Creating a project When you first access Datasets, you are prompted to create a new project. You can think of projects as folders for storing your datasets. Create a project at any time using the following steps: 1. From the **Cloud** tab, click **+ New Project**. ![](https://mintcdn.com/anaconda-29683c67/r-i16GgDcvoHQ-Uq/images/excel/dataset_new_project.png?fit=max\&auto=format\&n=r-i16GgDcvoHQ-Uq\&q=85\&s=da4a1b72d707d117e671f2615e8c509c) 2. Enter a unique title for your project and an optional description. 3. Designate the project owner(s) for your project. By default, you are set as the only project owner. > [!NOTE] > > Administrators and project owners are the only users allowed to edit projects. Anaconda.com organization administrators have full permissions for any projects owned by their organization. 4. (Optional) Provide access to your project by [inviting users](#sharing-a-project-with-other-users) from one of your organizations. 5. Click **Save**. ## Sharing a project with other users You can share a project to collaborate with others in your organization when creating a new project, or at any time using the following steps: 1. From the **Cloud** tab, click actions beside a project for which you have edit permissions, then click **Edit**. 2. Provide access to your project by inviting users from one of your [organizations](https://anaconda.com/app/profile/organizations). 1. Under **Your Organizations**, select an organization. 2. Under **Organization Users**, select a user to share your project with. 3. Choose whether the user should have read or write access to your project. 3. Click **Save**. ### Permissions Access to projects and the actions you can perform in them are determined by your permission level for the project. By default, you as the owner of your project have admin permissions; for projects owned by an organization, the admins of that organization have admin permissions for that project. | Permission level | Actions | | :- | :- | | Read | View, download | | Edit | View, download, upload | | Admin | View, download, upload, share, delete | ## Uploading data Protect your local datasets and increase their accessibility by saving them in cloud storage. If you experience hardware failure, or need to work on a different device, your projects will be right where you left them! Upload sheets and tables to your projects using the following steps: 1. From the **Cloud** tab, click **+ New Dataset**. ![](https://mintcdn.com/anaconda-29683c67/r-i16GgDcvoHQ-Uq/images/excel/dataset_upload.png?fit=max\&auto=format\&n=r-i16GgDcvoHQ-Uq\&q=85\&s=763e687bac58c3b7ff6770f20bba4fc8) 2. Under **Data**, choose a range of data manually, a specific table, or an entire sheet. 3. Under **Project**, select a project to house your dataset. 4. Under **Dataset Title**, provide a title for your dataset. 5. Complete the upload by clicking **Save to Cloud**. You can now see the established connection between your dataset and Anaconda's cloud storage on the **Connections** tab. ![](https://mintcdn.com/anaconda-29683c67/r-i16GgDcvoHQ-Uq/images/excel/dataset_upload_result.png?fit=max\&auto=format\&n=r-i16GgDcvoHQ-Uq\&q=85\&s=f9085c4ba842c7ef2c7629efcd575d38) When you make changes to the dataset, **re-upload** it to update the dataset stored in the cloud. ## Downloading data If another user shares a project with you, or if you've uploaded a dataset in another workbook or Anaconda Notebook, **download** appears beside that dataset. Datasets can be downloaded as either an Excel range reference or as an Anaconda Code object. > [tab] Excel Range > > To download a dataset as an Excel range reference: > > 1. Click **download** beside the dataset you want to download. > 2. Under **Workbook Placement**, select the sheet where you want to insert the data. > 3. Complete the download by clicking **Download to Workbook**. > > The data is now available in the selected sheet. > [tab] Anaconda Code object > > To download a dataset as an Anaconda Code object: > > 1. Click **download** beside the dataset you want to download. > 2. Click **Import as Anaconda Code object**. > > > [!NOTE] > > > > If you're unable to click **Import as Anaconda Code object**, go to **Settings** and, under **Generate Toolbox code as:**, select **Anaconda Code (=ANACONDA.CODE).** > > > > ![](https://mintcdn.com/anaconda-29683c67/r-i16GgDcvoHQ-Uq/images/excel/generate_as_anaconda_code.png?fit=max\&auto=format\&n=r-i16GgDcvoHQ-Uq\&q=85\&s=8e43513b13cacddb34b59e16c7babfbd) > 3. Click **Click to select**. > 4. Select an empty cell. > 5. Click **OK** in the Select Data dialog. > 6. Click **Download to Workbook**. > > The selected cell will display **PyScript Data**. Click to see details about the object. ## Understanding status icons Status icons appear by each dataset. Click the icons to perform the following functions: | Icon | Name | Function | | :- | :- | :- | | | Upload | Click to upload a dataset in your workbook to Anaconda's cloud storage. | | | Re-upload | Click to re-upload the dataset in your workbook to Anaconda's cloud storage. | | | Download | Click to download a dataset from Anaconda's cloud storage to your workbook. | | | Re-download | The dataset on Anaconda's cloud storage has been updated. Click to update the dataset in your Excel workbook with these changes. | | | Synced | The dataset in your Excel workbook is up-to-date with the dataset in Anaconda's cloud storage. | | | Conflict | The dataset on Anaconda's cloud storage has been updated and now conflicts with the dataset in your Excel Workbook. Click to resolve the conflict. |