CSV table row column transposition
Swap the rows and columns of CSV, and support Chinese, quotation marks, line breaks and empty cells.
CSV table row column transposition User manual
- Fill in the parameters or select the file according to the form, and check the unit and format first.
- Name, Xiao Wang, Xiao Li and Quantity, 2 and 3 lines can be converted into three lines.
- Click the processing button to view the results, you can copy or download and save.
Calculation method and processing rules
Swap rows and columns according to standard CSV parsing, and fill in null values for shorter rows, and output reserved field text.
scope of use
When downloading CSV, add single quotation marks to protect the formula prefix, and do not retain the table style.
Will the original numbers and empty cells change after transpose?
The fields are parsed according to the text, and do not take the initiative to change the leading zero into a number; the short line is filled into an empty cell. In order to reduce the risk of injected form formulas, fields that may be recognized as formulas are quoted in single quotes. Blank lines do not participate in transpose.
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?
When downloading CSV, add single quotation marks to protect the formula prefix, and do not retain the table style. Please compare the input unit, rounding method, applicable rules and data version first.