How to☝️ Export a Chart from Google Sheets

To export a chart from Google Sheets, select the chart and click on the three-dot menu in the upper right corner. From here, choose either “Download” to save as an image or PDF or “Publish chart” to embed the chart in a website or for social media.

You can export your Google Sheets chart in many different ways. This article will cover various options to export your chart from Google Sheets. Keep reading to learn more!

How to Export a Google Sheets Chart as an Image

Follow these simple steps to export a Google Sheets chart as an image. We’ll use a pie chart as our example.

1. Select the chart and click on the three-dot menu in the top right corner. A menu will pop up.

pie chart

2. Select Download.

download

3. A list of options will appear. Select PNG image from the list.

download menue

The PNG image just created by Google Sheets will save in your downloads folder. Feel free to move the file to a better location on your computer to use as you like.

How to Export a Google Sheets Chart as a JPG File

In order to save your Google Sheets chart as a JPG, start by following the directions for saving it as a PNG as described above. Once you have the PNG file, you will need to use a PNG to JPG converter to change the file.

1. Select an online PNG to JPG converter such as PNG2JPG.com.

2. Click on Upload Files and select the saved PNG image from your device.

upload file

3. Press Download.

PNG to JPG

This program will automatically convert your PNG image into a JPG file. It’s as easy as that!

jpj file

How to Export a Google Sheets Chart as a PDF Document

Google Sheets also offers the option to save your chart as a PDF. Here’s how:

1. Select the chart and click on the three-dot menu in the top right corner.

pie chart

2. In the menu that appears, select Download.

download

3. From the list of options, choose PDF document.

pdf document

This will export the Google Sheets chart as a PDF document.

How to Export a Google Sheets Chart to Other Apps

There are times when you may need to use your Google Sheets chart in other apps, such as Google Docs or Microsoft Word. Thankfully, Google Sheets allows this function without too much trouble. Check out the section below to see how to export your Google Sheets chart to other apps.

Google Docs

Here’s what you need to do in order to export your Google Sheets chart into Google Docs:

1. Open your Google Docs document.

2. From there, click the Insert menu.

Gdocs insert

3. Select Chart in the drop-down menu.

Gdocs chart menu

4. Choose the option From Sheets.

add gdocs sheet

5. A list of your spreadsheets in Google Sheets will appear. Select the file with the chart you wish to insert.

gdocs file

6. Once you have selected the chart, press the Import button. You can also link directly to the sheet itself by ticking the box beside “Link to spreadsheet.”

Gdocs export

The chart has now been inserted into your Google Docs document.

Microsoft Word

If you need to add your Google Sheets chart to a Word document, simply follow the steps described below. First, make sure you save the Google Sheets chart as an image by following the process mapped out above.

1. Open your Microsoft Word document.

2. Click Insert.

MW insert

3. Go to Picture.

MW pic

4. Select the Google Sheets chart saved as an Image (PNG or JPG) on your device.

MW

5. Insert the image into your Word document.

Voila! The chart you created in Google Sheets is now in your Word document.

MW end

Google Slides

Here is how to export a Google Sheets chart into Google Slides:

1. Open up Google Slides.

2. Go to Insert

G slide insert

3. Select Chart.

gslide chart

4. From the drop-down menu, click From Sheets.

gslide sheet

5. A window will open showing all your spreadsheets saved in Google Sheets.

Gslides insert chart

6. Select the spreadsheet that has the chart you want to use.

Gslides select

7. Make sure the option “Link to the spreadsheet” is checked.

Gslide import chart

8. Click on the chart and select Import.

Gslides import chart

Your Google Sheets chart has now been added to Google Slides.

G slide end

Microsoft PowerPoint

Adding your Google Sheets chart to a PowerPoint presentation is as easy as adding it to a Word document. Remember to make sure you save the chart as an image first.

Here’s how to do it:

1. Open your Microsoft PowerPoint presentation.

2. Click Insert.

MPP insert

3. Go to Picture.

MW pic

4. Select the saved Google Sheets chart and attach it to the Microsoft PowerPoint presentation.

MW

It’s that easy!

MW finish

How to Embed a Google Sheets Chart on Another Website

Google Sheets gives you the flexibility to embed its charts on other websites. Simply follow these steps to do so:

1. Select the chart and click on the three-dot menu at the upper right corner of the chart.

3 dot button

2. In the menu that pops up, go to the Publish chart option.

publish chart

3. The “Publish to the web” dialog box will appear.

publish to web

4. Click on the Embed tab.

link

 5. Copy the link provided.

embed

6. Paste the code into your website and click save.

When you go to take a look at your website, you’ll see the chart there.

Bonus: How to Publish a Shareable Link

Google Sheets allows you to publish a shareable link to your charts on Twitter, Facebook, and Gmail.

Here’s the step-by-step procedure to publish a shareable link to your Google Sheets chart:

1. Click on the three-dot menu at the top right corner of the chart.

3 dot button

2. In the menu, select Publish chart.

publish chart

3. A window will pop up, and you have three options to share the link using Gmail, Facebook, and Twitter.

publish to web

Let’s take a look at each option.

How to publish a shareable Google Sheets chart on Gmail:

1. Click on the link.

embed

2. Select the Gmail icon.

fb icon

3. Gmail will open up a new message. Add the email address of the person you want to send it to and fill out the Subject line.

Gmail send

4. The link will be shared via Gmail.

When others receive your email and click the link, they will see the chart.

gmail end

How to publish a shareable Google Sheets chart on Twitter:

1. Click on the link.

embed

2. Copy the code.

3. Click the Twitter icon.

code

4. A window will open to allow you to type a new tweet.

Twitter window

5. Paste the code into the new tweet along with any comments you want to include.

6. Hit Tweet.

With this method, the chart will be published as a link.

When users click on the chart’s link, it will give them the opportunity to view it.

Twitter end

How to publish a Google Sheets chart on Facebook:

1. Click on the link.

link

2. Press the Facebook icon.

Fb icon

3. A window will open showing the option to Share on Facebook.

Fb share

4. Paste the code into the new Facebook post along with any comments you want to include.

5. Hit Post to Facebook.

FB end

When someone clicks on the link, they will see the chart.

Google Sheet Chart

 

 

 

 

 

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Amna Aslam
Amna Aslam
Amna is an electrical engineer and freelance writer. She loves connecting businesses to their customers through engaging and informative content. When she is not working, she enjoys watching KDramas.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X