TapCub is live — analytics, insights and live chat, free on one platform

Excel to CSV · JSON Excel to JSON: convert XLSX rows into JSON objects

Turn a spreadsheet into data a script or an API can use. Each row becomes an object keyed by the header row, numbers and TRUE / FALSE keep their types, dates become ISO strings, and empty or duplicate headers get safe names. One sheet or the whole workbook.

  • Files stay on your device
  • Header row as keys
  • One sheet or all sheets

Convert Excel to JSON

Choose an .xlsx file. The JSON appears below; change the sheet or the shape at any time.

Convert

No file yet. Choose or drop an .xlsx file, or try the sample workbook.

    Raw keeps 1234.5 and 0.256; as shown gives 1,234.50 and 25.6%.

    How Excel cells are written

    Each row was converted with the same code the tool runs. Excel stores a date as a day count (46344) and a percentage as a fraction; the converter reads the cell format to write them the way you expect.

    How Excel cells are written
    CellExcel showsCSV (raw)CSV (as shown)JSON
    Number, 2 decimals1,234.501234.51,234.501234.5
    Percentage25.6%0.25625.6%0.256
    Date18/11/20262026-11-182026-11-18"2026-11-18"
    Date and time18/11/2026 09:302026-11-18 09:30:002026-11-18 09:30:00"2026-11-18 09:30:00"
    ID stored as text110105199003071239110105199003071239110105199003071239"110105199003071239"
    TRUE / FALSETRUETRUETRUEtrue
    Error#DIV/0!#DIV/0!#DIV/0!"#DIV/0!"
    =0.1+0.20.30.30.30.3

    Formulas are not recalculated: the converter uses the result Excel saved with the file. Files saved by some tools without results show those cells empty, and the tool tells you.

    Your files never leave this device: they are read and converted by your browser, and nothing is uploaded to TapCub or anyone else. To check, open your browser’s developer tools, go to the Network tab and run the tool: no file is sent.
    Read the result

    What a CSV keeps and what it drops

    CSV is plain text: one line per row, values separated by a delimiter. That makes it readable by almost anything, and it also means some workbook features cannot come along.

    Values

    Text, numbers, dates, TRUE / FALSE and error codes come across. Numbers are written without thousands separators so other programs read them as numbers; switch to “As shown in Excel” if you need the formatted look.

    Dates

    Excel stores dates as a count of days since 1900 (or 1904 in some old Mac files). The tool reads each cell’s format and writes ISO 8601, which databases, Python and JavaScript parse without guessing the day-month order.

    One sheet per file

    A CSV holds one table. Pick the sheet to convert, or download all sheets in a ZIP. Hidden sheets are listed and marked.

    Left behind

    Formulas (their results are kept), formatting, colours, comments, charts, pictures, filters and data validation. Merged cells are split; by default each cell repeats the value.

    Opening the CSV in Excel again? Turn on the UTF-8 BOM, or Excel may show accented letters and Chinese as garbled text.

    How to use it

    Convert Excel to CSV in four steps

    The defaults suit a database import or a script.

    1. 1

      Choose the .xlsx

      Drop it on the box or click to pick it. Old .xls files need to be saved as .xlsx first.

    2. 2

      Pick the sheet

      The first visible sheet is selected. Every sheet, including hidden ones, is in the list.

    3. 3

      Set the output

      CSV, TSV or JSON; delimiter; quotes; raw or displayed numbers; a BOM if the file goes back into Excel.

    4. 4

      Download or copy

      Download the file, all sheets as a ZIP, or copy the text into another tool.

    How it works

    How the converter reads an .xlsx file

    An .xlsx file is a ZIP archive of XML files (the Office Open XML format, ECMA-376). The tool unpacks it with the browser’s built-in decompression and reads only the parts it needs.

    • xl/workbook.xml lists the sheets, their order, whether they are hidden, and whether the file uses the 1900 or 1904 date system
    • xl/sharedStrings.xml holds every piece of text once; cells point to it by number
    • xl/styles.xml says which number format each cell uses, which is how a date is told apart from a plain number
    • Each xl/worksheets/sheetN.xml holds the cells: value, type and the result of any formula
    • CSV output follows RFC 4180: fields with the delimiter, quotes or line breaks are quoted, lines end with CRLF
    Parts of an .xlsx file the tool reads
    PartWhat it holdsUsed for
    xl/workbook.xmlSheet names and orderThe sheet list
    xl/sharedStrings.xmlAll text, stored onceText cells
    xl/styles.xmlNumber formatsDates, percentages
    xl/worksheets/*.xmlRows and cellsThe values you get
    mergeCells in each sheetMerged rangesFilling merged cells
    Worked example

    A sales sheet becomes CSV

    A sheet with an order number, a customer, an amount formatted as currency, a payment date and a tracking number stored as text.

    From Excel cells to a CSV line
    ColumnExcel showsStored in the fileCSV gets
    order_id100110011001
    customerChloé MartinText “Chloé Martin”Chloé Martin
    amount€310.50310.5 with a currency format310.5 (or €310.50 as shown)
    paid_at03/11/2026 16:0546329.670138888892026-11-03 16:05:00
    tracking_no00731004527Text “00731004527”00731004527

    The line becomes 1003,Chloé Martin,310.5,2026-11-03 16:05:00,00731004527. With a BOM, Excel opens it with the accent intact.

    Common mistakes

    Where Excel to CSV goes wrong

    Most problems show up when the CSV is opened again, not during the conversion.

    Garbled accents or Chinese

    Excel assumes a CSV without a BOM uses the local code page. Add the UTF-8 BOM, or import it through Data › From Text/CSV and pick UTF-8.

    Lost leading zeros

    The CSV still has 00731; Excel drops the zeros when it opens the file. Import the column as text, or convert the CSV back with CSV to Excel, which keeps them.

    Day and month swapped

    03/11/2026 means different dates in the US and Europe. ISO dates (2026-11-03) avoid the guess; keep them that way in the CSV.

    Wrong delimiter

    Excel in many European locales expects semicolons, because the comma is the decimal mark. Pick “Semicolon” for those users.

    FAQ

    Excel to CSV questions

    Still have a question?

    Chat with the team behind TapCub — we usually reply within a few hours on business days.

    How do I convert Excel to JSON?

    Drop the .xlsx file here. Each row of the selected sheet becomes a JSON object with the first row as keys. Download the .json or copy it.

    What if my header has blanks or duplicates?

    A blank header becomes column_N and a repeated one gets _2, _3, so every key is unique and no value is overwritten.

    Can I convert every sheet into one JSON file?

    Yes. Tick “All sheets in one JSON” to get an object with one array per sheet name.

    How are dates and numbers written?

    Numbers and booleans keep their JSON types. Dates become ISO 8601 strings such as "2026-11-18" or "2026-11-18 09:30:00", read from the cell format.

    Changelog

    Update history

    New features, fixes and data refreshes for this tool, newest first.

    1. · v1.0

      LaunchedFirst release.

    Missing something or found an error? Tell us — requests that come up often go into the next update. All tool updates

    See your data clearly. Find your growth.

    Every click, backed by data. Install one line of code and see your first numbers in a minute.

    No credit card · Free plans for analytics and chat · Cookieless analytics