Sample Employees CSV File — Free Download
An HR roster with departments, job titles, hire dates, salaries and a self-referencing manager_id column — useful for org-chart logic, payroll test runs and salary-distribution analysis.
Download the sample file
CSV · 180 rows · 12.8 KB · synthetic data, free for any use
Download CSV samplePreview
| employee_id | name | department | title | hire_date | salary | location | manager_id |
|---|---|---|---|---|---|---|---|
| EMP-0001 | Fatima Cohen | Operations | Manager | 2019-02-02 | 155790 | Madrid | · |
| EMP-0002 | Chen Murphy | Support | Manager | 2020-05-23 | 182480 | Madrid | · |
| EMP-0003 | Chen Tanaka | Sales | Lead | 2019-05-13 | 154851 | Madrid | · |
| EMP-0004 | Chen Nguyen | Support | Coordinator | 2023-05-22 | 80307 | Mumbai | · |
| EMP-0005 | Sam Tanaka | Finance | Coordinator | 2023-02-18 | 90426 | Toronto | · |
| EMP-0006 | James Tanaka | Marketing | Analyst | 2021-03-29 | 130203 | Austin | · |
Showing the first 6 of 180 rows.
Columns
| Column | Type | Description |
|---|---|---|
employee_id | string | Primary key, EMP-0001… |
name | string | Full name |
department | string | 7 departments |
title | string | Job title |
hire_date | date (YYYY-MM-DD) | Hire date, 2019 onward |
salary | integer | Annual salary, USD |
location | string | Office city |
manager_id | string | employee_id of the manager (blank for the top 8) |
What makes this file useful
- manager_id is a self-referencing foreign key — the first 8 employees have no manager, everyone else points at one of them, so recursive/tree queries have a clean root.
- salary has a realistic spread (roughly $42k–$185k), which makes it a good column for outlier detection and box plots.
- hire_date goes back to 2019, so tenure calculations produce a range of several years.
Use cases
- Build an org chart from the manager_id hierarchy
- Analyse salary distribution and outliers by department
- Test an HRIS or payroll CSV import
- Calculate tenure from hire_date
Open it in a tool
Load this sample — or your own file — into a real tool. Everything runs client-side.
Related guides
More sample datasets
Frequently asked questions
Is the salary data real?
No. Salaries are randomly generated within a plausible band and do not reflect any real company or market data.
Can I use it for an HR software demo?
Yes. It is designed to look like a real export and is free for commercial use.
How is the reporting hierarchy structured?
Employees EMP-0001 to EMP-0008 are leaders with an empty manager_id. Every other row references one of them.
How many rows?
180 employee rows plus the header.
Turn this into a saved workflow
Create a free account to save the steps from this guide as a reusable workflow and re-run it on any file, from any device.
Follow HowToCSV on Google
Add us as a preferred source on Google Search so our latest CSV guides and tutorials surface more often in your Top stories.