# How to specify HubSpot columns to export?

You may choose specific columns to import in the "Columns" setting. This is how the chosen columns will look:

![](https://s3.amazonaws.com/helpscout.net/docs/assets/57fbf3029033600277a688ab/images/67d82287450ee2419c5326bd/file-GKPKTrPh9X.png)

If the "Columns" setting is left empty, we will import a list of *all* basic and custom columns available for the chosen data entity.

If you wish to import only specific columns, you can select them in the "Columns" setting picker one by one, or copy-paste the needed column names from an external file, or from the Transfomrations tab in Coupler.io. Coupler.io will preserve your inserted columns' order.

**Copy-pasting from an external file:**

![](https://s3.amazonaws.com/helpscout.net/docs/assets/57fbf3029033600277a688ab/images/682f6bb38c0d8d14bd0df43f/file-x1TnRBG56B.gif)

**Copy-pasting from Transformations in Coupler.io:**

![](https://s3.amazonaws.com/helpscout.net/docs/assets/57fbf3029033600277a688ab/images/68419d82595d4c2f006d6391/file-JzJoILOEXl.gif)

If you specify the column names manually, rather than importing all columns or selecting the available ones from the drop-down picker, please ensure that the internal Hubspot names are entered correctly, without any extra spaces or invisible characters. This will ensure that the data is properly displayed in your destination. Otherwise, you may only see the column headers without any corresponding data. [See how to define the column's internal name.](https://docs.coupler.io/sources/category/crm/hubspot/best-practices/how-to-find-hubspot-columns-names)

![](https://s3.amazonaws.com/helpscout.net/docs/assets/57fbf3029033600277a688ab/images/62f15a8e80fd5a31e7ad02f7/file-61gdpcpdnE.png)
