In WeChat or In DingTalk Group, I want to send a screenshot of the data of an Excel form to my colleagues. The results are either pasted into a ball or only half cut, and the other party can't see it clearly. Or the leader asked you to make the report into a picture and insert it into PPT, and you found that the format was all messed up when you copied and pasted it directly. The requirement of converting Excel into pictures is quite common in work. Whether it's reporting materials, social media, or archiving backups, a clear picture is more convenient than a form file that needs special software to open.
Why do I need to convert Excel to HD images?
1. WeChat group chat and send data: Excel files cannot be sent in WeChat, and screenshots are long and mushy. It is especially convenient to turn the key forms into pictures and send them to the group.
2. Illustration of the report: PPT or Word is directly pasted with forms, and the format is always chaotic. First, convert the form into a high-definition picture and then insert it. The layout is stable.
3. E-commerce platform transmission parameters: upload goods on Taobao and Jingdong. The specification parameter table can only transmit pictures. It is very easy to convert the prepared Excel table into pictures and upload them directly.
4. Making training materials: Fixed data steps are required when writing operation manuals. Turn the form into a picture and put it in, others can't change it, so as to prevent the training documents from being modified.
5. Archiving of Fixed Evidence: Some data results need to be archived as credentials, and Excel is stored for fear of being mistakenly changed. If you save it in picture format, it is a snapshot of data that cannot be changed.
Table to JPG Effect Preview
before treatment:
after treatment:
method one: use HeSoft Doc Batch Tool to turn Excel into a picture
recommended Index:β β β β β
Advantages:
1. One-click batch: Whether you have 10 or 100 files, drag them in and start, and it will automatically queue up in the background without too much operation.
2. Minimal operation: The interface is not complicated. There are mainly three steps: selecting functions, adding files, and clicking to start. You can understand it at a glance.
3. Local security: pure desktop software, your data is only processed in your own computer, not uploaded to the Internet, and trade secrets are transferred at ease.
4. High output quality: it is not a simple screenshot, it can intelligently process table styles, generate high-definition and neat pictures, and it is no problem to directly use them for reports.
Disadvantages:
γ HeSoft Doc Batch Tool ] can only be used locally on the computer.
Operation steps:
1. Open γ HeSoft Doc Batch Tool ], select [Excel Tool] on the left, and then select [Excel to JPG Picture] on the right].
2. Click [Add File] in the upper right corner, or drag the Excel table file to be converted to the specified location to complete the file import.
3. Click [Next] to select the processing range. The pixel density (PPI) of the picture is 300 here first, and the value can be adjusted according to the requirements.
4. Click [Next], and the tool will automatically convert the Excel form into a high-definition picture, and will give a prompt after completion.
Method 2: Use Microsoft Excel to bring your own
recommended Index:β β β β β
advantages: The software comes with it, completely free of charge, without installing any new things, and it is most convenient to deal with one or two lines of data in an emergency.
Disadvantages: The steps are too fragmentary and can only be done page by page. There is no way to transfer pictures in batches. It is purely physical work.
Operation steps:
1. Select the area to be converted into a map in the table.
2. Click the clipboard button under "Start" and the "Copy" button in the tab.
3. Select "Copy as Picture" in the menu ".
4. The pop-up window directly points "OK".
5. Open the drawing software and paste it in.
6. Finally, save the drawing as JPG in the drawing.
Method 3: Use WeChat/QQ screenshots to convert Excel into pictures
recommended Index:β β β β β
advantages: Everyone can use it. If you want to cut it off, it is the fastest to solve the problem of Excel transferring pictures that need urgent treatment.
Disadvantages: clarity depends on luck. once the form is long, it will be cut several times. it is troublesome to put it together and looks unprofessional.
Operation steps:
1. Place the Excel form on the screen.
2. Press Alt A (WeChat) or Ctrl Alt A(QQ).
3. Pull the mouse box to select the table area.
4. Click the "Save" icon in the toolbar.
5, choose a good location, give the file a good name to find.
6. Click Save to get a screenshot.
Method 4: Use professional screenshot software to convert Excel into picture format
recommended Index:β β β β β
advantages: It has stronger function than WeChat screenshots, can scroll long pictures, and has better image quality.
Disadvantages: The essence is still screenshots, unable to handle ultra-wide tables, and it is unrealistic to convert multiple files in batches.
Operation steps:
1. Open Excel and screenshot software.
2. Set shortcut keys for screenshots, such as F1.
3. Press the shortcut key and select "Scroll Screenshot" mode.
4. Click on the table area to make it automatically scroll and intercept.
6. After cutting, simply cut it out in the editor.
7. Save as JPG picture.
Method 5: Use Ao Soft Online Conversion to Turn Excel into Pictures
recommended Index:β β β β β
advantages: online tools, do not need to install, open the web page can be used, support drag and drop upload, the operation is more intuitive.
Disadvantages: However, when Excel files are converted into PDF format, the free version needs to be limited in file size and number of times. Files must be uploaded to the server, which is risky of privacy disclosure and unstable in conversion quality.
Operation steps:
1. First convert Excel files into PDF.
2. The browser opens the Ao Soft online conversion page.
3. Click on the upload area to drag your PDF file into it or click on upload.
4. Select "JPG" picture in the conversion format.
5. Optionally set whether each page is output as a picture or merged.
6. Click the "Convert" button to start processing.
7. After the processing is completed, click the "Download" button to save the picture package locally.
Method 6: Use Excel plug-in (such as "Kutools for Excel") to turn the table into a picture
recommended Index:β β β β β
advantages: Integrated in Excel, rich in functions, its "export picture" function is more powerful than the original, and supports export to a variety of picture formats.
Disadvantages: Additional installation and purchase are required. There are restrictions on the Excel version on the computer. It is mainly suitable for single file operation.
Operation steps:
1. First, install the Kutools for Excel plug-in on the computer.
2. Open the target file with Excel and you will see the newly added "Kutools" tab.
3. click "Kutools"-> "import and export"-> "export area is picture".
4. Select the cell range to export.
5. In the pop-up dialog box, select the picture format and save options.
6. Click "Export" and select the path to save the picture.
Method 7: Use Mac preview to automatically convert Excel into high-definition pictures
recommended Index:β β β β β
advantages: Mac system native free program, through the creation of "workflow" can achieve a certain degree of batch conversion, high degree of automation.
Disadvantages: Apple computer users only, the creation process has a learning threshold, and does not support complex Excel formats.
Operation steps:
1. Open the "Automatic Operation" APP and create a new "Quick Operation".
2. Find actions such as "Copy Finder Items to Folder" and "Preview PDF" in the resource library.
3. Drag these actions to the right workspace in sequence and splice them into a process.
4. Configure the parameters of each action, such as JPEG for output format.
5. Save the workflow and assign a shortcut to it.
6. Select the Excel file in Finder and right-click to run through this workflow.
to sum up: free tools (screenshots, self-contained) are ineffective and cannot be used in batches. Professional software (Acrobat, VBA) is either expensive or difficult. Online websites are at risk of data leakage. It seems particularly difficult to find a tool that can convert Excel into pictures in batch, high definition and safety. This is why we do the function [Excel to JPG Picture]. Its goal is to use the simplest operation to help you turn a pile of Excel into a pile of high-definition pictures that can be used directly. You can really try it.