Split Multi-Value Excel Cells Into Clean Rows

Built for data analysts, operations teams, and anyone who works with Excel tables. Paste a table with cells like "red;blue;green", pick your delimiter, and expand every value into its own row or column — then export normalized CSV or Excel data in one click. No manual copy-paste, no formulas, no signup.

Results update live as you type — no button needed. The Example button fills a sample input.

Why use Excel Multi-Value Cell Splitter?

Instantly expand multi-value cells into separate rows or columns

Supports comma, semicolon, newline, pipe, and custom delimiters

Paste directly from Excel or upload CSV files

Export normalized data as CSV or Excel-ready JSON

Handles quoted fields, mixed delimiters, and large tables

FAQ

What is a multi-value cell in Excel?

A multi-value cell contains several values separated by a delimiter, such as "red;blue;green" or "New York, London, Tokyo". Excel's newer array features and manual data entry often produce these cells, but they are hard to analyze until each value is split into its own row or column.

Which delimiters can I use to split cells?

You can split on comma, semicolon, pipe, newline, tab, or any custom character. The tool automatically detects quoted fields so values containing commas are handled correctly.

Can I split cells into rows instead of columns?

Yes. Choose the row expansion mode to turn each value into a separate row while repeating the other columns. This is ideal for pivot tables, filtering, and database imports.

Is my Excel data uploaded to a server?

No. All splitting happens locally in your browser. Your data never leaves your device, making it safe for sensitive business or customer information.

Can I export the result back to Excel?

Yes. After splitting, copy the normalized CSV output and paste it into Excel, or download the CSV file and open it directly in Excel or Google Sheets.

Example input

Try it with this sample — paste it into the box above:

Name,Tags,Priority
Alice,"red;blue;green",High
Bob,"yellow;purple",Medium
Carol,"orange;pink;cyan",Low

How to use Excel Multi-Value Cell Splitter

  1. Enter or paste your data into the Paste your Excel table (CSV format) box above.
  2. The result appears instantly in the Normalized JSON output box — everything runs in your browser, nothing is uploaded.
  3. Use Copy or Download to keep the result, or Example to load a sample first.

Related tools

🔧

CSV Injection Detector - Scan CSV Formula Payloads

Detect CSV injection and formula injection payloads in CSV cells before they run in Excel

🔧

CSV Join Online – Merge Two CSV Files by Key

Merge two CSV files online by a shared key. Paste both CSVs, pick the join key, and get a

🔧

CSV to JSON Converter — A Love Letter to CSV

Convert CSV to JSON instantly. A love letter to the CSV format: celebrate simplicity, unlo
🔧

CSV Mojibake Fixer - Fix Garbled CSV Encoding to JSON

Fix garbled CSV text caused by encoding mismatches like Shift_JIS, EUC-JP, or GBK. Paste m
🔧

CSV Viewer - View CSV Files Online as JSON

Free online CSV viewer. Paste CSV data and instantly preview it as structured JSON. Inspec
🔧

OOXML Excel Editor - Convert XLSX CSV to JSON Online

Free online OOXML Excel editor and spreadsheet converter. Paste your XLSX/CSV export and i

← All tools