# Make a sheet

> Ask your agent for a budget, a tracker, a forecast or a report, from a line, a CSV or your Excel file. It opens in AllyHub's editor beside your chat, works like Excel, and exports to Excel with its formulas live.

Source: https://allyhub.com/docs/make/sheets · Updated 2026-11-15
Index of all docs: https://allyhub.com/llms.txt

Ask for a sheet and it opens beside your chat: real formulas, tables, charts, all of it working like Excel. Then mark up what's wrong and your agent fixes it. Making sheets is free, and you don't need an account.

## Start from one line

Say what goes in it and what you want to see. Attach your data as it is: an export from your bank, your store or your CRM. Start with **Use AllyHub**: your agent may have its own way to make a spreadsheet, and this tells it which one you mean.

```text
Use AllyHub to build a sheet of our 2026 revenue from this export: month, revenue, cost, profit, margin and growth month on month, with totals and a chart of revenue, cost and margin.
```

Back came a sheet that does the maths itself. Profit, margin and growth are formulas, so change a number and everything follows. Revenue got bars, margin a colour scale, growth arrows, and the chart puts margin on its own axis.

![A sheet from one request in ChatGPT: the request with the year's export attached (1), and the sheet in AllyHub's editor beside the chat, with the link that opens it again (2).](https://allyhub.com/pictures/docs/make/sheets-1.webp)

*1 What we asked, with the export. 2 The link that opens the sheet again.*

## Bring your Excel file

Already have a spreadsheet? Attach it and say what it should become:

```text
Use AllyHub to turn our customer list into a sheet we can keep up to date: the plan picked from a list, tags we can pick several of, and monthly revenue as bars.
```

The list came back as a table you can sort and filter, with the plan as a dropdown and tags as chips.

![A sheet made from an Excel file attached in ChatGPT (1): the customers as a table, the plan picked from a list (2), tags shown as chips, several to a customer (3), and monthly revenue as bars (4).](https://allyhub.com/pictures/docs/make/sheets-2.webp)

*1 The Excel file, attached. 2 The plan, from a list. 3 Tags, several to a customer. 4 Monthly revenue as bars.*

Formulas, formats, tables, filters, charts and notes come across from Excel. Macros and pivot tables don't, and your agent tells you what was left behind.

## Get a better first version

A few words in your request go a long way:

- **The columns:** "month, revenue, cost, profit". Say which ones are worked out, and how.
- **The numbers that matter:** "totals", "growth month on month", "margin as a percentage".
- **How it should look:** "bars for revenue", "red when margin drops below 30%", "arrows for growth".
- **What to choose from:** "plan from a list: Plus, Pro, Max". People then pick, instead of typing.
- **The chart:** what it shows, and what goes on a second axis.

## Mark it up

Circle what's wrong, and your agent fixes it. A box round the chart and "add profit as a line" says more than a paragraph.

In ChatGPT, you mark up with its **Annotate** button:

1. Press **Annotate** at the top of the browser pane.
2. Drag a box round the part: a cell, a column, a chart.
3. Write what to change, and press the tick.
4. Press **Send**. Your note goes to the chat, and your agent gets to work.

![Marking up a sheet in ChatGPT: Annotate is pressed at the top of the browser pane, a box is dragged round the chart, the note “Add profit to the chart as a line” is typed under it and kept with the tick, then Send puts the note in the chat as 1 annotation and the agent starts on it.](https://allyhub.com/pictures/docs/make/sheets-annotate.webp)

In Claude's app, press the pointer button at the right end of the pane's address bar, mark what you mean with its pen, box or text, then press **Add to chat**.

Or just say it in the chat: "add a quarterly summary", "sort by margin", "show 2025 beside it".

### Watch it fix it

The editor shows your agent at work: **AllyHub is editing** at the top, and a dot on the sheet's tab. Here the chart gets its profit line while you watch.

![The sheet as the agent changes it: AllyHub is editing at the top, a dot on the 2026 tab, and a profit line appearing on the chart.](https://allyhub.com/media/docs/make/sheets/change.webp)

## Edit it yourself

A number, a label, a colour? Click and type, as in Excel. What you change is saved to the sheet, and your agent sees it next time you ask.

![The revenue sheet in AllyHub's editor: a table with bars on revenue, a colour scale on margin and arrows on growth, totals under it, and a chart of revenue, cost and margin.](https://allyhub.com/media/docs/make/sheets/sheet.webp)

Here we typed a new December, and profit, margin, growth, the totals and the chart all followed. Then an average with a formula, made a percentage, and a tag ticked for a customer:

![Editing the sheet by hand: December's revenue is typed and the totals and chart change; =AVERAGE is typed with suggestions and made a percentage; on the Customers sheet, pilot is ticked in a customer's tags.](https://allyhub.com/media/docs/make/sheets/edit-by-hand.webp)

**Formulas** are Excel's, and the editor suggests functions as you type:

![Typing =AVER in a cell: AVERAGE, AVERAGEA, AVERAGEIF and AVERAGEIFS suggested, with what AVERAGE does.](https://allyhub.com/media/docs/make/sheets/formula.webp)

**Tables** sort and filter from their headers:

![A table column's filter menu: sort smallest to largest or largest to smallest, a search, and each value with a tick.](https://allyhub.com/media/docs/make/sheets/filter.webp)

**Dropdowns** keep entries tidy, and can hold several choices at once, shown as chips:

![A tags cell open on the Customers sheet: its chips over a list of tags, pilot and new ticked.](https://allyhub.com/media/docs/make/sheets/tags.webp)

**Charts** follow their cells. Click one for its **Chart Design** bar: change its type, its data, its title or its legend. There are 16 kinds, and a column chart can carry a line on a second axis.

![A chart selected, with its Chart Design bar: Change Chart Type, Select Data, the title and Legend.](https://allyhub.com/media/docs/make/sheets/chart.webp)

The toolbar has the rest you'd expect: number formats, colours and borders, conditional formatting (bars, colour scales, icons), freeze panes, find, data validation and more sheets.

## Get the file

Press **Export** at the top right of the editor, pick a **Format**, and press **Export**.

| Format | Good for |
| --- | --- |
| Excel | Working on in Excel. Formulas stay live, with tables, filters, formats, dropdowns and charts |
| PDF | Sending or printing |
| PNG | Posting or pasting as a picture |
| CSV | Another tool: one file a sheet |

Or just ask your agent for the file.

## What's free

Making, changing and exporting sheets is free, with no account. AllyHub's AI tools cost credits: AI research on real data, and AI images and voice; see [Pricing](https://allyhub.com/pricing).
