Data Extraction Assistant

An add-in for Microsoft Excel that extracts rows or data from one worksheet to many worksheets.

  • Extract data to other worksheets based on column entries
  • Create individual workbooks from worksheets
  • Selectively extract data based on matching entries
  • Alphabetize your worksheets
  • Extract to just one worksheet or to many worksheets

Download a trial version now!

The Data Extraction Assistant add-in for Microsoft Excel helps you extract rows or data from one worksheet to many worksheets. It is compatible with Microsoft Excel 2013-2024 and Office 365.

The extraction can be to the current workbook, to any open workbook, or to a new workbook. It is based on the entries in any column of the data that you specify. The Data Extraction Assistant can create new worksheets as needed. It also provides a feature that allows you to sort the sheets in alphabetical order and to quickly go to any worksheet.

One of our customers had a list of sales leads by region. He first used our Lookup Assistant add-in to list the sales manager for each region by each of the sales leads. At this point, he had a worksheet with several thousand rows and about 25 managers. He needed individual worksheets and workbooks by manager. He didn't want to send all the data to every manager!

With the Data Extraction Assistant, he was able to first split the data into multiple worksheets, one for each sales manager. Then he used the Data Extraction Assistant's option to save each worksheet as a new workbook! That left him the simple task of mailing out the workbooks to the sales managers.

When they sent back the results, he took the 25 workbooks and used the Consolidation Assistant to combine into one easy to examine worksheet with all the data from all the managers on the one worksheet!

When the extraction is completed you can then go to any of the worksheets using the sheet navigation tool included in the Data Extraction Assistant. If you need to create individual files from the worksheets, the Data Extraction Assistant has an option on the first dialog that creates individual workbooks. You can create output files in:

  • Excel 97-2003 format
  • Excel 2013-2024 and Office 365 format
  • PDF (if you are using Excel 2010 or higher)
“I have to say that this is probably the BEST add-on for Excel I’ve ever used. This product has saved our company an insurmountable amount of time and man-hours.” — Rick Kivler

Related add-ins