cancel
Showing results for 
Search instead for 
Did you mean: 

Excel to CSV conversion

TilakBhatia
Deputy Chef III
Deputy Chef III

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

2 ACCEPTED SOLUTIONS

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

View solution in original post

TilakBhatia
Deputy Chef III
Deputy Chef III

Hi @meghan-legaspi , 

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

Regards, 

Tilak

View solution in original post

4 REPLIES 4

gary1
Executive Chef III
Executive Chef III

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/

 

gary1_0-1705702907274.png

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

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

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. 

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
Deputy Chef III
Deputy Chef III

Hi @meghan-legaspi , 

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

Regards, 

Tilak