Skip to main content
Best answer

How do I turn an Microsoft Excel file in Google Drive to a JSON file?

  • November 29, 2023
  • 1 reply
  • 91 views

Hi I have an excel file located in my google drive. I want to turn it into that excel file into a json file to use in a zapier “Run python by code” block. However I am not sure how to turn the excel file to a json file.

If it was a google sheets I could use the “Get many spreadsheet rows”, but there I can’t find an equivalent for an excel file in google drive.

Best answer by Troy TessaloneBest answer by Troy Tessalone

Hi @testing123 

Good question.

If you upload the Excel file to GDrive, there is the option to convert that to a GSheet, then you can use the GSheet Zap options.

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31004 replies
  • Answer
  • November 29, 2023

Hi @testing123 

Good question.

If you upload the Excel file to GDrive, there is the option to convert that to a GSheet, then you can use the GSheet Zap options.