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.
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.
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:
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))
:
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:
A range of cells is referenced similarly:
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.
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