Posted on: July 23, 2020 Posted by: ndconsultingllc Comments: 0

Excel – Multiple Tabs to CSV

Using PowerShell, it's very easy to separate an Excel workbook with multiple tabs into separate CSV files or separate Excel files.

Using PowerShell, it’s very easy to separate an Excel workbook with multiple tabs into separate CSV files or separate Excel files.

In the below example, I have an Example workbook that has about 50 tabs. I want each tab to be a separate CSV file.

By running this PowerShell script you can easily separate each tab into it’s own file.

                                  

Excel – Multiple Tabs to CSV was last modified: August 10th, 2020 by ndconsultingllc
Categories: