This topic explains basic ideas of how to export only certain columns of your dataset. You can do this by several ways. This works for all supported source database types and all supported target data formats.

Solution 1: Using SQL

Using a SQL query, you can solve the task very quickly. Let's suppose we have a table 'Clients' with 5 fields/columns: ID, FirstName, LastName, BirthDate, Category; and we need to export only 3 of them: FirstName, LastName, BirthDate.

So, instead of writing a quick database query like


use this one:

SELECT FirstName, LastName, BirthDate FROM Clients

After executing the query, you get a dataset with chosen columns only.

Solution 2: Hiding Dataset Columns Before Exporting

After opening the dataset, you can just hide columns in the data grid. Right-click the needed column and choose Hide Column item from the context menu or select the column and press Alt+H. This operation just visually hides the columns and does not physically delete any data.

Then, after clicking Export button, scroll down to Column Range options and make sure the Visible columns option is selected.

Solution 3: Filtering Columns Using Field Mappings

After clicking Export button and choosing the initial export option, proceed to Field Mappings step.

Using the corresponding buttons, remove field mappings for those columns which you don't want to export.

See also

 Exporting Data