IMPORTDATA for CSV/TSV in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to import data from a CSV URL.

Google Sheets

=IMPORTDATA([1])

Drag options to blanks, or click blank then click option'

AIMPORTCSV

Bdata.csv

CA1

D"https://example.com/data.csv"

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put the URL in quotes

Using a cell reference without quotes

Using a function name that doesn't exist

The IMPORTDATA function requires the URL as a text string inside quotes.

2fill in blank

medium

Complete the formula to import data from a TSV URL.

Google Sheets

=IMPORTDATA([1])

Drag options to blanks, or click blank then click option'

A"https://example.com/data.tsv"

Bdata.tsv

CA2

DIMPORTTSV

Attempts:

3 left

💡 Hint

Common Mistakes

Using a local file name without quotes

Using a function that does not exist like IMPORTTSV

Not including the full URL

IMPORTDATA works for both CSV and TSV files by providing the correct URL as a string.

3fill in blank

hard

Fix the error in the formula to correctly import CSV data.

Google Sheets

=IMPORTDATA([1])

Drag options to blanks, or click blank then click option'

Ahttps://example.com/data.csv

B"https://example.com/data.csv"

Cdata.csv

DIMPORTDATA("https://example.com/data.csv")

Attempts:

3 left

💡 Hint

Common Mistakes

Leaving out the quotes around the URL

Using a cell reference without quotes

Trying to call IMPORTDATA inside its own argument

The URL must be a text string inside quotes. Without quotes, it causes an error.

4fill in blank

hard

Fill both blanks to import data from a CSV URL stored in cell A1.

Google Sheets

=IMPORTDATA([1][2])

Drag options to blanks, or click blank then click option'

AA1

B"

D'

Attempts:

3 left

💡 Hint

Common Mistakes

Adding quotes around the cell reference

Using single quotes instead of double quotes

Trying to concatenate quotes with the cell reference

When the URL is in a cell, just use the cell reference without quotes inside IMPORTDATA.

5fill in blank

hard

Fill all three blanks to import data from a URL in cell B2 and convert it to uppercase.

Google Sheets

=ARRAYFORMULA(UPPER([1]([2][3])))

Drag options to blanks, or click blank then click option'

AIMPORTDATA

BB2

D"

Attempts:

3 left

💡 Hint

Common Mistakes

Putting quotes around the cell reference

Using a wrong function name

Not wrapping with ARRAYFORMULA for range conversion

Use IMPORTDATA with the cell reference B2 (no quotes) inside UPPER wrapped by ARRAYFORMULA to convert all text to uppercase.