CSV Export Issue: State Column Appears Blank

Steven S. · 2025-11-06T17:19:50.788Z

When I try to export the data into a CSV, the State column is showing up as blank. https://app.clay.com/workspaces/658126/workbooks/wb_0t59imdtBQd4VZq2zum/tables/t_0t59jlpo9GA8dHrZnji/views/gv_0t59imnPhVREgsScyHF

CSV Export Issue: State Column Appears Blank | Clay

Clay Support
APP
·
·
Blank columns in CSV exports typically occur when integration fields show "run condition not met" in Clay or when object fields don't display raw data values.
To fix this, create a dedicated CSV Export View by duplicating your current view, then hide columns you don't need and focus on including only raw values.
If your State column contains complex data or formulas, check if it's referencing an entire object instead of a specific key - you may need to adjust the formula to target the specific data field you want.
Clay Support
APP
·
·
Was that helpful?
Steven S.
·
·
nope
Clay Support
APP
·
·
I'm sorry that didn't help. I'll connect you to a human agent who can assist you further.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Loading attachments
Steven S.
·
·
Also, when I export the data to CSV, the view is showing 292 rows, but it only exports 132
Aditi S.
·
·
Hi Steven - thanks so much for reaching out. To confirm - are you talking about the "Billing State" column?" From what I can see, this is blank within your table currently and checking the parent column it also has a null value there
Is it possible that there's a different state column you were hoping to export out that isn't getting populated?
Loading attachments
Steven S.
·
·
weird.... it orinanlly had the state but now i don't see it anymore
Aditi S.
·
·
I see - is it updated in your SFDC? As I am seeing that is where this is getting pulled from.
Steven S.
·
·
check on it again
Steven S.
·
·
I was filtering for states where the billing state was null
Aditi S.
·
·
Ah that makes sense! When you export and have a certain filter set (e.g. billing state as null), your exported list will also show that same behavior, which is why you noticed that column as empty in the export.
Would recommend setting the filter either to "Billing state has results" if you only want the results with that field filled in to be exported.
Hope that helps clarify things!
Steven S.
·
·
when I export, I don't set a filter on billing state
Steven S.
·
·
It's just not exporting it out
Steven S.
·
·
the count is also off

20 comments