Upload a CSV file to view it as a formatted table. Download as JSON or copy data instantly.
Comma or semicolon separated values
CSV (Comma-Separated Values) files are plain text files used to store tabular data. They are commonly exported from Excel, Google Sheets, bank statement downloads, and e-commerce platforms like Shopify.
A CSV viewer reads a comma-separated values file and renders it as a readable table — useful for quickly checking a bank statement export or data file without opening Excel. A CSV to JSON converter takes that same tabular data and restructures it as an array of JSON objects, using the header row as the key names for each object. This tool does both in one step: upload or paste the CSV, inspect it as a table, then download or copy the JSON.
Because everything runs in your browser via JavaScript's FileReader API, no code, install, or account is needed — and no Python script or upload to a third-party server is required either, which matters for sensitive data like bank statements or customer lists.
| CSV | JSON | |
|---|---|---|
| Structure | Flat rows and columns | Nested objects and arrays, one object per row |
| Best for | Spreadsheets, Excel, bank/accounting exports | APIs, web apps, JavaScript/developer tooling |
| Human-readable in | Any spreadsheet app or text editor | Text editors and code editors |
| Typed values | Everything is text | Can represent strings, numbers, booleans, nulls |
Need to go the other way, or format the resulting JSON further? Try the JSON Formatter.
| Who | Common Use |
|---|---|
| 🧑💻 Developers | Convert a CSV export into JSON for an API, database seed, or JavaScript app — no script needed |
| 💰 Bookkeepers & accountants | Quickly view a bank statement or accounting CSV export as a readable table |
| 📊 Data analysts | Inspect a data file's structure before importing it into another tool |
| 🎓 Students | See how tabular data maps to JSON objects when learning data formats |
| 🛒 E-commerce & ops | Check a Shopify or platform CSV export before uploading it elsewhere |
| Source | How to Export | Common Use |
|---|---|---|
| Commonwealth Bank (NetBank) | Accounts → Transactions → Export → CSV | Budget tracking, tax records |
| ANZ (Internet Banking) | Transaction history → Download → CSV | EOFY reconciliation |
| ATO (myTax) | Pre-fill data export | Tax records |
| Xero/MYOB | Reports → Export → CSV | Accounting reconciliation |
| Google Sheets / Excel | File → Download → CSV | Data sharing |
Why do my CSV characters look garbled?
The file likely uses Windows-1252 (Western European) encoding rather than UTF-8. Common with older Australian bank exports and Windows-generated files. To fix: open in Windows Notepad, File → Save As → Encoding: UTF-8. Then re-upload the saved file.
What is the difference between CSV and Excel files?
CSV is plain text — just values separated by commas, viewable in any text editor. Excel (.xlsx) is a binary format with formatting, multiple sheets, and formulas. CSV is universal and more compatible for data import/export; Excel is better for analysis and presentation. Most Australian accounting software (Xero, MYOB) exports to both.
Do I need to know Python to convert CSV to JSON?
No — this tool converts CSV to JSON with no code required. Upload or paste the CSV, and it's parsed and converted instantly in your browser. Python (pandas or the csv/json modules) is one way developers automate this, but for a one-off file this tool is faster.
What JSON structure does the converted file use?
Each CSV row becomes one JSON object, with the header row supplying the key names — so a CSV with columns name, age, city becomes an array of objects like {"name": "Alex", "age": "30", "city": "Melbourne"}. This is the standard, most widely compatible shape for JSON generated from tabular data.
Can I view a CSV file without opening Excel?
Yes — that's what the table view is for. Upload the CSV and it renders as a formatted, readable table directly in the browser, which is useful for quickly checking a file's contents before deciding whether to import it anywhere.
Does this handle CSV files with quoted fields or embedded commas?
Yes — quoted fields (where a value itself contains a comma, wrapped in double quotes per the CSV standard) are handled correctly, so addresses, names with commas, and similar fields parse into the right column instead of splitting incorrectly.
Is my CSV file uploaded to a server?
No. The file is read and parsed entirely in your browser using JavaScript's FileReader API — nothing is transmitted anywhere, which makes it safe for bank statements, customer data, or other sensitive spreadsheets.