.XLSX

Sample XLSX Files

Excel workbooks filled with realistic, consistent test data. Use them for import features, spreadsheet parsers and performance tests at different row counts.

.xlsxapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet5 filesFree · No sign-upUnlimited downloads

by Technology Channel · Free to use for testing and development, including commercial projects.

100 rowsPopular

sample-100-rows.xlsx

100 fictional orders with dates, currencies and statuses. Header row frozen and filterable.

100 rows
11 columns
Dates + currency

36.9 KB Download

1,000 rows

sample-1000-rows.xlsx

1,000 fictional orders with dates, currencies and statuses. Header row frozen and filterable.

1,000 rows
11 columns
Dates + currency

91.2 KB Download

10,000 rows

sample-10000-rows.xlsx

10,000 fictional orders with dates, currencies and statuses. Header row frozen and filterable. Good for import and performance tests.

10,000 rows
11 columns
Dates + currency

662 KB Download

100,000 rows

sample-100000-rows.xlsx

100,000 fictional orders with dates, currencies and statuses. Header row frozen and filterable. Good for import and performance tests.

100,000 rows
11 columns
Dates + currency

6.3 MB Download

Multiple sheets, formulas and charts

sample-multiple-sheets.xlsx

Six linked sheets with SUMIF/COUNTIF formulas, currency and date formats, frozen headers, filters, a bar chart and a line chart.

6 sheets
Formulas
2 charts

75.6 KB Download

Use cases

What you can test

Spreadsheet import, column mapping and validation.
Parser speed and memory with 10,000 and 100,000 rows.
Reading formulas versus their cached values.
Multiple named sheets and an embedded chart.
Date, currency and number formatting.
Export round trips: XLSX to CSV and back.
Pagination and virtual scrolling in data grids.

Reference

XLSX format facts

Extension	.xlsx
MIME type	application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File signature	50 4B 03 04 (PK.., ZIP container)
Origin	Microsoft, 2007 · ECMA-376, ISO/IEC 29500
Files here	5 · 7.1 MB in total
License	Free for any use, no attribution

About the format

What is a XLSX file?

XLSX is the Excel workbook format introduced with Office 2007, part of Office Open XML. Like DOCX, it is a ZIP archive of XML parts: worksheets, shared strings, styles and charts.

A worksheet can hold up to 1,048,576 rows and 16,384 columns. Large files are where many parsers slow down, so test with realistic sizes before you ship an import feature.

Developers

Read with pandas

import pandas as pd  # pip install pandas openpyxl

df = pd.read_excel("files/xlsx/sample-1000-rows.xlsx")
print(df.shape)
print(df.head())

Download with cURL

curl -O https://samplefiles.technologychannel.org/files/xlsx/sample-100-rows.xlsx

FAQ

XLSX files: common questions

What data is inside the spreadsheets?

Fictional but realistic records such as names, emails, cities, dates, products and amounts. None of it belongs to real people.

Do the formulas recalculate?

Yes. The multi-sheet workbook uses live formulas such as SUM and AVERAGE, so Excel, Google Sheets and LibreOffice recalculate them when you edit a value.

Can I use these spreadsheets in commercial projects?

Yes. Every spreadsheet here is free for any use, including commercial testing, demos and tutorials. No attribution is required.

Can I download the same spreadsheet more than once?

Yes, as many times as you like. There is no sign-up, no daily limit and no waiting timer. Direct links also work in scripts, CI jobs and automated tests.

Keep testing

Related formats

All 20 formats

All XLSX sample files