Overview

Overview

Overview

Quadratic is designed to be familiar to 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.

🤖
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: Scroll for vertical pan. Shift + Scroll for horizontal pan. On Magic Mouse you can pan in any direction with a single 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 the equals sign = on any empty cell to open the cell type selection menu.

Choose which language you want and open the code editor will open to the right.

image

icon
Note: all computation related to formulas and code runs locally on your computer.

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).

Browser support

Long-term, we plan to provide parity across modern browsers and operating systems. However, currently, Quadratic is optimized for the following use cases:

  • Desktop Chrome
  • Read-only on mobile devices