Image Tools
PDF Tools
Developer ToolsBase64 Images in HTML, CSS and JSON: Best Practices
Inline images can speed up a page or slow it down. Here are clear rules for when Base64 is the right tool.
API data is usually JSON, but people want a spreadsheet. Convert a JSON list into CSV and open it in Excel or Google Sheets.
JSON is great for programs. Spreadsheets are great for people. Converting JSON to CSV lets you sort, filter and chart API data without writing code.
The best JSON shape
The tool works best with a list of objects that share the same keys:
[
{"name": "Ali", "city": "Karachi"},
{"name": "Sara", "city": "Lahore"}
]Each object becomes one row, and each key becomes a column.
Steps
- Open the JSON to CSV converter.
- Paste your JSON into the input box.
- Choose JSON to CSV.
- Press Copy result or Download.
- Open the CSV file in Excel or Google Sheets.
Common problems
- Invalid JSON: check for missing commas, single quotes instead of double quotes, and trailing commas.
- Nested objects: data inside data does not fit a flat table. Flatten it first, or pick the list you need.
- Special characters: if Excel shows strange letters, import the file as UTF-8 text.
Your data stays in your browser. Need the opposite direction? Read how to convert CSV to JSON.
Try it now: JSON to CSV / CSV to JSON
Convert data between JSON and CSV instantly.
Open JSON to CSV / CSV to JSON