Macro to convert XLSX to CSV

I have 300 excel XLSX files that I need to get converted into CSV comma delimted files. I typically use a VBA script in excel, that goes to the folder where I have the files saved and goes through and creates a copy of the excel file as a CSV format. I would like to be able to do this in Alteryx.

Can someone help me figure out a batch macro that that do this?

Thanks!

Workflow

Datasets

Output

Batch Macro

Dynamic Processing

Optimization

Accepted answers

All comments

JoBen

Hey @aamerin, try building a batch macro like this, and it should work.

Thableaus

Hi @aamerin

Here's an example of how you could do it.

You need to change the Directory Tool to the folder where your XLSX files are.

Cheers,

Workflow Sample.yxzp

Jbrooks

Hi @aamerin,

Here is an example of how you could build it as an app where all you have to do is select the input and output folders. You have to run it as an app, and not just a standard work flow. Let me know if you have any questions.

xlsx to csv app.yxzp

aamerin

Can you send me a screen shot of your workflow? I have an older version of Alteryx and can't open your file

aamerin

@Jbrooks Can you send me a screen shot of your workflow? I have an older version of Alteryx and can't open your file

miantanzeel

Total Excel Converter is the perfect choice to convert any type of table. Supported input formats include Excel and Excel 2007, XLSM, XLT, XLTM as well as OpenOffice formats ODS, XML, SQL, WK2, WKS, WAB, DBF, TEX, and DIF. The list of target formats is even more extensive: convert your tabled files into DOC, DOCX, PDF, HTML, Access, TXT, ODT, ODS, XML, SQL, CSV, Lotus, DBF, TEX, DIFF, SYLK, and LaTeX. Instead of spending hours trying to gather various converters for each file type, download the one tool that can handle them all!

Total Excel Converter supports almost all Excel extensions: XLS, XLSX, XLSM, XLSB, XLT, XLTM, XLTX, XLK, XLW. When the new Office is released, we will add new file types too.

The widest list of output file types: DOC, PDF, HTML, MHT, XHTML, CSV, TXT, TIFF, JPEG, SVG, RTF, XML, XLS, XLSX, ODS, ODT, Lotus, DIFF, SYLK, LATEX, SQL, DBF, Access!

saicharansirangi

@Jbrooks

What if there are multiple sheets in a workbook, it is converting only first sheet

faiqz

Hi, do you have this workflow? I tried to develop on my own but I am still lack in macro. Thank you in advance

andynicky89

You can use a batch macro in Alteryx to convert XLSX files to CSV files. The macro is composed of two tools - a Text Input tool and an Output Data tool. You can configure the Text Input tool to select all the XLSX files in a folder and the Output Data tool to convert the files to CSV.

To do this, first, open the Text Input tool and configure it to select all the XLSX files in the folder. To do this, select 'Directory' from the 'Data Source' dropdown menu and then enter the path of the folder containing the XLSX files.

Next, configure the Output Data tool to convert the XLSX files to CSV. To do this, select 'Output to CSV' from the 'Type' dropdown menu and then select 'Delimited' from the 'Format' dropdown menu.

Finally, connect the two tools together to complete the macro. You can then run the batch macro to convert all the XLSX files in the folder to CSV files.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703