Online Spreadsheet Editor, Column Combiner & Format Converter
Edit multi-sheet workbooks right in your browser. Merge columns or stack files, sort, filter, run formulas, and export to .xlsx, .ods, .csv, .tsv, .md, .json, .sql, or .yaml.
Drop XLSX, CSV, TSV, Markdown (.md), or JSON here
Runs locally inside browser memory. Multi-sheet workbooks open into tabs automatically.
Combine Two or More Columns
Merge 2+ columns cleanly without writing formulas.
Split Column by Delimiter
Remove Duplicate Rows
Find & Replace
Sort Rows
Filter or Delete Matching Rows
Fill, Prefix / Suffix & Extract Column
Merge Multiple Files / VLOOKUP Join Sheets
Append rows from multiple files/tabs or join two sheets by a key column.
Option A: Stack / Append All Open Sheet Tabs
Option B: VLOOKUP / Left-Join Two Sheets by Key
Format Preview & Export Converter
Column Profiler & Quick Summary
| Col | Header | Filled | Blank | Unique | Dupes | Min / Max / Avg |
|---|
Paste CSV, TSV, Markdown Table, JSON, or HTML
Confirm Action
Combine Columns
Merge 2 or more columns with spaces, commas, dashes, or custom text while skipping blanks.
Merge & Join Sheets
Append multiple CSV/Excel tabs by header name or run a VLOOKUP left-join on key columns.
Markdown Table (.md)
Convert Excel/CSV to GitHub-Flavored Markdown tables or paste raw `.md` back into cells.
TSV, JSON, SQL & YAML
Export `.tsv`, `.jsonl`, SQL `INSERT` scripts, `.html`, `.xml`, and `.ods` cleanly.
Split Column & Extract
Split names, addresses, emails, or regex patterns into clean separate columns.
Sort & Filter Rows
Numeric or A-Z sorting, rule-based row filtering, and 1-click blank row removal.
Remove Duplicates
Purge duplicates across the whole row or match on a single column like Email or SKU.
Transpose & Fill Down
Swap rows into columns, fill blank cells down, strip HTML tags, or add prefix/suffix.
How to Combine Columns in Excel (4 Tested Methods + Online Tool)
Merging a First Name in Column A with a Last Name in Column B into a Full Name column is one of the highest-volume Excel tasks. Use the 1-click Combine Columns button in the green bar above, or copy one of the four standard desktop Excel formulas below.
1. Ampersand Operator (&)
Works in every Excel version and directly inside SheetCombine's formula bar.
2. TEXTJOIN (Skips Blanks)
Ignores empty middle-name cells so you never get awkward double spaces.
3. CONCAT Function
Replaces legacy `CONCATENATE` in Excel 2019, Microsoft 365, and Google Sheets.
4. Flash Fill (Ctrl + E)
Type `"John Smith"` in row 2 next to your source columns, press Enter, then hit `Ctrl + E` in desktop Excel to fill remaining rows statically.
Supported Import & Export Formats
| Format | Extension | Best Use Case |
|---|---|---|
| Excel & Calc | .xlsx, .ods | Multi-sheet workbooks with all tabs preserved. |
| Delimited Text | .csv, .tsv, .txt | RFC-4180 CSV, tab-separated TSV, EU semicolon CSV, or pipe-delimited logs. |
| Markdown & Web | .md, .html | GitHub READMEs, docs, Notion/Obsidian notes, and standalone HTML tables. |
| Developer Data | .json, .jsonl, .sql, .yaml, .xml | APIs, NDJSON streams, database `INSERT` seeds, config files, and feeds. |
Step-by-Step Illustrated Guides & Formula Tools
All 9 Guides →Combine Columns Without Errors
Compare &, CONCAT, and TEXTJOIN against 1-click joining.
VLOOKUP Multiple Criteria
Generate multi-key XLOOKUP / INDEX-MATCH formulas or join workbook tabs.
Excel Formula Not Calculating?
Fix Manual mode, Text lock, Ctrl+`, and dirty spaces in 6 steps.
