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
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]
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?