Try Kimi at kimi.com →

How to Analyze Spreadsheets
With Kimi AI

Upload an Excel or CSV file and let Kimi clean the data, find trends, write formulas and build pivot tables and charts, then download a finished .xlsx file. Here's how, with prompts, formula examples and ways to check the numbers.

Excel & CSV Formulas, pivots & charts Download as .xlsx
sales-2026.xlsx2,418 rows DateRegionProductRevenue 03-01NorthPro1,240 03-01SouthLite380 03-01SouthLite380 03-02EastPro1,105 03-02WestMax2,060 03-03NorthLite415 03-03NorthLite415 03-04EastMax1,980 2 duplicate rows removed KKimi Sheets analysing… =SUMIFS(D:D,B:B,"North") REVENUE BY REGION North South East West Xsales-summary.xlsxformulas · pivot · chart
OPTIONS

Four ways to analyze spreadsheets with Kimi

Use chat to ask about a file, and Kimi Sheets when you want a finished Excel workbook back.

What you needUseWhat you get
Quick questions about a fileKimi chatAttach the file and ask. Answers come back as text and tables in the chat.
A finished .xlsx with formulas, pivots and chartsKimi Sheets (Agent)Builds a real Excel file you can preview and download. Uses agent credits.
Files and folders on your computerKimi WorkThe desktop app works on local files, including an Excel plugin for spreadsheet tasks.
Many files in a script or appKimi APIUpload files with the Files API and process them in code.

More on the desktop app: Kimi Work guide. Credits and plans: Kimi pricing.

STEPS

How to analyze a spreadsheet with Kimi Sheets

  1. 1

    Open Kimi Sheets

    Sign in at kimi.com, then choose Sheets in the sidebar or click the Agent button under the message box.

  2. 2

    Upload your file

    Attach your Excel (.xlsx) or CSV file. Each file can be up to 100 MB, and you can add up to 50 files.

  3. 3

    Describe the result you want

    Say what to calculate, how to group it and what to output, for example “Revenue by region and month as a pivot table, plus a bar chart.”

  4. 4

    Preview the workbook

    Kimi shows the sheets it built. Check the structure, then ask for changes in plain words.

  5. 5

    Download and check

    Download the .xlsx, open it in Excel, Google Sheets or WPS, and check the key totals and formulas yourself.

A good first prompt

Analyse the attached spreadsheet. Explain what the data shows, give the 5 most important findings with the numbers behind them, and build a summary sheet with a pivot table and one chart. Use formulas, not typed values, and flag any data problems.

New to Kimi? Read the beginner's guide first.

PROMPTS

9 prompts for spreadsheet analysis

Attach your file, copy a prompt and replace the [brackets] with your columns and goals.

Clean

Clean messy data

Use in: Sheets

Clean the attached spreadsheet: remove duplicate rows, set all dates to YYYY-MM-DD, trim spaces, make amounts numeric and standardise names and country codes. Don't guess missing values; flag them. Add a sheet called 'Cleaning log' listing every change.

Summary

Find the main trends

Use in: Chat or Sheets

Analyse the attached sales data. Describe what each column contains, then give me the 5 most important trends, the best and worst performers, and anything unusual. Show the numbers behind each point.

Pivot

Build a pivot table

Use in: Sheets

Create a pivot table from the attached data showing total [revenue] by [region] (rows) and [month] (columns), with grand totals and each region's share of the total as a percentage.

Charts

Make a simple dashboard

Use in: Sheets

Build a dashboard sheet from the attached data: 4 key numbers at the top, a line chart of [revenue] by month, a bar chart by [product], and a top-10 table. Keep the charts linked to the data.

Formulas

Write or explain a formula

Use in: Chat

I need a formula in [Excel] that [goal, e.g. totals sales for the North region in March]. My columns are: [A: Date, B: Region, C: Product, D: Revenue]. Give the formula, explain it step by step and show one worked example.

Merge

Combine several files

Use in: Sheets

Combine the attached [12] monthly files into one sheet. Match columns by name, add a 'Source file' column, remove exact duplicates, and add a summary sheet with monthly totals.

Anomalies

Spot errors and outliers

Use in: Chat or Sheets

Check the attached spreadsheet for problems: totals that don't add up, outliers, negative values where they shouldn't be, missing data and duplicates. List each issue with its row number and how sure you are.

Forecast

Simple forecast

Use in: Sheets

Using the monthly data in the attached file, forecast the next [6] months of [revenue]. Show low, base and high scenarios, explain the method in plain words, and keep every assumption in its own cell so I can change it.

Finance

Budget vs actual

Use in: Sheets

Compare the budget and actual figures in the attached file. Add variance and variance % columns, highlight lines over budget by more than [10%], and write a 5-line summary for my manager.

More ideas in the Kimi prompt library.

CLEAN

Clean messy data first

Most wrong answers come from messy data: mixed date formats, numbers stored as text, extra spaces and the same customer spelled three ways. Ask Kimi to clean the file before you analyse it.

  • 1
    Standardise. One date format, one currency, consistent names and codes.
  • 2
    Remove duplicates. Ask Kimi to show which rows it removed.
  • 3
    Flag, don't guess. Missing or odd values should be marked for you, not invented.
  • 4
    Keep a log. A “Cleaning log” sheet shows every change so you can undo it.
DateCustomerAmountCountry 3/1/26 2026-03-01 acme ltd Acme Ltd $1,200 1,200.00 UK GB 2026-03-02 2026-03-02 ACME Ltd. Acme Ltd 1200 1,200.00 United Kingdom GB 02 Mar 2026-03-02 Bolt Inc N/A — flagged us US 2026/03/04 2026-03-04 bolt inc Bolt Inc 950.0 950.00 USA US — flagged Cora GmbH €800 860.00 USD DE BEFORE: messy AFTER: clean Kimi is fixing dates, names, amounts and country codes… Cleaning log✓ 5 dates set to YYYY-MM-DD ✓ 3 names merged✓ amounts made numeric ✓ € converted at a rate you set⚠ 2 cells flagged for you to check, not guessed Ask for a cleaning log so you can see every change.Example data for illustration

Messy rows become a consistent table, with problems flagged instead of guessed.

FORMULAS

Excel formulas Kimi can write for you

Describe what you want and your column layout. These examples assume Date in column A, Region in B, Product in C and Revenue in D.

You ask Kimi for…Formula it can writeCopy
Total sales for one region=SUMIFS(D:D, B:B, "North")
Total for one region in March 2026=SUMIFS(D:D, B:B, "North", A:A, ">=2026-03-01", A:A, "<=2026-03-31")
Count orders over $1,000=COUNTIFS(D:D, ">1000")
Look up a price by product code=XLOOKUP(F2, Products!A:A, Products!C:C, "Not found")
Month-on-month growth=IFERROR((C3-C2)/C2, "")
Running total=SUM($D$2:D2)
Flag duplicates=IF(COUNTIF(A:A, A2)>1, "Duplicate", "")

Tip: add “explain it step by step” to learn the formula, and say whether you use Excel, Google Sheets or WPS, since a few functions differ.

CHECK

How to check Kimi's numbers

Kimi is strong at spreadsheet work, but it can still miss rows or a mismatch. In Puter's October 2026 finance test, K3.1 Pro didn't make up any figures, but it missed a $20M gap that Kimi K3 pointed out in two of three runs. Reconcile the numbers yourself.

Reconcile the totals

Compare Kimi's grand totals with a quick SUM in your own sheet. If they don't match, ask Kimi which rows it left out.

Look for formulas, not typed numbers

Click on a few result cells. Live formulas update when data changes; typed-in numbers don't. Ask Kimi to “use formulas, not hard-coded values”.

Spot-check a few rows

Pick three rows and work them out by hand. It takes two minutes and catches most errors.

Ask it to flag, not guess

Tell Kimi to flag missing or odd values instead of filling them in, and to say which ones it changed.

FINANCE

Financial models with Kimi K3.1 Pro

Moonshot built K3.1 Pro for finance work, from research to finished workbooks with linked formulas. These are Moonshot's own reported results.

64.4OfficeQA Pro v2

Analysis of real financial documents; the top score in Moonshot's comparison.

+7.2Financial modelling

Points gained over K3 on formula linkage, financial logic and workbook quality.

+11.6Financial research

Points gained over K3 on research that has to hold up to a fact check.

4.2×Business operation

K3's score on a long simulated business-management task.

Best use: let Kimi build the first draft of a forecast or model, with every assumption in its own cell, then have someone who knows the business check the data and formulas before you rely on it. See the Kimi K3.1 Pro guide for more.
LIMITS

Kimi spreadsheet limits

LimitWhat it isSource
File typesExcel and CSV, plus PDF, Word, PPT, images and TXT as sourcesKimi Help Center
File sizeUp to 100 MB per fileKimi Help Center
Files at onceUp to 50 filesKimi Help Center
Row limitNot publishedVery large files may need splitting or summarising first
Output.xlsx you preview online, then download; Excel, CSV and other formatsKimi Help Center
CostChat questions are free within limits; Sheets runs as an agent task and uses creditsKimi plans

Working from PDFs instead? Kimi Sheets can pull tables out of PDFs into Excel. See how to analyze PDFs.

API

Analyze spreadsheets with the Kimi API

For many files or a repeating report, upload CSV or Excel files with the Files API, or summarise large data in pandas first and send only the summary.

import os from pathlib import Path from openai import OpenAI client = OpenAI( api_key=os.environ["MOONSHOT_API_KEY"], base_url="https://api.moonshot.ai/v1", ) # Upload the CSV or Excel file and extract its contents f = client.files.create(file=Path("sales-2026.csv"), purpose="file-extract") data = client.files.content(file_id=f.id).text reply = client.chat.completions.create( model="kimi-k3.1-pro", messages=[ {"role": "system", "content": data}, {"role": "user", "content": "Total revenue by region and month as a table. " "Then list the 3 biggest changes and any rows that look wrong."}, ], ) print(reply.choices[0].message.content) client.files.delete(file_id=f.id)
  • 1
    Small files: upload with purpose="file-extract" and send the extracted text as a system message.
  • 2
    Big files: do the grouping and sums in pandas. It's exact and much cheaper than sending every row.
  • 3
    Let Kimi explain: ask for trends, causes and next steps from the summary.

K3.1 Pro costs $2 per million input tokens and $10 per million output tokens. Keys and setup: Kimi API guide.

FIXES

Fix common spreadsheet problems

Kimi gave text, not an Excel file
  • Use Sheets or the Agent button, not normal chat.
  • Ask for “a downloadable .xlsx file” in your prompt.
  • Check you have agent credits left this month.
The totals don't match my sheet
  • Ask Kimi to list which rows it included and excluded.
  • Check for hidden rows, filters, text-formatted numbers and blank cells.
  • Ask it to rebuild the totals with SUMIFS formulas so you can see the logic.
Dates or numbers come out wrong
  • Say the date format your file uses, such as DD/MM/YYYY.
  • Say the currency and decimal separator.
  • Ask Kimi to show 5 example rows before and after conversion.
The file is too big or slow
  • Remove columns and sheets you don't need before uploading.
  • Save as CSV, which is usually smaller than .xlsx.
  • Split the data by year or region and analyse each part.
Charts or formatting are lost in Excel
  • Open the file in a recent version of Excel or WPS.
  • Ask Kimi to use standard Excel charts and functions only.
  • Google Sheets may change some chart styles on import.

Other issues? See Kimi troubleshooting.

FAQ

Kimi spreadsheet FAQ

Yes. You can upload Excel (.xlsx) and CSV files to Kimi and ask questions in chat, or use Kimi Sheets to clean the data, build pivot tables, charts and formulas, and download a finished .xlsx file.

Kimi Sheets is Kimi's spreadsheet agent. You describe what you want or upload data, and it builds a real Excel workbook with formulas, pivot tables and charts that you can preview online and then download.

You can ask questions about spreadsheets in normal chat on the free plan. Kimi Sheets runs as an agent task and uses agent credits; the free plan includes a small monthly allowance and paid plans include more.

Each file can be up to 100 MB, and you can upload up to 50 files at a time. Kimi doesn't publish a row limit, so for very large data, remove unused columns, save as CSV or split the file.

Yes. Describe what you want and your column layout, and Kimi can write formulas such as SUMIFS, COUNTIFS and XLOOKUP and explain them step by step. In Kimi Sheets it can also link formulas across several sheets.

Kimi Sheets creates Excel (.xlsx) files. You can upload the .xlsx to Google Drive and open it in Google Sheets, though some chart styles may change. To analyse a Google Sheet, download it as .xlsx or CSV first.

Yes. Moonshot says Kimi K3.1 Pro can build workbooks with linked formulas and scenarios, and reports gains in financial modelling over K3. Treat the result as a first draft and have someone check the formulas and assumptions.

Kimi is good at spreadsheet work, but it can still miss rows or misread values. Always reconcile key totals, check that results use live formulas, and spot-check a few rows by hand.

Try it with your own spreadsheet

Open Kimi, choose Sheets, attach a file and paste one of the prompts above.