I made a nice Google Spreadsheet which I later on wanted to integrate as a table into a Google Docs Document. I thought this was an easy task, but sadly I was wrong. A simple copy & paste didn’t work. So I searched the web for possible solutions. But all i found were some outdated solutions using the no longer available “show as html” feature.
So I came up with my own solution, which is quite easy but needs the help of your desktop spreadsheet application like Excel, LibreOffice or OpenOffice. I’m sure there are others, that will work, too.
Everything you have to do is to copy your spreadsheet from Google Docs and paste it in your desktop spreadsheet application, which asks you how you want to convert the data. It will automatically use the right settings, so just click okay. Now select your whole spreadsheet and paste it in your Google Docs document and you will have a nicely formatted table.
Know a solution, that will make this task more efficient or easier? Please tell me in the comments!