CSV exports show pick list item's value, not title

[emd0083]

I noticed that when exporting query results as CSV, fields that are based on pick lists have value exported instead of title.

Is there a setting I missed? I’d like to have any exports use title by default.

[!example]-

The Agent Title field (:agent: Title) uses the system pick list, AgentTitles.

When this field is included in a query, the results use the item’s Title.

If I then click Create CSV and open the file, it shows the item’s Value.

FYI: this happens for any of my fields that are based on a “real” pick list. PrepType doesn’t seem to be impacted. Maybe because it is based on its own table and doesn’t use the same title / value pairing method(?)

System Information (v7.11.4)

Specify 7 System Information - 2026-03-20T20_30_43.170Z.txt (1.1 MB)

[Grant]

Hi @emd0083,

Thank you for your report and for how well it is formatted!

This is a known behavior at this time, which is described in ticket #7554 on GitHub. I’ve added your report to this, but we are looking to address this in the future. Your report pushes this up in our prioritization process, so thank you for reaching out!

To make this consistent in the short term, this requires you to set the pick list item ‘Value’ to the same contents as the ‘Title’ field. The difficulty here is that you would need to also update the database records so that the value in the assigned field (e.g. :agent: Title) matches the new pick list item value.

If you’d like us to do this for you since you are hosted on Specify Cloud, just let me know! It just takes us a few minutes behind-the-scenes to perform this update. I am hopeful a permanent solution for this discrepancy is on the horizon.