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 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