The guide describes many methods for converting.xls to.jpg, such as built-in tools for exporting an Excel worksheet as an image file and internet converters that are entirely free.
Have you ever had an excel data sheet that you needed as an image? Converting an Excel sheet to an image can be useful whenever you need an image instead of a spreadsheet, but especially when creating a whitepaper or instructional, putting together a presentation, or securely emailing spreadsheet data.
Within Excel, you have the option to save the file to a variety of formats, but surprisingly, JPG is not on the list!
The guide will describe many methods for converting.xls to.jpg, including built-in tools that let you save an Excel worksheet as an image file as well as free online Excel to JPG converters.
- Excel to JPG with Print Screen – a quick way to convert a sheet’s on-screen area to an image.
- Excel to JPG with Snipping Tool – another method for converting on-screen areas from.xls to.jpg.
- Save Excel as JPG by copying and pasting – allows data to be copied beyond the scroll.
- Create a live image of a worksheet’s data by using the Camera tool to create an image of an Excel file.
- Online Excel to JPG converters – free services for converting xls to jpg and xlsx to jpg.
Print Screen tool to convert .xls files to .jpg files
With the Print Screen option, convert Excel to JPG
This method is the most widely used for converting Excel to JPG with one significant limitation: You can only save the portion of your Excel sheet that is visible on-screen to JPG. If that’s okay with you and your data needs then this is how you can use the print screen feature to convert excel to JPG:
- To ensure that all relevant data is shown on the screen, zoom in or out of the spreadsheet.
- Hold the Alt key down while pressing the PrtSc key on your keyboard.
- Open the graphics editor of your choice; Microsoft Paint is a good free option.
- Use the Paste button or the Ctrl + V keyboard shortcut to paste the copied screen.
- To save the pasted image, click the blue drop-down arrow in the Paint window’s upper left corner, then choose Save As or just click Ctrl + S.
- Enter the appropriate file name in the Save As window and select one of the picture formats listed below:
JPEG (.jpg) is the best format for intricate photos and images. JPEG prints the clearest.
GIF is excellent for producing low-resolution images, which are ideal for straightforward drawings.
PNG – provides for the creation of files with low resolution that load quickly and seem clear. This is the most popular image format due to its versatility.
Once you click Save, you’re done!
Tip: The Print Screen option captures the entire screen, including the ribbon, top menu, scrollbar, and sheet tabs. If you only want to export the data, use the Crop function before saving an image to remove any unnecessary parts.
Snipping Tool to convert Excel Data to JPG
You can convert .xls to .jpg (.xlsx to .jpg) with the Snipping Tool! This is yet another incredibly simple way to obtain an image of your Excel sheet that few people are aware of despite it already being in your computer! Snipping Tool is a screen capture tool that is included with all modern versions of Windows, from Windows 7 to Windows 10.
In contrast to the Print Screen feature, Snipping Tool gives you the following options for what to capture:
- Free-form snipping enables you to draw any shape on the screen and include only that portion of your Excel sheet in an image.
- Rectangular snip – the default capture option for rectangular snips.
- Window snipping enables the capture of a dialog box or a resized Excel window.
- Full-screen snip – like Print Screen, captures the entire screen.
To convert Excel to JPG (or another image format), follow these three simple steps:
- Select the type of snip you want to capture. To do so, click the little arrow next to the Mode button (or the arrow next to New in older versions), and then choose one of the options listed above.
- Choose the section of your sheet that you want to capture. The selected area will be copied to the Snipping Tool window immediately.
- Click the Save button, enter a file name, select an image format (.jpg,.png, or.gif are supported), and then click OK. It’s as simple as that!
Tip: Use the Pen, Highlighter, and Eraser tools if you need to make changes to the captured image.
Save as an image in Excel Settings
Did you know you can edit settings to allow you to save your entire spreadsheet as an image? This method allows you to convert your file to an image file within the actual Excel program! There’s multiple image types available to download from including .jpg, .png, and .gif.
The previous methods, no matter how straightforward they are, have one significant limitation: they can only capture the portion of a worksheet that is visible on the screen. Zooming out may be useful in some situations, but not when capturing a large table with tens of thousands of rows.
There’s an easy way to get around this limitation though by using the tried and true copy/paste technique. This method will allow you to copy any part of an Excel sheet, and then paste the copied contents wherever you want.
To save your Excel worksheet as an a.jpg image, follow these steps:
1. Choose any Excel data you want to save as an image
Tip: To select a large table, select the first cell and then press Ctrl + Shift + Enter to expand the selection of the most recently used cell.
2. To copy the selection to the clipboard, press Ctrl + C.
Alternatively, in the Clipboard group on the Home tab, click the little arrow next to Copy, and then click Copy as Picture.
This gives you the option of saving the copied data as shown on the screen or as shown when printed:
3. Launch Microsoft Paint or your preferred graphics editor.
4. To paste the copied data, press Ctrl + V.
5. Save the new file as a JPEG, GIF, or PNG image. Done!
An Excel table saved as an image is visually indistinguishable from the original. This method is a perfect choice if you want to save large tables or retain the best image quality possible.
Tip: Did you know you can remove gridlines? If you don’t want gridlines in the image, go to the View tab and uncheck the Show gridlines check box before copying the data.
Use the built-in camera tool
This is a well-kept but incredibly cool feature in Excel! With this built-in tool you can capture a screenshot within the Excel app. Using the Camera tool is another quick way to capture a snapshot of your Excel data.
Here’s what’s really neat about this built-in tool:
The camera tool creates a dynamic image that syncs with the original dataset and gets updated whenever the original data changes.
Because the Camera tool does not appear by default, you must manually add it to the ribbon or Quick Access Toolbar. To finish it, follow these steps:
- Select More Commands from the small drop-down menu in the upper-left corner of your Excel. This brings up the Options dialog box.
- On the right pane, under the Choose commands from option, select Commands Not in the Ribbon.
- Scroll down the list until you find the Camera command, then select it and add it to the right-hand section by clicking the Add button.
- Select OK.
The Camera button is now available on the Quick Access Toolbar!
Simply do the following to save an Excel table as an image using Camera:
- Choose a subset of cells to capture. To photograph a chart, select the cells that surround it.
- Select the Camera option.
- Click anywhere in the worksheet to insert a snapshot.
- You can now resize the image by dragging the sizing handles. Alternatively, you can use the Picture Tools tab that appears when you select an image to apply different Picture Styles.
Tip: By default, Microsoft Excel adds a border to the image; if you don’t want it, on the Format tab, in the Picture styles group, select Picture border > No outline.
When you’re satisfied with the image design, you can export the Excel camera output to wherever you want. Simply select the image and press Ctrl + C to copy it (or right-click and then click Copy). Then, open another program, such as Paint, Word, or PowerPoint, and press Ctrl + V to paste the copied image. Alternatively, you can combine elements from several worksheets onto a single page and save it as an image using any of the methods described above. Just keep in mind that only linked images are “live” on the sheet.
Excel to JPG converters online
If you have a large amount of Excel files that you need to convert then using an online Excel to JPEG converter can help you save time. Luckily, you have many choices when it comes to what program to use! Out of the types of excel to jpg sites that let you convert free, but how do you know which ones are really safe?
Here are just a few of the numerous free converters that are trusted and popular:
Convert Free – Convert XLS to JPG online & free
You can convert XLS to JPG online and for free with Convert Free! This is a free online service that supports a broad variety of document and image formats, including an Excel to a JPG conversion, which makes it my top choice for an online converter.
Here’s how to change an Excel sheet to a JPG file online using Convert Free:
- Select the source .xls or .xlsx file with your mouse and drag it onto the page from your PC, Google Drive, or Dropbox.
- Choose JPG or another image format. There are over 20 different formats that are supported! These formats include JPEG, PNG, GIF, BMP, TIFF and more.
- Save the JPG file you converted to Dropbox or Google Drive, or download it. My favorite part is that you don’t need to provide an email to receive your download, you can download it directly onto your computer!
When using ConvertFree’s convert free version, the file size limit is 200 MB.
ConvertFree – free online Excel to JPG conversion
Convert Free is another well-known and trusted online tool that converts an excel data set to an image format. Despite this site being user-friendly and safe to use it has one small problem. With Convert Free you cannot download the converted files directly from the website. Instead, the output is sent via email. You can download it from the email but I prefer avoiding the extra step if possible. Aside from that, Convert Free is a fantastic and free Excel to JPG converter: It is a trusted converter for good reason.
If neither of the above tools suits you, you can find a plethora of other similar services by typing “convert xls to jpg online” or “xlsx to jpg online” into your preferred search engine.
This is how to convert Excel to JPG free online and on your desktop! I hope this guide was helpful today. Thank you for reading and I hope you return next week to see our upcoming blog post!