Home
Events
Groups
Members

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

University
Clay live events

Powered by Tightknit

Export Numbers with Commas in CSV Format: A Step-by-Step Guide

·

·

I have a column with numbers that include a comma (like 2,000) but when I export as a CSV I get "2000" instead of "2,000". How do I export the list to include the comma?

Export Numbers with Commas in CSV Format: A Step-by-Step Guide | Clay

5 comments

· Sorted by Oldest

Clay Support
APP
·
·
The CSV export mirrors your Clay table exactly, so formatting changes like missing commas typically occur during the export process. [1]
To preserve number formatting with commas, create a dedicated "CSV Export View":
1. Duplicate your current view
2. Hide or delete columns you don't need
3. Focus on including only the raw values you need [2]
You may also want to check your column data type by right-clicking the column and selecting "Edit Column" > "Select Data Type" to ensure it's formatted as text rather than a number, which would preserve the comma formatting.
This approach ensures your exported CSV contains the essential data with proper formatting. [3]
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you still need help with exporting your list to include commas in the numbers, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific issues you’re encountering?
Drew H.
·
·
Got it, thanks AI
Clay Support
APP
·
·
Glad I could help. Let me know if you need anything else.