topic Excel to CSV conversion in Workato Pros Discussion Board

Excel to CSV conversion

TilakBhatia — Fri, 19 Jan 2024 20:56:47 GMT

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

Re: Excel to CSV conversion

gary1 — Fri, 19 Jan 2024 22:22:53 GMT

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

Re: Excel to CSV conversion

TilakBhatia — Sat, 20 Jan 2024 18:08:52 GMT

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.

Re: Excel to CSV conversion

meghan-legaspi — Mon, 22 Jan 2024 11:30:39 GMT

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

Re: Excel to CSV conversion

TilakBhatia — Mon, 22 Jan 2024 11:43:50 GMT

Hi @meghan-legaspi ,

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

Regards,

Tilak