Exwog - from Excel to Word reports generator by template

Free generator of Word files by template (Word file) on the basis of the Excel data file


Exwog screenshot

Work on Mac OS, Windows and Linux

Allows to set names of new generated word files

Allows to set sheets and rows of needed data

Allows to set framing characters for the names of Excel columns

Easy in use


Store your data in Excel format (.xls and .xlsx) and generate Word format files (.doc and .docx) in a few clicks:)


Download


How does it work?


1

Take a look at your excel file


In this example excel-file contains customers information. Each line corresponds to a specific customer. The names are arranged in the column A, surnames in column B and professions in column C.

Excel file

Click to view




2

Create word document (.doc or .docx)


Word file

Click to view

Create a "template" (word-file) for the formation of new documents (word-files). Here the "template" text contains the excel-file column names, framed by curly brackets: {A}, {B} and {C}.

The program will generate a new documents by "template" replacing all {A}, {B} and {C} by corresponding values of cells from excel-file: {A} - name, {B} - surname, {C} - profession.

You can also set your framing symbols on the Settings tab of the program.




3

Select paths for files and folders


Select a paths for the files and folders (buttons labeled Select). In the program you specify the following paths:

Excel file with data (*.xls, *.xlsx) - this is the path to your excel-file data (information about customers);

Word template file (*.doc, *.docx) - this is the path to your "template" (word-file created at the previous step);

Folder to save the new word files - this is the path to the folder where the program will save new generated documents.

Exwog - from Excel to Word reports generator by template

Click to view




4

Set sheets and rows of needed data


Exwog - from Excel to Word documents generator by template

Click to view

Set numbers of sheets and rows of your excel-file data (customers information) by which you want to create documents:

Excel file data sheets - numbers of your excel-file sheets which will participate in the formation of new documents;

Excel file data rows - numbers of lines of sheets (sheets, specified in the Excel file data sheets) of your excel-file that will be involved in the formation of new documents. Separate document (word-file) will be created on the basis of the data of each of the specified row.

The numbering of sheets and rows in a program begins with a 1.

If you want to the formation of the document was attended by all the sheets and/or rows of your excel-file with data - on the right click on the corresponding button labeled Numbers (and its label will change to All).




5

Set new word files names template


Set a new word files names template:

New word files names template - is the names template for the new documents generated by the program (word-file). Here the names template contains the excel-file column names, framed by curly brackets: {A} and {B}.When forming a new document program will replace all {A} and {B} by corresponding values of cells from excel-file - this will be the name of a new document (word-file).

You can set your framing characters on the Settings tab of the program.

Exwog - from Excel to Word files generator by template

Click to view




6

Click "Generate"


Exwog - documents generator by template

Click to view

Click Generate button, and the progress of execution will be displayed. Docs (word-files) will be created as much, as rows of excel-file is involved in the formation.




7

Thats all


All documents (word-files) are created and situated in the folder specified in the Folder to save the new word files. Thats all:)

Word files

Click to view