XML to Word fill

How to Convert XML to Word

XML Merge into Word & PDF templates

XML is one of the most widely-used formats for sharing structured information. Applications for XML are endless because of its simplicity and self-describing nature of data. Most of the databases and applications allow you to export data in XML format.

Many of us are familiar with mail merge - populate Excel data into word documents. How about merging XML to Word or PDF? XML is the universal standard for data interchange; Microsoft Word and PDF are the most popular document formats. Often times you find a need to populate XML file to Word or PDF document templates. Let me narrate my own experience.

 

Why convert XML to Word

Once I landed in a situation, where I had to fill a word template with an XML file to generate a document that was to be shared with vendors. The word document has corporate branding-Header, Footer, Logo etc. and contained around 15 dynamic fields. Over a period of time, the number of XML files I received per day started increasing. It reached 5-6 XML files per day, which translates to the manual filling of documents by cut-and-paste 5-6 times a day. You can imagine how frustrating and painful this tedious job is.

Then I started searching for software/tools to automate this task. Unfortunately, I couldn’t find a simple tool that addresses my requirement but only came across APIs, code samples, and libraries i.e. all geeky stuff. I used one of the libraries and did some coding to convert XML to Word.

I am sure some of you would have come across these situations with XML files in your day-to-day business.

  1. Your CRM allows you to export data in XML format and you want to export that data into your proposal template to create proposals real fast.
  2. You export data from your Database in XML format and want to export that into a Word document as per your company’s branding guidelines
  3. You receive a customer response in XML format and want to populate that data into a word template for companywide distribution.
Whatever be the scenario, converting XML to Word brings in a lot of productivity gains and reduce manual errors.

Start XML to WORD Population





XML to Word - Approaches

 

There are different approaches to achieve this. The most common approach is to employ IT team to build a tool for populating XML to Word document. This is an expensive option both from development and maintenance perspective.

Another familiar approach is “Save As” XML file as Word document to make it more readable and cut-and-paste that data that into a template. What an epic waste of time. You don't gain any productivity improvements with this approach.

DIY SAAS is the best approach but as I said before not many solutions are available.So we built EDocGen. EDocGen is DIY SAAS software for populating XML to Word document built for business users and sysadmins.

 

Why EDocGen

If you are looking for a DIY system to generate documents from XML data then possibly EDocGen is the only solution. With intutive interface, you can map dynamic fields of document to XML data thus controlling the the data you wish to show on your document.

It supports dynamic population of text, tables, content blocks, hyperlinks and images from XML data. It also supports multi-lingual templates, conditional statements (if-else), and calculations.

EDocGen is the perfect solution to auto-fill XML file to Word template.

Ease of Template creation: Business uses use existing document templates to auto-generate documents. It doesn't force users to switch to system's templates/formats. Business users can convert existing document into template just by adding few tags into their word document template. Then populate these templates with XML data to generate documents.

Top notch performance: Generate thousands in few seconds to few minutes depending on the complexity of template

Four level XML: Supports population of upto 4-level XML into word template

EDocGen supports both on-demand and bulk document generation. Following sections describe how to convert XML to Word using EDocGen.

There are two ways to populate XML file to Word using EDocGen - Through App UI and API.


App UI - XML to Word Documents

Step1:

EDocGen supports dynamic population text, tables, hyperlinks, images, text areas, and content blocks into template. So first step is to add relevant tags to dynamic fields. EDocGen uses these tags to identify the dynamic sections of the template. After this, upload template into EDocGen.

 

Step2:

After upload, you can see your template in EDocGen. Hover over document template and click “Create Document” action button. This opens a screen and in the drop-down select “generate documents from XML". Upload XML and map XML elements to template's dynamic fields. Clicking on generate button creates bulk documents in zip format in output folder.

XML to Word Document Generation

Optimization


As you can see, you can use your existing XML without any data transformation for XML to Word document creation. Mapping screen allows for population of any valid XML file into the template, using . If you use the same XML file format, again and again, mapping it every time is time-consuming particularly if you have a large number of dynamic fields in your template.

If node names matches with template's dynamic fields, EDocGen automatically maps them. So you can skip the mapping screen and click generate button to create documents. So you adjust either the template or XML accordingly to match dynamic tag names to XML nodes.

Please refer to working example for a detailed account of how to go about excel to word document population.


API - XML file to Word Document Generation

EDocGen is API first product and supports population of nested tables for up to 4-level XML files.


H1

H2

H3

H4

{#table1}{#table2}{#table3}{#table4}{t41}

{t42}

{t43}

{t44}{/}{/}{/}{/}


It's Windows OpenXML based API that supports filling of dynamic text, tables, content blocks, hyperlinks and images in word templates with XML data. The process is very similar to above. In Step1, add relevant dynamic tags to your template. In step2, upload the template into EDocGen through API. In step3, call API function by passing template ID and XML file.



Whether you are creating single document or multiple documents, EDocGen is the best solution for converting XML file to Word. Register and start populating your XML data into Word template.

Give it a try by registering. Trail is better than reading 1000 words.

Popular Posts

Auto Fill JSON to Word

Posted by admin

JSON because of its lightweight is fast becoming the de-facto standard for data-interchange

NextGen Document Generator

Posted by admin

Will you ever fill a document manually, if there is a choice to use a system/tool that

How to export Excel to Word

Posted by admin

Almost every business user at some point in time would have copied data from excel to word