Link Excel files and complete your data without manual copying
Upload the main file and one or more files that hold the data you need, choose the columns, and the tool brings them for each employee by employee ID or ID / iqama number.
The first 20 rows of the main file are free, then one subscription covers all tools.
What is the Data Linking tool?
Data Linking is a tool that completes the data of an Excel file from one or more files using the employee ID or the ID / iqama number. You choose the columns and where each one goes in the result, and the tool highlights employees not found and conflicts between files, all inside your browser.
What does the tool do?
- Link by employee ID or ID / iqama number, and by the other number if the employee is not found
- Merge more than one file or sheet on each side
- Match columns by meaning even if their names differ
- Fill blank cells only or replace existing values, as you choose
- Highlight employees not found and conflicts between files
- Export the main file with its original formatting plus a review sheet
How it works
- Upload the main file and the source files
- Choose the columns and where each one goes
- Review the colored result and export the completed file
Who is it for?
Suited to anyone who gathers employee data from several files, such as phone numbers, job titles and employers, and wants to unify them in one file.
Your files stay with you
Your files are processed entirely inside your browser on your device, and are never uploaded to any server.
Frequently asked questions
Do the columns have to be in the same order in both files?
No. You choose the link column and the columns you need from each file, whatever their order or name.
Will the data in my original file change?
Your original file on your device is not modified. A new exported copy is created, and depending on your choice only blank cells are filled or values are replaced.