CSV Inputs into one Excel document

[slinky123]

Hi All,

I have a number of CSV files that are held in one folder and I would like to consolidate all of the data into one Excel spreadsheet.

E.g. File1 -> Tab 1, File2 -> Tab 2 etc. of the newly created Excel spreadsheet.

I have used the directory tool so can now see the full path of each file, the directory and filename but I am not sure where to go next.

Any ideas?

Many thanks,
Scott

[BenMoss]

Do you have a black box with a question mark in it @slinky123?

[slinky123]

Yes I do Ben.

[BenMoss · Accepted solution]

Okay, so can I ask you to delete that tool.

Then right click on the canvas and hit 'Insert > Macro'

Then navigate to the file 'Batch Macro.yxmc' which should exist in your unzipped folder.

Next step is to connect the directory tool to this macro.

Then, configure the macro, so select the full path field 'Full Path'. Specify an output location (where you want to write the .xlsx file too), and then the name of the .xlsx file you wish too write.

Then you should be able to run it.

Ben

[slinky123]

Fantastic! Works a dream! Can't thank you enough Ben, you're a legend1

[jn]

Hello BenMoss,

I need help to reach one sheet from a .csv file

I get error if i use a formula tool to pass the file path of .csv to  my batch macro. 

[FullPath] + "/" + "Sheet1$" works file with .xlsx

this does not work for .csv file. Do you happen to know the input path for one sheet in .csv to be passed to a batch macro.