Hi, I noticed that when Clay handles imported CSV, it literally only use 'Comma' You can see this issue only occurs if the company names contain ",S.A." or ",Ltd." While excel and google sheet can easily parse them correctly, Clay will parse them into an extra column
Hi, thank you for reaching out. The issue you're facing is that the CSV file you’re working with is using semicolons (;) to separate columns, instead of commas (,), which is the standard format for CSV files. To resolve this, you'll need to re-export the file using an application that correctly saves CSV files with commas as separators. When I open that original file in a simple text editor, I see the columns are separated with semicolons rather than commas. Something similar to what is shown below:
I would recommend trying to re-export this file as a csv using another app. I happened to use Apple Numbers, but saving/exporting as CSV worked as expected for me, and resulted in columns separated by commas:
...and a test import to Clay with the updated file worked as expected in my test account. I don't have specific guidance for the spreadsheet software you're using, but I believe the issue is with how that original file is being saved, rather than with Clay's handling of the file.
.png){kind=logo}
