Skip to main content
The Spreadsheet editor creates and edits tabular data inside the canvas. When your request calls for rows and columns — a comparison matrix, a budget template, a project schedule, a pricing table — ZeroTwo structures and populates the data in a live spreadsheet instead of a plain text table.

​
When to Use the Spreadsheet Editor

The Spreadsheet editor is the right choice when your output is inherently tabular:
Use CaseExample Prompt
Comparison tables”Compare the top 5 CRM tools across pricing, integrations, and ease of use”
Budget templates”Create a monthly household budget template with categories and formulas”
Project schedules”Build a 12-week project timeline with tasks, owners, and milestones”
Pricing tables”Create a SaaS pricing table for Free, Pro, and Enterprise tiers”
Data conversion”Convert this JSON data into a formatted spreadsheet table”
Feature matrices”Show which features are included in Free, Pro, and Enterprise plans”
Inventory lists”Create an inventory sheet with SKU, name, quantity, and unit cost”
Schedules”Build a weekly meeting schedule with time, topic, attendees, and location”
Provide the column names you want upfront — the AI will fill in the data. “Create a table with columns: Product, Price, Storage, Free Tier, Verdict” produces a more useful output than a vague request.

​
What ZeroTwo Can Do in the Spreadsheet Editor

​
Create Tables from Scratch

Describe the columns and the data you want. ZeroTwo creates the headers, populates the rows, and formats the table. Prompts to try:
  • “Create a comparison table of the top 5 cloud storage services with columns for storage limit, monthly price, free tier size, and notable features”
  • “Build a monthly budget template with categories for housing, food, transport, entertainment, savings, and miscellaneous — include a totals row”
  • “Make a feature comparison matrix for Free, Pro, and Enterprise plans of a project management tool”

​
Convert Existing Data

Paste raw data — JSON, CSV, a plain text list, a copied web table — and ask ZeroTwo to convert it. Prompts to try:
  • “Convert this JSON array into a spreadsheet”
  • “Turn this comma-separated data into a formatted table”
  • “I have a list of transactions — structure this into a spreadsheet with columns for date, description, amount, and category”

​
Add Calculated Columns and Formulas

Ask ZeroTwo to add formula-based columns or summary rows. Prompts to try:
  • “Add a totals row at the bottom using SUM”
  • “Add a column that calculates the monthly cost times 12 for the annual total”
  • “Add an AVERAGE row below the data”
  • “Add a percentage column showing each item as a share of the total”

​
Modify and Extend

After the table is created, continue iterating in the chat:
  • “Add a column for customer support rating (1–5)”
  • “Remove the last two rows”
  • “Sort the table by price, lowest to highest”
  • “Add 5 more rows of realistic example data”

​
Formula Support

The Spreadsheet editor supports standard spreadsheet formulas. ZeroTwo can write formulas directly into cells when instructed.
CategoryFormulas
MathSUM, AVERAGE, MIN, MAX, ROUND, ABS
TextCONCATENATE, UPPER, LOWER, LEN, TRIM
LogicIF, AND, OR, NOT
LookupVLOOKUP, HLOOKUP, INDEX, MATCH
DateTODAY, NOW, DATEDIF, DAYS
Example prompt: “Add a formula in column D that calculates the total cost by multiplying column B (quantity) by column C (unit price)“

​
Adding and Removing Rows and Columns

You can modify the table structure manually in addition to asking the AI:
  • Add a row: Right-click a row number → “Insert row above” or “Insert row below”
  • Remove a row: Right-click a row number → “Delete row”
  • Add a column: Right-click a column header → “Insert column left” or “Insert column right”
  • Remove a column: Right-click a column header → “Delete column”
  • Resize a column: Click and drag the column border in the header row

​
Exporting as CSV

Click the Download CSV button in the canvas toolbar to export the spreadsheet as a .csv file.
1

Open the canvas toolbar

Look for the toolbar at the top-right of the canvas panel.
2

Click Download / Export

Select CSV from the export options.
3

Open in your spreadsheet app

Open the downloaded .csv in Microsoft Excel, Google Sheets, Apple Numbers, or any compatible application for further editing.
CSV export includes cell values only. Formulas are exported as their computed values, not as formula strings. Column formatting (bold headers, colors) is not preserved in CSV — those are display properties only.

​
Limitations

The Spreadsheet editor is a lightweight tool designed for AI-generated structured data. It is not a full replacement for Excel or Google Sheets. It does not support:
  • Complex nested formulas or array formulas
  • Charts and graphs (use the HTML Preview canvas for data visualizations instead)
  • Cell-level formatting (colors, fonts, borders)
  • Multiple sheets or tabs in one canvas
  • Pivot tables or advanced data modeling
For complex financial modeling, large datasets, or collaborative editing, export to CSV and continue working in Excel or Google Sheets.

​
Tips for Best Results

Name your columns explicitly. “Create a table with columns: Product Name, SKU, Price, Stock, Category, Last Updated” gives ZeroTwo a precise structure to fill in.
Specify the number of rows. “Add 10 example rows” prevents the AI from generating too few entries or an unexpectedly large table.
Ask for realistic sample data. “Populate it with realistic example data for a B2B SaaS company” produces more useful placeholder content than generic filler.
Export to CSV early. If you plan to continue working in Google Sheets or Excel, export the CSV as soon as you have a good structure — then extend it in your preferred tool.

​
Related Pages

Export Canvas

Download your spreadsheet as a CSV file.

HTML Preview

Build charts and data visualizations from your data.

Canvas Overview

All 7 canvas editor types and how to activate Canvas Mode.

Troubleshooting

Fix common spreadsheet canvas issues.