Skip to content

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
DataFrameas
df
variable
SELECT *
FROM Sheet1 -- Replace 'Sheet1' with the name of the sheet you want to import from
Spinner
DataFrameas
df1
variable
eazeazeaz

Want to learn more?

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

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