Steps
- Upload your workbook - Drop an .xlsx, .xls, .xlsm, or .xlsb file. Parsing happens locally, so nothing is uploaded.
- Pick the sheet - Multi-sheet workbooks let you choose which tab to convert.
- Choose the output shape - Use the first row as keys to get an array of objects, or keep raw rows as arrays. Pretty-print for readability.
- Copy or download - Copy the JSON to your clipboard or download it as a .json file.
Before You Start
- The first row usually works best as column headers - clean them up before converting.
- Empty cells become null values so row lengths stay consistent.
- Dates arrive as Excel's underlying values; format them as text in Excel first if you need ISO strings.
Alternative Methods
- Power Query (desktop Excel) - Transform a table and output JSON via Power Query's advanced editor - powerful but requires writing M code.
- Scripting - Python (pandas.read_excel + to_json) or Node.js (SheetJS) work well for automated pipelines.