In this article:

Insert a Google Doc Into a Google Sheet (Easiest Way in 2024)

October 23, 2024

In this tutorial, we will show you how to insert a Google Docs file into Google Sheets in just a few simple steps. Simply follow the steps below.

how to insert a google doc into a google sheet

How to Insert a Google Doc Into a Google Sheet

Follow the steps below to insert a Google Docs file into Google Sheets.

1. Open Your Google Docs File

Sign in to Google Docs and open the document you want to insert into Google Sheets. Make sure the content is formatted properly for easier importing later.

how to insert a google doc file into a google sheet

2. Download the File in a Zipped Format

Click "File" in the menu, then select "Download." Choose "Web page (.html, zipped)" to download the document in a compressed file.

how to insert a google doc into google sheet

3. Unzip the Downloaded File

Locate the (.zip) file on your computer and right-click to extract it. This will give you an (.html) file that Google Sheets can import.

how to place a google doc into a google sheet

4. Import The Extracted File into Sheets

In your Google Sheets, click "File," select "Import," and upload the (.html) file. Choose "Append to current sheet" and click "Import data" to insert it below the existing content.

how to insert a google docs into a google sheet

5. Adjust The Cells 

Once the file is imported as data, you can adjust it accordingly.

how to insert a google docs file into google sheet

We hope that you now know how to insert a Google Doc into Google Sheets. If you enjoyed this article, you might also like our articles on how to insert your image behind a cell in Google Sheets and how to insert a document into Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->