ClarityHow to use this tool
- Enter csv with column headers.
- Select Update result to view the result.
- Check the method and assumptions below before using the result.
Input reference and sample values
Use the units and choices shown for each field. Sample values are provided for practice, not as recommendations.
| Input | Format and units | Sample |
|---|---|---|
| CSV with column headers | Keep the structure and separators shown in the sample. Line breaks are retained in this input. | name,score
Alex,95
Sam,88 |
Result for these sample inputs
[
{
"name": "Alex",
"score": "95"
},
{
"name": "Sam",
"score": "88"
}
]- Data rows
- 2
- Columns
- 2
Select Try the example in the form to load these values and calculate them again. This replaces the current form inputs. Compare the result with the method and worked explanation below.
The method, explained
Read quoted fields, escaped double quotes and line endings. Use unique column headers as object keys and preserve every cell as a string.
name,score followed by Alex,95 becomes an object with name "Alex" and score "95" inside a JSON array.
What to keep in mind
Comma delimiter only; headers must be nonempty and unique. Every data row must match the header width. Up to 100,000 input characters. Numbers remain strings to preserve leading zeroes.
Reference: RFC 4180: comma-separated values
Common questions
Can a cell contain a comma or line break?
Yes, if the cell is surrounded by double quotes. A double quote inside such a cell must be doubled.
Will 00123 become 123?
No. All cell values stay strings, preserving identifiers and leading zeroes.
Methodology maintained by ClarityKit. How these tools are built and checked.