# Excel & CSV to JSON

Convert Excel (XLSX, XLS), ODS, CSV and TSV to JSON, and JSON back to an XLSX file. Numbers stay numbers, dates become ISO dates.

Send a spreadsheet by link or as base64 and get clean JSON: numbers as numbers, dates as ISO dates, formulas as their last calculated value, empty trailing rows and columns dropped. Or send JSON rows and get a tidy .xlsx file back. Files are read in memory and never stored. A file that cannot be read is refused and not charged.

- Both directions in one API.
- Clean JSON: numbers as numbers, dates as ISO dates, formulas as their last calculated value, empty trailing rows and columns dropped.
- Files are read in memory and never stored; a file that cannot be read is not charged.

## Calls

### `POST https://readymadeapi.com/v1/sheets/read`

Turn an XLSX, XLS, ODS, CSV or TSV file into JSON: every sheet, or the one you name, as rows of objects keyed by the header row or as plain arrays.

- Price: $0.00064 per file
- MCP tool: `sheet_convert_read`
- Answers in the same call.

Request:

```json
{
  "file_url": "https://readymadeapi.com/samples/orders.xlsx"
}
```

Answer:

```json
{
  "format": "xlsx",
  "sheets": [
    {
      "name": "Orders",
      "rows": 3,
      "columns": ["order_id", "ordered_on", "customer", "units", "unit_price", "paid"],
      "data": [
        {
          "order_id": 1001,
          "ordered_on": "2026-11-03",
          "customer": "Client GmbH",
          "units": 40,
          "unit_price": 180,
          "paid": true
        },
        {
          "order_id": 1002,
          "ordered_on": "2026-11-07",
          "customer": "Atelier Nord",
          "units": 12,
          "unit_price": 80.5,
          "paid": false
        },
        {
          "order_id": 1003,
          "ordered_on": "2026-11-14",
          "customer": "Maison Lune",
          "units": 3,
          "unit_price": 350,
          "paid": true
        }
      ],
      "truncated": false
    }
  ]
}
```

### `POST https://readymadeapi.com/v1/sheets/write`

Turn JSON rows into an Excel file with one sheet per table: a bold header row, real numbers, columns sized to their content.

- Price: $0.00064 per file
- MCP tool: `sheet_convert_write`
- Answers in the same call.

Request:

```json
{
  "sheets": [
    {
      "name": "Orders",
      "rows": [
        {
          "id": 1,
          "item": "Lamp",
          "price": 24.5
        },
        {
          "id": 2,
          "item": "Desk",
          "price": 180
        }
      ]
    }
  ]
}
```

The answer is the file itself (`application/vnd.openxmlformats-officedocument.spreadsheetml.sheet`).

## Limits

- XLSX, XLS, ODS, CSV or TSV; by link, up to 15 MB.
- Reading: 10,000 rows per sheet unless you ask for more, up to 50,000 rows and 1,000,000 cells; the answer says when a sheet was cut.
- Writing: up to 20 sheets and 200,000 cells.

## Questions

**What if the file has several sheets?**

Every sheet comes back, or the one you name, as rows of objects keyed by the header row or as plain arrays.

**What does the Excel file look like?**

One sheet per table, a bold header row, real numbers and columns sized to their content.

## Using it

- Send `Authorization: Bearer <key>` and a JSON body. Keys and credit: https://readymadeapi.com/account
- Every answer carries `X-Request-Id`, `X-Units` and `X-Charged-Usd`.
- An error is a JSON problem with a `title` to act on and a `detail` in plain words; nothing is charged for it.
- Full schema: https://readymadeapi.com/openapi.json
