Google Docs to Google Sheets - Step-by-Step Guide
AD
Adele
Jun 06, 2025
Google Docs to Google Sheets - Step-by-Step Guide
To convert Google Docs to Google Sheets, the quickest method is to copy a table or list from your Doc, open a new spreadsheet, and paste it directly - Google Sheets preserves the row-and-column structure automatically. For plain text or bulk data, you can download the Doc as a CSV or plain-text file and import it into Sheets. Neither route requires any add-on or paid tool.
This guide walks through every method with exact steps, explains when each one works best, and covers the common formatting issues you will hit along the way.
Why move content from Google Docs to Google Sheets?
Google Docs is built for writing. Google Sheets is built for analyzing. The two overlap when you need both - for example, a survey you drafted in a Doc that now needs to become a spreadsheet for reporting, or a checklist that should turn into a tracked task list. Converting the content saves you from retyping and keeps the data consistent.
How to convert Google Docs to Google Sheets
There are three practical methods. Choose the one that fits your content type.
Step 1: Identify your content type
Look at what is in your Google Doc before you start:
- Table - rows and columns already structured. Use the copy-paste method below.
- Bulleted or numbered list - use copy-paste, then split the text into columns after pasting.
- Plain paragraphs or mixed content - download as plain text or CSV, then import.
- Large dataset with many docs - use Google Apps Script to automate.
Step 2: Copy the content from Google Docs
Highlight everything you want in the spreadsheet. Right-click and choose Copy, or press Ctrl+C on Windows or Cmd+C on Mac. If you are copying a table, click inside the table first, then press Ctrl+A to select all table cells, then copy.
Step 3: Open Google Sheets
Go to sheets.google.com and open a new or existing spreadsheet. Click the cell where you want the data to start - usually A1.
Step 4: Paste into the spreadsheet
Press Ctrl+V or Cmd+V. Google Sheets will place each table cell in its own spreadsheet cell. Bulleted lists paste as one item per row in column A. Tabbed text from a Doc splits cleanly across columns.
If the paste lands in a single cell instead of spreading across the grid, try Paste Special (Ctrl+Shift+V) and choose "Paste values only" - then use the Data menu to split text into columns.
Step 5: Clean up and format
After pasting, do a quick pass:
- Resize columns by dragging the column header borders
- Remove blank rows with right-click "Delete row"
- Use Format > Number to set date, currency, or number formats
- Use Data > Remove duplicates if you merged content from several docs
Alternative: download as CSV and import
If copy-paste produces garbled output, the download-and-import route is more reliable for plain text or tab-separated data.
- In Google Docs, go to File > Download > Plain Text (.txt) or Tab-separated values if your Doc already has tab-delimited data.
- In Google Sheets, go to File > Import > Upload, and select the file you just downloaded.
- In the import dialog, set "Separator type" to "Tab" or "Detect automatically" and click Import data.
This approach works well for exported reports, survey exports, or any Doc that was originally generated from a structured data source.
Automate with Google Apps Script
For teams that regularly move data from Docs to Sheets, Apps Script removes the manual steps entirely. Here is a basic script that reads all paragraph text from a Doc and writes each paragraph as a row in a Sheet:
javascriptfunction docToSheet() {
var doc = DocumentApp.openById('YOUR_DOC_ID');
var sheet = SpreadsheetApp.openById('YOUR_SHEET_ID').getActiveSheet();
var body = doc.getBody();
var paragraphs = body.getParagraphs();
paragraphs.forEach(function(para, i) {
sheet.getRange(i + 1, 1).setValue(para.getText());
});
}
Replace
YOUR_DOC_ID and YOUR_SHEET_ID with the IDs from each file's URL. Run the script from the Apps Script editor (Extensions > Apps Script in Sheets).What does not transfer cleanly
Even with the best method, some elements need manual fixes:
- Merged cells in Docs tables paste as separate cells in Sheets
- Images and drawings do not transfer - only text and numbers move
- Fonts and colors are stripped; Sheets applies its own default style
- Checkboxes paste as the text "TRUE" or "FALSE" rather than interactive boxes
- Formulas in a Doc (if added with an add-on) do not carry over as live Sheets formulas
Need a Google Form instead of a Sheet?
If your Google Doc contains questions - a quiz, survey, or assessment - converting to a spreadsheet is only half the picture. You probably also need a Google Form to collect new responses.
Formswrite converts a Google Doc into a Google Form in one click. Paste the Doc link, click Convert, and Formswrite builds the Form with all questions, answer options, and quiz answer keys in place. There is no add-on to install and no manual retyping.
Once you have a Form, Google Forms automatically writes every response into a linked Google Sheet - so you get both the form and the spreadsheet in a single step. See the Google Doc to Google Form converter for more detail.
Formswrite also exports to 40+ platforms including Moodle, Canvas, Kahoot, and Quizizz. A free plan is available; export to most third-party platforms requires a paid plan.
FAQ: Google Docs to Google Sheets
Can Google Docs export directly to Google Sheets?
There is no one-click export button built into Google Docs. The practical options are: copy and paste content directly into Sheets, download the Doc as a plain-text or CSV file and import it into Sheets, or write a short Google Apps Script to automate the transfer.
How do I convert a table in Google Docs to Google Sheets?
Click inside the table in your Google Doc, select all cells, copy, then paste into Google Sheets. Each cell in the Doc table lands in its own spreadsheet cell. You may need to resize columns and remove a blank header row after pasting.
Why does my pasted content land in one cell instead of spreading across columns?
This happens when the text uses spaces rather than tabs to separate values. Use Data > Split text to columns after pasting, or paste via Paste Special and choose "Paste values only" first, then split.
Can I automate moving data from Google Docs to Google Sheets?
Yes. Google Apps Script lets you write a short function that reads text or table data from a Doc and writes it to a Sheet on a schedule or trigger. The script runs inside the Google Workspace environment with no external tools needed.
Does Google Sheets support importing a .docx file?
Google Sheets does not import Word or .docx files directly. Convert the document to Google Docs format first via Google Drive (right-click the .docx file and choose Open with Google Docs), then copy the content into Sheets.
What is the easiest way to turn a Google Doc with questions into a form?
Use Formswrite. Paste your Doc link, click Convert, and you get a ready Google Form with all questions and answer options. Google Forms then creates a linked Sheet automatically when the first response comes in.
Is Formswrite a plugin or add-on?
No. Formswrite is a standalone website - nothing to install in Google Docs or Chrome. Go to formswrite.com, paste your document link, and click Convert.
How long does it take to convert a Google Doc to Google Sheets?
For copy-paste, a few seconds. For a large Doc downloaded as CSV and imported, under a minute. For Apps Script automation, a few minutes to write and run the script the first time, then instant on subsequent runs.
Turn your spreadsheet into a form
Convert an Excel sheet or Google Sheet of questions into a Google Form.
Convert a spreadsheet →Or go straight to a converter: Google Docs to Forms, PDF to Google Form, Word to Google Form, Google Forms Quiz Generator