loremfile

Sample XLSX files for testing — free, CC0, hotlinkable

XLSX is Excel's workbook format, and the one import screens and data pipelines are asked to read more than any other. These workbooks cover the shared people dataset and the cell-level details that trip readers.

xlsx/1sheet-10rows.xlsx and xlsx/1sheet-1000rows.xlsx hold one sheet with a bold, frozen header row and ten or a thousand records of the people dataset; the first ten rows are the same in both.

xlsx/with-formulas.xlsx has SUM, AVERAGE, IF and VLOOKUP formulas over a ten-line order table, each with its result cached in the file, so readers that do not calculate, such as pandas, still see values. xlsx/with-types-and-formats.xlsx has one row per cell type and number format, including dates, percentages, currency and text that only looks numeric, such as 007.

For size limits, xlsx/1mb.xlsx and xlsx/10mb.xlsx add a sheet of incompressible noise images. Related formats: CSV, DOCX and Parquet.

6 files. The same list as JSON: https://loremfile.dev/xlsx/index.json

XLSX files
FileSizePropertiesDescription
10mb.xlsx 10.1 MB 2 sheets, 52 rows About 10MB: a people sheet plus a second sheet of embedded incompressible seeded-noise PNGs, so the size is honest rather than padded.
Snippets 
curl -O https://loremfile.dev/xlsx/10mb.xlsx
<a href="https://loremfile.dev/xlsx/10mb.xlsx">download</a>
1mb.xlsx 994.6 KB 2 sheets, 6 rows About 1MB: a people sheet plus a second sheet of embedded incompressible seeded-noise PNGs, so the size is honest rather than padded.
Snippets 
curl -O https://loremfile.dev/xlsx/1mb.xlsx
<a href="https://loremfile.dev/xlsx/1mb.xlsx">download</a>
1sheet-1000rows.xlsx 156.7 KB 1 sheets, 1,001 rows One sheet: a bold, frozen header row plus a thousand records of the shared people dataset. The first ten rows are the same records as the ten-row fixture.
Snippets 
curl -O https://loremfile.dev/xlsx/1sheet-1000rows.xlsx
<a href="https://loremfile.dev/xlsx/1sheet-1000rows.xlsx">download</a>
1sheet-10rows.xlsx 7.2 KB 1 sheets, 11 rows One sheet: a bold, frozen header row plus ten records of the shared people dataset across all fourteen columns.
Snippets 
curl -O https://loremfile.dev/xlsx/1sheet-10rows.xlsx
<a href="https://loremfile.dev/xlsx/1sheet-10rows.xlsx">download</a>
with-formulas.xlsx 5.5 KB 1 sheets, 11 rows SUM, AVERAGE, IF and VLOOKUP over a ten-line order table, each with its result cached in the file. Readers that do not calculate — pandas, openpyxl's data_only mode — still see the values.
Snippets 
curl -O https://loremfile.dev/xlsx/with-formulas.xlsx
<a href="https://loremfile.dev/xlsx/with-formulas.xlsx">download</a>
with-types-and-formats.xlsx 5.5 KB 1 sheets, 17 rows One row per cell type and number format: text, integer, float, negative, booleans, date, time, datetime, percentage, currency, scientific, an empty cell, and text that only looks numeric ('007', '2020-01-01', a phone number).
Snippets 
curl -O https://loremfile.dev/xlsx/with-types-and-formats.xlsx
<a href="https://loremfile.dev/xlsx/with-types-and-formats.xlsx">download</a>

File names follow the naming grammar. Verify a download against sha256sums.txt.