What is OTS? What is OTS? OTS is used as the file extension for spreadsheet files saved in OpenDocument Spreadsheet Template format. .OTS files are binary files that can be opened by Apache OpenOffice or Microsoft Office. Try with the sample .OTS file included below.

File Extension: .OTS

MIME Type: oasis.opendocument.spreadsheet

File Content: Spreadsheet Template

.OTS files are spreadsheet template files saved in OpenDocument Spreadsheet Template format. Here are the first 128 bytes of a sample .OTS file dumped in HEX values:

50 4b 03 04 14 00 00 08 00 00 59 bf 5d 47 7b 96 PK........Y..G..
a3 4e 37 00 00 00 37 00 00 00 08 00 00 00 6d 69 .N7...7.......mi
6d 65 74 79 70 65 61 70 70 6c 69 63 61 74 69 6f metypeapplicatio
6e 2f 76 6e 64 2e 6f 61 73 69 73 2e 6f 70 65 6e n.vnd.oasis.open
64 6f 63 75 6d 65 6e 74 2e 73 70 72 65 61 64 73 document.spreads
68 65 65 74 2d 74 65 6d 70 6c 61 74 65 50 4b 03 heet.templatePK.
04 14 00 00 08 00 00 59 bf 5d 47 00 00 00 00 00 .......Y..G.....
00 00 00 00 00 00 00 1a 00 00 00 43 6f 6e 66 69 ...........Confi

.OTS files are actually ZIP files. See the ZIP identifier "PK" in the above HEX dump. When an .OTS file is extracted by a ZIP tool, you will see these files and folers:

<DIR>          Configurations2
         4,242 content.xml
<DIR>          META-INF
           986 meta.xml
            55 mimetype
             0 out.txt
         7,136 settings.xml
         6,908 styles.xml
<DIR>          Thumbnails
6 File(s)         19,327 bytes

 Directory of \Configurations2
<DIR>          accelerator
<DIR>          floater
<DIR>          images
<DIR>          menubar
<DIR>          popupmenu
<DIR>          progressbar
<DIR>          statusbar
<DIR>          toolbar
0 File(s)              0 bytes

 Directory of \Configurations2\accelerator

             0 current.xml
1 File(s)              0 bytes

 Directory of \Configurations2\floater

0 File(s)              0 bytes

 Directory of \Configurations2\images
<DIR>          Bitmaps
0 File(s)              0 bytes

 Directory of \Configurations2\images\Bitmaps
0 File(s)              0 bytes

 Directory of \Configurations2\menubar
0 File(s)              0 bytes

 Directory of \Configurations2\popupmenu
0 File(s)              0 bytes

 Directory of \Configurations2\progressbar
0 File(s)              0 bytes

 Directory of \Configurations2\statusbar
0 File(s)              0 bytes

 Directory of \Configurations2\toolbar
0 File(s)              0 bytes

 Directory of \META-INF
         1,905 manifest.xml
1 File(s)          1,905 bytes

 Directory of \Thumbnails
         1,128 thumbnail.png
1 File(s)          1,128 bytes

     Total Files Listed:
9 File(s)         22,360 bytes

.OTS OpenDocument Spreadsheet file sample: Click sample.ots to download.

.OTS OpenDocument Spreadsheet Template files can be created and moodsied by these software:

• Apache OpenOffice - Opens and creates .OTS OpenDocument Spreadsheet files
• Microsoft Excel 2010 - Opens and creates .OTS OpenDocument Spreadsheet files