How to Export Data and Save as Image in Excel?

In this tutorial, we will learn the approaches to save Excel as image. We will discuss the use of the keyboard shortcut, Camera, Copy a Picture and Save as Picture commands. Application of the graphical image editor, Snipping tool, and PowerPoint while saving Excel as image are also delineated.

Imagine a situation where you are bound to create a report. In contrast, you only own a spreadsheet file. In this case, you may require to use other applications to prepare a report using graphs, charts, and data. Therefore, the conversion of the graphs, charts, and data into images is inevitable.

Download Practice Workbook

To practice, please download the Excel Workbook file from the link below.

How to Save Excel Spreadsheet File as Image

1. Use Copy as Picture Command

The command Copy as Picture is an amazing tool to convert the Excel range into an image directly.

• Initially, select the B4:D14 range >> Then go to the Home tab >> Next, expand the Copy command >> After that, select Copy as Picture option >> Thus Copy Picture dialog appears >> Further, select As shown on screen option from the Appearance section >> Also select Picture from Format section and hit the OK button.

• Now press Ctrl + V keys to paste the range as an image >> Then Right-Click on Mouse to have Context menu >> Further, select the Save as Picture option from the Context menu list.

• Thus Save as Picture dialog appears. Next, edit the File name and select the JPEG File Interchange Format option from the Save as type field >> Finally, hit the Save Command.

• Therefore, we obtain the Excel range as JPEG file format with the Picture1 file name.

2. Apply Keyboard Shortcut

Screenshot options depend based on the hardware. For instance, an HP laptop allows Fn + Print Screen keys for screenshots. While some computer works with Windows + Print Screen keys. Also, you may use Shift + Windows + S keys to take screenshots.

• Here we are pressing Windows + Shift + S keys to take a screenshot and open with Snip & Sketch tool.

• Thus the captured screenshot opens with a default Image editor >> Then click on the Save As command from the Snip & Sketch dialog.

• Therefore, we saved the Excel spreadsheet as an image by capturing a screenshot.

Note: The use of Fn + Prt Sc keys captures the entire window (1366×768) and opens it with a default image editor.

3. Open with Snipping Tool

The Snipping Tool is the widely used screenshot tool.

• First, open the Spinning Tool application >> then expand the Mode command >> Next select the Rectangular Snip option from the list.

• Thus, the captured screenshot opens with the Snipping Tool dialog >> Next click on the Save command >> Type the File name and select JPEG from the Save as type field >> Finally, hit the Save command.

• In the end, we obtain the Excel spreadsheet as an image in the selected location.

4. Use Camera Feature

The most uncommon feature of converting the range of the Excel spreadsheet file into an image is using the Camera tool.

• Initially, press Alt + F + T to open the Excel Options dialog >> Then go to the Quick Access Toolbar menu >> Next select Commands Not in the Ribbon from the Choose commands from field >> After that, select Camera option >> Further, click on the Add command >> Finally, hit the OK command.

• Now select the B4:D14 range >> Click on the Camera command from the Excel dialog bar >> Select a suitable cell on Excel to place it as an image.

• Lastly, you can save images in .png/.jpg format by using the Save as Picture command from the Context menu.

How to Save an Excel Chart as Image

1. Use Save as Picture Tool

The Save as Picture tool from the Context menu can be useful to you in terms of converting the graph to a JPG or PNG  image.

• Firstly, Right-Click on the Mouse selecting the Excel chart >> Secondly, click on the Save as Picture option from the Context menu list.

• After that Save as Picture dialog appears. Next, edit the File name and select the JPEG File Interchange Format option from the Save as type field >> Finally, click the Save button.

• Thus, we save the Excel chart as a JPEG image.

2. Export with MS Paint

By copying and pasting to a graphics tool like MS Paint, one can save Excel charts as a JPEG or PNG image.

• To save the Excel charts as an image, firstly, copy the chart by pressing Ctrl + C keys from the Excel file >> Then open the MS Paint application >> Next, press Ctrl + V to paste the chart >> After that, click on the Save command >> Also, type Picture4 in the File name and select JPEG from the Save as type field >> Finally, hit the Save command.

3. Open with MS PowerPoint

Using the MS PowerPoint application you can export an Excel chart as an image.

• To save the Excel charts as an image, firstly, copy the chart by pressing Ctrl + C keys from the Excel file >> Then open the MS PowerPoint application >> Next, press Ctrl + V to paste the chart >> After that, press Ctrl + Shift + S keys to open Save As dialog.

• Thus Save As dialog appears. Next, rename the File name and select the JPEG File Interchange Format option from the Save as type field >> Finally, hit the Save command.

4. Use Excel VBA Macro

Users can save charts in a JPG or PNG image format from a specific sheet by applying a simple VBA code.

• Insert the following VBA code into the created module and click on the Run icon or press the F5 key.

Sub Save_Chart_As_Image()
Dim my_Chrt As ChartObject
Dim f_Path As String
    ' Setting the file location to save the chart as image
f_Path = "E:\Exceldemy\chart.png"
    ' Picking up chart from the Export worksheet
Set my_Chrt = Worksheets("Export").ChartObjects("Chart 1")
    ' Save the chart as PNG in the defined location
my_Chrt.Chart.Export f_Path, "PNG"
    ' Display message if the execution is successful
    MsgBox "Chart saved successfully to: " & f_Path
End Sub

• Therefore, we obtain the image of the Excel chart named chart in the E:\Exceldemy\ directory.

How to Export All Excel Charts and Graphs as Image

Using the below approach, you will be able to save all of your charts and graphs automatically in a desired location.

• Press Alt + F + A + O keys to open the Save As dialog.

• Thus Save As dialog appears. Now rename as Save Excel as Image from the File name >> Then select Web Page from the Save as type field >> Next select the Entire Workbook option from Save field >> Finally hit the Save command.

• Therefore, we get the outcome as images of charts.

How to Save an Excel Table as Image

The use of the Camera tool can be an excellent way to save an Excel table as an image.

• Firstly select the B4:D14 range >> Then click on the Camera command >> After that click on a suitable cell to the table as an image.

• Further, you will be able to export as a picture by using the Save as Picture option from the Context menu.

Note: Conversion of Excel tables as JPEG, JPG, and PNG are almost similar approaches to conversion range from an Excel file.

Why Convert Excel to JPG/PNG Image?

Excel is quite helpful for performing calculations and producing graphs visually illustrating results. To make your file more accessible, especially if you’ve developed something like a graph in Excel, you can convert spreadsheets into images. However, JPG or PNG are the most widely used picture formats. Any recipient you send it to ought to be able to open it. In addition, images allow you to be inserted while constructing necessary reports, surveys, banners, and so on.

Frequently Asked Questions

1. Will I lose formatting when I save Excel as JPG?

You can save an Excel file as JPG using the static spreadsheet without changing its formatting. However, the dynamic spreadsheet may lead changing in its formatting while converting as JPG or PNG images.

2. How do I save an Excel table as a high-resolution image?

First, select the range >> Click on the Camera command >> Select a cell to insert the table as an image >> Right-Click on the Mouse selecting the image >> Click on the Save as Picture option from the Context menu list >> edit the File name and select the JPEG File Interchange Format option from the Save as Type field from the Save As dialog >> Finally, hit the Save command.
You may go through Save Excel Table as Image with High Resolution for better understanding.

3. How can I save images from Excel?

Right-Click on the Mouse selecting the image individually >> Click on the Save as Picture option from the Context menu list >> Edit the File name and select the JPEG File Interchange Format option from the Save as Type field from the Save As dialog >> Finally, click the Save button.
To learn 3 amazing approaches, you may go through Save Pictures from Excel.

Conclusion

In short, we illustrated the approaches to save Excel as image concisely. Further, if you are keen enough to learn some advanced approaches to saving Excel tables, and charts in a picture format, you can follow the resources from the Knowledge Hub section. However, Use the comment section below to leave your thoughts. Any suggestions regarding the article are appreciated.

Save Excel as Image: Knowledge Hub

• Save Picture to Folder
• Save Image as JPG
• Save Table as Image High Resolution
• Save Chart as Image High Resolution
• VBA to Save Chart as Image

<< Go Back to Export Data from Excel | Learn Excel