Convert Google Docs Table to Spreadsheet – How to Guide

google docsgoogle sheets

I've tried selecting the table in the document, copying it, and pasting into a new spreadsheet, but this results in a one-column spreadsheet with all of the columns flattened into one.

I don't see a way to select a single column, or I could potentially copy the table a column at a time (it only has about 13 columns).

I only have to do this to one document, so a multi-step process is OK.

PS, I'm using the Chrome browser on a Mac

Best Answer

I just tried it in Chrome on Windows and it works the following way. Start selecting the table just below the lower-left cell (click where the cursor changes to the one indicating text entry) and drag the selection all the way up to the top-left cell until all of them are filled with a blueish highlight. Then press CTRL + C, switch to Google Spreadsheet and press CTRL + V.

In the screenshot the highlight is gray because the window was out of focus.

image