Datasets by tool

Excel Practice Datasets

These are realistic tables to practise Excel on, not a list of 50 identical rows. Each one has something to summarise with a pivot table, a key to look up, dates to calculate with and a pattern worth charting. Open a dataset to see its columns and sample rows, then download it as an Excel file.

Pivot tables and summaries

Transactions with categories, amounts and dates: the raw material for pivot tables. Summarise sales by product category and payment method, expenses by category and business flag, or household spending by month. Add a slicer on payment_method and a timeline on the date column.

E-commerce13 cols · 200 rows

Sales Transactions

This dataset provides granular, line-item records of point-of-sale transactions, including product details, quantities, pricing, discounts, payment methods, and references to customers and store locations. It is ideal for retail analytics, sales performance tracking, and customer behavior analysis, enabling businesses to optimize inventory, marketing, and operational strategies.

product_namequantitypayment_method
Standard Widget2credit_card
Promo Mug1cash
Premium Headphones1debit_card
transaction_idtransaction_datetimecustomer_id+7 more
Other18 cols · 200 rows

Small Retailer Sales Transactions

This dataset provides detailed transaction-level sales data from small local retailers, including product, payment, and retailer information. It enables comprehensive analysis of sales trends, business performance, and consumer behavior, supporting decision-making for retail operations and market research.

retailer_nameproduct_nameproduct_category
SuperMart DowntownOrganic Milk GallonGrocery
ElectroHubBluetooth HeadphonesElectronics
FashionistaSummer DressApparel
transaction_idtransaction_dateretailer_id+12 more
Finance20 cols · 200 rows

Finance Expense Categorization Dataset

This dataset contains detailed, structured expense records including transaction dates, amounts, categories, payment methods, merchant details, and location information. It is ideal for personal finance management, business accounting, machine learning classification, and budgeting applications, providing granular insights into spending patterns and expense tracking.

merchant_nameamountcategory
The Grove Bistro53.25Food
Pacific Utilities0Other
Netflix Australia19.99Entertainment
currencyis_business_expensereceipt_available+14 more
Finance18 cols · 200 rows

Personal Finance Budgeting Records

This dataset provides detailed, household-level records of income and expenses, including transaction categories, payment methods, recurrence patterns, and basic household demographics. It enables comprehensive budgeting analysis, supports financial literacy initiatives, and can power personalized financial recommendations and research into household spending habits.

record_typecategorysubcategory
incomesalary–
expenserent–
incomeinvestmentdividends
household_idrecord_idamount+12 more

Lookups, dates and text

Records with IDs that point at each other and dates to do arithmetic on. Look up a manager by manager_id, work out tenure from hire_date or days overdue from due_date, and match order lines to their order. Good practice for XLOOKUP, DATEDIF and NETWORKDAYS.

Human Resources26 cols · 202 rows

Employee Records

This dataset provides a comprehensive view of employee records, including personal information, job roles, departmental assignments, salary details, employment history, and performance metrics. It is designed to support workforce management, HR analytics, and organizational planning, making it ideal for data-driven decision-making in human resources.

first_namelast_namejob_title
IsabellaMartinezLead Software Engineer
AdityaSinghFinancial Analyst
SophieDurandMarketing Director
employee_iddate_of_birthemail+20 more
Finance16 cols · 100 rows

Accounts Receivable and Aging Analysis

This dataset provides a comprehensive view of accounts receivable balances, aging buckets, collection rates, bad debt, write-offs, and AR days, enabling organizations to monitor financial performance and optimize collection strategies. It supports granular analysis by payer and invoice, facilitating prioritization of collection efforts and risk assessment for outstanding receivables.

payer_namepayer_typeaging_bucket
Springfield Health Insuranceinsurance1-30
Green Valley MedicalcustomerCurrent
MetroCare Partnersinsurance61-90
ar_record_idpayer_idinvoice_id+10 more
Human Resources12 cols · 62 rows

Employee Leave Balance Ledger

This dataset provides a detailed, period-based ledger of employee leave accruals, usage, and balances across multiple leave types and departments. It supports compliance monitoring, resource planning, and trend analysis for HR teams, offering granular visibility into workforce availability and leave patterns.

employee_nameleave_typestatus
Maria Chenannualactive
David Singhsickactive
Sarah Albrightannualactive
employee_iddepartmentperiod_start_date+6 more
E-commerce23 cols · 200 rows

Order History

This dataset provides a detailed record of customer purchase histories, including order metadata, item-level details, shipping and tracking information, and customer lifetime value metrics. It enables comprehensive analysis of purchasing behavior, order fulfillment, and customer value for e-commerce businesses. The data is structured for easy integration with analytics platforms and supports advanced segmentation and forecasting.

order_statuscurrencyitem_name
deliveredUSDWireless Mouse
shippedCNYSmartphone Stand
deliveredEURYoga Mat
order_idcustomer_idcustomer_email+17 more

Conditional formatting and charts

Numbers that vary for a reason: defect rates by line and shift, store footfall by day of the week, and grades by course and semester. Highlight the outliers with conditional formatting, then chart what you found.

Manufacturing9 cols · 200 rows

Manufacturing Line Defect Counts

This dataset provides detailed, shift-level defect counts for each product type and manufacturing line, enabling granular quality control analysis and predictive modeling. With fields for defect categories, production volumes, and calculated defect rates, it supports both operational monitoring and advanced AI-driven analytics to improve manufacturing processes.

shiftdefect_typedefect_rate
MorningSurface0.01
AfternoonMechanical0
NightElectrical0.12632
production_lineproduct_typetotal_units_produced+3 more
Other15 cols · 200 rows

Retail In-Store Foot Traffic Counts

This dataset provides anonymized, daily foot traffic counts for physical retail locations, enriched with store details, holiday indicators, weather conditions, and special event annotations. It enables robust sales forecasting, staffing optimization, and marketing campaign impact analysis by correlating footfall with external factors and store attributes.

store_nameday_of_weekis_holiday
FreshMart DowntownFridayfalse
MegaMart UptownSaturdayfalse
Boutique ParisienneFridaytrue
foot_traffic_idstore_idstore_street_address+9 more
Education16 cols · 200 rows

Grade Records

This dataset provides detailed academic performance records for students, including individual course grades, GPA calculations, credit information, and academic standing per term. It is ideal for tracking student progress, analyzing academic trends, and supporting institutional reporting and interventions.

student_first_namestudent_last_namecourse_name
EmilyGarciaCalculus I
JamalONeilIntroduction to Psychology
PriyaSinghOrganic Chemistry
record_idstudent_iddate_of_birth+10 more

Every dataset in this collection

11 datasets

E-commerce13 cols · 200 rows

Sales Transactions

This dataset provides granular, line-item records of point-of-sale transactions, including product details, quantities, pricing, discounts, payment methods, and references to customers and store locations. It is ideal for retail analytics, sales performance tracking, and customer behavior analysis, enabling businesses to optimize inventory, marketing, and operational strategies.

product_namequantitypayment_method
Standard Widget2credit_card
Promo Mug1cash
Premium Headphones1debit_card
transaction_idtransaction_datetimecustomer_id+7 more
Other18 cols · 200 rows

Small Retailer Sales Transactions

This dataset provides detailed transaction-level sales data from small local retailers, including product, payment, and retailer information. It enables comprehensive analysis of sales trends, business performance, and consumer behavior, supporting decision-making for retail operations and market research.

retailer_nameproduct_nameproduct_category
SuperMart DowntownOrganic Milk GallonGrocery
ElectroHubBluetooth HeadphonesElectronics
FashionistaSummer DressApparel
transaction_idtransaction_dateretailer_id+12 more
Finance20 cols · 200 rows

Finance Expense Categorization Dataset

This dataset contains detailed, structured expense records including transaction dates, amounts, categories, payment methods, merchant details, and location information. It is ideal for personal finance management, business accounting, machine learning classification, and budgeting applications, providing granular insights into spending patterns and expense tracking.

merchant_nameamountcategory
The Grove Bistro53.25Food
Pacific Utilities0Other
Netflix Australia19.99Entertainment
currencyis_business_expensereceipt_available+14 more
Finance18 cols · 200 rows

Personal Finance Budgeting Records

This dataset provides detailed, household-level records of income and expenses, including transaction categories, payment methods, recurrence patterns, and basic household demographics. It enables comprehensive budgeting analysis, supports financial literacy initiatives, and can power personalized financial recommendations and research into household spending habits.

record_typecategorysubcategory
incomesalary–
expenserent–
incomeinvestmentdividends
household_idrecord_idamount+12 more
Human Resources26 cols · 202 rows

Employee Records

This dataset provides a comprehensive view of employee records, including personal information, job roles, departmental assignments, salary details, employment history, and performance metrics. It is designed to support workforce management, HR analytics, and organizational planning, making it ideal for data-driven decision-making in human resources.

first_namelast_namejob_title
IsabellaMartinezLead Software Engineer
AdityaSinghFinancial Analyst
SophieDurandMarketing Director
employee_iddate_of_birthemail+20 more
Finance16 cols · 100 rows

Accounts Receivable and Aging Analysis

This dataset provides a comprehensive view of accounts receivable balances, aging buckets, collection rates, bad debt, write-offs, and AR days, enabling organizations to monitor financial performance and optimize collection strategies. It supports granular analysis by payer and invoice, facilitating prioritization of collection efforts and risk assessment for outstanding receivables.

payer_namepayer_typeaging_bucket
Springfield Health Insuranceinsurance1-30
Green Valley MedicalcustomerCurrent
MetroCare Partnersinsurance61-90
ar_record_idpayer_idinvoice_id+10 more
Human Resources12 cols · 62 rows

Employee Leave Balance Ledger

This dataset provides a detailed, period-based ledger of employee leave accruals, usage, and balances across multiple leave types and departments. It supports compliance monitoring, resource planning, and trend analysis for HR teams, offering granular visibility into workforce availability and leave patterns.

employee_nameleave_typestatus
Maria Chenannualactive
David Singhsickactive
Sarah Albrightannualactive
employee_iddepartmentperiod_start_date+6 more
E-commerce23 cols · 200 rows

Order History

This dataset provides a detailed record of customer purchase histories, including order metadata, item-level details, shipping and tracking information, and customer lifetime value metrics. It enables comprehensive analysis of purchasing behavior, order fulfillment, and customer value for e-commerce businesses. The data is structured for easy integration with analytics platforms and supports advanced segmentation and forecasting.

order_statuscurrencyitem_name
deliveredUSDWireless Mouse
shippedCNYSmartphone Stand
deliveredEURYoga Mat
order_idcustomer_idcustomer_email+17 more
Manufacturing9 cols · 200 rows

Manufacturing Line Defect Counts

This dataset provides detailed, shift-level defect counts for each product type and manufacturing line, enabling granular quality control analysis and predictive modeling. With fields for defect categories, production volumes, and calculated defect rates, it supports both operational monitoring and advanced AI-driven analytics to improve manufacturing processes.

shiftdefect_typedefect_rate
MorningSurface0.01
AfternoonMechanical0
NightElectrical0.12632
production_lineproduct_typetotal_units_produced+3 more
Other15 cols · 200 rows

Retail In-Store Foot Traffic Counts

This dataset provides anonymized, daily foot traffic counts for physical retail locations, enriched with store details, holiday indicators, weather conditions, and special event annotations. It enables robust sales forecasting, staffing optimization, and marketing campaign impact analysis by correlating footfall with external factors and store attributes.

store_nameday_of_weekis_holiday
FreshMart DowntownFridayfalse
MegaMart UptownSaturdayfalse
Boutique ParisienneFridaytrue
foot_traffic_idstore_idstore_street_address+9 more
Education16 cols · 200 rows

Grade Records

This dataset provides detailed academic performance records for students, including individual course grades, GPA calculations, credit information, and academic standing per term. It is ideal for tracking student progress, analyzing academic trends, and supporting institutional reporting and interventions.

student_first_namestudent_last_namecourse_name
EmilyGarciaCalculus I
JamalONeilIntroduction to Psychology
PriyaSinghOrganic Chemistry
record_idstudent_iddate_of_birth+10 more

Questions

Can I download these as .xlsx files?
Yes. Excel is one of the download formats on every dataset page, alongside CSV, JSON, Parquet, JSONL, SQL, TSV and XML.
Do I need an account to download?
You can see sample rows on every dataset page without one. Downloads need a free account: a 10-row sample costs nothing, and a new account's free credits cover your first full download.
Is the data real?
No. Every row is synthetic, generated to behave like real data, so you can share your workbook without worrying about anyone's personal details.

What should your data show?

Preview 20 rows free
No signup. No card.