Convert CSV to clean JSON

When to convert CSV to JSON

The most common scenarios: feeding a REST API with a product list exported from a spreadsheet, importing data into a NoSQL database like MongoDB or Firestore, generating test fixtures for a Node.js or Python script, or connecting a Google Sheets export to a Make or Zapier automation that expects JSON.

CSV to JSON also helps when you need to inspect data structure before piping it into a tool — JSON is easier to validate and debug than a flat file.

The first row is crucial

The header row becomes the property names of every JSON object. Column names should be concise and free of special characters. Spaces are preserved but may cause problems in some APIs — consider using camelCase or underscores.

name,age,active
Alice,30,true
Bob,25,false

Produces:

[
  {"name":"Alice","age":30,"active":true},
  {"name":"Bob","age":25,"active":false}
]

Type inference

When type inference is enabled, the converter automatically converts compatible values to their native JSON type instead of leaving everything as strings.

• "42" becomes the number 42.
• "3.14" becomes the number 3.14.
• "true" and "false" become booleans.
• An empty cell becomes null.

This matters when consuming the JSON in a typed context — a REST API or a database schema that validates types will reject "42" as a number.

Nested objects from dot-notation columns

If your CSV headers use dot notation (user.email, address.city), the tool can reconstruct nested JSON objects. A column named user.email becomes {"user":{"email":"..."}} instead of a flat key.

CSV pitfalls to watch for

• BOM encoding — Excel sometimes adds a hidden byte-order mark at the start of the file that corrupts the first column header.
• Variable separators — a file may mix commas and semicolons across rows if it comes from multiple sources.
• Fields with line breaks — a multi-line address inside a quoted field breaks naïve CSV parsers that split on newlines.

How to do it with Flowfiles

1. Open the JSON CSV converter.
2. Switch to CSV to JSON mode.
3. Paste the CSV content.
4. Select the correct delimiter (comma, semicolon, or tab).
5. Enable type inference if needed.
6. Convert, then copy or download the JSON.