Tuesday, March 22, 2011

How to Export OpenOffice Calc to XML


1. Open your Calc spreadsheet in OpenOffice.org's Calc program.
2. Click 'File' in the top menu and select 'Save As'. Alternatively, hold the 'Ctrl' and 'Shift' keys down and press 'S'.
3. Click the drop-down menu next to 'Save as type' and select 'Microsoft Excel 2003 XML (xml)'.
4. Enter a new name for your spreadsheet if one is not automatically chosen. If you previously saved this document the original file name is filled in. You can use this file name without overwriting the original file, since the extension will be different.
5. Click 'Save' to export your Calc spreadsheet in XML format.

Blogger news