Tutorial

Four features, from first try to power user. Every step matches the real UI, with example prompts you can copy.

Feature guides

✨

1. Generate a table with AI

Start from scratch: describe the table in one sentence and AI builds a complete spreadsheet. No file needed.

Best for

Payroll sheetsSales recordsSchedules & inventoryAny new table

Steps

  1. 1Open the workspace and choose the first tab, "Generate Table".
  2. 2Describe the table in plain language: which columns, roughly how many rows, and what each row contains.
  3. 3Click "Generate with AI". In a few seconds, a preview appears with the row and column count.
  4. 4Not quite right? Use the "continue editing" box (add a column, sort, format numbers…) and click the AI edit button to iterate.
  5. 5When happy, click "Download Excel file" to get an .xlsx file with today’s date in the name.

💬 Example prompts

Create a 5-row employee payroll table with name, department, base salary, bonus and total
Create a 10-row sales detail table with order no., date, customer, product, qty, unit price and amount
Edit: round all number columns to 2 decimal places
Edit: add an "After-tax salary" column equal to base salary × 0.8
💡

Be specific: list the column names, row count and any relationships between columns (e.g. "amount = qty × unit price").

📊

2. Edit an existing spreadsheet

Upload an Excel file and let AI edit data in bulk from a sentence. Every change is reviewed before applying.

Best for

Add calculated columnsConditional taggingData cleaningBulk formatting

Steps

  1. 1Open the workspace and choose the second tab, "Edit Table".
  2. 2Click or drag in an Excel file (.xlsx / .xls / .csv). It is parsed locally in your browser and never stored.
  3. 3Preview the original data, describe the edit you want, then click "AI Edit".
  4. 4Review the change log: each row/column change with old value, new value and type (added/modified/removed), plus the full new preview.
  5. 5Click "Apply changes" when satisfied, or "redo" with a new instruction.
  6. 6Pick an export style (original layout / beautified) and download the edited Excel file.

💬 Example prompts

Add a "Profit" column equal to "Revenue" minus "Cost"
For rows where Revenue is above 10000, mark "Excellent" in the Grade column
Trim spaces in the name column, lowercase all emails, remove fully duplicate rows
Sort by department, then by base salary descending within each department
💡

The free plan supports files up to 200 rows. Quote column names exactly as they appear in the header for the most accurate results.

⚙️

3. Generate VBA code with AIPro

Automate Excel without knowing VBA: describe the task, get the macro plus step-by-step run instructions.

Best for

Batch formattingCustom functionsMerge worksheetsEvent automation

Steps

  1. 1Open the workspace and choose the third tab, "VBA Code" (marked with a Pro badge).
  2. 2Describe what you need in plain language and click "Generate VBA". Non-Pro users get one free trial.
  3. 3The result shows the code type (Sub macro / custom function / event procedure), the code itself, and usage steps.
  4. 4Click "Copy VBA code". Open your Excel file and press Alt + F11 to open the VBA editor.
  5. 5In the editor menu choose Insert → Module, paste the code, then close the window.
  6. 6Run it: press F5 for a Sub (or Developer → Macros in Excel); type =FunctionName() in a cell for a custom function; event procedures fire automatically on the matching action.

💬 Example prompts

Color the font red for every negative cell
Write a function that converts a number to Chinese uppercase currency text
Merge all worksheets in this workbook into one new sheet
After I type a value in column A, auto-fill the current time in column B on the same row
💡

Save a backup copy before running macros. If Excel shows a security warning, click "Enable Content" to allow the macro to run.

🧮

4. Formula helpers

At the bottom of the workspace — no upload required. Generate, explain and debug formulas on the fly.

Best for

Writing a new formulaUnderstanding a formulaFixing formula errors

Steps

  1. 1Open the workspace and scroll to the "Formula tools" section at the bottom. There are three tabs.
  2. 2Generate: describe the need in plain language; get the formula plus explanation, examples and edge cases.
  3. 3Explain: paste a formula you don’t understand; AI breaks down every function and argument.
  4. 4Debug: paste a formula that errors or returns wrong results; AI identifies the problem and returns a fixed version.
  5. 5Every result has a copy button — one click and you can paste it straight into Excel.

💬 Example prompts

(Generate) Count people who are male and over 30, using gender in column B and age in column C
(Explain) =IFERROR(VLOOKUP(A2,PriceList!A:B,2,FALSE),"Not found")
(Debug) =SUMIF(A:A, >100, B:B) — why does this throw an error?
💡

When debugging, include what you intended the formula to do — AI can then tell a syntax error apart from wrong logic.

FAQ

Is my file uploaded and stored on your servers?+

No. The Edit Table feature parses your Excel file locally in your browser. The file itself is never stored on our servers. Only the text instruction you type is sent to the AI to perform the edit.

Which file formats are supported?+

Editing supports .xlsx, .xls and .csv; the result is always exported as .xlsx. Generate Table needs no file at all — just describe what you want in plain language.

How does the free quota work?+

You can try without an account, and logged-in users get a higher free quota. The remaining daily count is shown in the UI and refreshes every day. VBA includes one free trial for non-Pro users; Pro unlocks 200 runs per day plus all features.

What if the AI makes a wrong change?+

Every edit is listed in a change log (row, column, old value, new value, change type) and applied only after you confirm. You can also ask the AI to redo it. Generated tables can be refined for as many rounds as you like before downloading.

Try it now

No signup required to start. Come back to this page whenever you need help.

🚀 Try for freeSign up for more quota