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

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(?)

:info_: System Information (v7.11.4)

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

Hi @emd0083,

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

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. :slight_smile: I am hopeful a permanent solution for this discrepancy is on the horizon.

Sorry it took so long for me to get back to this! I have a couple questions…

  1. Does the ‘Value’ allow for spaces now? IIRC, Sp6 documentation used to recommended not putting spaces in ‘Value’.
  2. Would ‘Value’ allow characters, like periods? I have a picklists for Qualifier and Addendum where the ‘Title’ should be things like “sp.”, “aff.”, “sp. inq.” — I noticed these fields are also producing the stored ‘Value’ when used in labels. I could code the formatting into the report expression, but I don’t want to mess with it if the ‘Value’ can simply be updated to match ‘Title’.

Hi @emd0083,

  1. Yes, spaces are completely fine for ‘Value’!
  2. Value supports special characters and periods.

The catch is that if you change a Value in the Pick List Editor, Specify does not cascade that change to your existing records.

Because the database stores the literal string, those records will essentially “unlink” from the pick list. In the form view, the field might appear as invalid because the existing data no longer matches any available option in the list.

To fix this, you have to manually reconcile the data using one of these two methods:

  1. Batch Edit :batchedit_: Use the Query Builder :queries_: to find all records containing the old (now invalid) value, then use Batch Edit to overwrite them with the new one.
  2. SQL: With direct database access, you can run an UPDATE statement to change the values globally. I can assist you with this if needed!

Sweet. I want to make the changes directly to the database, so I submitted the remote access request. I’ll be in touch.

Thanks so much! :slight_smile: