Why Payroll Runs on CSV
HRIS tools, payroll processors, benefits vendors, and accountants rarely share one database. CSV is still the bridge for new-hire rosters, pay-element uploads, time imports, and journal exports—especially during cutovers and multi-vendor setups.
Because payroll data is sensitive and exacting, a wrong delimiter or lost leading zero is not a cosmetic bug—it is a pay error.
Common Payroll CSV Types
Know which file you are holding before you edit it.
| File type | Typical columns | Used for |
|---|---|---|
| Employee census | employee_id, name, department, pay_type | HRIS / benefits setup |
| Time import | employee_id, date, hours, earning_code | Hourly pay runs |
| Pay register export | employee_id, gross, taxes, net, pay_date | Accounting / audits |
| Deduction / benefit | employee_id, plan, amount, effective_date | Carrier feeds |
| GL journal | account, debit, credit, memo | Posting to the ledger |
Step-by-Step: Prep a Payroll Import CSV
Follow the vendor template—not a generic spreadsheet habit.
- Download the official import template from the payroll or HRIS system.
- Map your source columns exactly (names, order, required fields).
- Keep employee_id and SSN/tax IDs as text—preserve leading zeros.
- Use the date format the vendor documents (ISO when allowed).
- Export UTF-8 CSV from Excel (Excel to CSV) or clean in the Online CSV Editor.
- Validate row counts and sample employees before the full load.
- Import a pilot group first when the system allows.
High-Risk Fields
These columns fail most often.
- Employee numbers with leading zeros.
- Bank account / routing numbers (text only; never scientific notation).
- Pay rates vs pay amounts—do not mix units.
- Earning and deduction codes that must match the system’s list exactly.
- Terminated vs active status flags with inconsistent spellings.
Privacy and Access
Payroll CSV often contains PII and financial account data.
- Store files in approved locations only; set retention limits.
- Redact before sending samples to vendors or using browser tools when policy requires.
- Prefer company-managed conversion environments for production files.
- Log who exported and imported each pay run file.
Real-World Examples
Where payroll CSV shows up weekly.
New HRIS cutover
People ops exports a census from the old system, cleans department codes, and imports into the new HRIS with a 25-person pilot.
Time aggregator → payroll
A workforce tool exports hours CSV; payroll maps earning codes and loads after manager approval.
Accountant GL post
Pay register exports become a journal CSV for the ledger after mapping payroll liability accounts.
Common Mistakes
Avoid these on pay week.
- Opening the file in Excel and saving over the only copy.
- Wrong pay-period dates causing duplicate or missed earnings.
- Mismatched employee IDs between time and payroll systems.
- Locale decimal commas breaking amount fields.
- Uploading the previous period’s file by accident.
Best Practices
Controls that keep pay accurate.
- Immutable raw exports; edit only copies.
- Checksum or row-count log per import.
- Template version noted in the filename.
- Two-person review for first-time mappings.
- Reconcile totals to the payroll register after load.
Why Use Convert CSV Online?
Convert CSV Online is free, browser-based, and requires no account for everyday conversions. For non-sensitive samples and format checks, preview in the Online CSV Editor and convert Excel ↔ CSV cleanly. For production payroll files, follow your company’s privacy policy and use approved systems. Client-side workflows work on Windows, macOS, and Linux browsers.
Validate structure on safe samples
Prove headers and types on redacted rows before touching the live pay run file.
Conclusion
Payroll CSV success is template fidelity plus text-safe IDs, correct dates, and strict privacy. Pilot the import, reconcile totals, and never let Excel silently rewrite employee or bank identifiers.
FAQ
What is a payroll CSV file?
A spreadsheet-style export or import used to move employee, time, earning, deduction, or journal data between HRIS, payroll, and accounting systems.
How do I import CSV into payroll software?
Use the vendor’s template, map columns exactly, keep IDs as text, export UTF-8 CSV, and run a small pilot before the full load.
Why did employee IDs lose leading zeros?
Excel or a converter treated them as numbers. Force those columns to text for the entire pipeline.
What date format should payroll CSV use?
Whatever the payroll vendor documents. Prefer ISO YYYY-MM-DD when the system allows it.
Is it safe to edit payroll CSV online?
Only when policy allows and data is redacted or processed in an approved environment. Production payroll files often must stay in controlled systems.
How do I move payroll results into accounting?
Export the pay register or journal CSV, map accounts, and import into the ledger—or convert related finance formats via the Finance File Converter when needed.
References
Convert your CSV in the browser
Preview, clean, and convert CSV files free with Convert CSV Online—no installation and no account required for everyday conversions.