Issue with CSV import with regards to certain characters

[aadit_bimbhet]

Hi,

I’m trying to import data from CSV into Airtable. This data is a product catalog that I want to import into Airtable to manage it there going forward. But upon uploading, I’m seeing this � character appearing in some data points and not sure why this is happening and how to fix it. Would appreciate any advice.

For example, data in my csv file is exactly as per the below:
“…A lazy isle to which nature has given singular trees, savory fruits, men with bodies vigorous and slender, and women in whose eyes shines a startling candor…” - (baudelaire, les fleurs du mal, parfum exotique, 5-8)

What’s appearing in Airtable after importing the file is:
��A lazy isle to which nature has given singular trees, savory fruits, men with bodies vigorous and slender, and women in whose eyes shines a startling candor�� - (baudelaire, les fleurs du mal, parfum exotique, 5-8)

Another example, this is a line I am importing:
Invented by scientists during 35 years of research, StriVectin’s proprietary NIA-114 technology

And this is what is appearing in Airtable:
Invented by scientists during 35 years of research, StriVectin�s proprietary NIA-114 technology

Thanks!

[Joss]

saule_aymaganova:

That is probably the problem with MS word converting file into .CSV

No, it’s airtable issue. Supports answered that they don’t support any non English languages.

[Andres_Hidalgo]

If you have R installed you can change the encoding with this code

df <- read.csv2("Your File's Directory.csv")

write.csv(df, "Your New File's name.csv", fileEncoding = "UTF-8")

It should now import without any issue

[Eduardo_Sayer]

Debes guardar tu CSV en Excel como CSV UTF-8