Split Excel table into sheets by field: 1 click. Optipe DTS → 100 sheets in seconds!
The Split in Sheets application of Optipe Data Tools Suite allows you to split data in an Excel table based on the value of a field or column.
Use this application to:
- Split a table into multiple sheets, depending on the value of a field.
Features:
- The extraction is generated in a new sheet with the data you select from the table.
- You can define the fields to extract.
- To select non-consecutive fields, hold down the Ctrl key and then click each of the items you want to select.
See also:
- Extract Data from Excel Table
- Send Excel Worksheets with Optipe MultiMail
