Best 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.

  • 28 June 2023
  • 5 replies
  • 133 views

Userlevel 1

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.

icon

Best answer by Troy Tessalone 28 June 2023, 17:39

View original

5 replies

Userlevel 7
Badge +14

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

 

Userlevel 1

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. 

 

Userlevel 7
Badge +14

@Ryan Tripi 

Try this Zap action: GDrive - Upload File

 

Userlevel 1

Looks like that worked, thanks

Userlevel 7
Badge +11

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

Happy Zapping! ⚡

Reply