Skip to content
TestingFile

ODS · 4 files

Sample ODS files - free spreadsheet downloads

Download clean OpenDocument Spreadsheet files with predictable dummy data. Each sample has one Data sheet for testing LibreOffice Calc, uploads, imports and spreadsheet parsers.

4 files ODS 10 - 5,000 rows Simple rows and columns

ODS sample library

Download ODS sample files by row count

4 files

10 rows

2.1 KB

10-row ODS sample file (2.1 KB)

1 sheet

ODSDownload ODS

100 rows

4.6 KB

100-row ODS sample file (4.6 KB)

1 sheet

ODSDownload ODS

1,000 rows

25.6 KB

1,000-row ODS sample file (25.6 KB)

1 sheet

ODSDownload ODS

5,000 rows

117.2 KB

5,000-row ODS sample file (117.2 KB)

1 sheet

ODSDownload ODS

OpenDocument spreadsheet guide

Use ODS samples to test spreadsheet imports

ODS is the OpenDocument Spreadsheet format used by LibreOffice Calc, Apache OpenOffice and other compatible office software. These files contain fictional data for safe testing.

What is inside each ODS sample?

Each workbook has one Data sheet with ID, name, email, company, city, country, amount and date columns. The 10-row sample is intentionally smaller with three columns. No macros or formulas are included.

Choose a file by row count to test a small upload, a typical data import or a larger spreadsheet-processing limit.

Before using a sample

  • ✓Confirm that the software accepts the .ods extension.
  • ✓Check that the first row is read as column headings.
  • ✓Verify text, numeric values and dates after import.

Frequently asked questions

What is an ODS file?

ODS is the OpenDocument Spreadsheet file format used by LibreOffice Calc and other compatible spreadsheet applications.

Can I open these samples in Excel?

Current versions of Microsoft Excel can open many ODS files. Check the imported cells and formatting in your target version.

Do these ODS files contain formulas or macros?

No. These samples use one sheet of simple test data without formulas or macros.

ODS format details

Extension

.ods

MIME type

application/vnd.oasis.opendocument.spreadsheet

Workbook structure

Data

Free ODS sample files for LibreOffice and import testing

Use these downloadable ODS test files to check OpenDocument compatibility, spreadsheet uploads, import workflows and parser behavior.

Pick a sample size

Use 10 or 100 rows for quick checks, 1,000 for everyday imports or 5,000 rows to test larger ODS files.

Check OpenDocument support

Open a sample in LibreOffice Calc or test whether your application reads ODS worksheets and cell values correctly.

Use predictable dummy data

Samples contain fictional names and example addresses, making them suitable for development and test environments.

About the ODS format

ODS is the spreadsheet document format in OpenDocument Format (ODF), an open format family for office documents.

OpenDocument standard

OpenDocument is an XML-based family standardized as ISO/IEC 26300. ODS is used for spreadsheet documents.

ZIP package with XML

A typical ODS file is a ZIP package containing XML parts and resources. Its content, styles, metadata and settings are stored in separate document parts.

Compatible office software

ODS files are supported by LibreOffice Calc and other office applications. Feature support and visual details can vary, so check imports in the software used by your workflow.

Source article: Wikipedia: OpenDocument