Category guide

Excel Tools

Spreadsheet work often starts with a table that needs to move between Excel, CSV, and JSON. Choose a tool based on the source and destination. These conversions run in your browser, and each export makes its treatment of formulas, formatting, and cell types explicit.

Choose the right tool

XLSX to CSV

Choose one worksheet and export visible cell values as a comma-separated table for an import pipeline.

XLSX to JSON

Use the first row as field names and turn subsequent worksheet rows into JSON records for an API or script.

CSV to XLSX

Package a CSV table as a one-sheet Excel workbook while retaining every input cell as text.

JSON to XLSX

Create a spreadsheet from an array of JSON objects, with object keys becoming column headers.

All tools

Example workflow: move a support export into an application

  1. Start with the XLSX file and choose the worksheet containing the rows you need, rather than exporting an unrelated sheet.
  2. Download CSV for a table import, or JSON when the application expects named fields in each record.
  3. Check the result against the source, especially formulas, dates, leading zeros, and cells that contain nested data.

Before you use the result

These are data conversions, not workbook preservation tools. Charts, styles, macros, formulas, and multiple sheets are not carried into a CSV or JSON result. A newly created XLSX contains one data sheet and text cell values.

Choose a result for the next step

CSV is a good handoff when another program expects a rectangular table. JSON works when a program expects objects with named fields. Both exports use one selected worksheet and its visible cell values, so a formula is not recalculated by the site. If the workbook has more than one sheet, choose the one you intend to export before downloading.

The reverse direction creates a new workbook. CSV to XLSX keeps source fields as text, which helps preserve identifiers such as 00123. JSON to XLSX uses the combined set of object keys as headers and serializes nested values as JSON text in a cell. Inspect the workbook in your spreadsheet application before sharing it.

All four tools process data locally. They are intended for manageable imports and reports, with file, text, and cell-count limits to keep browser memory bounded. If you need a workbook with formulas, charts, formatting, or several sheets preserved, use a spreadsheet editor rather than a data converter.