How to open the ODS file to Excel. What is the ODS file extension? Opening on android

ODS is a popular spreadsheet format. It can be said that this is a kind of competitor to Exelev's XLS and XLSX formats. In addition, ODS, in contrast to the above analogs, is an open format, that is, it can be used for free and without restrictions. Nevertheless, it also happens that the document with the extension of ODS needs to be discovered in Excel. Let's find out how it can be done.

OpenDocument Spreadsheet (ODS) developed by the Oasis community, with its creation, was meant as a free and free analogue of Excel formats. He saw him in 2006. Currently, ODS is one of the main formats of a number of tabular processors, including popular free app OpenOffice Calc.. But with Excel this format "Friendship" naturally did not work out, as they are natural competitors. If you open documents in ODS Excel format standard means able, the possibility of saving an object with such an extension microsoft. refused to introduce into his brainchild.

The reasons to open ODS format in Excel can be set. For example, on a computer where you need to start the spreadsheet, it simply may not be an OpenOffice Calc application or another analog, but a package will be installed Microsoft Office.. It can also happen that the table should be carried out by the tools that are available only in Excel. In addition, some users among the set of table processors captured the skills of working at the proper level only with Excel. That's when it becomes actual question Opening a document in this program.

Opened format in versions of Excel, starting with Excel 2010, quite simple. The launch procedure is not much different from the opening of any other tabular document In this application, including objects with the expansion of XLS and XLSX. Although there are nuances here, in which we will focus in detail below. But in more early versions of this tableware processor The discovery procedure is significantly different. This is due to the fact that ODS format appeared only in 2006. Microsoft developers the ability to start this type of documents for Excel 2007 had to be implemented almost in parallel with its development of the OASIS community. For Excel 2003 I had to produce a separate plugin altogether, since this version It was created long before the release of ODS format.

However, even in new versions, Excel does not always manage to display the indicated spreadsheets correctly and without loss. Sometimes, when using formatting, not all items can be imported and the application has to restore data with loss. In the event of problems, the corresponding information message appears. But, as a rule, it does not affect the integrity of the data in the table.

Let's first focus in detail at the opening of ODS in actual versions Excel, and then briefly describe how this procedure occurs in older.

Method 1: Run through the opening window

First of all, we will focus on the launch of ODS through the window opening window. This procedure is very similar to the opening procedure of XLS or XLSX format, but has one small, but significant difference.

Method 2: Running Double Click Mouse Button

Moreover, standard option The opening of the file is its launch of the left mouse button on the name. In the same way, you can open ODS to Excel.

If the computer is not installed on the computer, the OpenOffice Calc application is installed and you did not reassign another program ODS Opening the default format, then with the launch in this way in Excel will not be there any problems. The file will open, as Excel recognizes it as a table. But if the OpenOffice office package is installed on the PC, then when you double click the mouse button on the file, it will start in Calc, and not in Excel. In order to start running in Excel, you will have to spend some manipulations.

But the method described above is suitable only for one-time opening of the object. If you plan to constantly open ODS documents to Excel, and not in other applications, that is, it makes sense to do this application The default program to work with the files with the specified extension. After that, it will not be necessary to open additional manipulations for opening the document, and it will be enough to double-click the left mouse button on the desired object with the ODS extension.

There is another option to assign an Excel default application to open objects with the ODS extension. This option is more complicated, but, nevertheless, there are users who prefer to enjoy it.

Click on the button "Start" Windows located in the lower left corner of the screen. In the menu that opens, select the item "Default Programs".

If in the menu "Start" You will not detect this item, select the position "Control Panel".

In the window that opens Control panels Go to section "Programs".

In the next window, choose the subsection "Default Programs".

After that, the same window starts, which will open if we clicked on item "Default Programs" directly in the menu "Start". Choose a position .

Window starts "Mapping file types or protocols to specific programs". In the list of all file extensions that are registered in system Registry Your copy instance, looking for the name ".Ods". After you find it, we allocate this name. Next click on the button "Change the program ..."which is located on the right side of the window, on top of the extension list.

Again opens a familiar window to choose an application. Here you also need to click on the name « Microsoft Excel.» and then click on the button OkAs we did in the previous version.

But in some cases, you can not detect "Microsoft Excel" In the list of recommended applications. This is especially likely if you use the old versions of this program, which have not yet provided an Association with ODS files. It can also happen because of the failure in the system or due to the fact that someone has been forcibly deleted Excel from the list of recommended documents for documents with the extension of ODS. In this case, in the application selection window, click on the button. "Overview…".

After completing the last action, the window starts "To open with…". It opens in the program location folder on the computer ( "Program Files"). You need to go to the directory of the location of the file that runs Excel. To do this, move to the folder called "Microsoft Office".

After that, in the opened directory you need to select a directory that contains the name "Office" And version number office package. For example, for Excel 2010 - it will be the name "Office14". As a rule, only one office package from Microsoft is installed on the computer. Therefore, simply select the folder that contains the word in your title. "Office"and click on the button "Open".

In the opened directory looking for a file called "Excel.exe". If there is no shown of extensions in your Windows, it may be called "Excel". This is the launch file of the application of the same name. We highlight it and click on the button "Open".

After that, we return to the program selection window. Even earlier among the list of names of the names "Microsoft Excel" There was no, now it will definitely appear. Highlight it and clay on the button Ok.

After that, the file types of mapping window will be updated.

As you can see in the File Type Mapping window, now documents with the default ODS extension will be associated with Excel. That is, with double clicking on the icon this file The left mouse button, it will automatically be opened in Excel. We just have to complete the work in the file types by clicking on the button. "Close".

Method 3: Opening ODS format in old versions of Excel

And now, as promised, briefly focus on the nuances of the opening of ODS format in the old versions of Excel, in particular in Excel 2007, 2003.

In Excel 2007 two options for opening a document with the specified extension:

via the program interface;
through clicking on its icon.

The first option, in fact, is no different from the similar way to open in Excel 2010 and in later versions we described a little higher. But in the second version will dwell in more detail.

Go to the tab "Add-in". Select item "Import file in ODF format". You can also perform the same procedure through the menu. "File"By choosing a position "Imports of the spreadsheet in ODF format".
When performing any of these options, the import window is launched. It should select the object you need with the ODS extension, highlight it and click on the button. "Open". After that, the document will be launched.

In Excel 2003, everything is much more complicated, as this version came out earlier than the ODS format was developed. Because the documents with this expansion are required to install the Sun ODF plugin. Installation of the specified plugin is performed in normal mode.

After installing the plugin, the panel called "Sun Odf Plugin". On it will be placed button "Import file in ODF format". Click on it. Next need to click on the name "Import file ...".
Import window starts. It is required to highlight the desired document and click on the button. "Open". After that, it will be launched.

As you can see, the opening of the ODS format tables in the new versions of Excel (2010 and above) should not cause difficulties. If anyone has problems, this lesson will allow them to overcome them. Although, despite the simplicity of launch, it is not always possible to display in Excel this document Without loss. But B. outdated versions Programs Opening objects with specified expansion is associated with certain difficulties, up to the need to install a special plug-in.

Users who have skills to work with electronic documents Surely met different types files. But not many know that there are documents with the extension of ODS, and even more so how to use this format and how to open it.

What kind of format and why is used

The type of ODS file is a document, containing tables In the format "Open Document". Star Office and Open Office programs are used to create and generate files with such an extension. The extension was developed by the "Oasis" developer team, and has long been an international and recognized format that can be used without restrictions.

This extension is a replacement For all XLS and XLSX, which are used in Microsoft Office package applications. When saving in such a format, it is possible to get access to the source codeThis is the most important advantage of ODS format.

Opening in Excel

Open ODS file in Excel is easy enough. This will not arise problems in Excel versions since 2010. Sometimes, you need to download a special plugin to make the ability to view the ODS format files in EXEL 2003 and 2007 versions.

Guarantee integrity and correctness It is impossible to transmit content. There are cases of loss of some data, but, as a rule, it does not affect the integrity of the tables.

If a read error occurs, Excel is trying to fix them, after which the corresponding message is displayed.

Standard opening method

The easiest way is to open a file with the extension of ODS through microsoft program Excel:

Through "open with the help"

You can also use the "Open Usat" command, unless conformity is set:

Installing the default opening program

With frequent use of documents with the ODS extension, it will be useful to establish compliance with a specific application:

Old version

Excel 2007.

In this version of the program there are two ways to open:

Via program interface. This method It does not differ from what is used in MS Excel 2010 and above.
Click on icon.

The essence of the second way is to go to the tab " Superstructure", choose " Import in formatODF ». Next select the desired document of the ODS spreadsheets, highlight it and click on the button " Open”.

Excel 2003.

In the case of this version, everything is a bit more complicated, because the format appeared much later than the MS Office 2003 came out. For opening you need to download and install the plugin. Sun Odf.”:

When the installation procedure is completed, the panel will appear. Sun.ODF.Plugin.". Click on it, then go to item " Import file ...”.
The import window will start, in which it follows select the desired document And click "Open."

Opening on android

For owners of smartphones under android management An application "Andropen Office" was developed. This tool is one of the most popular platform editors. Google Play. MARKET. "Open Office" supports work with dozens of types of documents, including electronic ODS tables.

Also supports reading ODS. and other open formats microsoft documents Office, Adobe, etc.

Method of conversion

For the format conversion to the desired, it is enough to use the ODS online converter to XLS. If you correctly ask a search query, you can find tens of sites that will help convert ODS to the XLS table online.

One of these sites is Online Convert Free. With it, you can convert documents, archives, audio and video recordings, images and e-books.

You can open and save files in OpenDocument Spreadsheet (ODS) format, which is used by some electronic table editors, such as OpenOffice.org Calc and Google Docs.

Choose File > Open > A computer > Overview.

To view only the files saved in OpenDocument format, in the list of file types (next to the field File name) Select.

Find the file you want to open, and then click Open.

Note:

Important: If you need a version of the file for Excel, save it in a suitable format (for example, XLSX), and then save it again as the OpenDocument table.

In the list File type Select OpenDocument spreadsheet (* .ods).

Enter the file name and save it.

When opening or maintaining sheets in OpenDocument Spreadsheet format (ODS), formatting can be partially lost. This is caused by the fact that OpenDocument Spreadsheet and Excel applications support various features and parameters, such as formatting and table. For more information about differences between OpenDocument Spreadsheet and Excel Formats, see the difference between OpenDocument Spreadsheet formats and Excel (XLSX).

Tip:

Opening the OpenDocument Spreadsheet spreadsheet in Excel

Note: When opening the OpenDocument table in Excel, its formatting may differ from formatting in the application in which it was created. This is caused by differences between applications that use OpenDocument format.

Saving Excel File in OpenDocument Table format

For more information about OpenDocument format

When opening or maintaining sheets in the OpenDocument table format, some formatting parameters may be lost. This is due to various functions and parameters, such as formatting and tables that are supported in OpenDocument spreadsheet applications in Excel. For more information about the differences between the OpenDocument e-table and Excel format, see the difference in the OpenDocument (ODS) table format and Excel Online format (XLSX).

Tip: Before sending a file to another user, it is recommended to close the file and open it again to view how it looks in the OpenDocument Spreadsheet format (ODS). To compare Excel format with OpenDocument Spreadsheet format, first save the file to excel formatand then open excel version And the version of OpenDocument Spreadsheet, view the files and check them for differences.

ODS - open format spreadsheets based on Oasis. The document consists of columns, rows and cells, data is stored in XML. It also contains text, images, diagrams. Expansion completely freely, which means to open it absolutely in any program to work with the spreadsheets, besides the format is a direct alternative to the XLSX format, which is used in MS Excel starting from version 2007. However, since the ODS does not belong to Excel, then With him he will be bad, view and edit ODS best in his "native" programs that are unlike Excel are free.

Free programs that can open and edit.ods.

- Gnome Office is part of the GNOME Office, applies to free based. It can open most of the spreadsheet formats, including ODS. The editor has more than 214 unique features, which are no longer anywhere, and thanks to the open source code, you can add your own or edit the existing one.
- Free office package from which the extension extension .ods. The program has a pleasant and intuitive interface similar to MS Excel. Open source Allows you to change the functions of the program.
- Editor of spreadsheets from the free LibreOffice office package. It has a nice interface, many features, support extensive amounts of formats. You can also export a table in PDF.

The most common problem, due to which users cannot open this file, is an incorrectly assigned program. To fix it in Windows, you need to right-click on the file, in the context menu, bring the mouse to "Open Using" item, and select the Select Program item drop-down menu. As a result, you will see a list. installed programs On your computer, and you can choose the appropriate. We also recommend checking the box opposite the item "Use this application for all ODS files".

Another problem with which our users also occur quite often - the ODS file is damaged. Such a situation may arise in cases of cases. For example: the file was downloaded not fully as a result server errorsThe file was damaged initially, etc. To eliminate this problem, use one of the recommendations:

Try to find the desired file. In another source on the Internet. You may be lucky to find a more suitable version. Google search example: "file FileType: ODS". Just replace the word "file" to the name you need;
Ask to send you original file Once again, it may have been damaged during transmission;