Importing from CSV data to Excel

Importing multiple CSV files from a source location to a single excel file with each tab named with loaded CSV filename. In this blog, we will go through steps to automate the above task via Windows's Power Shell and via UNIX's Perl scripting. Step 1: Open up a PowerShell console, and navigate to the folder … Continue reading Importing from CSV data to Excel