IMPORTDATA for CSV/TSV in Google Sheets - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

What does IMPORTDATA return for a CSV URL?

You use the formula =IMPORTDATA("https://example.com/data.csv") in a Google Sheets cell. The CSV file contains:

name,age,city
Alice,30,New York
Bob,25,Los Angeles

What will be the output in the sheet starting from the cell with the formula?

Google Sheets

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

A A single cell with the entire CSV text as one string

B A table with 3 columns and 3 rows: name, age, city in first row; Alice, 30, New York in second; Bob, 25, Los Angeles in third

C An error saying 'Unable to fetch data'

D Only the first row of the CSV (header) is imported

💡 Hint

IMPORTDATA imports the whole CSV as a table, splitting by commas and new lines.

IMPORTDATA fetches the CSV file and splits it into rows and columns automatically, placing each value in its own cell.

📊 Formula Result

intermediate

How does IMPORTDATA handle TSV files?

You enter =IMPORTDATA("https://example.com/data.tsv") where the TSV file contains:

product	price	quantity
Pen	1.5	10
Notebook	3.0	5

What will be the output in the sheet?

Google Sheets

=IMPORTDATA("https://example.com/data.tsv")

A A table with 3 columns and 3 rows, splitting values by tabs

B A single cell with the entire TSV text as one string

C An error because IMPORTDATA only works with CSV files

D Only the first row (header) is imported

💡 Hint

IMPORTDATA supports both CSV and TSV files and splits by commas or tabs accordingly.

IMPORTDATA detects the tab separators in TSV files and imports the data into separate cells accordingly.

❓ Function Choice

advanced

Which formula correctly imports a CSV file from a URL?

You want to import data from a CSV file at https://data.example.com/info.csv. Which formula will correctly import the data as a table?

A =IMPORTDATA("https://data.example.com/info.csv")

B =IMPORTRANGE("https://data.example.com/info.csv", "Sheet1!A1:C10")

C =IMPORTXML("https://data.example.com/info.csv", "//table")

D =IMPORTHTML("https://data.example.com/info.csv", "table", 1)

💡 Hint

IMPORTDATA is designed for CSV and TSV files, while others are for HTML, XML, or other sheets.

IMPORTDATA fetches CSV or TSV files and imports them as tables. IMPORTHTML and IMPORTXML are for web pages, IMPORTRANGE is for other Google Sheets.

🎯 Scenario

advanced

You want to import a CSV but only get an error

You use =IMPORTDATA("https://example.com/data.csv") but get an error: "Could not fetch URL". What is the most likely reason?

A You need to use IMPORTHTML instead

B The CSV file is too large for IMPORTDATA

C The file is not a CSV but an Excel file

D The URL is not publicly accessible or requires login

💡 Hint

IMPORTDATA can only fetch files from URLs that anyone can access without login.

IMPORTDATA requires the URL to be publicly accessible. If login or permissions are needed, it cannot fetch the file.

❓ data_analysis

expert

How many rows and columns does IMPORTDATA produce?

You import a CSV file with 5 rows and 4 columns using =IMPORTDATA("https://example.com/sample.csv"). The CSV has a header row plus 4 data rows.

How many rows and columns will the imported data occupy in the sheet?

A 5 rows and 5 columns

B 4 rows and 4 columns

C 5 rows and 4 columns

D 6 rows and 5 columns

💡 Hint

IMPORTDATA imports all rows including the header, and all columns as in the CSV.

The CSV has 5 rows total (1 header + 4 data) and 4 columns, so IMPORTDATA fills 5 rows and 4 columns in the sheet.