In this tutorial, we will learn How to Convert Google Doc to Google Sheets.
You might have a requirement wherein you want to transfer your data in Google Docs to Google Sheets. Let’s find out How to convert Google doc to Google Sheets
Here are the steps to convert Google doc to Google Sheets.
- By using Copy and Paste method
- Select all the data in your Google doc that you need to convert to Google Sheets.
- Go to your Google Sheet and Right-click on it then Choose Paste or keyboard Shortcut press Ctrl + V.
- Saving Google doc to Microsoft Word and then Copying the Data
- Go to the Main Menu bar of your Google doc and click on the FILE menu
- Now open the save file in Microsoft Word.
- Go to your Google Sheet and Right-click on it then Choose Paste or keyboard Shortcut press Ctrl + V.
How to Convert Google Doc to Google Sheets : Step by Step Guide
You can convert Google doc to Google Sheets using Copy and Paste method
You can simply use the copy and paste method to convert small tables with fewer data. However, you might have a formatting issue with columns and rows.
Enclosed are the steps to copy and paste.
Step 1: Select all the data in your Google doc that you need to convert to Google Sheets.
Once the data is selected right click with the mouse and click on Copy. You can also use the keyboard shortcut Ctrl + C
Step 2: Go to your Google Sheet and Right-click on it then Choose Paste or keyboard Shortcut press Ctrl + V.
It works perfectly fine when you have a small dataset. But with a large dataset, your original formatting might be lost.
Saving Google doc to Microsoft Word and then Copying the Data
Another method to convert Google Docs to Google Sheets is to save your Google doc to MS word format and then copy it from MS word to Google Sheet.
Enclosed are the steps for the same.
Step 1: Go to the Main Menu bar of your Google doc and click on the FILE menu
On the top left corner of your Main menu bar select the File menu
File>Download>Microsoft Word (.docx). Save this file on your computer
Step 2: Now open the save file in Microsoft Word.
- Once the file is open in MS word, navigate to the top left corner of the table until you see a cross sign with arrow signs in all directions.
- Click on that sign to Select the entire table
- Now right click and select copy or use the keyboard Shortcut CTRL+C.
Step 3 : Go to your Google Sheet and Right-click on it then Choose Paste or keyboard Shortcut press Ctrl + V.
Using this method will paste the entire table with rows and Columns as it is without changing the source formatting.
Other FAQs
Is it Possible Convert a Google Doc to Google Sheets?
if the data on your Google doc is in tabular format with rows and columns, then you can convert Google Docs to Google Sheets.
If you are trying to copy any other data format without a table, you will not get the desired source formatting after pasting it in Google Sheet.
Conclusion
In the above tutorial, we have discussed two methods to convert Google Docs to Google Sheet.
We hope this tutorial on How to Convert Google Doc to Google Sheets was helpful.
Related articles :
Google Sheets Formulas Not Updating ( Easy Fix )
How to Add or Remove Dollar Sign in Google Sheets ( Easy Guide )
How to use Median IF function in google sheets ( Easy Guide )
