I have a lot of CSV files (>150) all with the same columns (5) amount, separated with ";" and all with the same column data.
Question:
How can I get those files copied into 1 major file and then transform it into a .XLS file?
Here the excel columns I want:
[TABLE="width: 500"]
<tbody>[TR]
[TD]site_page_url
[/TD]
[TD]domain
[/TD]
[TD]email_address
[/TD]
[TD]site_name
[/TD]
[TD]remarks
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Question:
How can I get those files copied into 1 major file and then transform it into a .XLS file?
Here the excel columns I want:
[TABLE="width: 500"]
<tbody>[TR]
[TD]site_page_url
[/TD]
[TD]domain
[/TD]
[TD]email_address
[/TD]
[TD]site_name
[/TD]
[TD]remarks
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]