JSON file to Word fill

Convert JSON file to Word

JSON Population into Word Template

JSON because of its lightweight is fast becoming the de-facto standard for data-interchange replacing fatty XML. Hence it is often used for serializing and transmitting structured data over a network.

Almost all databases including traditional databases - Oracle, MySQL, SQL Server and document databases such as MongoDB allow you to export data in JSON format. Creating mail merge with JSON as the data source for producing various business documents greatly enhance organization’s efficiencies.

Let’s take the case of HR operations. HR teams fill templates manually with Organization’s HRMS/ERP system data to generate an offer, experience, increments letters etc. Exporting employee data from ERP as JSON and populating templates with it saves HR team from tedious, expensive and error-prone manual documentation. Similarly, the sales team can auto-generate proposals and post-sales documents. Such automation benefits every department of the organization including Legal, Finance, Marketing. Moreover, business users can users can auto-generate documents on-demand without seeking IT support.

Start JSON to WORD Population





Why EDocGen for JSON to Word

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


JSON to Word

With EDocGen, you can populate JSON into

  1. Word templates to create Word documents
  2. Word templates to create PDF documents
  3. PDF templates to create Word documents
  4. PDF templates to create PDF documents

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


EDocGen is the perfect solution to auto-fill JSON 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 JSON data to generate documents.

Use JSON data as-is: You can populate the JSON data as-is without any data transformation. In the mapper screen (field map), map JSON data to dynamic fields. On this page all dynamic fields in your document template get listed along with drop downs of JSON keys. All you need to do is select the appropriate JSON key for each dynamic template field.

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

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

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

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

 

How To - JSON file to Word Document Generation

Step1:

The first step is to convert existing word document into EDocGen template. It's a very simple step.Just add the relevant dynamic tags for text, tables, images, text areas, and content blocks. EDocGen uses these tags to identify the dynamic sections of the template. After adding tags, upload template into EDocGen.

 

Step 2:

Hover over document template to see “Create Document” action button. Click on it and in the drop-down select “generate documents from JSON". Upload JSON and map JSON elements to template's dynamic fields. Click generate button to create documents.

JSON format temmplate

 

Optimization

As you can see, no JSON data transformation is required for JSON to Word document creation. You can use any JSON file format and populate that into the template, using mapping screen. If you use the same JSON file, again and again, mapping it every time is time-consuming particularly if you have a large number of dynamic fields in your template.

By modifying JSON keys in line with the template's dynamic fields, you can skip the mapping screen and auto-fill data. While creating JSON, have template's dynamic tag names as JSON keys.

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



API - JSON file to Word Document Generation

It's Windows OpenXML based API that supports filling of dynamic text, tables, content blocks, hyperlinks and images in word templates with JSON array 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 JSON file.



EDocGen is API first product and supports nested tables up to 4-level JSON files.


H1

H2

H3

H4

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

{t42}

{t43}

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



The corresponding JSON for this table population is

[{
	"table1": [{
		"table2": [{
			"table3": [{
				"table4": [{
					"t41": "t41data",
					"t42": "t42data",
					"t43": "t43data",
					"t44": "t44data"
				}]
			}]
		}]
	}]
}]


EDocGen is the simplest and fastest solution to convert JSON file to Word, online or through API. Moreover, it supports multi-lingual templates, conditional statements (if-else), and calculations. For example you can populate JSON data in French, Japanese, Spanish etc. to generate multi-lingual documents. Register and start populating your JSON data into Word template.

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

Popular Posts

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