Excel (Source)

Google Drive

  1. Start a new SQL block and select "Sheets / CSV / Block" as the source.
  2. image
  3. Add a Sheet to your from statement by typing {{NAME}} . Replace NAME with a one word short reference to the Sheet / table (e.g. select * from {{users}}).
  4. In the "Parameters" section, pick "Excel" as the type.
  5. image
  6. Select the spreadsheet from the drop down. We currently only support .xlsx files and this will show all .xlsx files in your Google Drive.
  7. Enter the Sheet name you want to query from.
  8. Run your SQL. Choose a destination to send the data from Excel wherever you need it!