About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Convert a CSV File to UTF-8

  • 28 January 2022
  • 2 replies
  • 276 views
Y

Hi Guys, iam tryin to read an attached csv file with the Formatter of Zapier.

I got following Error: 

When i save the csv file as UTF-8 and send it again it works perfectly.

 

so it seems like as i have to convert the incoming csv file to utf-8. is there any way to automate this process?

 

thanks

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

SamB
Rank
Userlevel 7
Badge +11

Hey @yasinyaso! :)

What format is the CSV file originally encoded as? I’m not sure what app is being used to generate the CSV file originally but are there any settings you can change in that app to ensure that the file is always generated in UTF-8 format?

Are you using the “Detect Automatically” option for the Type of CSV File field? If so, I wonder if it might be an issue with the auto-detection not working correctly. In which case selecting the correct type of file from the dropdown list of options for that field in the Zap may help to get the CSV file recognised. 

Aside from that, perhaps you could use a file conversion app, like CloudConvert for example, to change the format of the file before its imported by the Formatter step?

Y

Hey @SamB thanks for your Reply.

 

the File comes directly from my supplier, i have no possibility to change the process while creating the file… :(

Terms & Conditions