Guides
Practical Excel how-tos, no fluff.
Clear, step-by-step guides to the everyday spreadsheet tasks: translating formulas, converting between Excel, CSV and JSON, and merging workbooks. Each one is backed by a free tool that runs entirely in your browser.
How to Compare Two Excel Files (Row and Cell Diff)
Diff two spreadsheets to see what was added, removed or changed, down to the individual cell.
Read guideHow to Convert CSV to SQL INSERT Statements
Generate ready-to-run INSERT statements from a CSV, with a table name and dialect you choose.
Read guideHow to Convert CSV to XML
Turn a CSV into valid XML, choosing element names and whether values are tags or attributes.
Read guideHow to Extract a Column from a CSV
Keep only the columns you need from a wide CSV, and reorder them while you are at it.
Read guideHow to Merge CSV Files (Align Columns, Keep Every Row)
Combine many CSVs into one file, matching columns by name so mismatched files still line up cleanly.
Read guideHow to Remove Duplicate Rows from a CSV
Drop repeated rows from a CSV, matching the whole row or just the columns that define a record.
Read guideHow to Split a CSV File (By Rows or By a Column)
Break a big CSV into evenly sized pieces, or one file per category, with the header carried into each part.
Read guideHow to Transpose Excel Rows to Columns
Flip a table on its side so rows read as columns, then copy it or save it as a workbook.
Read guideHow to Convert CSV to Excel Without Breaking Data
Build a real XLSX from a CSV with typed cells, instead of double-clicking and watching Excel mangle your data.
Read guideHow to Convert Excel to CSV (One Sheet, Clean Output)
Export one sheet to CSV with the right delimiter and quoting, so the file imports cleanly into any tool.
Read guideHow to Convert an Excel Sheet to an HTML Table
Get a semantic HTML or Markdown table from a sheet, instead of the heavy styled markup Excel copies.
Read guideHow to Convert Excel to JSON (Array of Row Objects)
Map a sheet to an array of objects keyed by your headers, the shape most APIs and apps expect.
Read guideHow to Convert JSON to Excel (Array to Workbook)
Map an array of objects to a real XLSX, with keys as headers and objects as rows, straight from an API response.
Read guideHow to Merge Excel Files Into One
Two ways to combine workbooks: a tab per file, or stack matching columns into one continuous table.
Read guideHow to Translate Excel Formulas Between Languages
Why SUM becomes SUMME and SOMME, and how to move a formula between language versions of Excel without the #NAME? error.
Read guideSkip the reading — just use the tools
Every guide is backed by a free, in-browser tool. Browse them all.
See all file tools