> ## Documentation Index
> Fetch the complete documentation index at: https://getchatcache.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Export ChatGPT conversations to JSON or CSV files

> Export ChatGPT as structured JSON for programmatic use or as CSV for Excel and Google Sheets. Both formats are processed locally in your browser.

ChatCache supports two structured data formats for developers and analysts: JSON and CSV. JSON preserves the full conversation structure in a machine-readable format, while CSV produces a flat tabular file you can open directly in Excel or Google Sheets. Both formats are processed entirely in your browser with no data sent to any server.

**JSON**

## JSON export

JSON export serializes the conversation as an array of message objects. Each object contains the speaker role and the message content, giving you a clean structure to work with in any programming language.

### Example structure

```json theme={null}
[
  {
    "role": "user",
    "content": "Explain the difference between a list and a tuple in Python."
  },
  {
    "role": "assistant",
    "content": "A list is mutable, meaning you can change its contents after creation. A tuple is immutable — once defined, its values cannot be modified."
  }
]
```

### Use cases

* **Programmatic processing** — load conversations into scripts, pipelines, or applications
* **Fine-tuning datasets** — use exported JSON as training data for custom models
* **Developer workflows** — inspect conversation structure, filter by role, or transform content

### Processing

JSON export runs entirely in your browser. No data leaves your device.

**CSV**

## CSV export

CSV export produces a flat `.csv` file where each row represents one message in the conversation. The file opens directly in Excel, Google Sheets, or any tool that reads comma-separated values.

### Column structure

```text theme={null}
role,content
```

Each row contains the speaker role (`user` or `assistant`) and the full text of that message.

### Use cases

* **Spreadsheet analysis** — sort, filter, and annotate messages in Excel or Google Sheets
* **Data review** — share conversation exports with non-technical stakeholders in a familiar format
* **Bulk processing** — import into databases or BI tools that accept CSV input

### Processing

CSV export runs entirely in your browser. No data leaves your device.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.