Anyfile is in beta, so a few things may not work perfectly yet. Tell us what you find

OpenDocument spreadsheet template

Open and edit OTS files

You can open, view and edit OTS files for free right here in your browser, without LibreOffice Calc and without uploading anything. An OpenDocument template for spreadsheets. Opening it in LibreOffice gives a fresh untitled sheet, while the original keeps its formulas and styles for next time.

Files are converted in your browser and never uploaded. By using Anyfile you agree to the Terms of Use.

View an OTS file without LibreOffice Calc

Open and viewYes
EditYes
Create a new oneNot yet
Save as OTSYes, keeping what Anyfile doesn’t show
FormatBy OASIS, since 2005

Edit OTS files

A grid that scrolls through any number of rows, with a formula bar and in-cell editing; about 200 of Excel’s functions worked out as you type (one Anyfile doesn’t have keeps the value saved in the file, and says so); number formats including Excel’s own codes, fonts, fills, borders, alignment, wrap and merges; the fill handle; copy and paste with Excel and Google Sheets; rows and columns inserted and deleted with references kept right; sort, filter, find and replace, AutoSum, frozen panes and sheet tabs. Unchanged sheets are saved exactly as they were; a changed sheet keeps its cells, styles, merges, sizes and charts, but its conditional formats and validation aren’t carried over yet. Pictures aren’t shown. Saved as a template, or as XLSX, ODS, CSV or TSV.

More about the spreadsheet editor

.ots

OpenDocument spreadsheet templateOpenDocument Spreadsheet Template

An OpenDocument template for spreadsheets. Opening it in LibreOffice gives a fresh untitled sheet, while the original keeps its formulas and styles for next time.

Repeat layouts in LibreOffice, like expense sheets or staff rotas.

Opens in LibreOffice Calc, Apache OpenOffice Calc

Questions

How do I open an OTS file without LibreOffice Calc?

Drop it on this page, or choose it. It opens in Anyfile’s spreadsheet editor right in your browser, with nothing to install and no account.

Can I edit an OTS file online for free?

Yes. A grid that scrolls through any number of rows, with a formula bar and in-cell editing; about 200 of Excel’s functions worked out as you type (one Anyfile doesn’t have keeps the value saved in the file, and says so); number formats including Excel’s own codes, fonts, fills, borders, alignment, wrap and merges; the fill handle; copy and paste with Excel and Google Sheets; rows and columns inserted and deleted with references kept right; sort, filter, find and replace, AutoSum, frozen panes and sheet tabs.

What can I convert an OTS file to?

XLSX, ODS, CSV, TSV, or a ZIP. Drop it here and choose.

Are the formulas kept?

Yes. They’re worked out as you type and saved as formulas. A function Anyfile doesn’t have keeps the value saved in the file.

Is my OTS file uploaded?

No. It opens, changes and saves on your device. Nothing is sent to a server.