Download sample Excel files
| File | Contents | Rows | Sheets | Size | Download |
|---|---|---|---|---|---|
| XLSXCustomers – 100 rows | customers data | 100 | 1 | 14.9 KB | Download |
| XLSXCustomers – 1,000 rows | customers data | 1,000 | 1 | 102 KB | Download |
| XLSXOrders – 1,000 rows | orders data | 1,000 | 1 | 60.9 KB | Download |
| XLSXProducts – 100 rows | products data | 100 | 1 | 10.0 KB | Download |
| XLSXEmployees – 1,000 rows | employees data | 1,000 | 1 | 67.2 KB | Download |
| XLSXWorkbook with formulas | SUM, AVERAGE, IF, COUNTIF, INDEX/MATCH, VLOOKUP | 15 | 2 | 6.5 KB | Download |
| XLSXWorkbook with 4 sheets | Customers, Orders, Products, Employees | 200 per sheet | 4 | 60.4 KB | Download |
| XLSXWorkbook with charts | Bar chart + line chart | 12 | 1 | 7.4 KB | Download |
| XLSXLarge workbook – 100,000 rows | orders data | 100,000 | 1 | 5.6 MB | Download |
| XLSLegacy XLS (Excel 97–2003) | customers data | 1,000 | 1 | 260 KB | Download |
| order_id | customer_id | order_date | status | items | subtotal | tax | shipping | total | currency |
|---|---|---|---|---|---|---|---|---|---|
| 100001 | 89 | 2025-12-09 00:37:00 | delivered | 5 | 129.70 | 9.40 | 0.00 | 139.10 | USD |
| 100002 | 37 | 2025-02-12 20:05:00 | delivered | 7 | 419.21 | 30.39 | 0.00 | 449.60 | USD |
| 100003 | 79 | 2025-08-25 18:53:00 | delivered | 1 | 567.29 | 41.13 | 0.00 | 608.42 | USD |
| 100004 | 73 | 2025-09-10 19:01:00 | delivered | 5 | 163.32 | 11.84 | 0.00 | 175.16 | USD |
| 100005 | 91 | 2025-06-02 05:58:00 | shipped | 5 | 273.05 | 19.80 | 0.00 | 292.85 | USD |
| 100006 | 74 | 2025-05-19 02:33:00 | delivered | 2 | 551.69 | 40.00 | 0.00 | 591.69 | USD |
Files with formulas, charts and multiple sheets
- sample-formulas.xlsx — a sales table with
SUM,AVERAGE,IF,COUNTIF,INDEX/MATCHand aVLOOKUPinto a second sheet. Good for testing formula evaluation in libraries such as openpyxl, SheetJS or Apache POI. - sample-multiple-sheets.xlsx — four sheets (Customers, Orders, Products, Employees) with 200 rows each.
- sample-with-chart.xlsx — monthly revenue and expenses with a bar chart and a line chart.
Large XLSX for testing
orders-100000.xlsx has 100,000 rows and 10 columns. Use it to test memory use and import speed; for read-only processing, open it in streaming mode (for example openpyxl.load_workbook(path, read_only=True)).
XLS vs XLSX
XLSX (Excel 2007 and later) is a ZIP archive of XML files and supports 1,048,576 rows. XLS is the older binary format from Excel 97–2003, limited to 65,536 rows and 256 columns. Many upload forms still need to accept XLS, so customers-1000.xls is included for testing.