Automated creation of documents and population of tables

For a globally active Chemical Group with decades of experience, lexoro developed a solution that automatically creates documents and reports for the registration, compliance and other processes. By using classic automation, the tedious collection of data & information and the filling of templates could be accelerated with a high degree of automation and thus high potentials of time savings.

The challenge

Since many reports showed a high page count with several chapters that have to be manually processed, highly-qualified employees were forced to focus a lot of their capacities on these tedious tasks. The challenge: saving these top experts time and therefore the company money by either fully automating classic routine tasks and partially automating more complex and intelligent tasks.

The problem

  • Very high time expenditure
  • Manual compilation of all relevant information from other documents and internal systems
  • Text and table generation and population of diverse reports, documents and tables
  • Distributing relevant content into proper chapters and tables


Our customer is a globally active Chemical Group with decades of experience. By offering all kinds of products, substances and chemicals throughout various industry and supply chains, this company is a true innovator in digitization and sustainability.

The solution: Automated creation of documents and population of tables

For the automated generation and population of reports, dossiers, documents, tables and more, lexoro has automated the conversion of relevant information from internal systems and sources into the respective target document.

Thanks to the RPA, NLP and NLG technology implemented by lexoro, the client could benefit from time saving or automation level of about 70% and top experts can focus on other topics.

The process

Using Robotic Process Automation RPA technology a software robot automatically copies the relevant data, texts and tables from in-house systems and sources. Using Natural Language Processing (NLP), necessary texts or text elements are modified and rewritten, e.g., tenses (present/future tense in past tense) are adapted and codes with the final terminology in the text are replaced. Relevant tables are automatically evaluated & summarized for the respective chapter. Based on the contents of the tables, appropriate descriptive texts can be generated using Natural Language Generation (NLG). Finally the Chemical reports or documents with populated tables for further manual processing and adjustment are generated and exported.

12345lexoro AutomationSelection of templatesCopying data &information fromin-house systems& textsData preparation & SupplementationFilling of thetemplate or thetables with therelevant dataGeneration ofthe report or documentAutomated copying & filling of relevant data, texts & tables into Chemical reports and documents

1Selection of the template

Manual selection of the required template or the chapter or table to be created.

2Copying of text & tables

Software robot automatically copies the relevant data, texts & tables from internal company systems, which have been collected and created in advance.

3Modifying & adaption of text and text elements

With the help of Natural Language Processing, necessary texts or text elements are prepared, supplemented & analyzed - e.g. adjustment of tenses (present/future tense in past tense) and replacement of codes with the final terminology in the text

4Populating the template or the tables with the relevant data

Fully automatic filling of the defined templates & tables with relevant data in the designated chapters Typical use cases: chemical safety reports, review report, substitution plan, socio-economic analysis, etc.

5Generating the report or document

Final generation & export of the report or a report with completed tables for further manual processing & review.

The benefits for the customer

Reduction of tedious data collection processes and increase of quality standards through 100% error-free RPA technology
  • Automatic document creation with data preparation – approx. 70% time saving
  • 100% error-free RPA technology with support of AI – individually tailored to you
  • Standardization of workflow – ECHA-compliant creation of reports & tables
  • Relieve and empower employees by saving time – better analysis possible
  • Fast solution development according to your needs – directly measurable ROI

The savings potential achieved

4000 h / 300.000 €
Reduction in work performed per year. Total up to 3 FTE at 70% PQ

Have your savings potential calculated now!

Do you want to write your own success story with the help of Intelligent Automation? Contact our experts for RPA, NLP, NLG
and Machine Learning and learn how much you can save with the innovative automation of your workflows and processes.

Your contact person

Michael Fischbäck

Business Development Consultant

Downloads and further content on the use case


View mockup