> ## 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

export const Conflict = ({small}) => {
  if (small) {
    return <span className="inline_icon">
        <svg class="inline" width="16" height="16" viewBox="0 0 512 512" xmlns="http://www.w3.org/2000/svg">
          <path d="M10 2c2.82 0 4.41 1.92 4.65 4.25h.07a3.33 3.33 0 0 1 3.27 3.66c-.32-.4-.7-.76-1.12-1.07a2.3 2.3 0 0 0-2.15-1.6h-.07a1 1 0 0 1-1-.9C13.45 4.33 12.11 3 10 3S6.55 4.32 6.35 6.35a1 1 0 0 1-1 .9h-.07A2.33 2.33 0 0 0 3 9.62 2.33 2.33 0 0 0 5.28 12h2.67c-.09.32-.15.66-.18 1H5.28A3.33 3.33 0 0 1 2 9.62c0-1.8 1.37-3.27 3.1-3.37h.25C5.6 3.9 7.18 2 10 2Zm8 11.5a4.5 4.5 0 1 1-9 0 4.5 4.5 0 0 1 9 0Zm-3.8 0 1.15-1.15a.5.5 0 0 0-.7-.7l-1.15 1.14-1.15-1.14a.5.5 0 0 0-.7.7l1.14 1.15-1.14 1.15a.5.5 0 0 0 .7.7l1.15-1.14 1.15 1.14a.5.5 0 0 0 .7-.7l-1.14-1.15Z" fill="#dc3246"></path>
        </svg>
      </span>;
  }
  return <span className="inline_icon">
      <svg class="inline ___12fm75w f1w7gpdv fez10in fg4l7m0" aria-hidden="true" width="60" height="60" viewBox="0 0 22 23" xmlns="http://www.w3.org/2000/svg">
        <path d="M10 2c2.82 0 4.41 1.92 4.65 4.25h.07a3.33 3.33 0 0 1 3.27 3.66c-.32-.4-.7-.76-1.12-1.07a2.3 2.3 0 0 0-2.15-1.6h-.07a1 1 0 0 1-1-.9C13.45 4.33 12.11 3 10 3S6.55 4.32 6.35 6.35a1 1 0 0 1-1 .9h-.07A2.33 2.33 0 0 0 3 9.62 2.33 2.33 0 0 0 5.28 12h2.67c-.09.32-.15.66-.18 1H5.28A3.33 3.33 0 0 1 2 9.62c0-1.8 1.37-3.27 3.1-3.37h.25C5.6 3.9 7.18 2 10 2Zm8 11.5a4.5 4.5 0 1 1-9 0 4.5 4.5 0 0 1 9 0Zm-3.8 0 1.15-1.15a.5.5 0 0 0-.7-.7l-1.15 1.14-1.15-1.14a.5.5 0 0 0-.7.7l1.14 1.15-1.14 1.15a.5.5 0 0 0 .7.7l1.15-1.14 1.15 1.14a.5.5 0 0 0 .7-.7l-1.14-1.15Z" fill="#dc3246"></path>
      </svg>
    </span>;
};

export const Synced = ({small}) => {
  if (small) {
    return <span className="inline_icon">
        <svg class="inline" width="16" height="16" viewBox="0 0 512 512" xmlns="http://www.w3.org/2000/svg">
          <path d="M10 2c2.82 0 4.41 1.92 4.65 4.25h.07a3.33 3.33 0 0 1 3.27 3.66c-.32-.4-.7-.76-1.12-1.07a2.3 2.3 0 0 0-2.15-1.6h-.07a1 1 0 0 1-1-.9C13.45 4.33 12.11 3 10 3S6.55 4.32 6.35 6.35a1 1 0 0 1-1 .9h-.07A2.33 2.33 0 0 0 3 9.62 2.33 2.33 0 0 0 5.28 12h2.67c-.09.32-.15.66-.18 1H5.28A3.33 3.33 0 0 1 2 9.62c0-1.8 1.37-3.27 3.1-3.37h.25C5.6 3.9 7.18 2 10 2Zm8 11.5a4.5 4.5 0 1 1-9 0 4.5 4.5 0 0 1 9 0Zm-2.85-1.85-2.65 2.64-.65-.64a.5.5 0 0 0-.7.7l1 1c.2.2.5.2.7 0l3-3a.5.5 0 0 0-.7-.7Z" fill="#0cca4a"></path>
        </svg>
      </span>;
  }
  return <span className="inline_icon">
      <svg class="inline" width="60" height="60" viewBox="0 0 22 23" xmlns="http://www.w3.org/2000/svg">
        <path d="M10 2c2.82 0 4.41 1.92 4.65 4.25h.07a3.33 3.33 0 0 1 3.27 3.66c-.32-.4-.7-.76-1.12-1.07a2.3 2.3 0 0 0-2.15-1.6h-.07a1 1 0 0 1-1-.9C13.45 4.33 12.11 3 10 3S6.55 4.32 6.35 6.35a1 1 0 0 1-1 .9h-.07A2.33 2.33 0 0 0 3 9.62 2.33 2.33 0 0 0 5.28 12h2.67c-.09.32-.15.66-.18 1H5.28A3.33 3.33 0 0 1 2 9.62c0-1.8 1.37-3.27 3.1-3.37h.25C5.6 3.9 7.18 2 10 2Zm8 11.5a4.5 4.5 0 1 1-9 0 4.5 4.5 0 0 1 9 0Zm-2.85-1.85-2.65 2.64-.65-.64a.5.5 0 0 0-.7.7l1 1c.2.2.5.2.7 0l3-3a.5.5 0 0 0-.7-.7Z" fill="#0cca4a"></path>
      </svg>
    </span>;
};

export const Redownload = ({small}) => {
  if (small) {
    return <span className="inline_icon">
        <svg class="inline" width="16" height="16" viewBox="0 0 512 512" xmlns="http://www.w3.org/2000/svg">
          <path fill="currentColor" d="M10 2c2.82 0 4.41 1.92 4.65 4.25h.07a3.33 3.33 0 0 1 3.27 3.66A5.74 5.74 0 0 0 7.77 13H5.28A3.33 3.33 0 0 1 2 9.62a3.33 3.33 0 0 1 3.28-3.37h.07C5.6 3.9 7.18 2 10 2Zm3.5 16a4.5 4.5 0 1 1 0-9 4.5 4.5 0 0 1 0 9Zm1.6-4.9L14 14.2v-2.7a.5.5 0 0 0-1 0v2.7l-1.1-1.1a.56.56 0 1 0-.8.8l2 2c.22.22.58.22.8 0l2-2a.56.56 0 1 0-.8-.8Z"></path>
        </svg>
      </span>;
  }
  return <span className="inline_icon">
      <svg class="inline" width="60" height="60" viewBox="0 0 22 23" xmlns="http://www.w3.org/2000/svg">
        <path fill="currentColor" d="M10 2c2.82 0 4.41 1.92 4.65 4.25h.07a3.33 3.33 0 0 1 3.27 3.66A5.74 5.74 0 0 0 7.77 13H5.28A3.33 3.33 0 0 1 2 9.62a3.33 3.33 0 0 1 3.28-3.37h.07C5.6 3.9 7.18 2 10 2Zm3.5 16a4.5 4.5 0 1 1 0-9 4.5 4.5 0 0 1 0 9Zm1.6-4.9L14 14.2v-2.7a.5.5 0 0 0-1 0v2.7l-1.1-1.1a.56.56 0 1 0-.8.8l2 2c.22.22.58.22.8 0l2-2a.56.56 0 1 0-.8-.8Z"></path>
      </svg>
    </span>;
};

export const Download2 = ({small}) => {
  if (small) {
    return <span className="inline_icon">
        <svg class="inline" width="16" height="16" viewBox="0 0 512 512" xmlns="http://www.w3.org/2000/svg">
          <path d="M10 2c2.82 0 4.41 1.92 4.65 4.25h.07a3.33 3.33 0 0 1 3.27 3.66c-.32-.4-.7-.76-1.12-1.07a2.3 2.3 0 0 0-2.15-1.6h-.07a1 1 0 0 1-1-.9C13.45 4.33 12.11 3 10 3S6.55 4.32 6.35 6.35a1 1 0 0 1-1 .9h-.07A2.33 2.33 0 0 0 3 9.62 2.33 2.33 0 0 0 5.28 12h2.67c-.09.32-.15.66-.18 1H5.28A3.33 3.33 0 0 1 2 9.62c0-1.8 1.37-3.27 3.1-3.37h.25C5.6 3.9 7.18 2 10 2Zm3.5 16a4.5 4.5 0 1 1 0-9 4.5 4.5 0 0 1 0 9Zm1.6-4.9L14 14.2v-2.7a.5.5 0 0 0-1 0v2.7l-1.1-1.1a.56.56 0 1 0-.8.8l2 2c.22.22.58.22.8 0l2-2a.56.56 0 1 0-.8-.8Z" fill="currentColor"></path>
        </svg>
      </span>;
  }
  return <span className="inline_icon">
      <svg class="inline" width="60" height="60" viewBox="0 0 22 23" xmlns="http://www.w3.org/2000/svg">
        <path d="M10 2c2.82 0 4.41 1.92 4.65 4.25h.07a3.33 3.33 0 0 1 3.27 3.66c-.32-.4-.7-.76-1.12-1.07a2.3 2.3 0 0 0-2.15-1.6h-.07a1 1 0 0 1-1-.9C13.45 4.33 12.11 3 10 3S6.55 4.32 6.35 6.35a1 1 0 0 1-1 .9h-.07A2.33 2.33 0 0 0 3 9.62 2.33 2.33 0 0 0 5.28 12h2.67c-.09.32-.15.66-.18 1H5.28A3.33 3.33 0 0 1 2 9.62c0-1.8 1.37-3.27 3.1-3.37h.25C5.6 3.9 7.18 2 10 2Zm3.5 16a4.5 4.5 0 1 1 0-9 4.5 4.5 0 0 1 0 9Zm1.6-4.9L14 14.2v-2.7a.5.5 0 0 0-1 0v2.7l-1.1-1.1a.56.56 0 1 0-.8.8l2 2c.22.22.58.22.8 0l2-2a.56.56 0 1 0-.8-.8Z" fill="currentColor"></path>
      </svg>
    </span>;
};

export const Reupload = ({small}) => {
  if (small) {
    return <span className="inline_icon">
        <svg class="inline" width="16" height="16" viewBox="0 0 512 512" xmlns="http://www.w3.org/2000/svg">
          <path fill="currentColor" d="M10 2c2.82 0 4.41 1.92 4.65 4.25h.07a3.33 3.33 0 0 1 3.27 3.66c-.32-.4-.7-.76-1.12-1.07a2.3 2.3 0 0 0-2.15-1.6h-.07a1 1 0 0 1-1-.9C13.45 4.33 12.11 3 10 3S6.55 4.32 6.35 6.35a1 1 0 0 1-1 .9h-.07A2.33 2.33 0 0 0 3 9.62 2.33 2.33 0 0 0 5.28 12h2.67c-.09.32-.15.66-.18 1H5.28A3.33 3.33 0 0 1 2 9.62c0-1.8 1.37-3.27 3.1-3.37h.25C5.6 3.9 7.18 2 10 2Zm3.5 7a4.5 4.5 0 1 1 0 9 4.5 4.5 0 0 1 0-9Zm1.6 4.9a.56.56 0 1 0 .8-.8l-2-2a.56.56 0 0 0-.8 0l-2 2a.56.56 0 1 0 .8.8l1.1-1.1v2.7a.5.5 0 0 0 1 0v-2.7l1.1 1.1Z"></path>
        </svg>
      </span>;
  }
  return <span className="inline_icon">
      <svg class="inline" width="60" height="60" viewBox="0 0 22 23" xmlns="http://www.w3.org/2000/svg">
        <path fill="currentColor" d="M10 2c2.82 0 4.41 1.92 4.65 4.25h.07a3.33 3.33 0 0 1 3.27 3.66c-.32-.4-.7-.76-1.12-1.07a2.3 2.3 0 0 0-2.15-1.6h-.07a1 1 0 0 1-1-.9C13.45 4.33 12.11 3 10 3S6.55 4.32 6.35 6.35a1 1 0 0 1-1 .9h-.07A2.33 2.33 0 0 0 3 9.62 2.33 2.33 0 0 0 5.28 12h2.67c-.09.32-.15.66-.18 1H5.28A3.33 3.33 0 0 1 2 9.62c0-1.8 1.37-3.27 3.1-3.37h.25C5.6 3.9 7.18 2 10 2Zm3.5 7a4.5 4.5 0 1 1 0 9 4.5 4.5 0 0 1 0-9Zm1.6 4.9a.56.56 0 1 0 .8-.8l-2-2a.56.56 0 0 0-.8 0l-2 2a.56.56 0 1 0 .8.8l1.1-1.1v2.7a.5.5 0 0 0 1 0v-2.7l1.1 1.1Z"></path>
      </svg>
    </span>;
};

export const Upload2 = ({small}) => {
  if (small) {
    return <span className="inline_icon">
        <svg class="inline" width="16" height="16" viewBox="0 0 512 512" xmlns="http://www.w3.org/2000/svg">
          <path fill="currentColor" d="M10 2c2.82 0 4.41 1.92 4.65 4.25h.07a3.33 3.33 0 0 1 3.27 3.66c-.32-.4-.7-.76-1.12-1.07a2.3 2.3 0 0 0-2.15-1.6h-.07a1 1 0 0 1-1-.9C13.45 4.33 12.11 3 10 3S6.55 4.32 6.35 6.35a1 1 0 0 1-1 .9h-.07A2.33 2.33 0 0 0 3 9.62 2.33 2.33 0 0 0 5.28 12h2.67c-.09.32-.15.66-.18 1H5.28A3.33 3.33 0 0 1 2 9.62c0-1.8 1.37-3.27 3.1-3.37h.25C5.6 3.9 7.18 2 10 2Zm3.5 7a4.5 4.5 0 1 1 0 9 4.5 4.5 0 0 1 0-9Zm1.6 4.9a.56.56 0 1 0 .8-.8l-2-2a.56.56 0 0 0-.8 0l-2 2a.56.56 0 1 0 .8.8l1.1-1.1v2.7a.5.5 0 0 0 1 0v-2.7l1.1 1.1Z"></path>
        </svg>
      </span>;
  }
  return <span className="inline_icon">
      <svg class="inline" width="60" height="60" viewBox="0 0 22 23" xmlns="http://www.w3.org/2000/svg">
        <path fill="currentColor" d="M10 2c2.82 0 4.41 1.92 4.65 4.25h.07a3.33 3.33 0 0 1 3.27 3.66c-.32-.4-.7-.76-1.12-1.07a2.3 2.3 0 0 0-2.15-1.6h-.07a1 1 0 0 1-1-.9C13.45 4.33 12.11 3 10 3S6.55 4.32 6.35 6.35a1 1 0 0 1-1 .9h-.07A2.33 2.33 0 0 0 3 9.62 2.33 2.33 0 0 0 5.28 12h2.67c-.09.32-.15.66-.18 1H5.28A3.33 3.33 0 0 1 2 9.62c0-1.8 1.37-3.27 3.1-3.37h.25C5.6 3.9 7.18 2 10 2Zm3.5 7a4.5 4.5 0 1 1 0 9 4.5 4.5 0 0 1 0-9Zm1.6 4.9a.56.56 0 1 0 .8-.8l-2-2a.56.56 0 0 0-.8 0l-2 2a.56.56 0 1 0 .8.8l1.1-1.1v2.7a.5.5 0 0 0 1 0v-2.7l1.1 1.1Z"></path>
      </svg>
    </span>;
};

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.
</Tip>

## Understanding datasets

Let's take a look at the different elements and tabs within Datasets.

<Frame>
  <img src="https://mintcdn.com/anaconda-29683c67/PbSvZr6CkxQA7zZ5/images/dataset_anatomy.png?fit=max&auto=format&n=PbSvZr6CkxQA7zZ5&q=85&s=c8fd39bf6e79b167fbbae88c44cd93b4" alt="" style={{ width: "400px" }} width="540" height="800" data-path="images/dataset_anatomy.png" />
</Frame>

<Steps>
  <Step title="Cloud">
    Shows all projects and project contents
  </Step>

  <Step title="Connections">
    Displays datasets previously uploaded to or downloaded from Anaconda's cloud storage
  </Step>

  <Step title="New Project">
    Create a new project to store and share datasets (sheets and tables)
  </Step>

  <Step title="New Dataset">
    Create a new dataset and assign it to a project
  </Step>

  <Step title="Filters">
    Apply filters to efficiently locate data in your catalog
  </Step>

  <Step title="My Datasets">
    A collection of all your cloud projects and their nested datasets
  </Step>

  <Step title="User Datasets">
    Projects to which you have access, owned by other individuals
  </Step>

  <Step title="Organization Datasets">
    Projects to which you have access, owned by organizations
  </Step>

  <Step title="Status Icons">
    Indicates the [connection status](#understanding-status-icons) of your dataset
  </Step>
</Steps>

## 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**.

   <Frame>
     <img src="https://mintcdn.com/anaconda-29683c67/atV1FF4bOzhiwIx6/images/dataset_new_project.png?fit=max&auto=format&n=atV1FF4bOzhiwIx6&q=85&s=aa10558a3e5bbcaac20e196515fc0987" alt="" style={{ width: "400px" }} width="1092" height="2050" data-path="images/dataset_new_project.png" />
   </Frame>

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.
   </Note>

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 <Icon icon="ellipsis-vertical" iconType="solid" /> 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**.

   <Frame>
     <img src="https://mintcdn.com/anaconda-29683c67/atV1FF4bOzhiwIx6/images/dataset_upload.png?fit=max&auto=format&n=atV1FF4bOzhiwIx6&q=85&s=ce1301cf5c8164eddcf5668fbed15db1" alt="" style={{ width: "400px" }} width="556" height="800" data-path="images/dataset_upload.png" />
   </Frame>

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.

<Frame>
  <img src="https://mintcdn.com/anaconda-29683c67/atV1FF4bOzhiwIx6/images/dataset_upload_result.png?fit=max&auto=format&n=atV1FF4bOzhiwIx6&q=85&s=864748c7328fc7b866efd2db4db09371" alt="" style={{ width: "400px" }} width="557" height="800" data-path="images/dataset_upload_result.png" />
</Frame>

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.

<Tabs>
  <Tab title="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>

  <Tab title="Anaconda Code object">
    To download a dataset as an Anaconda Code object:

    1. Click **download** beside the dataset you want to download.
    2. Select **Import as Anaconda Code object**.

           <Note>
             If you're unable to select **Import as Anaconda Code object**, go to <Icon icon="gear" iconType="solid" /> **Settings** and, under **Generate Toolbox code as:**, select **Anaconda Code (=ANACONDA.CODE).**

             <Frame>
               <img src="https://mintcdn.com/anaconda-29683c67/6VLBNxmQuUc6ZAMN/images/generate_as_anaconda_code.png?fit=max&auto=format&n=6VLBNxmQuUc6ZAMN&q=85&s=f8e8d013debf33a9220b6c1f0e93fe90" alt="" width="1438" height="684" data-path="images/generate_as_anaconda_code.png" />
             </Frame>
           </Note>
    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 <Icon icon="cloud" iconType="regular" /> **PyScript Data**. Click <Icon icon="cloud" iconType="regular" /> to see details about the object.
  </Tab>
</Tabs>

## Understanding status icons

Status icons appear by each dataset. Click the icons to perform the following functions:

| Icon           | Name        | Function                                                                                                                                           |
| :------------- | :---------- | :------------------------------------------------------------------------------------------------------------------------------------------------- |
| <Upload2 />    | Upload      | Click to upload a dataset in your workbook to Anaconda's cloud storage.                                                                            |
| <Reupload />   | Re-upload   | Click to re-upload the dataset in your workbook to Anaconda's cloud storage.                                                                       |
| <Download2 />  | Download    | Click to download a dataset from Anaconda's cloud storage to your workbook.                                                                        |
| <Redownload /> | 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 />     | Synced      | The dataset in your Excel workbook is up-to-date with the dataset in Anaconda's cloud storage.                                                     |
| <Conflict />   | 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. |
