# CSV viewer editor

> Inspect parsed CSV rows and columns.

[Open tool](https://www.toolcabana.com/ab/csv-viewer) · [Developer and data](https://www.toolcabana.com/ab/category/developer-and-data)

Tool ID: csv-viewer. Requested language: ab. Description language: en. Complete guide translation: no; untranslated sections use English.

## Overview (en)

CSV viewer editor parses CSV into a table so you can inspect and edit rows and columns, up to 500 rows and 50 columns in the grid. The preview shows up to 5,000 rows. You can choose the delimiter and whether the first row is a header, then export the data as CSV or JSON.

## Supported tasks (en)

Edit up to 500 rows and 50 columns in the grid. The result preview shows up to 5,000 rows. JSON export keeps literal values; CSV export escapes common spreadsheet formula prefixes.

## Steps (en)

1. Type or paste your source, or load an example.
2. Change the basic settings or open Advanced mode to fine-tune the result.
3. Review and copy or download your result. Pause Live results to run manually. Sources or individual settings above 20,000 characters require an explicit run.

## Settings

- Delimiter (en; key: delimiter; type: select): , [en], ; [en], 	 [en], | [en]
- First row contains column names (en; key: header; type: checkbox)
- CSV line endings (en; key: newline; type: select): CRLF [en], LF [en]
- Quote every CSV cell (en; key: quoteAll; type: checkbox)
- Add UTF-8 BOM for spreadsheet compatibility (en; key: bom; type: checkbox)

## Limitations (en)

Text operations generally accept up to 2,000,000 characters. Individual parsers, generators and formulas apply additional limits shown by their controls.

## Example input

```text
name,count
ToolCabana,2
Example,3
```

## Privacy and connections (en)

This operation processes its source in your browser. Copy and download are explicit actions; source input is not saved in an account or history.

## Questions (en)

### How do I open a CSV file as a table?

Paste the CSV text, choose its delimiter, and indicate whether the first row contains column names. The rows appear in a table; without a header, columns are labeled Column 1, Column 2 and so on.

### Can I export edited CSV data as JSON?

Yes. The tool offers both edited.csv and data.json downloads. The JSON keeps each cell value literally as an array of rows.

### Why are some exported CSV cells prefixed with an apostrophe?

The CSV export escapes cells that start with common spreadsheet formula characters to reduce formula injection. The JSON export is not altered this way.

### Where is my input processed?

This operation processes its source in your browser. Copy and download are explicit actions; source input is not saved in an account or history.

### What are the input limits?

Text operations generally accept up to 2,000,000 characters. Individual parsers, generators and formulas apply additional limits shown by their controls.

## Related tools

- [CSV delimiter converter](https://www.toolcabana.com/ab/csv-delimiter)
- [CSV to JSON](https://www.toolcabana.com/ab/csv-to-json)
- [JSON to CSV](https://www.toolcabana.com/ab/json-to-csv)
- [JSON schema validator](https://www.toolcabana.com/ab/json-schema)