Excel to CSV conversion

[TilakBhatia]

HI Memebers,

Can someone please tell me the easiet way to convert excel to csv format in workato what I would avoid is renaming the file using on-prem or SFTP server, however any direct file renaming works which can be hosted in workato. Or any other potential solution will help.

Regdars, 

Tilak Bhatia

[meghan-legaspi · Accepted solution]

Hey @TilakBhatia,

I recommend looking at this collection for help with this issue: https://app.workato.com/accelerators/python_javascript 

@gary1, thank you for calling out that the link from that product hub page isn't working. As you said, the link may have been removed if the recipe changed or was no longer working. I will bring it to our team's attention.

Thanks,
Meghan

[gary1]

I use an API service for XLSX conversions. I never found a great solution within Workato. 

There used to be an example recipe with a massive JavaScript action to convert a spreadsheet to CSV but 1) I never got it to work and 2) it appears to be unavailable now.

@meghan-legaspi any idea what happened to this?

This URL has a link at the very bottom to an example automation:

https://www.workato.com/product-hub/javascript-connector-the-freedom-to-transform-your-way/

It links to this recipe, but it's no longer available:

https://app.workato.com/recipes/1381928-simple-xlsx-to-csv#recipe 

[TilakBhatia]

Thanks Gary for the response. Now you have confimed that there's no OOTB solution I would probality look for JS or Pythod solution to convert the file. Will keep posted. 

Thanks. 

[meghan-legaspi · Accepted solution]

Hey @TilakBhatia,

I recommend looking at this collection for help with this issue: https://app.workato.com/accelerators/python_javascript 

@gary1, thank you for calling out that the link from that product hub page isn't working. As you said, the link may have been removed if the recipe changed or was no longer working. I will bring it to our team's attention.

Thanks,
Meghan

[TilakBhatia · Accepted solution]

Hi @meghan-legaspi , 

The solution worked liked a charm, Thank you very much. I used python solution for the file conversion. 

Regards, 

Tilak