CSV column selection and rearrangement
Extract, delete, or rearrange CSV fields by column number, leaving text and leading zeros.
CSV column selection and rearrangement User manual
- Fill in the parameters or select the file according to the form, and check the unit and format first.
- Enter 1, 3, 2 to rearrange the first three columns as the first, third, and second columns.
- Click the processing button to view the results, you can copy or download and save.
Calculation method and processing rules
The column number starts from 1, and the selected column is output in the order of filling; if the column is not enough, the null value is filled, and the prefix of the protection formula is prefixed when downloading.
scope of use
Up to 200 columns, 2000 rows, do not retain excel styles, blank rows are ignored.
Does the column number include the header?
The column number refers to the column position from left to right, and the first row is also handled according to the same rules. Enter 3,1 to put the third column in front of the first column; the delete mode will keep the original order of the remaining columns, and all columns are not allowed to be deleted.
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 200 columns, 2000 rows, do not retain excel styles, blank rows are ignored. Please compare the input unit, rounding method, applicable rules and data version first.