Exchanger XML Editor provides a number of ways to import from various external data sources including structured text files, Excel spreadsheets and database tables - see http://www.exchangerxml.com/editor/pdf/ImportA4.pdf
You may also be interested to know that Cladonia Limited, the publisher of Exchanger XML Editor, has released a free XML Editor for use in a non-commercial environment called Exchanger XML Lite.
The Lite edition is completely free for home, academic or non-profit use. No registration required, no 30-day usage limit.
Exchanger XML Lite is a Java-based product that provides comprehensive functionality for viewing, authoring and editing XML data and documents.
• Multi-document interface
• Comprehensive XSLT Debugger
• DTD, RelaxNG, XML Schema support
• XPath, XQuery, XSLT, XSL:FO, SVG, SOAP, WSDL
• Import from Database, Excel, text files
• XML Digital Signatures
• Generate schema from instance
• Generate instance from schema
• Emacs shortcuts
For more information visit http://www.freexmleditor.com
Alternatively, if you require a commercial license, or would like to try out the Grid or XML Diff/Merge functionality, then download the Exchanger XML Professional edition from http://www.exchangerxml.com
and register for a 30-day trial license.