At the request of your employer, you have created a spreadsheet to share with all your colleagues to manage the vacation organization. Not being able to complete the creation of the report during working hours, you put the file in your USB stick but when you went to open it from your home computer, you realized that it was in ODS format (instead of the classic Excel format) and you were unable to open it. Is this actually the case and now you fear having to redo everything from scratch? So relax and let me help you solve your problem.
If you give me a few minutes of your free time, I can point you out how to open ODS file using some of the programs that allow viewing and editing. In addition, I will propose some alternative solutions to open a file in ODS format without having to install any software on the PC: you must know, in fact, that there are free online services that allow you to open ODS files from any computer. Finally, you will also find a list of applications for smartphones and tablets in case you want to have access to your ODS files anytime, wherever you are. Interesting, right?
If you can't wait to learn more, all you have to do is make yourself comfortable, take five minutes of free time and read the next paragraphs. Identify the solution that best suits your needs, try to put into practice the instructions I'm about to give you and I'm sure you will be able to open ODS files in no time. All I have to do is wish you happy reading and wish you a big good luck for everything!
Programs to Open ODS Files
Among the solutions you can rely on for open ODS files, there are programs to install on your computer, which allow you to both open spreadsheets in ODS format and make changes to them. Here are some of the most interesting.
LibreOffice is a free and open source productivity suite that allows you to create text documents, presentations and databases. Among the applications included in the suite there is also Calc which allows you to create spreadsheets and open files in a variety of formats, includingODS.
If you think LibreOffice is the solution that best suits your needs, connected to the official website of the program, click on the button Download now and, in the new open page, presses the button Download version [version]. If you are using a Mac, you must also click on the button Translated user interface, to download the language pack needed to translate LibreOffice into Italian (which, on the other hand, is included “as standard” in the Windows version of the software).
Download completed, if you have a PC Windows, double-click the file LibreOffice_ [version] .msi, pigia sul pulsating Run and click sui pulsnti forward (for two consecutive times) e Install. Wait, then, for the installation to finish and press the button end to close the window.
I invented a Poppy, double-click the file LibreOffice_ [version] _MacOS.dmg, drag LibreOffice in the folder Applications macOS and open the latter. Then right-click on the program icon and, at the first start, select the item apri from the menu that appears to avoid macOS restrictions for applications from non-certified developers.
After starting LibreOffice for the first time on Mac, close it (by pressing cmd + q), then open the dmg package of the Italian language pack, right click on the executable LibreOffice Language Pack and start the latter by choosing the item apri from the context menu. In the window that is shown to you, click on the buttons apri e Install, select the voice /Applications/LibreOffice.app and click again on Install. Then click on Yes, identify me, type the password Mac administration tool and click OK twice in a row to complete the language pack installation.
Now you can open your ODS file with LibreOffice Calc. To do this, double-click on the file to open and it will automatically start with Calc. If not, associate opening ODS files with LibreOffice: su PC Windows, right click on a file in ODS format, select the entry Property from the menu that appears and presses the button Change related to the item Open with, then select LibreOffice e pigia sui pulsnti OK e Apply; if you use a Poppy, right click on the ODS file, select the option Get information and expand the entry Open with, then select LibreOffice from the drop-down menu that appears next to the item Open with And that's it.
Microsoft Excel (Windows/macOS)
Microsoft Excel is another solution to open an ODS file from a computer. The popular program for creating and editing spreadsheets is included in Microsoft's Office suite.
If Microsoft Office is already installed on your computer, you can open an ODS file by double-clicking its icon. In case of problems, right click on the ODS file, select the entry Property on Windows PC e Get information on Mac and make sure next to the option Open with Microsoft Excel is set, otherwise proceed to select it. Alternatively, you can right click on the file and select the entries Open with> Microsoft Excel give the menu check if you press.
If, on the other hand, you don't have Microsoft Office on your computer, you can buy it by connecting to the Microsoft Office store or any electronics store. In case you want to test its features first, you can download the 30-day free trial version by activating Office 365 Home, a subscription plan (available as a free trial for one month) that allows you to use all Microsoft Office applications and take advantage of other features and services without any obligation to renew.
To download Microsoft Excel to your computer, connect to the Office website and click the button try free present in the box relating to Office 365 Home, dopodiché pigia sul pulsnte Try free for 1 month and enter your Microsoft account login information. If you don't have one yet, you can read my guide on how to create a Microsoft account.
On the newly opened page, click the button forward, choose a payment method from credit or debit card, direct debit o PayPal and enter the data, then enter your billing information and press the buttons forward, Save e Subscribe. Now, click the button Install two consecutive times to start the Office download.
Download completed, if you have a PC Windows double-click on the file you just downloaded to start the automatic installation of Office, while if you use a Poppy double-click the file Microsoft_Office_ [version] _Installer.pkg, pigia sul pulsating Continue twice in a row and click the buttons Accept e Install. Then enter the password of your user account on macOS to start the installation and wait for it to complete. To learn more, you can read my guide on how to download Office for free.
When you first start Excel, click the buttons Start e Log in, enter the login credentials to your Microsoft account, wait for the free trial to be activated and press the button Get started with Excel. To open an ODS file, click on the entries Fillet e apri and select the file to open or simply double-click on the ODS file of your interest.
You should know that by activating the free trial at Office 365 Home, you have also activated the automatic renewal (10 euros / month). To avoid unwanted charges at the end of the free trial, connect to the Office website, log in with your account and click on your photo at the top right, then select the item My Account, click the option Manage and select the item Office 365 Home present under the option Subscriptions affected.
On the newly opened page, click the option Manage, select the voice Modification present next to the option Recurring billing and select the item Turn off recurring billing, dopodiché pigia sul pulsnte Confirm cancellation to deactivate the automatic renewal of the subscription and that's it.
Open ODS Files Online
It was preferred open ODS files online without having to install new programs on your computer, you must know that you can rely on one of the online services that allow you to open, view and edit the content of ODS files directly from the browser: here are some of the most interesting.
The first solution to open an ODS file online that you can consider is Excel Online, the free online version of Microsoft Excel, which allows you to create new spreadsheets and upload those on your computer.
To access Excel Online, go to the Office website and click the button Log in, then enter your Microsoft account login information in the fields Email, Skype Phone e Password e pulsing sul pulsating Log in.
If, however, you do not yet have a Microsoft account, click on the item Click here to create one, enter an email address in the field [email protected] e pulsing sul pulsating Log in, then enter a password in the appropriate field and presses the button again forward. On the newly opened page, enter your details in the fields Name e Surname and continue with the guided registration.
After logging into Office Online, click on the icon Excel present under the heading App and, in the newly opened page, select the item Upload a new workbook to upload the ODS file on your computer. Wait, then, for the file to load and that's it.
As you can understand from the warning message above, editing the ODS file with Excel Online may cause incompatibility problems, such as formatting differences.
Google Drive is another solution to open ODS files online. By logging into Google's cloud storage service with your account, you can create and share new calculation files, text documents, presentations and much more. In addition, the service allows you to upload files directly from your computer.
To open an ODS file with Google Sheets, connect to the Google Drive site and click the button Go your Google Drive: if you are already logged in to your Google account, access to the service is automatic, otherwise select yours Google account, enter the password and click sul pulsating forward to log in. If, on the other hand, you don't have an account yet, you can read my guide on how to create Google accounts.
Now, press the button New present at the top left and select the option Cartoon of file from the menu that appears, then select the ODS file to open, wait for the upload and double-click on fillet just loaded to open it. If you need to make changes, press the button Open with Google Sheets at the top to switch to file editing mode.
App to Open ODS Files
If your intention is to view an ODS file from your smartphone and tablet, you should know that there are several applications that allow both the reading of the files and the modification and creation of new spreadsheets. Here is a list of app to open ODS files that you can take into consideration.
- AndrOpen Office (Android): is a faithful port of OpenOffice for Android. It has the same interface and functions as OpenOffice for computers, allowing you to view, edit and create text documents, spreadsheets, presentations and more. It is available for free, but also in a Professional Pack version at a cost of 4,49 euros.
- Microsoft Excel (Android/iOS/Windows 10 Mobile): is the official Microsoft Excel application which, unlike what many think, is completely free. It allows you to create, view, share and edit spreadsheets, even those in ODS format.
- Google Sheets (Android / iOS): is the mobile version of Google Sheets. It allows you to both create new spreadsheets and open those uploaded to Google Drive, the famous Google service dedicated to text documents, spreadsheets, presentations, etc.
- OOReader (Android/iOS): is a free application that allows you to open files in XLS, XLSX, ODT, RTF, POT, PPT, ODS and many more formats. Unlike the applications mentioned above, it does not allow you to make changes and create new files.