1.1.4. Connect to spreadsheets

Leave a Comment / By LearningTableau / October 18, 2024

Which option allows connection to Google Sheets?

Google Drive

Google sheets

Google BigQuery

Looker

None

Which file types can you connect to using the Excel connector?

csv

xls

xlsx

txt

When you connect with Tableau to this file type a single table will automatically load

csv

xlsx

Google sheets

xls

None

What are key considerations when connecting Tableau to Microsoft Excel data?

Tableau automatically removes empty rows and columns from Excel sheets during the import process.

Tableau treats each worksheet or named range in Excel as a separate data source.

Excel formulas are directly converted into Tableau calculated fields without modification

When connecting to Excel, Tableau allows you to union multiple sheets into a single data source without manual configuration.

None

Time's up

Time is Up!

Post navigation

1.1.3. Connect to extracts

1.1.5. Connect to .hyper files (or .tde files)