Excel to JSON Date Format Issues — Serial Numbers, Wrong Dates, and How to Fix Them

You convert your Excel file to JSON and the date column looks like this: 45000 instead of "2026-03-01". Or you get "2026-01-03T00:00:00.000Z" when you wanted "2026-01-03". Or dates in one column work fine while another column shows gibberish. Date handling is the most common frustration in Excel-to-JSON conversion. This guide explains exactly what's going wrong and how to fix it.

Why Excel Dates Become Serial Numbers in JSON

Here's the core issue: Excel stores dates as numbers internally. January 1, 1900 is serial number 1. January 1, 2026 is roughly 45658. The date "2026-01-01" that you see in your spreadsheet is just Excel displaying that number in a human-readable format.

When a converter reads the cell value without interpreting the cell format, it reads the raw number (45658) and outputs that in the JSON. The date display was purely cosmetic in Excel — the JSON converter saw the underlying number.

This affects cells where the format was applied after data entry, cells pasted from external sources, or cells where the column format was later changed to a date display but the underlying data was already a number.

How Our Tool Handles Dates Automatically

The Excel to JSON converter uses date cell detection — when a cell has a date format applied in Excel, the tool interprets the serial number as a date and outputs it as a string in ISO 8601 format (YYYY-MM-DD). This is automatic for cells that Excel recognizes as dates.

The result looks like this for a date column:

{
  "invoice_date": "2026-03-15",
  "amount": 1500
}

What causes it to fail: cells where someone typed a date as plain text ("March 15, 2026") without Excel recognizing it as a date, or cells where the number was entered directly without a date format applied.

Sell Custom Apparel — We Handle Printing & Free Shipping

How to Fix Serial Numbers Showing in JSON Output

If your JSON output shows numbers like 45000 where you expect dates, here's how to fix it:

Method 1 — Format as Date in Excel first:

1. Select the date column in Excel
2. Press Ctrl+1 (Format Cells)
3. Choose "Date" from the Number category
4. Select a format like YYYY-MM-DD
5. Click OK, then save and re-convert

Method 2 — Use TEXT() formula to force ISO format:

Add a helper column with: =TEXT(A2,"YYYY-MM-DD") — this outputs the date as a text string in ISO format, which will appear correctly in JSON as a string (in quotes).

Method 3 — Fix after conversion:

If you're using the JSON programmatically, you can calculate the actual date from the serial number: date_serial - 25569 gives days since 1970-01-01 (Unix epoch), which most date libraries can convert directly.

Dates With Time Components — ISO 8601 and Timezone Issues

When a cell contains a datetime value (date + time), the JSON output includes the time component: "2026-03-15T14:30:00". This is technically correct but may not be what you want if you're working with date-only values.

To strip the time component: in Excel, format the column as a "Date" type (not "Custom" with time), or use TEXT(A2,"YYYY-MM-DD") to explicitly output just the date part.

For timezone-aware JSON, note that Excel doesn't store timezone information in date cells — all Excel dates are local/naive. If your downstream system requires UTC timestamps, you'll need to append the timezone offset after conversion. The browser tool outputs naive date strings (no timezone designator), which is the safest default.

GST Filing and Financial Date Format Requirements

If you're converting Excel data for GST/GSTR-1 filing, date formats matter because the portal validates the format. GST typically expects dates as "DD/MM/YYYY" or "YYYY-MM-DD" depending on the field.

To ensure the right format: use TEXT(A2,"DD/MM/YYYY") or TEXT(A2,"YYYY-MM-DD") in a helper column to force the exact format the portal expects, then convert that column. The JSON will contain string values in the correct format rather than auto-detected date objects.

This avoids any ambiguity about whether the downstream system will parse the ISO date correctly.

Frequently Asked Questions

Why do some dates convert correctly and others show as numbers?

The difference is usually in how the cell format was applied. Cells properly formatted as Date in Excel will convert correctly. Cells where the date was typed as text, or where formatting was applied inconsistently, may output as serial numbers.

What does "45000" mean as a date serial number?

Excel date serials start from January 1, 1900 (serial 1). To calculate the actual date: add the serial number to 1900-01-01 minus 2 days (Excel has a historical leap year bug). Online serial-to-date calculators can do this instantly. Serial 45000 is approximately September 18, 2023.

Can I convert a date serial to a real date without going back to Excel?

Yes. If you subtract 25569 from the serial number, you get days since 1970-01-01. Multiply by 86400 to get Unix timestamp in seconds. Most programming languages can then convert that to a readable date. Alternatively, Google Sheets can do it: paste the serial number and format as Date.

Does the browser tool handle dates from non-English Excel versions (e.g., localized date formats)?

Yes. Date detection is based on the cell format type, not the display string. So a date formatted as DD.MM.YYYY in a German Excel file will still be correctly identified as a date and output in ISO 8601 format.