Data Conversion Tools with Add-ins/plug-ins for Excel

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

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 Data Labels
Transpose Cross Tables
Transpose Cross Tables
Line Up Multi-Line Records
Line Up Multi-Line Records
Replicate Headers & Footers
Replicate Headers & Footers
Replicate Group Fields
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 & Extract Data Types
Find Data to Delete Rows
Find Data to Delete Rows
Find Data Pattern to Shift Cells
Find Data Pattern to Shift Cells
Find Data Pattern to Insert Rows
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
Delete Blank Rows & Columns
Unmerge & Replicate Cells
Unmerge & Replicate Cells
Encode Colors
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 Columns
Split Text To Rows
Split Text To Rows
Concatenate Columns
Concatenate Columns
Pad Out with Leading Zeros
Pad Out with Leading Zeros
Trim Spaces within Cells
Trim Spaces within Cells

See the full list of TOOLS AND FEATURES


  Get a FREE STEP-BY-STEP SCREENCAST with PRODUCT TRIAL

Let us help you to convert your Excel file into a data table with Report Inverter:

Submit a representative sample file covering the data structure you wish to convert and we will send you in few hours a compact screencast showing the conversion steps.


Report Inverter works with Microsoft Excel 2016, 2013, 2010, 2007, 2003 SP

The product includes Help Documentation. You can access it from the main menu or from any form of the Program

Please contact us for any additional information you may need.

Copyright © 2008-2017 Databilio. All rights reserved.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation
in the United States and/or other countries.

 

 

Secure Purchase

Buy NOW

Buy Report Inverter for Excel

Price: $99 USD

 

Download Report Inverter for Excel