Why do values containing commas survive?

CSV wraps a value in quotes when it contains a comma or a line break. Splitting naively on commas shifts the columns, so this reads character by character and tracks whether it is inside quotes.

My CSV looks broken when opened in Excel.

That is a character-encoding problem. Open it through Excel’s data-import step and choose UTF-8.

What does automatic number detection do?

It puts a value like 30 in as a number rather than a string. Turn it off to keep everything exactly as written.

CSV ↔ JSON

Name: CSV ↔ JSON 변환
Author: KarmoLab

Both directions · pick the delimiter · numbers detected

CSV ↔ JSON 변환

표(CSV)와 JSON 을 서로 바꿉니다. 따옴표 안 쉼표·줄바꿈도 안 깨집니다

구분자

숫자·참거짓 자동 인식

켜기

CSV — 첫 줄이 열 이름

JSON — 객체 배열

2행 · 3열 을 JSON 으로 바꿨어요.

Converts between a CSV table and an array of JSON objects. Commas and line breaks inside quotes are handled by the rules, so columns never slip.

How to use it

Paste the CSV (first row is the column names)
The JSON appears as you edit the CSV
Editing the JSON converts it back the other way

Common questions

Why do values containing commas survive?: CSV wraps a value in quotes when it contains a comma or a line break. Splitting naively on commas shifts the columns, so this reads character by character and tracks whether it is inside quotes.
My CSV looks broken when opened in Excel.: That is a character-encoding problem. Open it through Excel’s data-import step and choose UTF-8.
What does automatic number detection do?: It puts a value like 30 in as a number rather than a string. Turn it off to keep everything exactly as written.

Other tools

Stays on your device What you enter is handled inside your browser only — nothing is stored or sent anywhere.

This tool page states where what you enter goes — see the badge above. All tools · KarmoLab · Who made this · Built with AI. View source