AK
appkiro.com| # | id | name | role | signup_date | active | |
|---|---|---|---|---|---|---|
| 1 | 1 | Alice Johnson | [email protected] | Admin | 2024-01-15 | true |
| 2 | 2 | Bob Smith | [email protected] | Editor | 2024-02-03 | true |
| 3 | 3 | Carol Williams | [email protected] | Viewer | 2024-02-20 | false |
| 4 | 4 | David Brown | [email protected] | Editor | 2024-03-05 | true |
| 5 | 5 | Eva Davis | [email protected] | Viewer | 2024-03-18 | true |
1[2{3"id": 1,4"name": "Alice Johnson",5"email": "[email protected]",6"role": "Admin",7"signup_date": "2024-01-15",8"active": true9},10{11"id": 2,12"name": "Bob Smith",13"email": "[email protected]",14"role": "Editor",15"signup_date": "2024-02-03",16"active": true17},18{19"id": 3,20"name": "Carol Williams",21"email": "[email protected]",22"role": "Viewer",23"signup_date": "2024-02-20",24"active": false25},26{27"id": 4,28"name": "David Brown",29"email": "[email protected]",30"role": "Editor",31"signup_date": "2024-03-05",32"active": true33},34{35"id": 5,36"name": "Eva Davis",37"email": "[email protected]",38"role": "Viewer",39"signup_date": "2024-03-18",40"active": true41}42]
Excel to JSON converts .xlsx and .xls workbooks into clean JSON right inside your browser. Multi-sheet parsing, type detection, key shaping, and Google Sheets / online file fetching all run locally — no installs, no command line, no copy of your data sitting on a server.
Spreadsheets remain the lingua franca of finance, ops, and research, but APIs, fixtures, configs, and modern apps consume JSON. Manually exporting, renaming columns, fighting UTF-8, and writing throwaway parser scripts wastes hours every week. This tool collapses that loop into a single page: engineers seed databases, QA teams build deterministic fixtures, analysts feed dashboards, and ops hand structured data to systems that expect JSON — without leaving the browser.
.json file.Data Source card hosts three input tabs. Paste content accepts the TSV/CSV that Excel writes when you copy cells; the delimiter is auto-detected. Extract from URLfetches via a server-side proxy that handles Google Sheets export links and direct .xlsx URLs without CORS errors. Upload Excel reads .xlsx/.xls files locally with drag-drop and click-to-browse, up to 25 MB.
Workbook Preview shows the active sheet's rows, sheet tabs for multi-sheet workbooks, a search filter for the preview, and column include/exclude chips for trimming the export.
Parse Settings control how rows become JSON: header row, skip empty rows, coerce values, key style, output shape, and column visibility.
Output JSON renders the result in a compact line-numbered viewer with Copy, Download, and a Pretty / Minified toggle.
column_N keys."42", "true", "null" into native JSON. Disable for IDs, SKUs, postal codes, and phone numbers that must remain literal strings.snake_case for SQL-flavored payloads; camelCase for JavaScript fixtures.snake_case + array of objects + Coerce values on.camelCase + array of objects.new Date() or backend parsers.Uploaded .xlsx and .xls files are parsed entirely in your browser. The Extract from URL tab is the only path that touches the server, and only to proxy the URL you supply so CORS does not block direct fetches. Nothing is stored.
Coerce types converted the string '00123' into the number 123. Disable Coerce types under Parse Settings when IDs, postal codes, SKUs, or phone numbers must remain literal strings.
Workbooks are parsed with cellDates enabled, so true date cells become Date objects and are emitted as ISO 8601 strings (for example 2024-03-18T00:00:00.000Z). Date-shaped strings from CSV stay as strings unless coercion identifies them as numbers.
Switch Output shape to 'All sheets map'. The result becomes { Sheet1: [...], Sheet2: [...] } with each sheet keyed by its name and the active-sheet selection ignored.
The preview is capped at the first 120 rows for responsiveness. Copy and Download both export the full row count, not the preview slice.
Up to 25 MB for both upload and URL fetch. Workbooks parse incrementally inside the browser; close the tab to release memory after large files.
Public Google Sheets links (auto-rewritten to a CSV export) and direct .xlsx or .xls URLs reachable over HTTPS. Auth-walled spreadsheets and local addresses are blocked by the proxy.