The tutorial explains different ways to convert .xls to .jpg including built-in tools that allow saving an Excel worksheet as an image file as well as free Excel to JPG converters online.
Converting an Excel sheet to an image sounds like something that can be useful in many situations such as designing a whitepaper or tutorial, creating a presentation, or safely sending your spreadsheet data via email.
Whilst you can easily save an Excel file to several formats including PDF by using the standard "Save As" dialog, surprisingly, .jpg is not in the list. Luckily, there exist a handful of different ways to convert Excel to JPEG, both desktop and online, and in a moment you will learn the most useful ones.
It is the most popular technique to convert the currently visible on-screen part of your Excel sheet to JPG or any other image format. Here's how:
Here's what my sample Excel table exported to Paint looks like:
It is another amazingly simple way to get an image of your Excel sheet that very few people know about. Snipping Tool is specially designed to take a snapshot of the screen and is included with all modern versions of Windows, from Windows 7 to Windows 10.
Unlike the Print Screen feature, Snipping Tool gives you the following choices as to what to capture:
To locate Snipping Tool on your computer, click the Start button, type "snipping tool" in the search box, and then click on Snipping Tool in the list of results. If you don't want to capture a snip immediately, click the Minimize button to send it to the task bar, switch to Excel and open the spreadsheet of interest.
To convert an Excel sheet to JPG (or another image format), perform the 3 quick steps outlined below:
Whatever simple and straightforward the previous methods are, they have one significant limitation - they can only capture the part of a worksheet that is visible on the screen. In some situations, zooming out might help, but not when it comes to capturing a really big table that contains tens or thousands of rows. To get around this limitation, use the good old copy/paste technique, which allows copying any part of an Excel sheet including beyond the scroll areas, and then pasting the copied contents to wherever you want.
To save your Excel worksheet as a .jpg image, perform the following steps:
Alternatively, on the Home tab, in the Clipboard group, click the little arrow next to Copy, and then click Copy as Picture…
This will give you the choice of whether to save the copied data As shown on screen or As shown when printed:
Visually, an Excel table saved as an image is indistinguishable from the original one. If you copy the image back to Excel, it's almost impossible to spot the difference unless you try selecting the data :)
One more way to quickly take a snapshot of your Excel data is using the Camera tool. A really cool feature of Excel Camera is that it creates a dynamic image that syncs with the original dataset and gets updated whenever the original data changes.
In order to use the Camera tool, you must add it to the ribbon or Quick Access Toolbar manually because it does not show up by default. To have it done, perform these steps:
Now, you have the Camera button on the Quick Access Toolbar:
To save an Excel table as image using Camera, just do the following:
Now, you can make the image bigger or smaller by dragging the sizing handles. Or, you can apply different Picture Styles by using the Picture Tools tab that appears as soon as you select the image. For example:
When you are happy with the image design, you can export the Excel camera output to anywhere. For this, simply select the picture and press Ctrl + C to copy it (or right-click and then click Copy). After that, open another application, say Paint, Word or PowerPoint, and press Ctrl + V to paste the copied image. Or, you can assemble bits from several worksheets onto one page, and then save it as image by using any of the methods described above. Just remember that only a linked picture on the sheet is "live". When copied outside of Excel, it becomes a regular image and it won't update when the original data in the worksheet changes.
If you have a lot of Excel files to be exported to images, you can save time by committing the job to some online Excel to jpg converter. Below you will find just a couple of many free converters available on the web.
It is my favorite online converter that supports a great variety of document and image formats including Excel to JPEG conversion.
Here's how you can convert Excel to JPG online:
To give it a try, please follow this link: Convertino Excel to JPG.
It's another popular online service that can convert your Excel files to JPG as well as to many other formats. With Zamzar, it's not possible to download the converted files directly from the web-site, they send the output by email, which is not my personal preference. Apart from that, it's a nice free XLS to JPG converter with an intuitive user interface:
To see it in action, please follow this link: Zamar XLS to JPG.
If for some reason neither of the above tools suits you, you can find plenty more similar services by typing something like "convert xls to jpg online" or "xlsx to jpg online" in your preferred search engine.
This is how you can convert Excel to JPG online and desktop. I thank you for reading and hope to see you on our blog next week!
8 responses to "How to convert Excel to JPG, PNG or GIF image"
Hi, no need for a response, just wanted to add to your list the "send to one note tool".
The shortcut: windows logo + s
this will freeze the screen and give you a cursor to select the area you want to clip.
Then it will be pasted in One Note as an image that you can, then, export or save, but only as a .png. Of course you can always paste it on word and change the format there.
Thank you for your list.
Hi Alex,
Thank you for this useful information. It has never occurred to me to use OneNote to make an image of Excel, but it works beautifully!
BTW, on Windows 10, the OneNote screen clipping shortcut is Windows + Shift + S.
Hi Svetlana,
I hope you are fine.
Can you help me with the issue of adding two range name in Name Manager having the below description:
Village 1, 2 & 3 having the province name of A
School 4, 5 & 6 having the same province name "A"
I need to save both Villages and Schools with the same Province Name individually, as mentioned above. Village Names and Schools Names will be used in the same Excel Worksheet but in different tabs (Different Sheets).
The problem is I cannot save the School Names with the same name as I saved the Village Names already.
Thanks,
Hi ,I'm looking for .PNG to excel converter any idea please let me know.
Thanks,
Pavan.
Hi,
I dearly want to know, that Ive prepared a simple dashboard in excel, now I want to display it on my computer's dashboard screen, 1- How to do this ?
2- and when I change data in the main excel file, the dashboard charts should change automatically according to the values changed in excel file... can anyone please help...
Thanks, your saved me a lot of stress
When I try to save an excel to PDF the pictures come out 1/4 the size on the PDF
Oh my god, thank you so much for the camera thing! It's hands down the best method to preserve the formatting. Kudos!