How to open a .OTS file online
Three steps, a few seconds, no Excel.
Choose your .OTS file
Drag your .OTS file onto the box above, or click Choose file.
Supported
Your .OTS file is opened: every sheet, formula and merged range.
Browse, search, export
Switch sheets, click a cell to see its formula, search the whole sheet and export it as CSV or JSON.
What is a .OTS file?
Everything worth knowing about OpenDocument Spreadsheet Template files.
An OTS file is an OpenDocument Spreadsheet Template, the template counterpart to .ods, used in LibreOffice Calc and Apache OpenOffice. Opening an .ots file creates a new unnamed spreadsheet pre-filled with the template's styles and data; it does not open the template itself for editing. Open it in LibreOffice Calc (free), Apache OpenOffice Calc, or Microsoft Excel. To edit the template directly, use File > Templates > Edit Template in LibreOffice, or rename the file from .ots to .ods.
Programs that open .OTS files
| Full name | OpenDocument Spreadsheet Template |
|---|---|
| Developer | OASIS (originated at Sun Microsystems / OpenOffice.org) |
| First released | 2005 (ODF 1.0, OASIS); ISO/IEC 26300 since 2006 |
| Category | Documents |
| MIME type | application/vnd.oasis.opendocument.spreadsheet-template |
| Signature | 50 4B 03 04 ("PK" - standard ZIP local file header) |
Related viewers
Other free viewers for related formats.
Is my .OTS file uploaded anywhere?
No. Your .OTS file is opened for you.
Are formulas recalculated?
The viewer shows the values Excel or LibreOffice saved in the file, plus the formula behind each cell when you click it. It doesn't recalculate, so what you see is exactly what the author saw when saving.
Can I open a password-protected .OTS file?
Not yet. Files encrypted with a password to open are detected and reported; sheets that are only "protected against editing" open normally.
Why doesn't my chart or image show?
This viewer focuses on cell data: values, formulas, merged cells and fill colours. Charts, images and pivot table layouts are not drawn yet.
How big a file can I open?
Up to 50 MB. Large sheets are shown 500 rows at a time so your browser stays fast. Search still covers every row.
Was this tool helpful?
Your rating helps us decide which tools to improve next.