Getting started
The infinite spreadsheet with Python, SQL, JavaScript, and AI.
Quadratic is a modern spreadsheet built for technical teams.
Quadratic combines familiar spreadsheet UI and formulas with the power of Python, SQL, JavaScript, and AI. Ingest data with SQL, analyze it with Python, JavaScript and Formulas, and speed that whole process up with the power of AI. All in the most familiar interface for working with data - spreadsheets.
Skip to a section of interest or get started in the short walkthrough below.
If you have any questions or feedback, we’d love to hear it! Share by contacting us.
Getting started
Get started in Quadratic by creating your first blank sheet or picking an example file.
Here is a list of some common first things to do in Quadratic:
Write your first line of Python code 🐍
Start your first first line of code by simply pressing /
after clicking a cell. This will open the command palette.
Picking your cell type will open the editor where you can start writing code.
In Quadratic you can reference cells in the spreadsheet to use in your code, and you can return results from your Python analysis back to the spreadsheet. By default, the last line of code is returned to the spreadsheet.
Single referenced cells are put in a variable with the appropriate data type. Multi-line references are placed in a DataFrame. Learn more here.
To learn more about Python, visit the Python section of the docs.
Use Formulas 🔢
Formulas in Quadratic are similar to how you'd expect in any spreadsheet. Formulas are relatively referenced as seen below.
To learn more about Formulas, visit the Formulas section of the docs.
Connect to your databases with SQL 🏡
With SQL in Quadratic you can create live connections from your spreadsheets to your data sources. Data from your SQL queries is returned to the sheet, anchored at the position of the SQL cell. Use the AI assistant to rapidly generate accurate SQL queries, and view your SQL schema in the editor's schema viewer. You can learn more here.
To learn more about SQL and connections, visit the SQL section of the docs.
Write some JavaScript 🟨
Press /
while in a cell and pick JavaScript as your code type.
From here, you'll find a first-class JavaScript experience. Do analytics, query APIs, use JavaScript packages, and create charts.
Learn more about JavaScript in Quadratic here.
Last updated