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

# AI Spreadsheets

> Generate, view, edit, and export Excel-compatible spreadsheets with formulas, charts, and formatting.

AI Spreadsheets lets you generate full Excel-compatible spreadsheets from a text prompt. The agent creates .xlsx files with formulas, charts, conditional formatting, data validation, and professional styling. You view and edit the result in an interactive grid directly in Runable, or download it and open it in Excel, Google Sheets, or any spreadsheet app.

## What the agent can build

When you describe what you need, the agent creates a complete workbook with:

<AccordionGroup>
  <Accordion title="Formulas and calculations">
    SUMIFS, INDEX/MATCH, COUNTIFS, IFERROR, TEXT, EDATE, and more. The agent writes formulas that reference cells, ranges, and other sheets so your data stays dynamic.
  </Accordion>

  <Accordion title="Charts">
    Bar charts, line charts, and other visualizations embedded in the workbook with labels, titles, and axis formatting.
  </Accordion>

  <Accordion title="Conditional formatting">
    Color scales for heatmaps, data bars for progress indicators, and cell rules for threshold-based highlighting (for example, margins below 10% flagged in red).
  </Accordion>

  <Accordion title="Data validation">
    Dropdown lists, input constraints, and validation rules that control what can be entered into cells.
  </Accordion>

  <Accordion title="Multiple sheets">
    Workbooks with multiple tabs. The agent can include an index sheet with hyperlinks for navigation between sheets.
  </Accordion>

  <Accordion title="Professional styling">
    Themed colors, hidden gridlines, freeze panes for headers, auto-filters for large tables, and properly sized columns.
  </Accordion>
</AccordionGroup>

## Example prompts

<Prompt description={`Monthly P&L tracker for a small restaurant`} actions={["copy"]}>
  Create an Excel spreadsheet for tracking monthly profit and loss at my restaurant, The Green Table. Include these sheets: (1) a Revenue sheet with columns for date, revenue source (dine-in, takeout, catering, delivery), amount, and payment method, with monthly subtotals and a running annual total using SUMIFS. (2) An Expenses sheet with columns for date, category (food cost, labor, rent, utilities, marketing, supplies, insurance), vendor name, amount, and payment method, with category subtotals per month. (3) A Monthly P\&L Summary sheet that pulls from Revenue and Expenses using formulas to show total revenue, total expenses, and net profit for each month with a YTD column. Add a bar chart showing monthly net profit trend. (4) A Dashboard sheet with KPIs: food cost percentage (target under 30%), labor cost percentage (target under 35%), and net profit margin. Use conditional formatting to highlight months where food cost exceeds 30% in red. Freeze the header row on every sheet. Professional styling.
</Prompt>

<Prompt description={`Client project tracker for a freelance designer`} actions={["copy"]}>
  Create a project tracking spreadsheet for my freelance web design business. I need: (1) an Active Projects sheet with columns for client name, project type (website, branding, landing page), start date, deadline, status (dropdown: Not Started, In Progress, Review, Complete), quoted price, hours estimated, hours logged, and notes. Add conditional formatting so overdue projects (past deadline and not Complete) highlight in red. (2) A Completed Projects sheet with the same columns plus a "final invoice amount" and "date paid" column. (3) A Financial Summary sheet that calculates total revenue by month, average project value, average hourly rate (revenue / hours), and a monthly revenue line chart. (4) A Prospects sheet for tracking leads: name, email, project type, estimated budget, lead source, follow-up date, and status (dropdown: New, Contacted, Proposal Sent, Won, Lost). Add auto-filters on all sheets and freeze the header rows.
</Prompt>

<Prompt description={`Inventory tracker for a small retail store`} actions={["copy"]}>
  Build an inventory management spreadsheet for my boutique clothing store. Include: (1) an Inventory sheet with columns for SKU, product name, category (dropdown: Tops, Bottoms, Dresses, Accessories, Outerwear), size, color, cost price, retail price, quantity in stock, reorder point, and supplier. Use conditional formatting to highlight any item where quantity in stock is at or below the reorder point in yellow. (2) A Sales Log sheet with date, SKU (dropdown from inventory), quantity sold, and a formula that calculates revenue per sale by looking up the retail price. (3) A Summary sheet with total inventory value (cost), total inventory value (retail), number of items below reorder point, top 10 selling products by quantity, and gross margin by category. Add a bar chart comparing revenue by category. Freeze headers, auto-filters, clean formatting.
</Prompt>

## The interactive viewer

Generated spreadsheets open in an interactive grid in the side panel. You can scroll through data, switch between sheets, and click into cells to view their content.

### Edit mode

Click the **Edit** button above the grid to enable editing. In edit mode you can:

* Edit cell values by clicking into any cell and typing
* Insert or delete rows and columns
* Move rows and columns
* Sort and paste data

Changes save automatically within a few seconds.

<Tip>
  Click **Exit Edit** when you are done to return to read-only view and prevent accidental changes.
</Tip>

## What the viewer does not support

The interactive viewer in Runable does not support everything a desktop spreadsheet app does. These limitations apply to the in-browser viewer only. The downloaded .xlsx file retains all features.

* Formulas display their calculated values but cannot be executed or edited in the viewer
* You cannot apply cell formatting (colors, borders, fonts) through the viewer
* You cannot create or edit charts through the viewer
* You cannot merge cells through the viewer

<Tip>
  If you need changes to formulas, charts, formatting, or structure, ask the agent in the chat. The agent can edit existing spreadsheets by updating cells, adding sheets, changing formulas, and restyling.
</Tip>

## Next steps

<CardGroup cols={2}>
  <Card icon="upload" href="/upload-and-view-xlsx-csv" title="Upload & View XLSX / CSV">
    Upload an existing spreadsheet file and view it in the interactive grid.
  </Card>

  <Card icon="file-export" href="/export" title="Export">
    Download your spreadsheet as XLSX or CSV.
  </Card>
</CardGroup>