Data Assistant

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

  • 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
Download a trial version now!
Data in report layout
Before
Data converted to a pivot-ready table
After

The Data Assistant add-in for Microsoft Excel helps you get your data into pivot tables the right way. It is compatible with Microsoft Excel 2010-2021 and Office 365.

The Data Assistant converts data that is 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.

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