IMPORTDATA for CSV/TSV in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at an online retail company.

📋 Request: Your manager wants you to quickly analyze the latest sales data which is stored in a CSV file online. They want you to import this data into Google Sheets to create reports.

📊 Data: You have a URL link to a CSV file that contains sales data with columns: Date, Product, Region, Units Sold, and Revenue.

🎯 Deliverable: Import the CSV data into Google Sheets using a formula, so the data updates automatically when the CSV file changes.

Sample Data

Date	Product	Region	Units Sold	Revenue
2024-05-01	Widget A	North	10	200
2024-05-01	Widget B	South	5	150
2024-05-02	Widget A	East	8	160
2024-05-02	Widget C	West	12	300
2024-05-03	Widget B	North	7	210
2024-05-03	Widget C	South	9	225
2024-05-04	Widget A	East	11	220
2024-05-04	Widget B	West	6	180

1

Step 1: Open a new Google Sheets document where you want to import the sales data.

Expected Result

A blank spreadsheet ready for data import.

2

Step 2: In cell A1, enter the IMPORTDATA formula with the URL of the CSV file to import the data.

=IMPORTDATA("https://example.com/sales_data.csv")

Expected Result

The sales data from the CSV file appears starting at cell A1, filling columns Date, Product, Region, Units Sold, and Revenue.

3

Step 3: Check that the data imported correctly by verifying the first row contains the headers and the following rows contain the sales records.

Expected Result

Row 1 shows headers: Date, Product, Region, Units Sold, Revenue. Rows 2-9 show the sales data matching the CSV content.

4

Step 4: To confirm the data updates automatically, refresh the CSV file online with new data and reload the Google Sheet to see the changes.

Expected Result

The Google Sheet updates to show the latest data from the CSV file without needing to re-enter the formula.

Final Result

Date       | Product | Region | Units Sold | Revenue
-----------------------------------------------------
2024-05-01 | Widget A| North  | 10         | 200
2024-05-01 | Widget B| South  | 5          | 150
2024-05-02 | Widget A| East   | 8          | 160
2024-05-02 | Widget C| West   | 12         | 300
2024-05-03 | Widget B| North  | 7          | 210
2024-05-03 | Widget C| South  | 9          | 225
2024-05-04 | Widget A| East   | 11         | 220
2024-05-04 | Widget B| West   | 6          | 180

✓The IMPORTDATA formula successfully pulls live data from the CSV URL.

✓Data updates automatically when the source CSV file changes.

✓This method saves time by avoiding manual copy-paste and ensures data accuracy.

Bonus Challenge

Use the imported data to calculate total revenue per region using a formula.

Show Hint

Use SUMIF to add revenue values where the region matches each region name.