Free Sample Sales Data (Excel)
What's in the free sample sales data file
The Sales Data sheet ships with 200 rows already filled in: date, region (North, South, East, West, Central), product (Product A-D), quantity and unit price - with Revenue calculated automatically as quantity times price on every row.
Ten extra rows are left blank at the end of the sheet so you can add your own practice entries and watch the formulas react instantly.
The Dashboard sheet shows a worked example: total revenue and region-level rollups built with SUMIF and COUNTIF, so you can check your own PivotTable results against a known-correct number.
A dataset with an answer key, not just raw numbers
excelx.com's own free sample sales datasets are explicitly raw and unfinished - their site comments confirm 'we don't have specific answer keys... we encourage you to dive in' - meaning you get 5 separate CC0 files with realistic columns but no dashboard, no PivotTable, and no way to check your work.
This file pairs the same kind of realistic data with a finished Dashboard tab built from real formulas, so you can compare your own PivotTable or SUMIF result against a working example instead of guessing whether you got it right.
Built for Excel learners, not developers
Kaggle, GitHub and w3resource host similar sample sales data, but they're framed for Python and BI practice - column names and formats assume you're writing code, not building spreadsheet formulas.
This file is framed entirely for business and Excel users: realistic US-style regions and products, straightforward columns, and a Dashboard tab you can open and study without touching a line of code.
Who this file is for
Students and self-learners practicing PivotTables, SUMIF/COUNTIF, and basic dashboards who want a realistic dataset with enough rows to make the practice meaningful.
Excel trainers and course creators who need a ready-made demo file with correct answers built in, instead of assembling sample data from scratch for every exercise.
How to use it
- Open Sales Data - 200 rows are already filled in with Revenue calculated per row.
- Add your own rows in the blank practice area at the bottom of the sheet.
- Open Dashboard to see a worked SUMIF/COUNTIF example as your answer key.
Download the free Free Sample Sales Data (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
CRM & Sales Pipeline Tracker
Once you're comfortable with this practice data, track your own real sales pipeline with the CRM & Sales Pipeline Tracker ($14) - true stage-to-stage conversion and a 3-scenario forecast against your monthly goal.
See the full versionFrequently asked questions
Is this raw data only, or does it include a finished example?
It includes both: 200 rows of realistic filled data plus a Dashboard sheet with a worked SUMIF/COUNTIF example, unlike raw-only datasets that give you numbers with no answer key.
Do I need to know Python or SQL to use this?
No. Every column and formula is built for Excel/Google Sheets users - no coding required, unlike developer-oriented sample datasets from Kaggle or GitHub.
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. Revenue and the Dashboard rollups keep calculating.
Can I add my own data to practice with?
Yes - 10 rows are intentionally left blank at the end of the Sales Data sheet for your own practice entries, and you can add more rows following the same pattern.
Is this real company data?
No. It's a realistic but fictional dataset built for practicing spreadsheet skills - dates, regions, products and quantities are illustrative, not from a real business.
What's the usage license?
Personal use or use within one business, including teaching and coursework. It's not meant to be resold or redistributed as a template product.