---
title: Validating Dependent Picklists
description: Understand how to mass-load values of dependent and controlling pick lists into Salesforce.com.
---

[Skip to content](https://knowledge.xappex.com/validating-dependent-picklists#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/validating-dependent-picklists#products)
- [Blog](https://knowledge.xappex.com/validating-dependent-picklists#blog)
- [About](https://knowledge.xappex.com/validating-dependent-picklists#about)

Open main navigation

Close main navigation

- [Products](https://knowledge.xappex.com/validating-dependent-picklists#products)
- [Blog](https://knowledge.xappex.com/validating-dependent-picklists#blog)
- [About](https://knowledge.xappex.com/validating-dependent-picklists#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)

# Validating Dependent Picklists

## Understand how to mass-load values of dependent and controlling pick lists into Salesforce.com.

A huge helper when mass-loading values of dependent and controlling pick lists into Salesforce.com.

To make sure values of dependent pick lists are loaded correctly into Salesforce.com, XL-Connector Enterprise Admin edition has the functionality to validate if correct values are being loaded into dependent picklists.

![](https://www.xappex.com/wp-content/uploads/2017/07/Screenshot_13.jpg)

 

After the tool runs, it will mark all invalid picklist values with a red background making it easy to spot and correct. If you run the tool again after correction, the red background will be cleared.

![](https://www.xappex.com/wp-content/uploads/2017/07/Screenshot_14.jpg)

- [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/validating-dependent-picklists#products)
- [Blog](https://knowledge.xappex.com/validating-dependent-picklists#blog)
- [About](https://knowledge.xappex.com/validating-dependent-picklists#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