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
8 columns, 150 data rows by default, plus a header row. These are the first ten rows of the default file.
| Customer ID | First Name | Last Name | City | Signup Date | Lifetime Value | Orders | |
|---|---|---|---|---|---|---|---|
| CUS-1000 | Nora | Sharma | nora.sharma@example.com | Manchester | 2024-04-05 | 10825.47 | 52 |
| CUS-1001 | Ethan | Rossi | ethan.rossi@example.com | Lisbon | 2023-06-20 | 15792.63 | 2 |
| CUS-1002 | Lena | Nguyen | lena.nguyen@example.com | Berlin | 2025-11-06 | 20759.79 | 15 |
| CUS-1003 | Lucas | Ferreira | lucas.ferreira@example.com | Malmö | 2025-01-20 | 1726.95 | 28 |
| CUS-1004 | Chloe | Weber | chloe.weber@example.com | Berlin | 2024-12-02 | 14956.85 | 63 |
| CUS-1005 | Ava | Okafor | ava.okafor@example.com | Malmö | 2024-02-16 | 19924 | 13 |
| CUS-1006 | Maya | Sharma | maya.sharma@example.com | Kraków | 2022-09-03 | 891.16 | 26 |
| CUS-1007 | Noah | Rossi | noah.rossi@example.com | Austin | 2025-09-18 | 5858.32 | 39 |
| CUS-1008 | Sofia | Haddad | sofia.haddad@example.com | Toronto | 2025-07-31 | 2562.73 | 10 |
| CUS-1009 | Felix | Yilmaz | felix.yilmaz@example.com | Bologna | 2024-10-14 | 7529.89 | 24 |
Download 150 rows
8 columns · header included · no signup
Direct files work without JavaScript. Choose another size below.
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.
The Excel download stores date columns as numeric Excel dates with a date format. CSV and JSON contain ISO date text; convert those fields to dates during import before using date arithmetic or grouping by month.
File layout and import notes
- Email is lowercase first.last@example.com, generated from the First Name and Last Name columns. These are synthetic addresses, not contact details.
- With the name columns in B and C, =LOWER(B2&"."&C2&"@example.com") reproduces the email in D2.
- Names and generated emails can repeat. Customer ID identifies the individual row; email is not a guaranteed unique key.
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. Direct links download the default-size files without JavaScript. The row-count control builds other supported sizes in your browser. Your spreadsheet contents are not uploaded and no account is involved.
Which formats can I download?
The original dataset is available as Excel (.xlsx), CSV and JSON. All three contain the same source 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. The browser control offers 25, 100, 150, 500 data rows, plus a header. Direct source links contain 150 data rows; the preview shows the first ten of those rows.