Select the data to extract

  1. Open the spreadsheet with the rows you want to extract.
  2. Select the table and click on the Extract Data icon to run the tool.
    Extract Data icon

    Tip

    If you click on any cell in your table and run the program, it will select the entire table automatically.

  3. You will see the add-in window listing all columns you have in the table. The 1st row content column next to Columns shows the first item of each column in your table. It can be useful if your worksheet doesn't have headers so you can see what kind of information is in the columns. See what kind of information is in the columns
  4. Select the columns with the data you need to export to a new location. All columns are selected by default. You can untick the checkboxes next to those you don't want to copy. Select the columns with the data to export

    Tip

    If you have a lot of columns in your table, take advantage of the Select All and Unselect All buttons to instantly tick or untick all the checkboxes in the list of columns.

    Take advantage of the Select All and Unselect All buttons
  5. It is also possible to indicate if there are header rows in your table. As a rule, the add-in indicates headers automatically. If it doesn't, you can check My table has headers. Indicate if there are header rows in your table

Define options

Group by column values

The Group by option allows choosing a column with the key values for grouping the extracted data. For example, you have a worksheet with employee information. You want to extract employees into a new workbook by their manager. So each workbook will contain every employee data for only one manager.

Choose a column with values for the extracted data to be grouped by

Tip

You can group by values in a certain column even if this column is unchecked in the list on the add-in window.

Do the following to use the Group by option:

  1. Enable the Group by feature on the options section by ticking the checkbox next to it. Enable the Group by feature on the options section
  2. Select the column with the key values in the drop-down list. Use this drop-down list to select the values for grouping the extracted data

Add column headers

It can be helpful to add column headers so that the data you export is labeled. You can turn on the Add column headers option by ticking the checkbox next to it.

Add column headers to the results

Note

If you check the Add column headers option while My table has headers is unchecked, you will get column labels instead of their headers.

If My table has headers is unchecked, you will get column labels, not headers

Skip empty cells and Autofit extracted columns

  1. Select the Skip empty cells option to avoid empty cells in the extracted data. You can do this by checking the box next to the Skip empty cells option. Select Skip empty cells option by ticking this checkbox

    Note

    The Skip empty cells option will be disabled when the Group by feature is used.

  2. Tick the Autofit checkbox if you want the new columns with extracted data to automatically adjust the width and display the contents in full. Tick the Autofit checkbox to enable the option

Select the destination for the extracted data

  1. Choose if you want to copy the data to the current or to a new workbook. To do this, click on the small arrow next to the Workbook option and select Current or New from the list. Choose to copy the data to the current or a new workbook
  2. Select To multiple worksheets if you want to extract each data set to a separate worksheet. Extract each data part to a separate worksheet
    Here is how your data may look like when you select to group by post and extract the rows to multiple sheets: Extract rows to multiple worksheets
    Choose To one worksheet to have the extracted data in one spreadsheet.
    Export data to one spreadsheet
  3. If you want to name worksheets after values in a certain column, select this column from the Name by drop-down list. Name worksheets after values in a certain column

    Note

    The Name by option will be disabled if the Group by feature is checked.

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish this message on the forum
 

Please remember that we work from 8am to 4pm GMT,
this is 4:00am to 12:00pm EST, 1:00am to 9:00am PST, and our public holidays may differ from yours.