# Custom exports to Excel - selected data fields only **URL:** \ **Category:** Lists, Lead Scoring & Workflows\ **Tags:** professional\ **Created:** [December 4, 2020, 6:11pm UTC](https://community.hubspot.com/t/custom-exports-to-excel-selected-data-fields-only/28786 "2020-12-04T18:11:30Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![TommyGarvin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tommygarvin/32/29892_2.png) [@TommyGarvin](https://community.hubspot.com/u/TommyGarvin)\ **Post date:** [December 4, 2020, 6:11pm UTC](https://community.hubspot.com/t/custom-exports-to-excel-selected-data-fields-only/28786/1 "2020-12-04T18:11:30Z")
I am new to HubSpot, working on exporting client data for use in Microsoft Power BI. The client has several hundred custom columns defined in Contacts. Starting from one of their filtered lists, I added a few columns to the export selection. This worked, but the selection is not saved. I need to find a way to select and save approximately 50 data fields. What is odd is there is a default list which comes up, always the same 39 fields, just not the right ones. I have no idea where this persisted list came from. It seems like there is a capability somewhere. ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [December 4, 2020, 7:13pm UTC](https://community.hubspot.com/t/custom-exports-to-excel-selected-data-fields-only/28786/2 "2020-12-04T19:13:41Z")
Hi @TommyGarvin, In the contacts tool (Menu \> _Contacts_ \> _Contacts_), you can add customize your columns (_Table actions_ \> _Edit columns_). Once you have your 50 columns, click the [_Save view_](https://knowledge.hubspot.com/crm-setup/create-customize-and-manage-your-saved-views) button (this is the important part). When you click again on _Table actions_, you’ll see that you can _Export view_. Your saved view can also be pinned to the contacts dashboard and made default – for faster access. Otherwise it’ll be saved under _All views_. You can now also filter this contact view by list membership (or any other contact criteria, really). Click _More filters_ and search the _Contact properties_ for _List membership_. Another option would be the [Power BI integration](https://ecosystem.hubspot.com/marketplace/apps/marketing/analytics-data/powerbi) from the App Marketplace – I haven’t used it myself but it might make your life easier. Hope this helps! ---
**Author:** ![TommyGarvin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tommygarvin/32/29892_2.png) [@TommyGarvin](https://community.hubspot.com/u/TommyGarvin)\ **Post date:** [December 4, 2020, 7:51pm UTC](https://community.hubspot.com/t/custom-exports-to-excel-selected-data-fields-only/28786/3 "2020-12-04T19:51:42Z")
Looks good, I am making progress. As soon as I verify I will accept as solution. Or, I might ask a follow-up question or two 😀 ---
**Author:** ![TommyGarvin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tommygarvin/32/29892_2.png) [@TommyGarvin](https://community.hubspot.com/u/TommyGarvin)\ **Post date:** [December 5, 2020, 2:44am UTC](https://community.hubspot.com/t/custom-exports-to-excel-selected-data-fields-only/28786/4 "2020-12-05T02:44:35Z")
I created the custom view. I now need to filter it. There are 38K contacts in the database. The client has a filtered list with the desired contacts, about 4K. I don’t see how to apply my view to a list, or maybe it is filter my view? ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [December 5, 2020, 8:12am UTC](https://community.hubspot.com/t/custom-exports-to-excel-selected-data-fields-only/28786/5 "2020-12-05T08:12:09Z")
Hi @TommyGarvin, You can apply an additional filter to your view to only show contacts who are in a certain list, just select _More filters_ and type _List membership_: ![35049iA5A6BC84F15518B9.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/8/8cb2b9d3583377d5d4b65d0c2c2f9675317dbe27.png) ![]() Best regards! ---
**Author:** ![TommyGarvin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tommygarvin/32/29892_2.png) [@TommyGarvin](https://community.hubspot.com/u/TommyGarvin)\ **Post date:** [December 5, 2020, 2:21pm UTC](https://community.hubspot.com/t/custom-exports-to-excel-selected-data-fields-only/28786/6 "2020-12-05T14:21:03Z")
They are filtering on a form submission rather than contact property. I don’t see an option in the filter choices. Since I know how to export all data from a List, as a seasoned programmer but totally novice HubSpot user, I would try to make a List from my View. Does that make sense? I’m sure there must be a way. From my SQL Server experience, one can both select data columns AND apply filter criteria in a SQL View. ---
**Author:** ![TommyGarvin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tommygarvin/32/29892_2.png) [@TommyGarvin](https://community.hubspot.com/u/TommyGarvin)\ **Post date:** [December 4, 2020, 7:54pm UTC](https://community.hubspot.com/t/custom-exports-to-excel-selected-data-fields-only/28786/7 "2020-12-04T19:54:17Z")
I am actively exploring the Power BI Integration you mentioned. The client is risk-averse, but the $0.00 price seems to be getting their attention. I’ll keep you posted. There is no official Power BI connector. The company CData offers a wide range of connectors which can be licensed. I have not yet had time to test the HubSpot connector. ---
**Author:** ![johnelmer](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/johnelmer/32/55984_2.png) [@johnelmer](https://community.hubspot.com/u/johnelmer)\ **Post date:** [December 5, 2020, 5:20pm UTC](https://community.hubspot.com/t/custom-exports-to-excel-selected-data-fields-only/28786/8 "2020-12-05T17:20:49Z")
@TommyGarvin there is an app in the HubSpot App Marketplace called the [HubSpot Connector for Power BI](https://ecosystem.hubspot.com/marketplace/apps/marketing/analytics-data/powerbi). This app has had hundreds of installations (our firm developed it). There is a free trial and the app installation is a simple self-service process. On a related note, we also offer an app for a **one-time** export all of your CRM data is the [Ultimate Data Export for HubSpot](https://ecosystem.hubspot.com/marketplace/apps/marketing/analytics-data/ultimate-data-export-224046). Ultimate Data Export is available free of charge in the HubSpot App Marketplace. With the Ultimate Data Export for HubSpot you can export the following data tables and their associations into Excel: - - Contacts - - Web Analytics - - Companies - - Deals - - Deal History - - Owners - - Campaigns - - Engagements - - Emails - - Products - - Tickets - - and more related subdata such as Pipelines and Associations. ---
**Author:** ![TommyGarvin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tommygarvin/32/29892_2.png) [@TommyGarvin](https://community.hubspot.com/u/TommyGarvin)\ **Post date:** [December 5, 2020, 6:03pm UTC](https://community.hubspot.com/t/custom-exports-to-excel-selected-data-fields-only/28786/9 "2020-12-05T18:03:10Z")
John, I completely agree. I have passed on this recommendation to my client. I’ll keep you posted on status in Q1.