Although Excel is the preferred tool for data analysis, additional programs such as Microsoft PowerPoint or Word are still used for reporting.
This guide covers a variety of methods for converting.xls to.jpg, including built-in tools for saving an Excel worksheet as an image file and free online Excel to JPG converters.
Converting an Excel table to an image appears to be useful in a variety of contexts, including producing a whitepaper or instructional, creating a presentation, and securely transferring spreadsheet data over email.
Method 1: Copying the table and saving it as an image in Microsoft PowerPoint/Word
This is an easy approach to copying a table from excel and pasting it as an image in either PowerPoint or Microsoft word. In this method, we just copy the table or data from Excel and transform it into a picture while pasting it into PowerPoint or Word.
The steps to accomplish so are as follows:
- Choose the cells in the table to which you wish to transfer a picture.
- Use Control + C or Command + C (if you are on a Macbook) to copy the cells, or right-click and select Copy from the menu.
- To paste this data as an image, open the PowerPoint slide (or MS Word page) where you wish to paste it.
- Copy the table and paste it (Control + V for Windows, Command + V for Mac). The Excel table is pasted as a table, not as an image, at this point.
- In the bottom right corner of the table, you just pasted, and click the based options symbol.
- Select the Picture (U) option from the drop-down menu.
The methods above will turn the table you’ve pasted into a picture.
You can crop, resize, and insert this wherever in your PowerPoint slide or Word document page, just like any other image.
If you want to learn more about Microsoft Excel and master some of the tricks to increase your productivity working with Excel, then check out our Microsoft Excel Category
Method 2: Convert an Excel Table to an image using the Snipping Tool
Another incredible and easy approach is to acquire an image of your Excel sheet that few people are aware of.
Snipping Tool is a feature of all contemporary versions of Windows, from Windows 7 to Windows 10, that allows you to capture a screenshot of the screen. The snipping tool presents you with options that can help you to capture only the details you see necessary. These options are:
- Rectangular snip: this is the default option for rectangular snips.
- Window snip: this allows you to take a screenshot of a dialogue box or a resized Excel window.
- Full-screen snip: Is the same as Print Screen, but it captures the complete screen.
- Free-form snip: You can draw any shape on the screen, and only that portion of your Excel sheet will be included in the image.
To find Snipping Tool on your computer, go to Start (Windows key), type “snipping tool” into the search field, and then select Snipping Tool from the list of results. You can also use the keyboard combination of windows key + shift key + s to access the snipping tool.
The steps below will help you to use this tool to save an Excel table as an image.
- Open your worksheet
- Use the keyboard combination Windows key + shift key + s to launch the snipping tool
The image below shows how the window will appear
- Select any of the options displayed at the top to make your snip. The options have been explained at the beginning of this subtopic.
- After selecting your preferred snipping method, you drag the (+) sign over the area you wish to take a shot off, and it is automatically saved on your clipboard or in the photos section of your device.
- Press control + V to paste your picture in PowerPoint or word
You can apply editing features such as cropping to your image to get the desired shot.
Method 3: Converting Excel table to an image using the camera tool.
Using the Camera tool is another approach to rapidly take a photo of your Excel data. Excel Camera provides a dynamic image that syncs with the underlying dataset and updates anytime the original data changes, which is a really unique function.
Because the Camera tool is not available by default, you must manually add it to the ribbon or Quick Access Toolbar. Follow these steps to get it done:
- Select More Commands… from the little drop-down menu icon in the upper-left corner of your Excel.
- This action will bring up the Options window. Select Commands Not on the Ribbon in the right pane under Choose commands from.
- To move the Camera command to the right-hand area, scroll down the list until you locate it, select it, and click the Add button.
- After that, press OK.
- Now the camera feature appears like this in the Quick Access Toolbar as displayed below.
Simply perform the following to save an Excel table as an image using Camera:
- Choose a range of cells that you’d like to capture. Select the cells that surround a chart to generate a snapshot of it.
- Select the Camera option.
- To add a photo to the worksheet, click anywhere on the page.
Now you can apply any form of editing you prefer to the image to make it suitable for what you are using it for.
You can export the Excel camera output to anywhere once you’re satisfied with the image design.
To do so, simply choose the image and copy it using Ctrl + C. (or right-click and then click Copy). After that, open another application, such as Paint, Microsoft Word, or PowerPoint, and paste the copied image using Ctrl + V.
Method 4: Convert an Excel Table to Image Using the Print Screen Feature
It is the most common method for converting the part of your Excel sheet that is now showing on-screen to JPG or another picture format. Here’s how to do it:
- Zoom in or out of the worksheet to see all relevant data on the screen.
- Press the windows key + prt sc key on your keyboard to take a screenshot of the screen.
- The image is automatically stored on your device. To apply changes to the image, open a graphics editor of your choice and press control + v to paste the image in it and apply your desired edits
- After that, you can press CTRL + S to save the image with the newly added edits.
- Choose one of the following image formats in the Save as window and type the desired file name:
- For sophisticated images and photos, JPEG (.jpg) is the best option.
- GIF Is a low-resolution picture format that works best for simple graphics.
- PNG – lets you create low-resolution files that load quickly but yet seem clean and beautiful; it’s good for nearly anything.
- Click Save.
NOTE: The ribbon, top menu, scrollbar, and sheet tabs are all captured when you use the Print Screen feature. Use the Crop function to take off superfluous sections before exporting an image if you simply want to export the data.
Method 5: Converting excel tables to images using an online Excel to JPG converter
If you have a large number of Excel files to convert to photos, you can save time by using an online Excel to jpeg converter. Below is just one of the many free converters available on the internet that you can use to save an Excel table as an image.
- Smallpdf – excel to jpg converter
How To Convert Excel to JPG Online for Free using Smallpdf
- Drag and drop your Excel file into the Excel Converter.
- Wait for the conversion to finish, then click “Export As” and select “Image.”
- Choose “Convert entire pages.”
- Download your datasheet, now in JPG format.
In this post, I have covered 5 different but very simple and straightforward procedures and methods to help you convert your excel tables to images as fast as possible.
I hope you find this piece helpful and with these methods you are able to save your Excel table as an image. Comment below any questions that you have concerning this topic.
You may be interested in any of the following as well, check them out.