# How to split multiple worksheets into multiple files?

**URL:** <https://community.unix.com/t/how-to-split-multiple-worksheets-into-multiple-files/338472>\
**Category:** Shell Programming and Scripting\
**Created:** [January 9, 2014, 6:16am UTC](https://community.unix.com/t/how-to-split-multiple-worksheets-into-multiple-files/338472 "2014-01-09T06:16:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Abhisrajput](https://community.unix.com/letter_avatar/abhisrajput/32/5_5575768a8748004e209b776fc1b2916d.png) [@Abhisrajput](https://community.unix.com/u/Abhisrajput)\
**Post date:** [January 9, 2014, 6:16am UTC](https://community.unix.com/t/how-to-split-multiple-worksheets-into-multiple-files/338472/1 "2014-01-09T06:16:52Z")

</div>

Dear all,  
My source contains excel file with multiple worksheets. As part of project requirement I need to split all the worksheets into multiple files in ETL.

For Example,  
Source File (A.xls) contains multiple worksheets B,C,D then Output should  
B.xls  
C.xls  
D.xls

Can anybody help me out, how to achieve it by Perl script.

Thanks  
Abhishek

---

<div class="post-metadata">

**Author:** ![rakeshkumar](https://community.unix.com/letter_avatar/rakeshkumar/32/5_5575768a8748004e209b776fc1b2916d.png) [@rakeshkumar](https://community.unix.com/u/rakeshkumar)\
**Post date:** [January 9, 2014, 6:51am UTC](https://community.unix.com/t/how-to-split-multiple-worksheets-into-multiple-files/338472/2 "2014-01-09T06:51:53Z")

</div>

This might be helpful  
[PERL: Split Excel Workbook to Indiv Excel files | Unix Linux Forums | Shell Programming and Scripting](http://www.unix.com/shell-programming-scripting/82612-perl-split-excel-workbook-indiv-excel-files.html)