如何Convert CSV 到 JSON

问题

你有 数据在 CSV 格式化和 need 它 as JSON 为过程在 JavaScript 或 API.

前置条件

• Understanding 的 CSV 格式化
• Understanding 的 JSON arrays 和 objects

步骤

1. 1. Parse the CSV header and rows

   Read the first line as the header row to get field names. Read each subsequent line as a data row, splitting on the delimiter (comma by default). Handle quoted fields that contain commas or newlines by respecting CSV quoting rules.

   输入

   name,age,city\nAlice,30,NYC

   输出

   headers: [name, age, city]

2. 2. Map rows to JSON objects

   For each data row, create a JSON object where each header field is a key and the corresponding cell is the value. Decide whether to infer types (numbers, booleans) or keep all values as strings. Type inference is convenient but can misinterpret values like zip codes.

   输入

   Alice,30,NYC

   输出

   {"name":"Alice","age":30,"city":"NYC"}

3. 3. Assemble and output the JSON array

   Collect all row objects into a JSON array. Format the output with indentation for readability if needed. Validate that the number of fields in each row matches the header count.

   输入

   [{Alice},{Bob}]

   输出

   JSON array of objects

预期结果

JSON 数组的 objects, 每个 representing CSV 行具有头-derived 关键.

常见错误

Comma inside a quoted field splits incorrectly

Use a proper CSV parser that respects quoting rules. Do not split on commas with a simple string split.

Zip codes or IDs lose leading zeros

If you infer types, numeric conversion strips leading zeros. Keep such fields as strings or use a schema to specify types.

排障指引

• If rows have inconsistent field counts, check for unquoted commas or multiline fields in the CSV.
• For large CSV files, use a streaming parser to avoid loading everything into memory.

安全限制

• CSV injection (formula injection) can affect spreadsheet applications. Sanitize cells that start with =, +, -, or @ if the output will be opened in a spreadsheet.