IMPORTDATA for CSV/TSV in Google Sheets - Dashboard Guide

Dashboard Mode - IMPORTDATA for CSV/TSV

Goal

See live data from a CSV file on the web inside your Google Sheet. This helps you track updates automatically without copying data manually.

Sample Data

Product	Sales	Region
Apples	100	East
Bananas	150	West
Cherries	200	East
Dates	120	South
Elderberries	90	West

Note: This data is from a CSV file hosted online.

Dashboard Components

• Raw Data Table: Imported live from CSV using =IMPORTDATA("https://example.com/sample-data.csv"). Shows all rows and columns from the CSV.
• Total Sales: Sum of sales column using =SUM(B2:B6). Shows total sales from imported data.
• Average Sales: Average sales using =AVERAGE(B2:B6). Shows average sales per product.
• Sales by Region: Summary table using =QUERY(A1:C6,"select C, sum(B) group by C label sum(B) 'Total Sales'",1). Groups sales by region.

Dashboard Layout

+----------------------+------------------+
| Raw Data Table       | Total Sales Card |
| (Imported CSV)       |                  |
|                      |------------------|
|                      | Average Sales Card|
+----------------------+------------------+
| Sales by Region Summary Table           |
+----------------------------------------+

Interactivity

You can add a filter dropdown for Region. When you select a region, the Raw Data Table, Total Sales, Average Sales, and Sales by Region summary update to show only data for that region.

This uses a filter formula or a slicer connected to the data range.

Self Check

If you add a filter to show only Region = East, which components update?

• The Raw Data Table shows only Apples and Cherries rows.
• Total Sales updates to 300 (100 + 200).
• Average Sales updates to 150.
• Sales by Region summary shows only East with total sales 300.

Key Result

Live import of CSV data with total, average sales, and sales by region summary.