How to split data into multiple (separated) Worksheets in Excel

How to split data into multiple (separated) Worksheets in Excel.

🡻 Download the free add-in here 🡻

FAQ
--------
1. How to install an Excel add-in?

2. How to fix the disappearing ribbon in Excel?

If you have an issue, don't hesitate to write to us:

In this #ExcelTutorial we'll show you how to use our free DataXL add-in to create multiple sheets basis on one-column values and then transfer data on each sheet.

We developed this tool for data split on multiple worksheets.

All right, so I'm here in the practice file.
In this example, we would like to split the range into 12 sheets by month.
Go to the DataXL tab on the ribbon.
Select the Range icon.
Select the 'Split range by sheets' option from the list.
Let's see the userform.
Add a source range.
Select the 'number of rows in header' option and enter the value. In this case, one.
Choose a splitting method; in this case, we want to split the range by columns.
Click OK.
Now we have 12 sheets that contain the monthly data.

If you want to learn more about Excel, visit our website - #ExcelTips
Our add-in is compatible with Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Office365

[SoPHIsticAtedGuy]

Oh let me figure out how to download this add on. This would be so helpful

[alicehuynh]

This video is really helpful. Thank you so much for that!

[AmeerAlDroubi]

Thank you very much you are a lifesaver 💗💗

[nicolewuethrich]

Thank you so much, this works perfect!

[godfather]

I've noticed at times this disrupts excel auto-ask to save feature when clicking on the X to close out of a workbook. Not sure if this is something that is known or can be resolved but wanted to share my experience so far. Otherwise this is just what I needed for my documents. Thanks

[stephanierosen]

wow, actually works really well, thank you for sharing FREE

[hillbillyblaze]

This is great. Save time and hassle from tracking down macros.

[florentinadanci-cnlrbistri]

Very usefull add-in for Excel! Thank you!

[andrewgitto]

I have formulas that are generated from separate charts in the master sheet. how do i get formulas to transfer over as well

[LeslieMatos]

Awesome! Worked so fast! This saved me so much time. THANK YOU!

[srikishanpallod]

This have saved me!! Thank you for making works so simple.
Almost did my 3 hrs work in 10 minutes.
Goddess Saraswati bless you with more knowledge so that you can help humanity.

Thanks again!!

[flortirelli]

Great video! Thanks :)
Greetings from Argentina

[rekhaprajapati]

Sir, can you help me from where I get the option of tools Data XL ?

[krishnatate]

Thx lot's sir.... Ur amazing sir....
Today is my so big happy day, u r really great sir... Amazing ur all videos... Thx...

[abduljaleelpanthakkan]

If you add a new column in the split excel sheets, what should you do to get to the main sheet?

[bettyegan]

It doesn't seem to like formatting, especially text-wrapping. If I have text wrapping in my headers it sets the row depth really high in the resulting sheets. The formatting doesn't seem to carry over well into the split sheets.

[vikasgaur]

Suppose, in column 'A' we have an entry multiple times. So will one entry in an individual worksheet create a worksheet with multiple rows? for example : column 'A' jan is multiple time, after running this macro will all 'jan' entry comes in 'jan worksheet'.? thank you

[Pathan]

This is working great but it expands cells width, can you please help with keeping the same width of cells as in my original sheet?

[pikiniki]

thanks for sharing this. It works fine, however when try to add a Macro button for the steps in the Add in, the macro doesn't work. Any solution ?

[situtul]

thank you so much. I subscribed to your Channel and notification button on.