What Mappd does for this workflow

Mappd converts Payroll CSV and Excel exports to HR system format by remapping column names, reformatting dates, and converting currency values. For this workflow: Employee Number → Staff ID; Forename → First Name; Surname → Last Name. Processing is entirely client-side — no file data is transmitted to a server. Typical run time: 3 min.

6 source columns handled
5 transforms applied
3 min typical run time
Free to use
HR · Payroll to HR template

Payroll export → HR upload. No manual reformatting.

Upload your Payroll export. The column mapping loads automatically. Download the HR system-ready file in 3 min.

"Your payroll system exports data no HR platform recognises. Different field names, salary as text with £ signs, dates in the wrong format. Every payroll run means manual cleanup."

Free to use · No card required · Processing in your browser

Go from 6 min manual work to 2 min with Mappd.
01
02
03
04

Scroll to continue ↓
v2.4
Change summary
6 columns renamed to HR system schema
3 salary values stripped of £ and commas
3 dates reformatted to ISO 8601
Download hr-system-import.csv

Column transformations applied

Employee Number → Staff ID
Forename → First Name
Surname → Last Name
Annual Salary → Salary (£ + commas stripped)
Start Date → Start Date (ISO)

Frequently asked questions

How do I convert a Payroll export to HR system format?

Upload your Payroll CSV or Excel file to Mappd. The Payroll to HR system recipe loads automatically and maps your columns. Review the changes and download the converted file. The process takes under 3 min.

What columns does this recipe rename?

Employee Number → Staff ID. Forename → First Name. Surname → Last Name. Annual Salary → Salary (£ + commas stripped). Start Date → Start Date (ISO).

Does my file get uploaded to a server?

No. All processing happens entirely in your browser using client-side JavaScript. Your file's data is only sent to Mappd's servers if you save the conversion to your history, and you can delete it any time.

Is this free?

Yes. Mappd is free to use, with no card required. The free tier includes 3 saved recipes and unlimited rows. Pro (£15/month) lifts the recipe limit and keeps your last 50 conversions. AI column matching is on Pro+ (£25/month).

What file formats does Mappd support?

CSV, TSV, XLSX, XLS, and ODS. Mappd handles encoding issues common in Payroll exports, including Latin-1 encoding, title rows above the header, and blank rows in the data.

Try it on your actual file.

The Payroll to HR system recipe loads automatically. Drop your file and it maps in 3 min.

Open Mappd with this recipe →

Free to use · No card required · See pricing