Sample Inventory Data
SKU-level stock with warehouse, quantity on hand, reorder point and unit cost — for conditional formatting and stock alerts.
What is in the file
7 columns, 120 data rows by default, plus a header row. These are the first ten rows of the default file.
| SKU | Product | Category | Warehouse | Qty On Hand | Reorder Point | Unit Cost |
|---|---|---|---|---|---|---|
| SKU-1000 | Noise-Cancel Headset | Peripherals | WH-Austin | 64 | 186 | 374.26 |
| SKU-1001 | Monitor 27" | Furniture | WH-Toronto | 164 | 59 | 226.49 |
| SKU-1002 | Wireless Mouse | Accessories | WH-Lisbon | 263 | 92 | 669.81 |
| SKU-1003 | Monitor 27" | Hardware | WH-Berlin | 362 | 125 | 522.04 |
| SKU-1004 | Mechanical Keyboard | Peripherals | WH-Austin | 462 | 158 | 251.36 |
| SKU-1005 | Ergonomic Chair | Furniture | WH-Toronto | 81 | 191 | 103.58 |
| SKU-1006 | Mechanical Keyboard | Accessories | WH-Lisbon | 180 | 64 | 546.9 |
| SKU-1007 | Ergonomic Chair | Hardware | WH-Berlin | 280 | 97 | 399.13 |
| SKU-1008 | Laptop Stand | Peripherals | WH-Austin | 379 | 131 | 620.08 |
| SKU-1009 | USB-C Dock | Furniture | WH-Toronto | 478 | 164 | 472.31 |
Download 120 rows
7 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
Stock tables are the classic conditional-formatting exercise, and this one is built so the exercise has an answer: quantities sit above, at, and below the reorder point often enough that a "highlight what needs reordering" rule lights up a useful fraction of the rows instead of all or none of them.
What you can practise with it
- Conditional formatting for stock below the reorder point
- Total inventory value with SUMPRODUCT
- Stock per warehouse with a PivotTable
- IF / IFS logic for a reorder status column
Try a related exercise
- Look up a value with XLOOKUP — Fetching a value from another column by matching a key — the single most-used skill in any real spreadsheet.
- Make a lookup fail gracefully — A column of #N/A is not a bug — but shipping it to a reader is. Handling the expected failure without hiding the real ones.
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 inventory 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, 120 data rows, plus a header. Direct source links contain 120 data rows; the preview shows the first ten of those rows.