Expand multi-value CSV fields into records
Split interests or tags stored in one cell into individual records without changing original identifiers or other fields.
It is only processed in the browser, not uploading or saving. Leaving the page will be cleared; the calculation can also be cleared and the result can be discarded. Do not enter other people's credentials or private keys.
Expand multi-value CSV fields into records User manual
- Fill in the parameters or select the file according to the form, and check the unit and format first.
- Record 007 contains reading|photography. Choose the vertical bar to produce two records retaining identifier 007.
- Click the processing button to view the results, you can copy or download and save.
Calculation method and processing rules
Expand one field using a literal separator in original record and item order. Empty items may be retained or discarded.
scope of use
Up to 1000 input rows and 2000 output rows or 20000 cells. Headers and leading zeros are preserved; downloaded formula prefixes are neutralized.
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 1000 input rows and 2000 output rows or 20000 cells. Headers and leading zeros are preserved; downloaded formula prefixes are neutralized. Please compare the input unit, rounding method, applicable rules and data version first.