Home

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

Explore Events
Clay Cup

Powered by Tightknit

Issues Importing CSV with £ Currency Values and Filtering Errors | Clay

Issues Importing CSV with £ Currency Values and Filtering Errors

·Dec 15, 2025 04:12 PM·

Does anyone know why when I import a CSV with £ values, and set the column to currency = £, I get these errors and I'm unable to filter?

7 comments

· Sorted by Oldest

Clay Support
APP
·
·
The warning icons suggest formatting issues with your currency values. Try removing commas, colons, and semicolons from your CSV before importing—these characters can interfere with how our system interprets the data.
Also ensure your CSV is UTF-8 encoded with comma separators for best results. If issues persist, upload to Google Sheets first, then download as CSV and re-import.
Clay Support
APP
·
·
Did that answer your question?
Jonathan M.
·
·
I already uploaded to Google sheets and imported it
Clay Support
APP
·
·
Since you've already tried the Google Sheets approach, the orange warning icons likely indicate formatting issues with the currency values themselves. Try removing all commas from the pound values in your CSV before importing—commas can interfere with how our system interprets currency data.
Also check that your CSV file name is short, as long filenames can cause import issues.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help resolving the currency formatting errors, I’m here to assist. Would you like to provide more details about the issue you’re encountering or any specific steps you’ve tried?
Intercom
APP
·
·
🔗 Merged conversation This thread has been merged into your main conversation. To keep the discussion going and see all replies, please continue in the main conversation.