FREE ONLINE TABLE TOOL

Split Cells into Rows

Split cells into rows, keeping identifiers and reporting excluded empty items.

No account neededFiles stay on your deviceOriginals preserved

Start with your data

Import data, confirm the rules, review the result, and export a new copy.

◈ Processed on your device
1Import data—2Configure—3Review—4Export

Drop your table here

Drag and drop a CSV, TSV, or delimited text file

UTF-8 · Up to 10 MB per file

Start with your data

File content is processed in your browser, without uploading it.
Kept in page memory · Continue across tools · Refreshing or closing clears the sessionCSV / TSV · UTF-8
Sample library · Normal / Boundary / Error

Clear this session?

Imported data, steps, and results will be released. Export any needed copies first. Original files are unaffected.

A CLEARER WAY TO WORK

Split cells into rows, keeping identifiers and reporting excluded empty items.

Explore the scope, review process, and results in three practical scenes.

01 / SCOPE & PURPOSE

Turn a multi-value cell into a usable detail table

A survey response may contain several selected options in one field.

Illustrative scene for Split Cells into Rows: Turn a multi-value cell into a usable detail table
Illustrative scene
02 / RULES & REVIEW

A worked tag example

Suppose the table contains an id column and a tags column.

Illustrative scene for Split Cells into Rows: A worked tag example
Illustrative scene
03 / RESULTS & NEXT STEPS

Export detail rows and continue carefully

After a full run, choose Export new copy and explicitly select the complete result, excluded sources, or source mapping.

Illustrative scene for Split Cells into Rows: Export detail rows and continue carefully
Illustrative scene
BUILT FOR YOUR TABLES

Available features

Explore the available features and choose what your table needs next.

Turn a multi-value cell into a usable detail table

A survey response may contain several selected options in one field.

Use in the tool

Confirm the input before choosing an item delimiter

Use Choose files, drag a file onto the input area, or select Paste a table.

Use in the tool

Empty items and fully excluded records are different counts

An entirely empty source cell creates one empty item by default.

Use in the tool

A worked tag example

Suppose the table contains an id column and a tags column.

Use in the tool

Check size before running the full expansion

Preview sample and estimate calculates an expected output count and displays a small sample.

Use in the tool

Repeated amounts and source traceability

Every unselected field is copied as text.

Use in the tool
HOW IT WORKS

Three steps to a reviewed result

Confirm the input, inspect changes, and save the output you need.

01

Import and confirm the source

Choose a CSV or TSV file, or paste a table. Check the delimiter, headers, and preview before confirming the full import.

  • Content stays in your browser
  • Source files remain intact
Go to the input area
02

Set the rules, run, and review

Split cells into rows, keeping identifiers and reporting excluded empty items.

  • Process the full dataset
  • Review results and sources
Set processing rules
03

Choose a scope and export a copy

Choose the result or report and CSV or TSV format. Review the export summary and protection count, then confirm download or copy.

  • Read-back verification before export
  • Choose the scope explicitly
Continue in the tool
Need detailed rules, examples, and limits?Read the full guide

Turn a multi-value cell into a usable detail table

A survey response may contain several selected options in one field. A product may have several tags, or an order may list several item codes separated by semicolons. Split Cells into Rows makes one output record for each item in a selected cell. The identifier and every other field are copied into each resulting record. This creates a detail table that can be filtered by individual tags while retaining the connection to the original response or product.

The operation expands exactly one selected column. It does not combine every item in one column with every item in a second column. That kind of Cartesian expansion can create misleading relationships and is outside this tool's scope. If two fields contain parallel lists, first establish how their items correspond. Running two independent row expansions may multiply the record count and should not be treated as evidence that the resulting pairs were present in the source.

Confirm the input before choosing an item delimiter

Use Choose files, drag a file onto the input area, or select Paste a table. Confirm file parsing lets you review how the file itself becomes records and columns. Select Parse and preview, verify the header and quoted fields, then Confirm import. CSV, TSV, and UTF-8 delimited text are supported. A line break inside a correctly quoted field remains inside one logical record even if the source occupies more than one physical text line.

Choose Source column and an item delimiter. The item delimiter can be a semicolon, comma, pipe, tab, newline, or another literal string. It is independent of the delimiter used to parse the file. If a CSV has comma-separated columns but the tags field contains red;blue, choose semicolon for the row expansion. If a field contains commas that belong to item names, those commas cannot simultaneously serve as unambiguous item boundaries without an agreed convention in the source.

The defaults preserve original item text, keep repeated items, and keep empty items. These defaults make the initial result easy to compare with the source. Enable Trim item edges only when surrounding spaces are presentation noise. Enable Remove repeated items within a cell only when repeats are not meaningful. Deduplication is local to each source cell: equal tags on two different products remain two different observations. Item order follows the original cell, including when repeated items are removed.

Empty items and fully excluded records are different counts

An entirely empty source cell creates one empty item by default. This retains a business record even when its tag list is blank. Consecutive delimiters also produce explicit empty items. With a semicolon delimiter, A;;B contains three items: A, an empty string, and B. Keeping those empty items yields three output records. Turning off Keep empty items yields two records and increments the excluded-item count by one.

A source record disappears completely only if no item survives its configured trimming, empty handling, and duplicate rules. For an empty source cell with Keep empty items disabled, one item is excluded and one source record is fully excluded. For A;;B under the same configuration, one item is excluded but the source record still contributes two outputs. The two counters answer different questions. Check both before concluding that a reduction in output count is harmless.

Empty definition provides separate switches for missing cells, empty strings, and whitespace-only content, plus exact additional markers. By default, an ordinary space is an item, and values such as 0, false, NULL, and N/A are text. Trimming item edges can turn a whitespace item into an empty string, after which the empty-item policy applies. This order is intentional and makes the effect of enabling both settings reproducible.

A worked tag example

Suppose the table contains an id column and a tags column. Record 001 has 红;蓝 and record 002 has an empty tags value. Select tags and use a semicolon. With the default settings, the result has three rows: 001 with 红, 001 with 蓝, and 002 with an empty item. The identifier remains text, so its leading zeros survive. The original ordering is retained: all items from the first record appear before items from the second.

Now disable Keep empty items and run again. Only the two rows for 001 remain. The summary reports one empty item, one excluded item, and one fully excluded source record. Excluded records contains the original record for 002, making the disappearance reviewable. Source mapping contains one entry for each surviving output and connects its generated identity to the source record and original item number. Item numbers are not renumbered merely because an earlier item was excluded.

For a different source containing A;A;B, repeated items are kept initially. With local deduplication enabled, the first A and B survive in their original order. With A; A, the two items are distinct until you also enable trimming. These examples explain why trimming and deduplication are separate controls rather than a combined cleanup switch: their interaction changes the meaning of the output and deserves an explicit choice.

Check size before running the full expansion

Preview sample and estimate calculates an expected output count and displays a small sample. The sample itself is limited to twenty visible output records and cannot be used to infer every source pattern. A full expansion still requires Run and review. The worker checks output records, columns, cells, and the source-mapping report against current limits before building the result. It blocks excessive expansion instead of returning a quietly truncated table.

A small input file can expand substantially. A thousand records with a hundred items each already create a hundred thousand detail records before additional fields are considered. Long copied descriptions can also multiply memory use. Reduce the input, shorten an item list through an explicit prior operation, or divide the work when a limit is reported. Cancel task terminates a long-running worker. No partly expanded table is promoted to a successful full result after cancellation.

Repeated amounts and source traceability

Every unselected field is copied as text. If an order total is 100 and the order has three tags, each tag row carries 100. Adding that field across the expanded rows would produce 300, but the expansion did not create two new orders or two additional amounts. Use a business rule that accounts for the original record identity when analyzing such measures. The preview warning is a reminder to distinguish repeated context from a measure that belongs independently to each item.

Source mapping preserves the source identity, file and logical-record location, selected column, and original item ordinal. You may also add Source record and Item number columns directly to the main output using their checkboxes. These optional columns are convenient when a downstream system cannot read a separate mapping report. Their names must not conflict with existing fields. The grid's source location remains available even when those additional exported columns are disabled.

Export detail rows and continue carefully

After a full run, choose Export new copy and explicitly select the complete result, excluded sources, or source mapping. A ZIP contains the result and its reports, with a manifest and safe filenames. CSV and TSV exports go through serialization and read-back checks, including quotes, Unicode, and multiline cells. Formula-prefix protection is selectable and may alter text; inspect the affected count before confirming download. It does not remove the need to choose appropriate text import settings in the receiving application.

Apply to workflow makes the expanded table available to grouped filling or filtering. A useful next step is to fill a department within a customer group while keeping original logical-source locations. Save rules if you need to repeat the same item policy, and verify the next file's field structure when loading them. Changing a delimiter or exclusion rule marks the previous result stale. Switching tools or interface language keeps the current session; refreshing or closing clears it, so retain any needed output before leaving.

Frequently asked questions

How do I put each item from a list cell on its own row?

Select the list column and its literal separator, then review the expansion. The other fields are repeated beside each item so that identifiers remain available. Check the empty-item rule and projected size. If an amount is repeated, do not sum the expanded amount as though each copy were a separate transaction.

Does an empty source cell remove its record?

Not with the defaults. It produces one empty item. If you exclude empty items, the report separately counts excluded items and source records with no surviving output.

Can I keep an ID alongside each survey option?

Yes. Every unselected field is copied to each expanded row, including the ID. The mapping report also retains original record and item positions.

Why did the total amount appear to increase?

Amounts are copied context, not newly created transactions. Summing the repeated amount over every item row can multiply an original total. Use the source identity when applying your business aggregation rule.

Can I expand several list columns together?

This version expands one column at a time. It does not infer item correspondence or silently create combinations across list columns. Establish that relationship before designing a multi-step transformation.

Ready to work with your table?

Start with a sample to learn the workflow, then process your own files.