--- title: "Excel customer data: free practice file with tasks and answers | PracticeExcel" description: "A free customer list with 150 customers to practice on: names, emails, cities, orders and spend. With 13 tasks on COUNTIFS, XLOOKUP, text functions and dates." canonical_url: "https://practiceexcelonline.com/learn/excel-customer-data" meta: "og:description": "A free customer list with 150 customers to practice on: names, emails, cities, orders and spend. With 13 tasks on COUNTIFS, XLOOKUP, text functions and dates." "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgY3VzdG9tZXIgZGF0YTogZnJlZSBwcmFjdGljZSBmaWxlIHdpdGggdGFza3MgYW5kIGFuc3dlcnM%2Cdescription_~QSBmcmVlIGN1c3RvbWVyIGxpc3Qgd2l0aCAxNTAgY3VzdG9tZXJzIHRvIHByYWN0aWNlIG9uOiBuYW1lcywgZW1haWxzLCBjaXRpZXMsIG9yZGVycyBhbmQgc3BlbmQuIFdpdGggMTMgdGFza3Mgb24gQ09VTlRJRlMsIFhMT09LVVAsIHRleHQgZnVuY3Rpb25zIGFuZCBkYXRlcy4%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1jdXN0b21lci1kYXRhIg%2Cs_SmZ69cNIYgNyvCeX.png" "og:image:height": "600" "og:image:type": image/png "og:image:width": "1200" "og:title": "Excel customer data: free practice file with tasks and answers | PracticeExcel" "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgY3VzdG9tZXIgZGF0YTogZnJlZSBwcmFjdGljZSBmaWxlIHdpdGggdGFza3MgYW5kIGFuc3dlcnM%2Cdescription_~QSBmcmVlIGN1c3RvbWVyIGxpc3Qgd2l0aCAxNTAgY3VzdG9tZXJzIHRvIHByYWN0aWNlIG9uOiBuYW1lcywgZW1haWxzLCBjaXRpZXMsIG9yZGVycyBhbmQgc3BlbmQuIFdpdGggMTMgdGFza3Mgb24gQ09VTlRJRlMsIFhMT09LVVAsIHRleHQgZnVuY3Rpb25zIGFuZCBkYXRlcy4%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1jdXN0b21lci1kYXRhIg%2Cs_SmZ69cNIYgNyvCeX.png" --- > Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt) # **Excel customer data: free practice file with tasks and answers** A free customer list with 150 customers to practice on: names, emails, cities, orders and spend. With 13 tasks on COUNTIFS, XLOOKUP, text functions and dates. By Nicolaj, founder of PracticeExcel · Updated November 12, 2026 · 12 min read A customer list is one of the first things anyone in sales, marketing or customer service gets handed in Excel. The questions are always the same kind: how many customers do we have in this city, what does a business customer spend, who is customer 2077, how many of them actually read the newsletter? Here is a customer list you can practice those questions on, with an answer key. The file is an export from a small online shop: 150 customers with name, email, city, segment, signup date, number of orders and total spend. It mixes text, numbers and dates, which is exactly what makes customer data good practice. You count with conditions, look up one customer, pull text apart and put it back together. Solve the tasks in the file first, then check your answers on this page. ## Customer data: 150 customers of an online shop **Free with an account** ### **Customer data for Excel practice** 150 customers with name, email, city, segment, signup date, orders and total spent. For COUNTIFS, XLOOKUP, text functions and dates. **What's in the file** - **Customers:** 150 customers with ID, name, email, city, segment, signup date, orders, total spent and newsletter. [**Create a free account to download**](https://practiceexcelonline.com/signup?next=/learn/excel-customer-data%23download-customers) [Already have an account? Log in](https://practiceexcelonline.com/login?next=/learn/excel-customer-data%23download-customers) Excel file (.xlsx). It also opens in Google Sheets. The account is free and also saves your progress in the exercises. The **Customers** sheet has one row per customer and ten columns: | **Column** | **Contents** | **Example** | | --- | --- | --- | | A Customer ID | A number from 2001 to 2150 | 2077 | | B First name | The first name | Olivia | | C Last name | The last name | Walker | | D Email | The email address in lower case | [**olivia.walker@gmail.com**](mailto:olivia.walker@gmail.com) | | E City | Chicago, Denver, Austin, Seattle or Boston | Denver | | F Segment | Private or Business | Private | | G Signup date | When the customer signed up, 2021 to 2025 | Mar 15, 2024 | | H Orders | The number of orders so far | 6 | | I Total spent | What the customer has spent in total | 4,250 | | J Newsletter | Yes or No | Yes | The names are made up, and several customers share a first and last name. The customer ID is the only thing that is unique, so that is what you look up. Private customers mostly use Gmail, Outlook and the like, while business customers have an address at their company's own domain. That difference is useful in the text tasks. Some customers have signed up but never ordered. They have 0 in **Orders** and 0 in **Total spent**. Keep them in mind when you work out averages, because they pull an average down. ## How to approach a task Customer questions usually hide a filter. "What does a business customer spend on average?" is an average with one condition. "How many business customers are in Chicago?" is a count with two. Before you type anything, ask yourself: 1. **Do you count, add up or average?** That decides whether you need COUNTIF, SUMIF or AVERAGEIF. 2. **Which customers count?** Each condition in the question becomes a pair of a range and a criterion. 3. **Is it about one customer?** Then it is a lookup, and you start with the customer ID. Once you know that, the formula is half written. Then sanity-check the answer: Chicago is the biggest city in the file, so it should have more customers than Boston. ## How to use the file Open the file and go to the **Tasks** sheet. Each task has a number, a question and an empty cell for your answer. Write your formulas on the **Customers** sheet, in an empty column to the right of the data, and type the result next to the task. Then compare it with the answer on this page. The data runs from row 2 to row 151. The answers use exact ranges like E2:E151. Save a copy of the file before you sort or delete anything, because the answers only match the data as it is in the file. The header row has filter buttons, so you can check a count by filtering and reading the row count on the status bar. ## Formula tasks on the customer data The tasks go from simple counts to lookups, text and dates. They are in the same order as in the file. ### **Formulas on the customer data** The tasks use the file Customer data for Excel practice. **Get the file** 1. **1\.** How many customers live in Denver?
**Show the answer** **44** Formula:=COUNTIF(E2:E151,"Denver")
2. **2\.** How many business customers are in Chicago?
**Show the answer** **20** Formula:=COUNTIFS(F2:F151,"Business",E2:E151,"Chicago")
3. **3\.** How much has a business customer spent on average? Round to a whole number.
**Show the answer** **$29,754** Formula:=ROUND(AVERAGEIF(F2:F151,"Business",I2:I151),0)
4. **4\.** What is the email address of customer 2077?
**Show the answer** **chloe.hall@gmail.com** Formula:=XLOOKUP(2077,A2:A151,D2:D151)
5. **5\.** What is the full name of customer 2033? Give the first and last name with a space between them.
**Show the answer** **Sophia Taylor** Formula:=XLOOKUP(2033,A2:A151,B2:B151)&" "&XLOOKUP(2033,A2:A151,C2:C151)
6. **6\.** Which domain does the first customer use? That is everything after the @ in D2.
**Show the answer** **icloud.com** Formula:=MID(D2,FIND("@",D2)+1,50)
7. **7\.** How many customers use a Gmail address?
**Show the answer** **39** Formula:=COUNTIF(D2:D151,"*@gmail.com")
8. **8\.** How many customers signed up in 2024?
**Show the answer** **28** Formula:=COUNTIFS(G2:G151,">="&DATE(2024,1,1),G2:G151,"<"&DATE(2025,1,1))
9. **9\.** How many customers have never placed an order?
**Show the answer** **18** Formula:=COUNTIF(H2:H151,0)
10. **10\.** Which customer ID has spent the most?
**Show the answer** **2,043** Formula:=INDEX(A2:A151,MATCH(MAX(I2:I151),I2:I151,0))
11. **11\.** What is the average order value across all customers? Round to a whole number.
**Show the answer** **$1,547** Formula:=ROUND(SUM(I2:I151)/SUM(H2:H151),0)
12. **12\.** What share of the customers get the newsletter? Round to three decimals.
**Show the answer** **42%** Formula:=ROUND(COUNTIF(J2:J151,"Yes")/COUNTA(A2:A151),3)
13. **13\.** How much have customers with 10 or more orders spent in total?
**Show the answer** **$1,381,503** Formula:=SUMIF(H2:H151,">=10",I2:I151)
### Count customers with one and two conditions The number of customers in one city is a plain COUNTIF: `**=COUNTIF(E2:E151,"Denver")**`. Upper and lower case do not matter in the criterion, so "denver" gives the same answer. Add a second condition and you need COUNTIFS. Business customers in Chicago are rows where the segment is Business and the city is Chicago: `**=COUNTIFS(F2:F151,"Business",E2:E151,"Chicago")**` Each condition is a pair of a range and a criterion, and a row only counts when all pairs match. The order of the pairs does not matter. Practice it in [**COUNTIFS with two conditions**](https://practiceexcelonline.com/practice/countifs/countifs-two-conditions). ### Average spend per segment AVERAGEIF works like SUMIF: where to look, what to look for and what to average. The average spend of business customers is: `**=ROUND(AVERAGEIF(F2:F151,"Business",I2:I151),0)**` The ROUND around it gives a whole number. Compare the result with the same formula for Private, and you see why most shops treat the two segments differently. Practice it in [**Average one group with AVERAGEIF**](https://practiceexcelonline.com/practice/averageif/averageif). There is a catch with averages on customer data. The customers who never ordered have 0 in **Total spent**, and they are part of the average. If you want the average of paying customers only, add a condition with AVERAGEIFS: `**=AVERAGEIFS(I2:I151,F2:F151,"Business",H2:H151,">0")**`. Which one is right depends on the question. Write down which one you used. ### Look up a customer by ID XLOOKUP finds a customer by ID and returns any column you like. The email address of customer 2077 is: `**=XLOOKUP(2077,A2:A151,D2:D151)**` The first argument is what to find, the second is where to find it and the third is what to return. Swap D2:D151 for E2:E151 and you get the city. The ID is a number in the file, so you look it up as a number without quotes. If the IDs had been stored as text, you would need "2077" in quotes, and a number would not match. That is one of the most common reasons for #N/A in real customer lists. Practice the lookup in [**Look up a price with XLOOKUP**](https://practiceexcelonline.com/practice/xlookup/xlookup). In a real sheet you rarely type the ID into the formula. Put it in a cell of its own, such as L1, and point to it: `**=XLOOKUP(L1,A2:A151,D2:D151)**`. Now anyone can type a new ID in L1 and see the email change. Add the same lookup for name, city and spend next to it, and you have a small customer card that looks up everything about one customer from a single cell. If someone types an ID that doesn't exist, the card shows #N/A in every field. Give XLOOKUP a fourth argument and it says something friendlier: `**=XLOOKUP(L1,A2:A151,D2:D151,"Unknown customer")**`. The fourth argument is only used when the ID is missing, so every real lookup works as before. Practice it in [**XLOOKUP with a not-found value**](https://practiceexcelonline.com/practice/xlookup/xlookup-if-not-found), then type an ID above 2150 in L1 to see it work. ### Join the first and last name A lookup returns one value. To get a full name, you do two lookups and join them with & and a space in quotes: `**=XLOOKUP(2033,A2:A151,B2:B151)&" "&XLOOKUP(2033,A2:A151,C2:C151)**` To build a full name column for every customer, it is simpler: `**=B2&" "&C2**` in a new column, filled down. Forget the space and the names run together. Practice it in [**Join first and last name with &**](https://practiceexcelonline.com/practice/join-text/join-names-ampersand). ### Take an email address apart Everything after the @ in an email address is the domain. FIND gives the position of the @, and MID takes the text from the next character: `**=MID(D2,FIND("@",D2)+1,50)**` The 50 is just a number large enough to reach the end of any address. MID stops at the end of the text, so it does no harm to ask for too many characters. FIND is case-sensitive and returns #VALUE! when the character is missing, which is a quick way to spot an email address without an @. Practice it in [**Find the @ in an email with FIND**](https://practiceexcelonline.com/practice/find-search/find-position-of-character). The part before the @ works the same way with LEFT: `**=LEFT(D2,FIND("@",D2)-1)**` gives everything up to the @, minus the @ itself. Try it in [**Take the prefix with LEFT**](https://practiceexcelonline.com/practice/left-right-mid/left-first-characters). ### Count email domains with a wildcard You don't need to take every address apart to count Gmail users. An asterisk in a COUNTIF criterion stands for any text, so this counts every address that ends in @gmail.com: `**=COUNTIF(D2:D151,"*@gmail.com")**` Swap the domain to count Outlook or Hotmail. Put the asterisk at both ends, as in "*gmail*", and you count addresses that contain the word anywhere. Wildcards work in COUNTIF, SUMIF, AVERAGEIF and their IFS versions, and in XLOOKUP if you ask for it. ### Dates as conditions The customers who signed up in 2024 are the rows with a signup date from Jan 1, 2024 up to, but not including, Jan 1, 2025. That is two conditions on the same column: `**=COUNTIFS(G2:G151,">="&DATE(2024,1,1),G2:G151,"<"&DATE(2025,1,1))**` The comparison goes in quotes and the date is joined on with &. "Less than the first of next year" is safer than "less than or equal to Dec 31", because it also works if a date has a time in it. More on dates in the guide to [**Excel dates**](https://practiceexcelonline.com/learn/excel-dates). ### The biggest customer and the average order To find which customer has spent the most, find the highest spend with MAX and its position with MATCH, then return the ID from the same position with INDEX: `**=INDEX(A2:A151,MATCH(MAX(I2:I151),I2:I151,0))**` The average order value is total spend divided by total orders, not the average of each customer's average. `**=ROUND(SUM(I2:I151)/SUM(H2:H151),0)**` gives it in one go. The two numbers differ because customers with many orders weigh more in the first one. ### Shares and big customers The share of customers who get the newsletter is the number of Yes values divided by the number of customers: `**=ROUND(COUNTIF(J2:J151,"Yes")/COUNTA(A2:A151),3)**` Format the cell as a percentage to read it as one. The guide to [**calculating percentages in Excel**](https://practiceexcelonline.com/learn/calculate-percentage-excel) has more on shares. SUMIF with a number condition adds up the spend of customers who match it. Customers with 10 or more orders are the loyal core of most shops: `**=SUMIF(H2:H151,">=10",I2:I151)**` Divide it by the total spend and you have the share of revenue that comes from them. Practice the condition in [**SUMIF with a number condition**](https://practiceexcelonline.com/practice/sumif/sumif-greater-than). ### Sort customers into groups with IFS Many shops split their customers into tiers by spend, so the best customers get a call and the rest get an email. IFS checks the conditions in order and returns the value for the first one that is true: `**=IFS(I2>20000,"Gold",I2>5000,"Silver",TRUE,"Bronze")**` Put the formula in a new column next to row 2 and fill it down. The order matters: if you check for more than 5,000 first, every Gold customer lands in Silver, because 25,000 is also more than 5,000. Start with the strictest condition. The TRUE at the end catches everyone who is left. Practice the structure in [**Grades with IFS**](https://practiceexcelonline.com/practice/ifs-switch/ifs-grades). When the column is filled, count each tier with COUNTIF and add up the spend per tier with SUMIF. In most customer lists a small Gold group stands for a large part of the revenue. That is the number a sales manager wants to see first. ## Build a customer summary Once you have solved the tasks, pull it together in a small summary. Type the five cities in column L, from L2 to L6. Next to them, count the customers, add up the spend and work out the average: `**=COUNTIF($E$2:$E$151,L2)**` `**=SUMIF($E$2:$E$151,L2,$I$2:$I$151)**` The ranges are locked with $, while L2 has to move when you fill down. Add a column that splits the count into private and business customers with COUNTIFS, and a row at the bottom with the totals. The totals should match the number of rows in the file and the sum of **Total spent**. If they don't, a city is spelled differently somewhere. A summary like this is what a pivot table gives you in a few clicks. Building it with formulas once teaches you what the pivot table does behind the scenes, and the formulas update when the data changes. ## Clean before you count The customer data in this file is tidy. Real exports rarely are. The same customer appears twice with two spellings, a city has a trailing space, an ID is stored as text in half the rows. Every one of those gives a wrong count without an error message, because "Denver " and "Denver" are two different cities to COUNTIF. So before you trust a count on a real list, check it: filter the city column and look at the list of values. Five cities should show five entries, not seven. If you want to practice fixing that kind of mess, the [**messy data**](https://practiceexcelonline.com/learn/excel-data-cleaning-practice) file has all of it, with tasks and answers. Customer lists also show up in Excel tests for jobs in sales, marketing and customer service. The questions look like the ones here: a count with two conditions, an average per group, a lookup on an ID and a share. More in the guide to [**Excel for job interviews**](https://practiceexcelonline.com/learn/excel-for-job-interviews). ## Practice without an answer key These exercises don't have a single number as the answer, but they are what you do with a customer list at work: - **Build a full name column** with `**=B2&" "&C2**`, and an email domain column with MID and FIND. Then sort by domain. - **Make a table per city** with the five cities in one column and COUNTIFS for private and business customers next to it. Lock the ranges with $ so you can fill both directions. - **Sort customers into tiers** with IFS: Gold above 20,000 spent, Silver above 5,000 and Bronze for the rest. Then count each tier. - **Find customers who have gone quiet:** signed up before 2023 with 0 orders. Filter on both columns, or count them with COUNTIFS. - **Highlight the top ten customers** with conditional formatting on the **Total spent** column. The guide to [**conditional formatting**](https://practiceexcelonline.com/learn/conditional-formatting-excel) shows how. - **Build a pivot table** with cities in rows, segments in columns and the sum of **Total spent** as values. ## When an answer doesn't match These are the mistakes that most often give a wrong number on customer data: - **A number looked up as text.** "2077" in quotes does not match the number 2077 in column A. Leave out the quotes. - **Customers with no orders forgotten.** They are in every average unless you leave them out on purpose. - **A missing asterisk.** "@gmail.com" without the asterisk only counts cells that say exactly @gmail.com, which is none. - **Dates typed as text.** ">=1/1/2024" can be read differently on another computer. Use DATE. - **The wrong average.** Average spend per customer and average order value are different numbers. Read the question twice. ## Customer data in Google Sheets The file works in Google Sheets. Upload it to Google Drive and open it with Google Sheets. Every task can be solved with the same formulas, and Google Sheets adds SPLIT, which takes an email address apart at the @ in one step. See the differences in [**Google Sheets vs. Excel**](https://practiceexcelonline.com/learn/google-sheets-vs-excel). ## More practice data This file is one of several free datasets with tasks and answers: - [**Sales and employee data**](https://practiceexcelonline.com/learn/excel-practice-data): 240 orders and 60 employees, for SUMIF, COUNTIFS, averages and dates. The sales file also feeds the [**pivot table practice**](https://practiceexcelonline.com/learn/pivot-table-practice). - [**Inventory data**](https://practiceexcelonline.com/learn/excel-inventory-data): 80 products with stock and prices, for XLOOKUP and SUMPRODUCT. - [**Messy data**](https://practiceexcelonline.com/learn/excel-data-cleaning-practice): 60 orders full of extra spaces, text numbers and duplicates, for cleanup practice. - [**Finance data**](https://practiceexcelonline.com/learn/excel-finance-practice-data): a year of bank transactions, for income, expenses, results and percentages. ## In short A customer list mixes numbers, text and dates, and that makes it great practice. COUNTIF and COUNTIFS count customers, AVERAGEIF and SUMIF work out spend per group, and XLOOKUP finds one customer by ID. FIND, MID and LEFT take an email address apart, and & puts a name back together. Solve the tasks in the file, check your answers here and work out where it went wrong when a number is off. To drill one formula at a time on a small sheet, start with the exercises below. They check your answer right away and show a hint when the formula is wrong. The first exercise in each topic is free. ![Nicolaj](https://practiceexcelonline.com/authors/nicolaj.webp) **About the author** ## **Nicolaj**, founder of PracticeExcel I'm a software developer, and I built PracticeExcel from scratch, including the spreadsheet itself and the engine that calculates the formulas. To make that work, I had to understand every function down to the details: how VLOOKUP behaves when a code has one space too many, why a date is really a number, and when ROUND gives a different answer than the number format. [More about Nicolaj](https://practiceexcelonline.com/about#nicolaj) ## **Practice what this guide covers** Graded exercises in a real grid, in the order the guide uses them. - [**Find the @ in an email with FIND**FIND and SEARCH →](https://practiceexcelonline.com/practice/find-search/find-position-of-character) - [**Join first and last name with &**Joining text with & and TEXTJOIN →](https://practiceexcelonline.com/practice/join-text/join-names-ampersand) - [**Take the prefix with LEFT**LEFT, RIGHT and MID →](https://practiceexcelonline.com/practice/left-right-mid/left-first-characters) - [**COUNTIFS with two conditions**COUNTIFS →](https://practiceexcelonline.com/practice/countifs/countifs-two-conditions) - [**Average one group with AVERAGEIF**AVERAGEIF and AVERAGEIFS →](https://practiceexcelonline.com/practice/averageif/averageif) - [**SUMIF with a number condition**SUMIF →](https://practiceexcelonline.com/practice/sumif/sumif-greater-than) ### **Function pages** - [**COUNTIF**](https://practiceexcelonline.com/functions/countif) - [**COUNTIFS**](https://practiceexcelonline.com/functions/countifs) - [**AVERAGEIF**](https://practiceexcelonline.com/functions/averageif) - [**XLOOKUP**](https://practiceexcelonline.com/functions/xlookup) - [**FIND**](https://practiceexcelonline.com/functions/find) - [**MID**](https://practiceexcelonline.com/functions/mid) - [**LEFT**](https://practiceexcelonline.com/functions/left) - [**SUMIF**](https://practiceexcelonline.com/functions/sumif) ## **Questions**
### Where can I find customer data to practice Excel? This page has a free customer list with 150 customers of an online shop, with names, email addresses, cities, segments, signup dates, orders and total spend. The file has a sheet of 13 tasks, and the answers are on this page.
### Which Excel functions can I practice with customer data? COUNTIF and COUNTIFS to count customers, AVERAGEIF for average spend, XLOOKUP to find a customer by ID, FIND and MID to take the domain out of an email address, & to join names, and SUMIF with a number condition.
### Is the customer data real? No. The names are made up and the email addresses do not exist. The data is built to look like a real customer export, so it is safe to share and practice on.
### Are the files free? Yes. The columns, tasks and answers are on this page. You download the file itself with a free PracticeExcel account, which also saves your progress in the exercises.
### Does the customer file work in Google Sheets? Yes. Upload it to Google Drive and open it with Google Sheets. Every task can be solved with the same formulas.
## **More guides** - [**Excel practice data: free datasets with tasks and answers**Two free Excel files to practice on: 240 sales orders and 60 employees. With 29 tasks on SUMIF, COUNTIF, lookups and dates, and answers you can check.](https://practiceexcelonline.com/learn/excel-practice-data) - [**Excel inventory data: free practice file with tasks and answers**A free inventory file with 80 products to practice on: stock, reorder points, cost and price. With 12 tasks on XLOOKUP, SUMPRODUCT and COUNTIFS, and the answers.](https://practiceexcelonline.com/learn/excel-inventory-data) - [**Excel data cleaning practice: a messy file with tasks and answers**A free messy Excel file to practice cleanup on: extra spaces, wrong case, text numbers, text dates, mixed phone formats and duplicates. With 14 tasks and answers.](https://practiceexcelonline.com/learn/excel-data-cleaning-practice) - [**Excel finance data: free practice file with tasks and answers**A free finance file with a year of bank transactions for a small firm. With 14 tasks on income, expenses, results, SUMIFS by month and percentages, and answers.](https://practiceexcelonline.com/learn/excel-finance-practice-data) - [**VLOOKUP vs XLOOKUP vs INDEX MATCH: which lookup to use**How VLOOKUP, XLOOKUP and INDEX with MATCH work, where each one breaks, and which to use in a test, an old workbook or a sheet you are building today.](https://practiceexcelonline.com/learn/vlookup-vs-xlookup-vs-index-match) ```json {"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#webpage","dateModified":"2026-11-12","datePublished":"2026-11-12","description":"A free customer list with 150 customers to practice on: names, emails, cities, orders and spend. With 13 tasks on COUNTIFS, XLOOKUP, text functions and dates.","name":"Excel customer data: free practice file with tasks and answers","url":"https://practiceexcelonline.com/learn/excel-customer-data","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#/schema/question/1"},{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#/schema/question/2"},{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#/schema/question/3"},{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#/schema/question/4"},{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/learn/excel-customer-data"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel guides","item":"https://practiceexcelonline.com/learn","position":2},{"@type":"ListItem","name":"Excel customer data: free practice file with tasks and answers","position":3}]},{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#article","@type":"Article","dateModified":"2026-11-12","datePublished":"2026-11-12","description":"A free customer list with 150 customers to practice on: names, emails, cities, orders and spend. With 13 tasks on COUNTIFS, XLOOKUP, text functions and dates.","headline":"Excel customer data: free practice file with tasks and answers","inLanguage":"en-US","thumbnailUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgY3VzdG9tZXIgZGF0YTogZnJlZSBwcmFjdGljZSBmaWxlIHdpdGggdGFza3MgYW5kIGFuc3dlcnM%2Cdescription_~QSBmcmVlIGN1c3RvbWVyIGxpc3Qgd2l0aCAxNTAgY3VzdG9tZXJzIHRvIHByYWN0aWNlIG9uOiBuYW1lcywgZW1haWxzLCBjaXRpZXMsIG9yZGVycyBhbmQgc3BlbmQuIFdpdGggMTMgdGFza3Mgb24gQ09VTlRJRlMsIFhMT09LVVAsIHRleHQgZnVuY3Rpb25zIGFuZCBkYXRlcy4%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1jdXN0b21lci1kYXRhIg%2Cs_SmZ69cNIYgNyvCeX.png","author":{"@id":"https://practiceexcelonline.com/#/schema/person/1"},"image":{"@id":"https://practiceexcelonline.com/#/schema/image/1"},"isPartOf":{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#webpage"},"mainEntityOfPage":{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#webpage"},"publisher":{"@id":"https://practiceexcelonline.com/#identity"}},{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"Where can I find customer data to practice Excel?","acceptedAnswer":{"@type":"Answer","text":"This page has a free customer list with 150 customers of an online shop, with names, email addresses, cities, segments, signup dates, orders and total spend. The file has a sheet of 13 tasks, and the answers are on this page."}},{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Which Excel functions can I practice with customer data?","acceptedAnswer":{"@type":"Answer","text":"COUNTIF and COUNTIFS to count customers, AVERAGEIF for average spend, XLOOKUP to find a customer by ID, FIND and MID to take the domain out of an email address, & to join names, and SUMIF with a number condition."}},{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"Is the customer data real?","acceptedAnswer":{"@type":"Answer","text":"No. The names are made up and the email addresses do not exist. The data is built to look like a real customer export, so it is safe to share and practice on."}},{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"Are the files free?","acceptedAnswer":{"@type":"Answer","text":"Yes. The columns, tasks and answers are on this page. You download the file itself with a free PracticeExcel account, which also saves your progress in the exercises."}},{"@id":"https://practiceexcelonline.com/learn/excel-customer-data#/schema/question/5","@type":"Question","inLanguage":"en-US","name":"Does the customer file work in Google Sheets?","acceptedAnswer":{"@type":"Answer","text":"Yes. Upload it to Google Drive and open it with Google Sheets. Every task can be solved with the same formulas."}},{"@id":"https://practiceexcelonline.com/#/schema/person/1","@type":"Person","description":"I'm a software developer, and I built PracticeExcel from scratch, including the spreadsheet itself and the engine that calculates the formulas. To make that work, I had to understand every function down to the details: how VLOOKUP behaves when a code has one space too many, why a date is really a number, and when ROUND gives a different answer than the number format.","jobTitle":"founder of PracticeExcel","name":"Nicolaj","url":"https://practiceexcelonline.com/about#nicolaj","image":{"@id":"https://practiceexcelonline.com/#/schema/image/2"}},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgY3VzdG9tZXIgZGF0YTogZnJlZSBwcmFjdGljZSBmaWxlIHdpdGggdGFza3MgYW5kIGFuc3dlcnM%2Cdescription_~QSBmcmVlIGN1c3RvbWVyIGxpc3Qgd2l0aCAxNTAgY3VzdG9tZXJzIHRvIHByYWN0aWNlIG9uOiBuYW1lcywgZW1haWxzLCBjaXRpZXMsIG9yZGVycyBhbmQgc3BlbmQuIFdpdGggMTMgdGFza3Mgb24gQ09VTlRJRlMsIFhMT09LVVAsIHRleHQgZnVuY3Rpb25zIGFuZCBkYXRlcy4%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1jdXN0b21lci1kYXRhIg%2Cs_SmZ69cNIYgNyvCeX.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgY3VzdG9tZXIgZGF0YTogZnJlZSBwcmFjdGljZSBmaWxlIHdpdGggdGFza3MgYW5kIGFuc3dlcnM%2Cdescription_~QSBmcmVlIGN1c3RvbWVyIGxpc3Qgd2l0aCAxNTAgY3VzdG9tZXJzIHRvIHByYWN0aWNlIG9uOiBuYW1lcywgZW1haWxzLCBjaXRpZXMsIG9yZGVycyBhbmQgc3BlbmQuIFdpdGggMTMgdGFza3Mgb24gQ09VTlRJRlMsIFhMT09LVVAsIHRleHQgZnVuY3Rpb25zIGFuZCBkYXRlcy4%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1jdXN0b21lci1kYXRhIg%2Cs_SmZ69cNIYgNyvCeX.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/2","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/authors/nicolaj.webp","inLanguage":"en-US","url":"https://practiceexcelonline.com/authors/nicolaj.webp"}]} ``` ## Sitemap See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.