Split Excel by Column Value
Split the worksheet by department, city, etc., and package and download multiple xlsx files.
Split Excel by Column Value User manual
- Fill in the parameters or select the file according to the form, and check the unit and format first.
- The orders will be split into two forms in Qingdao and Weifang by city column.
- Click the processing button to view the results, you can copy or download and save.
Calculation method and processing rules
The first behavior header, grouped in the original text of the specified column, each group retains the same header.
scope of use
Up to 100 groups, only cell text is reserved, no styles, macros, or formulas are reserved.
Will the input content be saved on the server?
This tool handles input in the browser, and does not upload files or form content. Typing practice scores are only saved in the native browser.
Why may the result be different from other tools?
Up to 100 groups, only cell text is reserved, no styles, macros, or formulas are reserved. Please compare the input unit, rounding method, applicable rules and data version first.