---
title: Bring Picklist Values to your Salesforce Report
description: How to add picklist values to your Salesforce reports.
---

[Skip to content](https://knowledge.xappex.com/bring-picklist-values-to-your-salesforce-report#main-content)

English

Show submenu for translations

![Xappex-logo-with-name.png\]](https://knowledge.xappex.com/hs-fs/hubfs/Xappex-logo-with-name.png?height=40&name=Xappex-logo-with-name.png)

- [Products](https://knowledge.xappex.com/bring-picklist-values-to-your-salesforce-report#products)
- [Blog](https://knowledge.xappex.com/bring-picklist-values-to-your-salesforce-report#blog)
- [About](https://knowledge.xappex.com/bring-picklist-values-to-your-salesforce-report#about)

Open main navigation

Close main navigation

- [Products](https://knowledge.xappex.com/bring-picklist-values-to-your-salesforce-report#products)
- [Blog](https://knowledge.xappex.com/bring-picklist-values-to-your-salesforce-report#blog)
- [About](https://knowledge.xappex.com/bring-picklist-values-to-your-salesforce-report#about)
- English
  
  Show submenu for translations
- Go to xappex.com

 Go to xappex.com

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Xappex Knowledge Base](https://knowledge.xappex.com/?hsLang=en)
2. [I use Microsoft Excel](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en)
3. [I use XL-Connector](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-xl-connector)

# Bring Picklist Values to your Salesforce Report

## How to add picklist values to your Salesforce reports.

### A Quick Tip to Make your Work with Salesforce Reports Even Easier

When you first pull a report from Salesforce to Excel using XL-Connector’s Get Reports function – you can populate your picklist columns with drop-downs containing all available picklist values. Here’s how to do that:

1. After you click the Reports button, click the Options tab.
2. Check the Enforce Picklists box from the options:![](https://www.xappex.com/wp-content/uploads/2017/09/Screenshot_9.jpg)
3. Your picklist values should now be populated:  
   ![](https://www.xappex.com/wp-content/uploads/2017/09/3.png)

- [I use Google Sheets](https://knowledge.xappex.com/i-use-google-sheets?hsLang=en)
- [I use Microsoft Excel](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#main-content)

    - [FAQs](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#faqs)
    - [I use XL-Connector](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-xl-connector)
    - [I use XL-Connector 365](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-xl-connector-365)
    - [I use Excel Merge package](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-excel-merge-package)
- [I use Looker Studio](https://knowledge.xappex.com/i-use-looker-studio?hsLang=en)

- [Products](https://knowledge.xappex.com/bring-picklist-values-to-your-salesforce-report#products)
- [Blog](https://knowledge.xappex.com/bring-picklist-values-to-your-salesforce-report#blog)
- [About](https://knowledge.xappex.com/bring-picklist-values-to-your-salesforce-report#about)

[![Chill listening crop-3](https://knowledge.xappex.com/hubfs/Xappex-Logo.svg "Chill listening crop-3")](https://www.xappex.com)

xappex.com Help Center

Copyright © 2026, Xappex LLC