ClockLap + any HR system: people sync from a CSV

No API? No problem. Export people from your HR system as CSV, match its columns once, and ClockLap adds, updates and suggests turning off people on every sync.

HRFileCAUSGlobal
Start free trialBook a demo
Dry run before the first syncReady

What syncs

CSV people import is the source of truth for people. On each sync ClockLap reads:

  • Any of: ID, name, email, employee number, department, location, manager, hourly pay rate, start and end dates, status
Time off. A worker file carries people only; time off isn’t read or sent.

How it works

  1. Export people as CSVComma, semicolon or tab separated, quoted fields welcome.
  2. Upload it or set up SFTPClockLap picks the newest file matching a name pattern.
  3. Match columns onceCommon header names are recognised; map the rest.
  4. Map locations and departmentsTo ClockLap sites and teams.
  5. Review the dry runApply it, then schedule it.

Matching people

Matched by earlier links, then email and employee number. Rows without an ID or email are skipped with a warning.

  • Who wins, per field. The HR system by default: ClockLap is updated to match. Set any field to “ClockLap” and it’s only filled in when the person is added.
  • New people. Added automatically, without an invite unless you turn invites on. You choose the role they get.
  • People who leave. Suggested for turning off (default), or turned off automatically. Their history stays.
  • Sites and teams. Map the HR system’s locations or departments to ClockLap sites once; moves follow on every sync.
  • Single sign-on users. People your identity provider manages through SCIM keep what SCIM writes; the sync skips those fields and says so.
  • Schedule. Hourly, daily (default) or manual. A scheduled sync can apply itself or only prepare a preview for an admin.
A dry run first. The first sync is always a dry run: a list of the people who would be added, updated or suggested for turning off, field by field. Nothing changes until an admin applies it, and scheduled syncs wait for that first approval.

What you need

  • A CSV export of your people
  • Optional: an SFTP server for automatic pick-up

Every run keeps a history: who and what was sent, per-line results, plain-language errors with a fix, and a redacted request log for admins. Webhooks fire on people_sync.completed.

Questions

How are dates and pay rates read?

ISO dates and slashed dates (month/day unless the first part is over 12) are understood, and pay rates like “$25.50” or “25,50 EUR” are read as amounts.

Is people sync included in the price?

Yes. HR connections are part of every ClockLap plan, with no add-ons.

Is ClockLap affiliated with CSV people import?

No. ClockLap connects to CSV people import using files it can import; it isn’t affiliated with or endorsed by CSV people import. The connection is generally available.

Related

More connections

All integrations
WDWorkdayHRBeta

Import a Workday worker report: upload it, or ClockLap picks it up from SFTP.

FileCAUSGlobal BHBambooHRHRBeta

Keep people, teams, sites and time off balances in step with BambooHR.

Direct APICAUSGlobal HBHiBobHRBeta

Bring people, departments, sites and time off balances in from HiBob.

Direct APICAUSGlobal CFCustom payroll filePayroll

Build the CSV your payroll imports: pick, order and rename columns.

FileCAUSGlobal

Clock in by arriving. Paid without retyping.

Try ClockLap free for 30 days with your own CSV people import account. No card needed.

Start free trialBook a demo

CSV people import is a trademark of its owner. ClockLap isn’t affiliated with or endorsed by CSV people import. Connections marked beta are being verified with live accounts.