Convert Reports to a Flat-Table 

Report Inverter for Microsoft® Excel®

Report Inverter for Excel is a product with a powerful set of tools aimed at converting a report structure into a data table.    

This friendly Plug-In for Excel allows you to perform automated reformatting actions, skipping the manual work of operating cell by cell, what would regularly represent a waste of time: hours or even days depending on the volume and complexity of the original data, dramatically increasing productivity.  

KEY FEATURES

• Convert irregular data structures into a data table format
  
• Extract data from text reports imported into Excel
  
• Obtain a CSV format file from the data conversion process.
  
• Convert report structures such as Headers and Footers, Multi-Line Records, Data Labels and Cross Tables
  
• True user-friendly interface which avoids using complex configuration panels or hard models designers
  
  
  

TOOLS

TOOLS TO CONVERT REPORT LAYOUT FEATURES They convert data layouts which may come from automated or manually operated reports into a structure of a data table, also known as flat file database.

Transpose Data Labels Transpose Cross Tables Line Up Multi-Line Records Replicate Headers & Footers Replicate Group Fields

TOOLS TO SEARCH/FIND AND REFORMAT DATA They modify the structure of the datasheet based on a search, or extract criterion established by the user on the basis of information contents and on data patterns. Their purpose is to perform an automated action every time an occurrence of the searched element is present.

Find Data & Extract Data Types Find Data to Delete Rows Find Data Pattern to Shift Cells Find Data Pattern to Insert Rows

TOOLS TO REFORMAT They perform reformatting actions contributing in the process of conversion of report layouts into a table of data.

Delete Blank Rows & Columns Unmerge & Replicate Cells Encode Colors

TOOLS TO TRANSFORM DATA They transform cell contents yielding a result that will modify the original data according to a specific purpose. It is possible, for instance, to split and concatenate texts into columns using separation characters.

Split Text To Columns Split Text To Rows Concatenate Columns Pad Out with Leading Zeros Trim Spaces within Cells