Overview

Overview

Getting started

Overview
Overview
Import Data
Import Data

Languages

Python
Python
Formulas
Formulas

Reference

Support
Support

Overview

Quadratic is designed to be familiar for anyone who has ever used a spreadsheet.

Our goal is to get you up and running quickly while expanding what is possible with a spreadsheet!

Quadratic allows you to use Python and SQL without any configuration!

If you find anything counterintuitive or just plain broken please submit a Github issue.

icon
Note: Quadratic is in Beta, so we don’t recommend relying on it for critical work.

Spreadsheet

The canvas in Quadratic is like a traditional spreadsheet grid. However, Quadratic is unique in that its grid is infinite meaning you can zoom in and out and pan in any direction to navigate your data.

image

Zoom

You can zoom in Quadratic using the zoom tool in the toolbar, or using your trackpad or mouse.

  • Trackpad: pinch fingers to zoom out, stretch fingers apart to zoom in.
  • Mouse: Ctrl and scroll the wheel up/down to zoom in/out.

Pan

  • Trackpad: Drag two fingers to pan the grid.
  • Mouse: on supported mice, drag with one finger.

Import data

  • Copy/paste: you can import data into a Quadratic Grid by copy/pasting it from any other data grid.
  • Fetch: use Python to fetch data from an API. Learn more.
  • Import CSV (coming soon): import data from a CSV file.
  • Data connectors (coming soon): hook up data from your SaaS tools and databases.

Cells

Sheets in Quadratic are laid out on a coordinate plane in rows and columns. An individual cell is referenced by its row (x) and column (y) coordinates within the sheet. For example:

image

A range of cells is referenced by specifying the coordinates of two distinct cells within the sheet. An inclusive selection is made around this range. For example, given the range cells((-2, -3), (2, 3)):

image

When using formulas, cells are referenced using the traditional A1 spreadsheet notation. However, since Quadratic works on a zero-index coordinate plane, the origin starts at A0 and negative values are represented by the n1 / nA notation. For example:

image

A range of cells is referenced similarly:

image

The specific syntax for referencing cells depends on which language you’re working in. For more info, see the language guides:

Formulas & code

Type = on any empty cell to choose which language you want to write and open the code editor.

Code editor

Return data to the spreadsheet

The actively-selected cell will populate with whatever is returned on the last line of code.

That said, different languages have additional ways of rendering data to the spreadsheet. See the language guides for more info:

Log information to the console

Under the text editor is the console where you can view information about the code you’re running.

The “Output” tab will display anything logged in your code (stdout and stderror).