> ## Documentation Index
> Fetch the complete documentation index at: https://docs.macro.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Spreadsheets

> Collaborative spreadsheets with formulas, charts, comments, and Excel import and export.

Spreadsheets support real-time editing by multiple people. [Agents](/product/agents) can read, calculate, and edit spreadsheets.

> To create a spreadsheet use shortcut <kbd>c</kbd> + <kbd>b</kbd>.

## Creating and importing

Press <kbd>c</kbd> + <kbd>b</kbd>, choose **Spreadsheet** from the **Create** menu, or choose **New → Spreadsheet** in [Drive](/product/drive).

Uploaded `.xlsx`, `.xlsm`, and `.csv` files open in a read-only preview with **Import notes**. **Edit in Macro** creates an editable copy. The original file is unchanged.

**Import and export → Import…** in the bottom-right corner imports a file into an open spreadsheet as new sheets or as a replacement.

Imports keep formulas, formatting, conditional formatting, dropdowns, notes, charts, images, and shapes. Macros in `.xlsm` files are removed.

## Editing

Type in a selected cell or double-click it to edit. Formulas start with `=`. Function suggestions and arguments appear while typing a formula. Click or drag across cells to insert a reference.

The toolbar has number formats, fonts, colors, borders, alignment, wrapping, and find and replace (<kbd>cmd</kbd>+<kbd>f</kbd>).

Drag the fill handle to fill a series. <kbd>cmd</kbd>+<kbd>d</kbd> fills down. <kbd>cmd</kbd>+<kbd>r</kbd> fills right.

**Format and data** includes:

* **Dropdown…**
* Sort
* Trim whitespace
* **Goal Seek…**

Type `@` in a cell to mention people, documents, channels, emails, or dates.

## Charts and images

**Insert chart or image** adds a chart from the selected cells. Chart types: column, bar, line, area, pie, doughnut, scatter, combo, radar, bubble, stock, and contour. Charts update when their data changes. Double-click a chart to edit it.

## Sheets

Click **+** to add a sheet. Double-click a tab to rename it. Drag tabs to reorder. Right-click a tab to duplicate, move, or delete it.

Formulas can reference other sheets, for example `='Launch budget'!B9`.

## Comments

Select cells and click **Comment**, or press <kbd>cmd</kbd>+<kbd>opt</kbd>+<kbd>m</kbd>. Commented cells show a triangle. **Comments** in the header lists all threads and the spreadsheet **Discussion**. Threads can be resolved and reopened.

## Ask Macro

**Ask Macro** opens an agent conversation with the selected cells attached. The agent can answer questions, run calculations without changing the spreadsheet, or edit it if you have edit access.

## Exporting

**Import and export** has **Download as Excel (.xlsx)**, which exports all sheets with formulas and formatting, and **Download as CSV**, which exports values from the current sheet.

## Sharing

Spreadsheets have owner, editor, commenter, and viewer access, team access, and links. Viewers can select and copy cells.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.