Thursday, April 28, 2016

Saving Google Docs/Sheets charts as PDF

Google docs natively supports saving charts as PNG. But if you want to generate high quality images, such as PDF, you can follow the steps below.

1. Go to the Google Spreadsheet page with the chart
2. Open Chrome Developer Tools (from Chrome hamburger menu -- 3 lines menu -- on the top right)
3. Select the "Elements" tab and click on the button "Select an element to inspect it" present on the top left.
4. Click in the chart area.
5. Look at the tree and find the beginning of svg description (e.g. <svg...).
6. Right click on the SVG line and select "Copy as HTML"
7. Paste it to your favorite editor, and save as "MyChart.svg"

You can use image processing tools, such as Photoshop or GIMP to export the files as PDF.

References:
1. http://www.osmanoglu.org/computing/89-how-to-export-google-spreadsheet-charts-as-svg

No comments:

Post a Comment