Excel to JSON Converter

A workbook can contain unrelated sheets such as Customers, Orders and Summary.

After you upload the file, the worksheet selector lists every sheet and the preview shows the selected sheet before conversion.

The first physical row is not always the header. Workbooks often contain a report title, a blank row, a generated date or grouped labels above the real field names.

Set the header row number before conversion. When headers are blank or duplicated, the tool warns, generates unique fallback keys and shows the final keys in the preview.

If no header is used, output arrays of arrays or generated keys according to the selected mode.

Numbers

Numeric cells are stored as JSON numbers unless the column should remain text.

Dates

Excel dates may be stored as serial numbers with date formatting. Recognized date cells convert to a documented string format. Numeric cells that are not date-formatted are never guessed as dates.

Booleans

True and false cells are preserved as JSON booleans.

Text and Leading Zeros

Codes such as 00123 remain strings when the workbook stores them as text. The preview exposes values that may lose leading zeros.

Empty Cells

Choose between empty string, null or omitting the property. The selected policy applies consistently.

A formula cell may contain formula text, a cached calculated value or display formatting.

• default to the stored calculated value
• offer formula text as an option
• warn when a cached value is missing

In a merged range, only the top-left cell may contain the value.

• Keep only the top-left value — the default.
• Fill the value across the merged range — useful for report tables, but it can change meaning.
• Warn and leave empty cells.

Completely empty rows can be removed or kept. Columns outside the used data are trimmed automatically.

When you copy cells from Excel or another spreadsheet, browsers receive tab-separated text.

All conversion inputs, including pasted text, are sent to the SolConverter API and storage for processing. Pasted text is uploaded unchanged as text.

Dates appear as numbers

The cell was read as a numeric value without date interpretation. Confirm the source formatting and the date-conversion option.

Leading zeros are missing

The source cell may already be numeric. Format identifier columns as text in the workbook before converting.

Formula results are stale

The converter reads the stored value and does not recalculate formulas. Open and save the workbook before converting if cached values need updating.

Blank headers create invalid keys

API capabilities determine input and table limits. Previews may be truncated; download the full output artifact.

Merged cells create null values

Choose a merged-cell strategy. Filling values across the range is optional and may not fit every workbook.

For large or complex files, start with a representative sample and review the generated output before relying on it.