Header rows and JSON objects
With headers enabled, each remaining row becomes an object. Empty header cells receive column_1-style names, and repeated names receive suffixes. Without headers, every row stays an array, including the first. Missing cells become null in object output. Column names are literal strings, so a period in a header does not automatically create nested objects.
All-sheet output and cell types
Selecting all sheets produces an object whose keys are sheet names and whose values are row arrays. Typed mode keeps stored numbers and booleans and represents date cells as ISO strings. Formatted mode exports displayed cell strings instead, which is useful for formatted account codes or dates. A JSON date is a string because JSON has no date type.
Workbook values and pasted tables
Workbook input preserves the saved cell types. Pasted tab-separated text contains text values rather than the original workbook cell metadata. Formula results must already be saved in the workbook; this tool does not calculate formulas. Review key names and null cells in the editable output before importing the JSON into another system.
Format references
Spreadsheet utilities · JSON format
File content is read and converted in the browser. Conversion does not upload the source to a server.