How to Open an ODS in MS Office

Written by mara shannon
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Open an ODS in MS Office
(Jupiterimages/Polka Dot/Getty Images)

The file extension ODS stands for "OpenDocument Spreadsheet." The spreadsheet programs included with free office suites such as OpenOffice and StarOffice save spreadsheets in ODS format. You can install a program such as OpenOffice to open the ODS file or convert it online with a site such as Zamzar. If you don't want to bother with that, however, you can install a free plugin to open ODS and other OpenDocument files with Microsoft Office.

Skill level:

Things you need

  • Microsoft Office
  • OpenXML/ODF Translator Add-in for Office or Sun ODF Plugin

Show MoreHide


  1. 1

    Download OpenXML/ODF Translator Add-in for Office or Sun ODF Plugin (see Resources). Double-click the EXE file and follow the instructions to install.

  2. 2

    Open a blank spreadsheet in Microsoft Excel.

  3. 3

    Click the "File" menu or the Microsoft Office button (depending on your version of Microsoft Office), then click "Open." Under the "Files of type" menu, select "All files."

  4. 4

    Locate the ODS file and double-click it to open the file in Microsoft Excel.

Tips and warnings

  • You may want to save a copy of the spreadsheet in XLS or XLSX (Microsoft Office spreadsheet formats) in order to make it easier to open on other computers and with different programs. To save a copy of the ODS file in Microsoft Excel format, go to the "File" menu (or click the Microsoft Office button) and select "Save as." Under "Save as type," select "Microsoft Excel," then click "Save."

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.