Data Mining and Analysis Tools for Excel

Analyze Your Data Quickly and Easily with these QI Macros Tools

You'll Save Time and Look Like an Expert

Customers tell us half the battle of meaningful data analysis is to get their data in a usable format.

  • Do you struggle with Excel's Pivot Table function?
  • Is your data buried in flat transaction files or text files like the ones below?
  • Do you struggle to turn this kind of data into actionable improvement stories?

Data Exported from Tracking Systems

excel data files exported from other system

Notes Exported from Tracking Systems

count words in Excel

QI Macros add-in for Excel installs a new tab on Excel's menu:

Excel 2013-2021, Office 365:


You'll Find These Easy to Use Data Mining Tools in QI Macros

Improvement Project Wizard (formerly Data Mining Wizard)

Analyzes an entire table of defect data using PivotTables, control charts and Pareto charts.

Creates all of the charts necessary to develop a rock-solid, bullet-proof business case for change.

PivotTable Wizard

Excel Pivot tables can be hard to learn but they are a snap with QI Macros. Just select up to four columns of data and then click on QI Macros PivotTable Wizard to create a PivotTable in seconds.

There are million dollar improvement projects lurking in your data. Don't miss out on these huge opportunities.

Word/Number Count Wizard

Counts the number of times a word or two-word phrase or number appears in text/number data. Use it to analyze employee feedback, call center notes, customer reviews and more. Easily create Pareto charts, too!

Want to know what customers are peeved about? Use Word Count to find out!

Unstack, Stack and Restack

Changes how your data is organized.

For example take a 6 x 6 matrix of data points and stack or restack it into as many columns and rows as you want (e.g. 4 x 9, 3 x 12; 18 x 2, etc.)

Stack and Unstack by labels or subgroups as well.

Paste Link/Transpose

Excel allows you to Paste Links to data or Transpose your data, but not both.. Use QI Macros to do both at the same time. QI Macros is also smart enough to prevent putting zeros instead of blanks in linked cells.

Use Paste Link / Transpose to link existing data to QI Macros Lean Six Sigma chart templates to simplify reporting.

Case Studies...

View Data Mining Tools Tutorial - 14 minutes

Other Reasons to Choose QI Macros



  • Only $349 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free