Feeding data to a program
Export the xlsx a colleague sent over as an array-of-objects JSON and use it directly as API test data or configuration.
Guide
Excel Converter is for opening a spreadsheet in the browser, taking one look at it, and turning it into something else: xlsx, xls and csv go out as XLSX, CSV, JSON, an HTML table or a Markdown table, and in the other direction a pasted JSON array becomes an .xlsx. Parsing and writing are both done by SheetJS inside the browser, and a workbook with several sheets can be exported one tab at a time.
Updated 2026-09-094 min read
Excel Converter is for opening a spreadsheet in the browser, taking one look at it, and turning it into something else: xlsx, xls and csv go out as XLSX, CSV, JSON, an HTML table or a Markdown table, and in the other direction a pasted JSON array becomes an .xlsx. Parsing and writing are both done by SheetJS inside the browser, and a workbook with several sheets can be exported one tab at a time.
It is a format changer, not an online spreadsheet editor. To print a sheet as PDF, click “Convert to PDF (new tool)” to hand the current file over to “Excel to PDF”; and if you only want to flick through a large table on a phone, “Excel and CSV Viewer” is lighter.
_<sheet name>. The JSON shape can be “array of objects (first row as keys)” or “array of arrays”.data.xlsx (a single Sheet1).| Input | Output | Notes |
|---|---|---|
sales.xlsx with the sheets “North” and “South”, exporting the active “South” as CSV |
<original-name>_South.csv, starting with a UTF-8 BOM |
Excel opens it on a double-click without mojibake |
| The same workbook as JSON (array of objects) | [{"customer":"A","amount":1200,"note":null}, …] |
Empty cells are written as null |
Pasting [["name","age"],["Ann",25]] |
data.xlsx with two rows and two columns in Sheet1 |
In an array of arrays the first row is not treated as keys |
Export the xlsx a colleague sent over as an array-of-objects JSON and use it directly as API test data or configuration.
Export or copy the Markdown table and paste it into a README, a wiki or a chat tool, with no vertical bars to type by hand.
Paste the array from an API response into “JSON to Excel” and hand the xlsx to a colleague who does not write code.
That is the UTF-8 BOM, which lets Excel recognise the encoding and show Chinese text correctly on a double-click. When reading the file from code, open it with a BOM-aware reader, or re-save it without the BOM in a text editor.
Click that worksheet's tab above “Data preview” and then the export button; every format except XLSX covers the active sheet only, and the file name carries the sheet name.
The most common cause is that the file is not UTF-8 — a GBK CSV exported by an old version of Excel, for instance. Run “Text Encoding Converter” on it first.
Spreadsheets and pasted JSON are parsed and generated locally in the browser, and the content is never uploaded to any server; the data leaves memory when the page is closed.
Updated 2026-09-09
Preview and convert xlsx/xls/csv to CSV, JSON, HTML or Markdown, and build Excel back from JSON
Supports xlsx / xls / csv; CSV must be UTF-8
Paste a JSON array (of objects or a 2D array) and generate a .xlsx file from it