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

# Anaconda Toolbox Excel Add-in

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

The Anaconda Toolbox Excel add-in includes two powerful components: **Anaconda Toolbox** and **Anaconda Code**. Together, they transform your spreadsheet workflows with AI-powered assistance, seamless code sharing, and the flexibility of Python.

> [!TIP]
>
> Powered by Anaconda—the same team that provides the Python libraries for Microsoft's Python in Excel.

> [card] [Installation Guide](https://anaconda.com/docs/legacy/excel/install.md)
>
> Get up and running with the Anaconda Toolbox Excel add-in in minutes.

## Anaconda Toolbox

Anaconda Toolbox makes Python accessible from your spreadsheets, even if you're not an expert. Quickly generate, save, and share code across Excel and Notebooks, create visualizations, and get help from our Anaconda Assistant, learning Python as you go.

### Key features

> [card] [Transform Tables into Visualizations](https://anaconda.com/docs/legacy/excel/toolbox/visualize.md)
>
> See your data come to life through the power of charts and interactive visualizations.

> [card] [Meet Anaconda Assistant](https://anaconda.com/docs/legacy/excel/toolbox/assistant.md)
>
> Your AI-powered assistant for Python-centric tasks in Excel, helping you learn as you work.

> [card] [Sync Your Data Anywhere](https://anaconda.com/docs/legacy/excel/toolbox/data.md)
>
> Start in one workbook, pick up in another—your data follows you with cloud storage integration.

> [card] [Run Code Again and Again](https://anaconda.com/docs/legacy/excel/toolbox/snippets.md)
>
> Upload, share, and reuse your favorite snippets of code across projects.

## Anaconda Code

[Anaconda Code](https://anaconda.com/docs/legacy/excel/code.md) empowers you to write Python or R code and run it locally, directly within Excel. This gives you flexibility and control over the environment in your workbook, allowing you to add and remove packages as needed, all while keeping code and data securely within your workbook.

> [!NOTE]
>
> Anaconda Code operates independently of Microsoft's Python in Excel feature.

### Key features

> [card] [Write and Execute Code](https://anaconda.com/docs/legacy/excel/code.md#running-code)
>
> Write Python or R code directly in Excel cells and run it locally within your workbook environment.

> [card] [Create Custom Functions](https://anaconda.com/docs/legacy/excel/code.md#creating-user-defined-functions)
>
> Build user-defined functions (UDFs) that can be called from any Excel cell using standard Excel formulas.

> [card] [Reference Worksheet Data](https://anaconda.com/docs/legacy/excel/code.md#using-the-ref-function)
>
> Connect your code to Excel data using the REF function to pull ranges directly into your Python or R scripts.

> [card] [Manage Your Environment](https://anaconda.com/docs/legacy/excel/code.md#managing-the-environment)
>
> Add and remove packages or choose different Pyodide or WebR versions to customize your coding environment.