Skip to main content
Answer

The CSV file couldn't be read, due to an encoding issue: 'utf-8' codec can't decode byte 0xcd is position 49: invalid continuation byte.

  • June 27, 2023
  • 5 replies
  • 195 views

Ryan Tripi

I am currently using the Gmail application to pull an xlsx file from an email I receive, except the attached spreadsheet includes 2 sheets. The Format app is unable to import it as a csv file because of this, and I only need one of the two sheets. Is there a way to split the spreadsheet into two separate csv files, one for each sheet, so I can work with them separately?

This is the error message I receive from the formatting app when I attempt to test run it.

Best answer by Troy Tessalone

@Ryan Tripi 

Try this Zap action: GDrive - Upload File

 

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

5 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • June 28, 2023

Hi @Ryan Tripi 

Good question.

This is possible using the GSheets API Request Zap action.

Using app APIs is an advanced approach.

Let me know if you need help, I’m a Certified Zapier Expert: https://zapier.com/experts/automation-ace

 


Ryan Tripi
  • Author
  • Beginner
  • June 28, 2023

That would help if I could upload the spreadsheet to google sheets, but right now when I try to create a spreadsheet using the xlsx file, it gives me this error. 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • June 28, 2023

@Ryan Tripi 

Try this Zap action: GDrive - Upload File

 


Ryan Tripi
  • Author
  • Beginner
  • June 28, 2023

Looks like that worked, thanks


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • June 28, 2023

That’s fantastic news @Ryan Tripi! Really pleased Troy was able to assist here. 😁🎉

Happy Zapping! ⚡