Combine & Split5 min read
How to Combine Two Columns in Excel & CSV (Formulas vs 1-Click)
Compare =A2 & " " & B2, CONCAT, and TEXTJOIN against a visual zero-formula combiner. Handles spaces, commas, blank cells, and leading zeros.
Illustrated Workflows • Real UI Screenshots • Zero Server Uploads
Spreadsheet Tutorials & Conversion Guides
Every guide pairs the manual Excel or Google Sheets formula method with a 1-click browser workflow you can run immediately — without installing desktop plugins or uploading spreadsheets to remote servers.
Combine & Merge6 min read
How to Merge Excel Sheets & Run VLOOKUP Without Formulas
Match and enrich rows across workbook tabs using a Left Join or vertically append stacked sheets without #N/A formula errors.
Format Conversion4 min read
Convert Excel & CSV to Markdown Tables (and Import Markdown Back)
Turn spreadsheet ranges into aligned GitHub Flavored Markdown pipe tables for READMEs and docs, or paste Markdown right back into editable cells.
Format Conversion6 min read
CSV vs TSV vs JSON, YAML & SQL Export: Which Format Fits Your Task?
Avoid delimiter collisions in addresses, export typed JSON or JSONL for APIs and pipelines, and generate ready-to-run SQL CREATE + INSERT scripts.
Formatting & UX5 min read
Style Multi-Selected Cells in Your Browser & Keep Colors in XLSX Export
Use Ctrl/Cmd range selection, fill and font color pickers, maximize mode, offline PWA install, and true styled .xlsx export in local memory.
Data Cleaning5 min read
How to Audit, Deduplicate, Sort & Clean Messy CSV Data Fast
Profile column fill counts, duplicates, and numeric ranges before trimming spaces, normalizing case, deduplicating, sorting, and transposing.
Troubleshooting5 min read
Excel Formula Not Calculating? 6 Exact Fixes & Causes
Fix formulas displaying as literal text, SUM() returning 0, Manual Calculation locks, Show Formulas mode, and hidden non-numeric spaces.
Data Cleaning5 min read
Excel Formula to Find Duplicates (COUNTIF, Multi-Column & Removal)
Copy working COUNTIF and COUNTIFS formulas to flag repeats or mark second copies only, or purge duplicates safely after trimming.
Data Cleaning5 min read
Fix Dropped Leading Zeros in Excel ZIP Codes & Extract Text
Stop desktop Excel from wiping zeros on 02134 ZIP codes when opening CSVs, pad 5-digit text codes, and split or extract delimited strings.
Troubleshooting5 min read
Fix Excel #SPILL!, #N/A, #VALUE! & #REF! Errors Fast
Clear blocking spill ranges, eliminate trailing spaces behind false #N/A matches, and join messy CSVs visually with zero formula breakage.
How Tools Work5 min read
How XML to CSV & Excel Parsing Works (Repeating Tags & CDATA)
Step-by-step look inside client-side XML tag detection, @attribute extraction, CDATA unwrapping, and RFC-4180 export in browser memory.
How Tools Work4 min read
How JSON & NDJSON to CSV/Excel Conversion Works Locally
Learn how JSON arrays and line-by-line NDJSON logs flatten sparse keys into uniform spreadsheet tables without uploading API dumps.
How Tools Work5 min read
How Merging Multiple CSV Files Works (Append Rows vs Left Join)
Understand vertical header-aligned stacking and O(1) trimmed Left Joins that match keys cleanly without #N/A errors.
How Tools Work4 min read
How SheetCombine Works 100% in Browser RAM (Zero-Upload Architecture)
Explore how FileReader parsing, 2D matrix transforms, formula evaluation, and Blob exports operate with zero server uploads.
How Tools Work4 min read
How CSV Delimiters Work in Excel (Comma vs Semicolon & UTF-8)
See how quote-aware delimiter detection separates commas, semicolons, tabs, and pipes cleanly across US and European Excel locales.
Jump Directly to Any Interactive Tool
Each workspace opens the browser spreadsheet engine pre-oriented around that task.
Full Editor
All tools + multi-tab workbook
Excel Online (No Login)
Browser grid + Chrome/Linux PWA
Google Sheets <-> Excel
Convert Sheets & Forms cleanly
Open .XLS & .ODS Online
View legacy .xls & LibreOffice files
New Blank Sheet
Clean canvas + demo or paste
Combine Columns
Merge columns with delimiter
Merge CSV Files
Stack CSVs or join by key ID
XML to CSV Converter
Parse repeating tags & attributes
JSON to CSV Converter
Flatten API arrays & NDJSON
Excel to JSON
XLSX / CSV -> JSON arrays
FR: XML en CSV
Convertisseur XML en CSV / Excel
VLOOKUP Multi-Criteria
2+ key lookup & join tool
XLOOKUP Multi-Criteria
XLOOKUP, INDEX/MATCH & SUMIFS
Formula Generator
TEXTJOIN, COUNTIF, MID, SUMIF
Clean CSV Online
Trim, dedupe & keep zeros
JSON & XML to Excel
Parse JSON, JSONL & XML payloads
CSV to SQL (.sql)
CREATE TABLE + INSERT export
Split Columns
Break full names or paths apart
Merge & Join Sheets
Left join or append rows
Markdown Table (.md)
GFM pipe table generator
CSV to TSV (.tsv)
Tab-delimited export & import
JSON / YAML / SQL
Structured dev exports
Remove Duplicates
Key-based row deduplication
Sort & Filter Rows
Multi-type sort & live filters
Transpose Table
Flip rows and columns
Excel <-> CSV
Client-side XLSX/CSV convert
