Converting Google docs to Google sheets

You might need to transfer some data that is in google docs to google sheets so that you can work on it more easily.

In this article let us see how to insert a google docs table into google sheets.

Using simple copy-paste

The first way is a simple copy-paste method. While it is the simplest way to copy from google docs, sometimes some rows or columns, especially in larger tables, do not paste as you want them to but it is still worth a try.

Select the text from the google docs table that you want to copy and press Ctrl+C on your keyboard or right click and select “copy”.

Right click on the cell in google sheets that you want to paste the table in and select “paste” or press Ctrl+V on your keyboard.

Using MS Word

A better method is to download the document and use MS Word to open it and transfer the table over to google sheets.

In your google docs page in the top left corner, select File>Download>Microsoft Word (.docx) and save it on your computer.

Re-open the file in MS Word and look for an icon at the top left of the table, pressing which will select the entire table. Click on that and press Ctrl+C on your keyboard to copy the table.

Open google sheets and press Ctrl+V on your keyboard to paste the table as is in your worksheet.

Note that converting from docs to sheets works best when your data is already in the form of a table. If you are trying to copy normal texts and paragraphs the formatting will be messed up and not look that great.

Recent Content