Skip to content
New Workbook
Sign up
Analyze Google Sheets data

Analyze Google Sheets data

  • Open the "Databases" tab in the sidebar on the left.
  • Click the + icon.
  • Select 'Google Sheets'.
  • Follow the on-screen instructions. In the file picker that appears, select the spreadsheet you want to access.
  • In the SQL cell below, select the Google Sheets file you just connected.
  • Adapt the query to pull data from the right sheet.
  • Click "Run" on the cell menu.

Your Google Sheets data is now available as a DataFrame df, ready to continue your analysis!

Spinner
DataFrameavailable as
df
variable
SELECT *
FROM Sheet1 -- Replace 'Sheet1' with the name of the sheet you want to import from
Spinner
DataFrameavailable as
df1
variable
eazeazeaz

Want to learn more?

Check out the dedicated documentation article for in-depth information.

Spinner
DataFrameavailable as
df2
variable
Current Type: Bar
Current X-axis: None
Current Y-axis: None
Current Color: None