Import from Databases, Text Files, and Microsoft Excel Sheets

oXygen offers you support for importing database data, MS Excel files and text files into XML documents, that can be further converted into other formats using the Transform features.

Connection and Table Selection Dialog

You can examine the database contents and select the table to be exported using the database browser. It is possible to refine the data source by editing the generated SQL select statement to suit your needs. You can join multiple tables or use advanced SQL expressions. You also have the possibility to generate an XML Schema from the database structure.

The Import Dialog

Mapping of the database fields as elements or attributes is very simple and you can change easily the names used in the XML file. A preview of the first rows in the SQL result and of the generated XML document is available. If the preview shows what is expected, you can choose to open the imported data directly into the editor and/or to save it to a file.

Fields Map Dialog

You have the possibility of importing data from Excel and text documents.

Import Excel File

The Import dialog box allows you to choose what sheets of the document you want to import. This dialog also displays the content of an Excel document in a tabular form, a preview of the generated XML document and provides options that allow you to customize the output.

Video Tutorials
Upcoming Events
oXygen-Users Meetup London 2015
oXygen-Users Meetup
June 5, 2015
London, UK
" oXygen XML Editor is the premier text editor for XML geeks, and an indispensable tool for O'Reilly's Production group. My team uses oXygen XML Editor for everything from simple XML editing to Schema validation and XSLT transformations. The digital production staff especially loves oXygen's built-in EPUB support, which eliminates a great deal of the grunt work that is usually entailed in editing EPUB files. The more we use oXygen, the more realize what a powerful tool it can be in digital and XML-based workflows."
Adam Witwer
Director of Content and Publishing Operations
O'Reilly Media