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

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.


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:


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! ⚡