Wie in Konvertieren CSV in JSON

问题

You haben Daten in CSV formatieren und brauchen it als JSON für processing in JavaScript oder ein API.

Voraussetzungen

• Understanding of CSV format
• Understanding of JSON arrays and objects

Schritte

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.

   Eingabe

   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.

   Eingabe

   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.

   Eingabe

   [{Alice},{Bob}]

   输出

   JSON array of objects

Erwartetes Ergebnis

Ein JSON Array von Objekte, jede representing ein CSV Zeile mit Header-derived Schlüssel.

Häufige Fehler

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.

Troubleshooting指引

• 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.

Sicherheitsgrenzen

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