Skip to main content
ZeroTwo
Guides
Language
Login

How do I analyze spreadsheets and data files in ZeroTwo?

Attach a CSV or Excel file and ask ZeroTwo to analyze it with Python, then review the code, charts, and files. On desktop you can also comment on cells.

Updated: 17 hours ago

You can give ZeroTwo a data file and ask about it in plain language. ZeroTwo can run Python code on the file and then show you the results, charts, and files that the code produces.

Attach your data

  1. In the message box, select the + button and choose Files and folders.
  2. Pick your file. ZeroTwo accepts CSV, TSV, XLS, XLSX, and ODS spreadsheets, along with many other file types.
  3. Ask your question in the same message, for example: "Summarize this file: columns, data types, and missing values."

The more precisely you describe what each column holds and what you want back, the less ZeroTwo has to guess. Name the output you want, such as a line chart saved as a PNG or an .xlsx with a new column.

How the analysis runs

ZeroTwo decides when code is worth running. A quick calculation it can answer directly may not need it. When it does run Python in a Chat conversation, a collapsible step reads Analyzing while the code works and Analyzed when it finishes. In Work mode the step reads Running Python and then Ran Python.

  • The code runs in a cloud sandbox that has pandas, NumPy, Matplotlib, seaborn, SciPy, scikit-learn, and openpyxl ready to use. In the desktop app, a Work conversation that is working on a folder on your computer can run its scripts on your own machine instead.
  • Files you attach to the current message are already in the sandbox when the code starts. ZeroTwo can also reload a file you attached in an earlier message by its file name.
  • In Chat, a Python run is limited to five minutes.
  • Select the step to read the code and its output. In Chat, files the code created are listed under Generated Files with a Download link, and charts it saves come back as images or files in the reply. Where interactive charts are available, ZeroTwo draws a chart as an interactive chart in the reply instead, unless you ask for an image or a file. In Work mode, the step lists the generated files.

To check a result, ask ZeroTwo to show the rows or formula behind a number, or open the step and read the code. For the full list of data formats and the file limits, see Analyzing spreadsheets and data files with ZeroTwo.

Open a spreadsheet in the viewer

When you open an XLSX, XLS, CSV, or TSV file, it opens in the file viewer panel. The viewer has a grid, a formula bar that shows the selected cell's address and contents, sheet tabs along the bottom, and a zoom menu from 50% to 400%. You can't type into cells in the viewer. To change the data, ask ZeroTwo.

Comment on selected cells

For a spreadsheet in your Library, or one on your computer in the desktop app, the viewer toolbar has a Comment on cells button, a speech bubble with lines of text. Use it to point at cells and ask for a change.

A spreadsheet open in the ZeroTwo viewer with a range of cells selected and a comment box below it
  1. Select Comment on cells in the viewer toolbar.
  2. Click a cell, or drag across a range. A pin marks your selection and a box with "Describe a change or ask a question" opens beside it.
  3. Type what you want, for example "Fix this formula", and press Enter.

ZeroTwo sends your text as a message in the active chat. If you started from the Library, it opens a chat and sends it there. The message carries the sheet name and the cell reference, such as B2:B20, so the request points at the right place. By default ZeroTwo records your note as a native Excel cell comment. If your text asks for a change, such as "Fix this formula", it makes that edit in the file instead. A file on your computer is changed where it is, and a Library file is saved back over the same file, which keeps the previous version. Press Escape or click elsewhere to close the box without sending.

A spreadsheet you open from a chat attachment shows the grid without this button.

Need more help? Search with the help chat, email us or ask in the ZeroTwo community on Discord.

Help chat

Signed in to ZeroTwo? Open Help, then Support, in the app to send us a message.

Related articles

Was this article helpful?

Log in to message us in the app.

Log in

ZeroTwo help chat

Get help from ZeroTwo

This chat only searches the articles here. It isn’t a person or an AI, and sends nothing. To reach ZeroTwo, email reed@zerotwo.ai or join the ZeroTwo Discord.