OpenOffice Calc: Import XML file - how it works

When using OpenOffice Calc, tables can also be created by importing them into the program as an XML file. In this practical tip, we will show you how to do this.

Import XML files into OpenOffice Calc - you have to do that

Note: These instructions are based on OpenOffice Calc 4.1.1 under Windows 7.

1. Start OpenOffice Calc and click on "Open" under "File" above.
2. Set the file type on the right to "All files" and search for the desired XML file.
3. With "Open" the file is imported into Calc.
4. A new window now opens. The XML file is converted here, so it can be read by Calc.
5. Wait for the process to complete and confirm the conversion.
6. Any errors will be shown to you so that you can fix them.

We'll tell you the best Easter eggs in Calc in the next practical tip.