Excel (Source)

Google Drive

  1. Start a new SQL block and select Sheets / CSV / Block as the source.

    Select Sheets/CSV/Block as Source

  2. Add a Sheet to your from statement by typing {{NAME}}. Replace NAME with a one word short reference to the Sheet / table (for example, select * from {{users}}).

  3. In the Parameters section, select Excel as the type.

    Select Excel under Parameters

  4. Select the spreadsheet from the drop-down. Since SeekWell currently only supports .xlsx files, this drop-down displays all .xlsx files in your Google Drive.

  5. Enter the Sheet name you want to query from.

  6. Run your SQL. Choose a destination to send the data from Excel to wherever you need it.

Was this page helpful?
×