4 mins read
HR professionals often spend valuable time and effort manually entering employee data such as names, salary, and deductions from scanned slips into an Excel file for record purposes. This task isn’t only a productivity killer but also prone to errors, especially when they have to process salary information for a large workforce.
Fortunately, there are methods available that can help them automate the conversion of salary slip data into Excel. In this blog post, we discuss two methods and explain each one through a step-by-step procedure.
2 Methods for HRs to Convert Scanned Salary Slips into an Editable Excel Sheet
In this section, we are going to discuss two methods for converting scanned salary slips into editable Excel data with minimal manual effort.
1. Use Excel’s Built-in Feature
Microsoft Excel offers a built-in feature to help users quickly extract tabular data from images. The feature is known as Data from Picture. But keep in mind that standalone versions of MS Office such as Office 2021 and Office 2024 do not have this facility. It is only available on Microsoft 365.
Below, we have discussed a step-by-step procedure that you should follow to use this functionality.
Import Scanned Salary Slip Using Data from Picture Option :
First, you have to insert the scanned salary slip using the data from picture option. For this, go to the “Data” tab in the ribbon. Next, look for the “From Picture” option.
Upon clicking, you will see two options: Picture from file and copy from clipboard. Go with the first option if the scanned salary slip is saved in your device’s local storage and the second option in case the image is copied to the clipboard.
After inserting the image using any of the options, Excel will take a few moments to analyze and process it.
Review and Edit Data, if Required :
Once the scanning is completed, MS Excel will provide both the image and an editable Excel table containing image data for review. You should carefully check each cell to determine that the data is complete and error-free.
If any changes are required, click the relevant cell and update the extracted data. Once you have reviewed the results, click ‘Insert Data’ to add the data to the worksheet.
Insert Data into Excel Sheet :
When the review is completed and you are satisfied, click on the “Insert Data” option, and the entire salary slip data will be presented in an Excel sheet.
As an HR professional, that’s how you can convert data from a scanned salary slip into Excel without manual effort.
2. Use Online Image to Excel Converter
A scanned salary slip is actually an image… right? So, you can also use a specialized image to Excel converter to perform the conversion. It effectively converts tabular images into an editable spreadsheet with a single click.
You can easily find several image-to-Excel converters online. However, their pricing, security features, and working processes may vary. For a pictorial demonstration of the upcoming steps, we selected Image to Excel by Imagetotext.info. It delivered consistent results during our testing and supports image to Excel conversion in multiple languages.
Here is the step-by-step procedure that you need to follow:
Upload Scanned Salary Slip :
First, you need to upload the scanned salary slip to the image to Excel converter. Usually, tools offer multiple uploading options such as drag-and-drop, copy-and-paste, or manual upload from local storage.
After uploading the picture, this is how the tool’s interface now looks:
Click the Button :
Now, simply click on “Convert to Excel” to start converting the uploaded scanned salary slip into editable Excel data.
Review Editable Excel Data :
Within a matter of seconds, the image to Excel converter will provide the extracted data in a well-formatted and editable spreadsheet.
You can edit and update any row or column in the output. Additionally, you can also copy or download the Excel data for later use.
Wrapping It Up
As an HR professional, now you do not have to manually enter data from a scanned salary slip into an Excel sheet. This is because automated methods such as Excel’s Data from Picture and Image to Excel converter can help convert scanned salary slips into an editable spreadsheet in just a few clicks.
In this blog post, we have explained both these methods in a step-by-step procedure along with pictorial demonstrations for a better understanding.
