Sample Employee Data
An HR roster with department, job title, hire date, salary and city — for lookups, headcount reporting and date maths.
What is in the file
8 columns, 150 rows by default. The first ten rows are shown below — the download contains exactly this data.
| Employee ID | First Name | Last Name | Department | Job Title | City | Hire Date | Annual Salary |
|---|---|---|---|---|---|---|---|
| EMP-1000 | Sofia | Bennett | Marketing | Coordinator | Malmö | 2022-09-03 | 145015 |
| EMP-1001 | Felix | Dubois | Finance | Manager | Berlin | 2023-12-03 | 54609 |
| EMP-1002 | Emma | Kowalski | Marketing | Coordinator | Austin | 2025-03-02 | 97827 |
| EMP-1003 | Adam | Dubois | Support | Manager | Berlin | 2020-05-22 | 121421 |
| EMP-1004 | Liam | Bennett | Marketing | Analyst | Austin | 2021-08-21 | 50639 |
| EMP-1005 | Oliver | Andersen | Support | Specialist | Kraków | 2022-11-19 | 74233 |
| EMP-1006 | Mia | Bennett | Operations | Analyst | Bologna | 2024-02-18 | 117451 |
| EMP-1007 | Jonas | Andersen | Sales | Specialist | Toronto | 2025-05-18 | 141045 |
| EMP-1008 | Nora | Novak | Operations | Engineer | Rotterdam | 2024-09-30 | 105767 |
| EMP-1009 | Ethan | Silva | Sales | Director | Lyon | 2025-12-30 | 129361 |
Built in your browser when you click. Nothing is uploaded, no signup, free for commercial use.
About this dataset
A people table is where most lookup practice actually happens: you have an employee ID on one sheet and need the department, the salary band or the hire date on another. Hire dates spread across several years, so DATEDIF, YEARFRAC and tenure banding all produce meaningful answers rather than a column of zeros.
What you can practise with it
- Return a salary for an employee ID with XLOOKUP
- Calculate tenure in years with DATEDIF or YEARFRAC
- Average salary per department with AVERAGEIFS
- Flag duplicates and split full names into first / last
Tools that work on this data
Free to use, share and republish — including commercially. Attribution isn't required, but it's what keeps these free to make, and there's one ready to paste below.
Questions
Is this sample employee data free to use?
Yes — for practice, teaching, demos and commercial work alike. The rows are generated, so there is no personal data in the file. Attribution is not required; if you would like to credit it, there is a ready-made line at the bottom of this page.
Do I have to sign up or give an email address?
No. The file is built in your browser when you click download; nothing is uploaded and no account is involved.
Which formats can I download?
Excel (.xlsx), CSV and JSON. All three contain the same rows, so you can use the CSV for an import exercise and the .xlsx for a formula exercise.
Can I choose how many rows I get?
Yes. Pick a row count before downloading — the default is 150 rows, which is what the preview on this page is drawn from.