Sample Customer Data
A CRM-shaped contact list with email, city, signup date and lifetime value — for merges, list comparison and text functions.
What is in the file
7 columns, 150 rows by default. The first ten rows are shown below — the download contains exactly this data.
| Customer ID | First Name | Last Name | City | Signup Date | Lifetime Value | Orders |
|---|---|---|---|---|---|---|
| CUS-1000 | Nora | Sharma | Bologna | 2025-04-20 | 22474.55 | 27 |
| CUS-1001 | Ethan | Rossi | Toronto | 2022-04-05 | 17507.39 | 13 |
| CUS-1002 | Lena | Nguyen | Bologna | 2023-01-20 | 12540.24 | 53 |
| CUS-1003 | Lucas | Ferreira | Toronto | 2023-11-06 | 7573.08 | 40 |
| CUS-1004 | Chloe | Weber | Austin | 2025-12-17 | 2605.92 | 38 |
| CUS-1005 | Ava | Okafor | Kraków | 2022-12-02 | 21638.77 | 24 |
| CUS-1006 | Maya | Sharma | Austin | 2023-09-18 | 16671.61 | 0 |
| CUS-1007 | Noah | Rossi | Kraków | 2024-07-04 | 11704.45 | 51 |
| CUS-1008 | Sofia | Haddad | Malmö | 2023-12-24 | 6737.3 | 5 |
| CUS-1009 | Felix | Yilmaz | Berlin | 2024-10-09 | 1770.14 | 55 |
Built in your browser when you click. Nothing is uploaded, no signup, free for commercial use.
About this dataset
The dataset to reach for when the exercise is about joining or comparing two lists rather than aggregating one. Emails are derived from the names, so a CONCAT / TEXTJOIN rebuild can be checked against the real column, and the mix of cities and signup dates supports both cohort and geographic slicing.
What you can practise with it
- Rebuild the email column with CONCAT or TEXTJOIN and compare
- Find rows present in one list but not another
- Extract the domain from an email with TEXTAFTER or MID + FIND
- Cohort customers by signup month
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 customer 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.