Getting started

Get started writing rich Python code inside the spreadsheet.

Python is a first-class citizen in Quadratic that integrates seamlessly with the spreadsheet. Below is a quick start to get going with Python in Quadratic.

Quick start

1. Select the cell where you want to write Python code.

1. Press / to bring up the cell type menu. Select Python.

1. Write Python in the code editor. The last line of code is returned to the sheet at the cell position.

Learn more

The following is a list of essential information for learning how Python works in Quadratic.

1. Reference cells - get data from the sheet into Python with cell references

2. Return data to the sheet - return Python outputs from code to the sheet

3. Import packages - import packages for use in your Python code

4. Make API requests - use the Requests library to query APIs

5. Visualize data - turn your data into beautiful charts and graphs with Plotly

The most common starting point is learning how to reference spreadsheet cells from Python in Quadratic.

Learn how to: 👉 Reference cells in the sheet from Python

Learn how to: 📥 Display data in the sheet from Python

Learn how to: 📈 Ingest data using Python

Learn how to: 📊 Visualize data using Python

Learn how to: 📦 Use Python packages in Quadratic

Learn how to: 🧹 Clean data using Python

Learn how to: 🎥 Manipulate data using Python