---
title: "Kition sheet: Spreadsheet editing"
description: "xlsx) directly. It has its own formula engine with close to 500 Excel functions, plus formatting, tables, charts and PivotTables."
canonical: "https://kition.ai/kits/sheet"
---

> Canonical HTML: [https://kition.ai/kits/sheet](https://kition.ai/kits/sheet)

[Kits](https://kition.ai/kits) sheet

Calculate with AI.

# Kition sheet

Kition sheet is a spreadsheet that works on Excel workbooks (.xlsx) directly. It has its own formula engine with close to 500 Excel functions, plus formatting, tables, charts and PivotTables. Your AI uses the same engine as you: it reads the cells, writes formulas, checks for broken ones, and can leave its changes as a draft for you to review.

**For** people who keep budgets, sales figures, lists and reports in Excel files and want an AI to do the spreadsheet work with them.

 Free, for macOS, Windows and Linux.

**Beta.** Kition sheet is in the desktop app and ready for real work, and still changing.

## What you can do

6 areas

### Formulas and functions

Write formulas the way you do in Excel, and get the same results.

-   Close to 500 Excel worksheet functions by name, from SUM and VLOOKUP to XLOOKUP, FILTER, UNIQUE, SORT, VSTACK, GROUPBY and PIVOTBY
-   Dynamic arrays that spill, LET and LAMBDA, named LAMBDAs, MAP, REDUCE and BYROW
-   Absolute, relative and mixed references, other-sheet and 3-D references, table references like Table1\[Sales\]
-   Defined names at workbook or sheet scope, with a Name Manager and Create from Selection
-   Trace precedents and dependents, evaluate a formula step by step, show formulas instead of values
-   Goal Seek, scenarios and data tables for what-if questions

### Formatting

Make a sheet readable with the formatting Excel users expect.

-   Fonts, sizes, colours, fills and borders, including formatting single characters inside a cell
-   Number formats: currency, accounting, percent, dates, times, fractions, scientific, or your own code
-   Alignment, wrapping, indent, text orientation and merged cells
-   Conditional formatting: cell rules, text rules, duplicates, top/bottom, above average, colour scales, data bars and icon sets
-   Cell styles, themes, and Format as Table with banded rows and a total row

### Charts and sparklines

Turn a range into a chart in one step.

-   Column, bar, line, pie, doughnut, area, scatter, bubble, radar and stock charts
-   Histogram, box and whisker, waterfall, funnel, treemap and sunburst
-   Combo charts with a line on a secondary axis
-   Chart titles, axis titles, legend position, quick layouts, colours, Select Data and Switch Row/Column
-   Line, column and win/loss sparklines inside cells

### Sort, filter and analyse

Find what matters in a list of rows.

-   Sort by several columns, by value, cell colour or font colour, or by a custom list
-   AutoFilter and Advanced Filter
-   Remove duplicates, Text to Columns, Flash Fill, subtotals, grouping and outlines
-   Data validation with dropdown lists, number, date and length rules, and custom formulas
-   PivotTables: rows, columns, values and filters, with sum, count, average and other summaries, grouping, sorting and report layouts

### Sheets, review and layout

Organise a workbook and get it ready to share or print.

-   Insert, delete, rename, move, colour, hide and unhide sheets
-   Insert, delete, resize, hide and unhide rows and columns; freeze panes and split the view
-   Comments with replies, notes, spelling check, and sheet and workbook protection
-   Page setup: margins, orientation, paper size, print area, print titles, scale to fit, headers and footers
-   Export the active sheet as a PDF laid out by your page setup, as CSV, or as a web page

### Built for your AI

An agent works through the same commands as the editor, so you can see what it did.

-   Every command has a parameter schema the agent follows
-   The agent reads values or formulas from any range, and sees a preview of the sheet
-   A check that finds formula errors, circular references, broken names and merge problems, naming the sheet and cell
-   Drafts: the agent prepares changes in a draft and leaves your file untouched until you accept

## Opens and saves

4 formats

File formats Kition sheet opens and saves

| Format | Open | Save | Notes |
| --- | --- | --- | --- |
| .xlsx | Opens | Saves | Keeps cells, formulas, styles, themes, merges, conditional formatting, validation, tables, comments, names, pictures, charts and PivotTables; parts it does not model (form controls, slicers, external links, embedded objects) are dropped on save |
| .pdf | Does not open | Exports | Export only, from File › Export: the active sheet as Print lays it out, written as a new file beside the workbook |
| .csv | Does not open | Exports | Export only, from File › Export: the active sheet’s cells |
| .html | Does not open | Exports | Export only, from File › Export: the active sheet as a web page |

## Ask your AI

328 commands

Kition sheet is an MCP server that follows KHP. Claude, ChatGPT, Cursor or any MCP agent uses the same 328 commands as the editor, in the file you have open. A few requests to try:

-   “Add a Share column to sales.xlsx that divides each region by the total, and format it as a percentage.”
    
    Writes the formulas with `range.setValues`, applies `home.numberFormat` with "Percentage", then reads the column back with `sheet.read`.
    
-   “Sort this list by region, then by revenue from high to low, and turn on filters.”
    
    Runs `data.sort` with two keys and turns on AutoFilter with `data.filter`.
    
-   “Make a column chart of monthly revenue and put it next to the table.”
    
    Runs `insert.chart` on the range with type "column", a title and a position such as H2.
    
-   “Build a PivotTable of total sales by region and quarter on a new sheet.”
    
    Runs `insert.pivotTable` on the data, then `pivot.addField` to put Region in rows, Quarter in columns and Sales in values.
    
-   “Something in this budget shows #DIV/0!. Find it and fix it without deleting the formula.”
    
    Runs the check to find the cell, then rewrites it with `cell.set` as a guarded formula such as =IF(C3=0,"",B3/C3), and checks again.
    

### What your AI can check

-   Check reports formulas that end in an error (#DIV/0!, #VALUE!, #REF!; #N/A as a warning) and formulas that refer to themselves
-   Check reports defined names that point nowhere, overlapping merges, merges that hide values, and formulas that read an empty cell past the data
-   The agent reads back the cells it changed, as values or as formulas, and sees a preview of the sheet
-   Drafts hold the agent's changes for you to review; the workbook itself stays as it was

[How KHP works](https://kition.ai/khp)

## Coming from Microsoft Excel

### Microsoft Excel

Opens your .xlsx workbooks and keeps formulas, styles, tables, charts and PivotTables. Macros are not kept.

## Good to know

Current limits

-   Workbooks saved here have not yet been tested in Excel across a large set of real files, so a repair prompt in Excel is possible
-   Content the kit does not model, such as form controls, slicers, timelines, external links and embedded objects, is dropped when you save
-   Charts keep their type and data, but many options are simplified: no trendlines, error bars or custom axis scaling
-   Old .xls files and password-protected workbooks do not open yet; you get a message asking you to save as .xlsx or remove the password
-   Very large workbooks (around 100 MB) do not open

## Embed it

### Embed it in your product

Kition sheet ships as a self-contained package, an editor plus a WebAssembly engine, that any web product can embed in an iframe.

[Embed a kit](https://developer.kition.ai/)

## Questions

### Can I open .xlsx files with macros (.xlsm)?

Kition sheet opens .xlsx. It does not run VBA macros, and when it reads a workbook with a VBA project it drops the macros with a warning.

### Will my Excel formulas still work?

Most will. The engine has close to 500 Excel functions, including dynamic arrays, XLOOKUP and LAMBDA. A few are missing, such as GETPIVOTDATA and the FORECAST.ETS family, and the CUBE functions return #N/A.

### Can it open old .xls files?

Not yet. It recognises an Excel 97-2003 file and asks you to save it as .xlsx in Excel first.

### Can it open password-protected workbooks?

Not yet. It recognises an encrypted workbook and tells you to remove the password in Excel and try again.

### Can my AI change my spreadsheet without me seeing it?

The agent edits through the same commands as the editor, and you see the result in the file. You can also ask the agent to work in a draft, which leaves the file untouched until you accept.

### Can I export a PDF or CSV?

Yes. File › Export writes the active sheet as a PDF (laid out by its page setup), as CSV, or as a web page, as a new file next to the workbook. Your AI can export the same way.

### What does it cost?

Kition sheet is free in the Kition desktop app.

[Previous kit**cad**](https://kition.ai/kits/cad)[Next kit**table**](https://kition.ai/kits/table)

Kition sheet is free in the desktop app.
