Linking Sheets with Docs in Google Sheets - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

What is the output of this formula linking a Google Doc?

You have a Google Sheet with this formula in cell A1:

=IMPORTDATA("https://docs.google.com/document/d/e/2PACX-1vQabc12345/pub?output=csv")

What will this formula do?

A It imports the published Google Doc content as CSV data into the sheet.

B It imports the Google Doc as an image into the sheet.

C It creates a live link to open the Google Doc but does not import data.

D It returns a #REF! error because IMPORTDATA cannot read Google Docs.

💡 Hint

Think about what IMPORTDATA does with URLs that point to CSV or TSV files.

IMPORTDATA imports data from a URL that points to CSV or TSV files. If the Google Doc is published as CSV, it imports the content as table data.

❓ Function Choice

intermediate

Which function correctly imports a table from a published Google Doc into Sheets?

You want to import a table from a Google Doc published as a web page. Which function should you use in Google Sheets?

A IMPORTXML

B IMPORTDATA

C IMPORTRANGE

D IMPORTHTML

💡 Hint

Think about which function imports tables or lists from web pages.

IMPORTHTML imports tables or lists from web pages, which works well with Google Docs published as web pages containing tables.

🎯 Scenario

advanced

You want to keep your Google Sheet updated with changes from a Google Doc table. What is the best approach?

You have a Google Doc with a table that changes often. You want your Google Sheet to update automatically when the Doc changes. Which method is best?

A Copy and paste the table manually each time it changes.

B Publish the Google Doc as a web page and use IMPORTHTML in Sheets to import the table.

C Use IMPORTRANGE to link the Google Doc to the Sheet.

D Download the Google Doc as Excel and upload it to Sheets.

💡 Hint

Consider which method allows automatic updates without manual work.

Publishing the Doc as a web page and using IMPORTHTML imports the table live, so changes in the Doc update the Sheet automatically.

📊 Formula Result

advanced

What error will this formula produce?

In Google Sheets, you enter:

=IMPORTRANGE("https://docs.google.com/document/d/abc123", "Sheet1!A1:B2")

What will happen?

A #REF! error because IMPORTRANGE cannot import from Google Docs.

B It imports the entire Google Doc as text.

C #VALUE! error because the URL is invalid.

D It imports the range A1:B2 from the Google Doc.

💡 Hint

IMPORTRANGE works only with Google Sheets URLs.

IMPORTRANGE only works with Google Sheets URLs, not Google Docs, so it returns a #REF! error.

❓ data_analysis

expert

How many rows will be imported by this formula?

You publish a Google Doc containing a table with 5 rows and 3 columns as a web page. In Google Sheets, you use:

=IMPORTHTML("published_doc_url", "table", 1)

How many rows will this formula import?

A 6 rows including an extra empty row

B 4 rows excluding the header row

C 5 rows including the header row

D Only 1 row because IMPORTHTML imports headers only

💡 Hint

IMPORTHTML imports the entire table including headers.

IMPORTHTML imports the whole table including the header row, so 5 rows total if the table has 5 rows.