How to Convert OpenOffice to Excel

This wikiHow teaches you how to save an OpenOffice Calc spreadsheet to the Microsoft Excel .xlsx format.

Method 1
Method 1 of 3:
Using Microsoft Excel for Windows

  1. Image titled Convert OpenOffice to Excel Step 1
    1
    Open Microsoft Excel. It’s in the All Apps area of the Start menu in Windows.
  2. Image titled Convert OpenOffice to Excel Step 2
    2
    Click Open Other Workbooks. It’s at the bottom of the left column.
  3. Image titled Convert OpenOffice to Excel Step 3
    3
    Click Browse.
  4. Image titled Convert OpenOffice to Excel Step 4
    4
    Navigate to the folder that contains the Calc file.
  5. Image titled Convert OpenOffice to Excel Step 5
    5
    Select All Files from the “File Type” drop-down. All files in the folder should now be displayed.
  6. Image titled Convert OpenOffice to Excel Step 6
    6
    Double-click the OpenOffice Calc file you want to convert. The contents of the spreadsheet will open in Excel.
  7. Image titled Convert OpenOffice to Excel Step 7
    7
    Click the File menu. It’s at the top-left corner of the screen.
  8. Image titled Convert OpenOffice to Excel Step 8
    8
    Click Save As. It’s in the left column.
  9. Image titled Convert OpenOffice to Excel Step 9
    9
    Select Strict Open XML Spreadsheet (.xlsx) Format.
  10. Image titled Convert OpenOffice to Excel Step 10
    10
    Click Save. The file is now saved as in the Microsoft Excel format.

Method 2
Method 2 of 3:
Using OpenOffice Calc for Windows or macOS

  1. Image titled Convert OpenOffice to Excel Step 11
    1
    Open the spreadsheet in OpenOffice Calc. Use this method if you have OpenOffice Calc on your PC or Mac.
  2. Image titled Convert OpenOffice to Excel Step 12
    2
    Click the File menu. It’s at the top-left corner of the screen.[1]
  3. Image titled Convert OpenOffice to Excel Step 13
    3
    Click Save As.
  4. Image titled Convert OpenOffice to Excel Step 14
    4
    Select Microsoft Excel 2007-2013 from the “Save as type” drop-down.
  5. Image titled Convert OpenOffice to Excel Step 15
    5
    Click Save. The file is now converted to the Microsoft Excel format.

Method 3
Method 3 of 3:
Using Google Sheets for Android, iPhone, or iPad

  1. Image titled Convert OpenOffice to Excel Step 16
    1
    Open Google Sheets on your phone or tablet. It’s the green icon with a white outline of a table.
    • If you don’t have this app, you can get it from the App Store or the Play Store.
  2. Image titled Convert OpenOffice to Excel Step 17
    2
    Tap the file you want to convert. This opens the spreadsheet in Google Sheets.
  3. Image titled Convert OpenOffice to Excel Step 18
    3
    Tap ⁝.
  4. Image titled Convert OpenOffice to Excel Step 19
    4
    Tap Share & export.
  5. Image titled Convert OpenOffice to Excel Step 20
    5
    Tap Save as Excel. This file is now saved as a Microsoft Excel spreadsheet.

You Might Also Like

How to
Unhide Rows in Excel
Create a Mortgage Calculator With Microsoft Excel
How to
Create a Mortgage Calculator With Microsoft Excel
Change from Lowercase to Uppercase in Excel
How to
Change from Lowercase to Uppercase in Excel
Unprotect an Excel Sheet
How to
Unprotect an Excel Sheet
Make a Spreadsheet in Excel
How to
Make a Spreadsheet in Excel
Create a Graph in Excel
How to
Create a Graph in Excel
Open a Password Protected Excel File
How to
Open a Password Protected Excel File
Convert Notepad to Excel
How to
Convert Notepad to Excel
Download Microsoft Excel
How to
Download Microsoft Excel
Link Sheets in Excel
How to
Link Sheets in Excel
Create a Drop Down List in Excel
How to
Create a Drop Down List in Excel
Add Links in Excel
How to
Add Links in Excel
Convert Excel to Word
How to
Convert Excel to Word
Run a Multiple Regression in Excel
How to
Run a Multiple Regression in Excel

References

  1. ↑ http://smallbusiness.chron.com/convert-openoffice-excel-54096.html

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
Tech Specialist
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 16,046 times.
How helpful is this?
Co-authors: 6
Updated: August 27, 2020
Views: 16,046
Categories: Microsoft Excel