Smart Advice. Agile. Personalized. Transparent.

A simple cheat to create multi-level value lists

I’ve done quite a few demos where ease of data entry was paramount and I’ve made extensive use of the cascading value lists.  I have grown tired of writing the xml so I built the attached excel document that builds the XML for me.  I added some instructions and cleaned it up so others might use it.  

So, to get started, open up the attached spreadsheet and follow the instructions:

1. Enter the list name and child list name

2. Enter each list value separated by the child values

3. Create the next cascading list using the name of the previous child

4. Repeat step 3 for each child list

5. Check for errors

6. Copy the generated xml into an xml editor and follow the instructions in the Intelligent Advisor documentation to import it into your project. 

It's that easy. 

Comments and feedback welcome. 


Photo credit: Chuttersnap

Join the discussion

Comments ( 3 )
  • Peter Thursday, June 14, 2018
    Awesome! I just need to work with an extensive hierarchical list and I was not happy to build everything manually in Notepad. You saved me a couple of hours of otherwise tedious work.
  • Paul Fowler Monday, October 29, 2018
    Ok. That is cool. Thank you.
  • Mitch Thursday, May 28, 2020
    What a fantastic tool! I put a couple hundred rows in my project via xml as a quick test. How does this work?
    Can this be made to generate a 3rd layer of children (or more)? The NAICS code list has 2196 entries broken out into 6 layers in the list of industries, eg: manufacturing, agriculture, ...
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.