How to Convert Open Office Spreadsheet to Excel

The Open Office suite of software programs can be used to open and create documents such as word processing documents and spreadsheet documents. Spreadsheets that are created using the Open Office software will be saved as ".ods" documents and can only be opened and edited using Open Office. In order to edit Open Office spreadsheets using Microsoft Excel, you will need to convert the spreadsheet into an Excel document using the Open Office Calc program.

Things You'll Need

• Open Office Calc

Instructions

1. Open the Open Office Calc program.

2. Click "File" at the top of Open Office Calc.

3. Choose "Open."

4. Select the Open Office spreadsheet document and click "Open." The Excel document will open.

5. Click "File" again.

6. Select "Save As." A window will open.

7. Click on the "Save as type" drop box inside the open window.

8. Choose one of the "Microsoft Excel" options. The option that you select will vary based upon which version of Microsoft Excel you are going to use to open the document (such as Excel 95 or Excel XP).

9. Click "Save" and the Open Office spreadsheet will be converted to Excel.

References

• Open Office