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 rows by default. The first ten rows are shown below — the download contains exactly this data.
| 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 |
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
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. The file is built in your browser when you click download; nothing is uploaded and no account is involved.
Which formats can I download?
Excel (.xlsx), CSV and JSON. All three contain the same 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. Pick a row count before downloading — the default is 120 rows, which is what the preview on this page is drawn from.