Data Assistant

An add-in for Microsoft Excel that converts report-style data into pivot-table-ready tables.

Download a trial version now!
  • Convert data in a nice looking report layout to the data layout needed for a pivot table
  • Handles data in different report layouts
  • Lets you apply the power of pivot tables to better analyze your data

The Data Assistant add-in for Microsoft Excel helps you get your data into pivot tables the right way.

The Data Assistant converts data in table form into data that is usable for pivot tables. The original data is not modified — a new table is created. Data in the converted format is the best format for pivot tables. The following screenshot illustrates data in a report format:

Typical report format.

This screenshot illustrates the above data converted to a data layout usable for pivot tables or filtering:

Typical report format.

There is a help and exercise file that helps you learn how to use the Data Assistant. It is available by clicking on the “Help/Exercise File” button on the dialog.

“Every time I use the Data Assistant, I give thanks for your work. Although all of your stuff is great, this has proven to be unique and valuable to me over the years.” — Michael Matza

Related add-ins