Unfortunately, you will not be able to update the data when you add new rows in the dataset (deleting rows is fine and will be accounted for). When you insert the data from Google Sheets into a Google Docs document, it is only linked to that specific range.įor example, in our example, we have inserted the range A1:E7 from Google Sheets into the Google Docs.īut what if I add a new row to the dataset (at the end of the dataset or somewhere in the middle). Also, you can also use conditional formatting on the Google Sheets data and it will be reflected in the data in Google Docs (I find this super cool!). Note that while you can update the data to reflect the color of the cell, the border of the table is not linked. And when I click on it, it will bring the formatting the spreadsheet data into Google Docs. And to apply that change and make it visible in the Google Docs, you need to click on the ‘Update’ button.Īpart from the change in the value in the cells, you can also bring the formatting from Google Sheets into Google Docs.įor example, if I manually change the color of a few cells in the original data in the Google Sheets, I will see the Update button in Google Docs. The Update button appears only when there has been a change in the Google Sheets data. When you change any data in the original range in Google Sheets (that has been copied and inserted in the Google Docs), you will see an option to update the table in Google Docs (only appears when you select any cell in the table). It will simply paste it as regular unlinked data. If you try to copy data from Google Sheets from one account into Google Docs from some other account, it will not show you the Paste Table dialog box. This works only when both the Google Sheets and Google Docs document are in the same account (or have been shared with full-access).It, however, gives you an option to update the data with a single click The copied data in Google Docs is connected/linked to the original data but it doesn’t get updated in real-time.There are two things you need to know when using this technique: You will have to manually update the table by clicking the update button (covered in the next section). Since this table is connected to the original data in Google Sheets, when you make any changes in the source data in Google Sheets, you will be able to update this table and reflect the changes in the copied table as well.Īnd remember that the data doesn’t get updated is not real-time. The above steps would insert the Google Sheets table in the Google Docs document.
In the Paste Table dialog box, make sure the ‘Link to Spreadsheet’ option is checked.
This would open the ‘Paste Table’ dialog box