CSV Inspector

What this tool is for

CSV Inspector helps you review the structure of a small delimited table before converting or opening it elsewhere. Processing happens in the current browser session, so the normal workflow does not require uploading the text to BiNotePads.

How to use CSV Inspector

1. Enter or paste the source data and keep an untouched copy when the order or formatting matters.
2. Choose the available options, then select Process.
3. Review the entire result before copying, downloading, publishing or importing it elsewhere.

Review a harmless formula-like value

Try this small sample before using your own text.

Sample input or options

id,note
0012,"red, blue"
0013,=1+2

What to check in the result

3 records; 2 data records; 2 columns; no structural warnings; 1 formula-like start.

Before you use the output

The header option is on and the delimiter is comma. The quoted comma stays inside one field and the ID remains text. The report never evaluates the formula-like value. A warning indicates a pattern worth reviewing, not proof of malicious content; zero warnings does not certify spreadsheet safety.

Inspect a table before converting it

Choose comma, semicolon or tab explicitly, then indicate whether the first record contains column names. The first record defines the expected field count. The report distinguishes parsed records from physical lines because a quoted field can contain a line break. A final line ending does not create an extra record; a genuinely blank record is retained and can trigger a width notice.

What a notice means

Widths are compared with the first record. Blank header cells and exact duplicate header names are reported when the header option is selected. Leading-zero identifiers remain strings. A leading byte-order mark is excluded from the first field during analysis and reported. The preview shows only the first 20 records; the report scans the whole accepted sample.

Quoted delimiters, doubled quotes and quoted line breaks are supported. Quotes inside an unquoted field, text after a closing quote and unclosed quotes produce an error rather than a guessed repair. Spaces after a closing quote are rejected by this strict parser. Other importers may accept different dialects; an error here is not a universal verdict on every CSV application.

Formula-like values need separate review

Cells beginning with formula-like characters, or with leading tab or line-break controls, are flagged for review. Ordinary negative numbers can be flagged too. The tool does not run, remove or sanitize formulas. Zero flags is not a guarantee that a spreadsheet will treat every value safely. Keep the original and use the receiving system's explicit text-import settings where appropriate.

Limits are 250,000 UTF-16 units, 5,000 records and 200 columns. Notice and flagged-cell lists show the first 100 entries each. See the CSV format description and OWASP discussion of spreadsheet formula injection. After reviewing a suitable simple table, the CSV to JSON converter can help prepare test data.

Common uses

• Checking import row widths
• Finding repeated or blank headers
• Reviewing formula-like starts before spreadsheet use

Limits and accuracy

A structural pass is not a schema, type or security approval; negative numbers can be flagged and spreadsheet behavior varies. Keep the original text, verify important results and use a specialized application when a task carries legal, security, financial or production risk.

Privacy and safety

This tool is intended for ordinary text and development samples. Do not paste passwords, authentication tokens, private keys, payment information, medical records or confidential client data into a general-purpose web page. Closing or refreshing the page can remove unsaved input.

Frequently asked questions