Forge Json

JSON to CSV

v1.0.0
Convert
arrayreversible

Description

JSON to CSV

Convert a JSON array of objects into CSV text. Supports field selection, nested object flattening, custom column mappings with expressions, and configurable delimiters.

How It Works

The utility takes an array of objects and produces CSV text. Each object becomes a row, and object keys become column headers.

Basic Conversion

All fields from the first object determine the columns. Values are quoted when they contain the delimiter character.

Column Selection

Specify an array of field names to include only certain columns in a specific order.

Nested Object Flattening

When enabled, nested objects are flattened using dot notation. Arrays within cells are joined with a configurable delimiter.

Custom Column Mapping

Define custom columns with expressions using {{fieldName}} syntax. Allows combining fields, renaming columns, and applying transformations.

Configuration

FieldTypeDefaultDescription
Delimiterenum,Field separator: ,, ;, \t (tab), or `\` (pipe)
Include HeadersbooleantrueAdd column names as the first row
Columnsjson[]JSON array of field names to include (empty = all fields)
Flatten Nested ObjectsbooleanfalseFlatten nested objects using dot notation keys (e.g., user.name)
Array Delimiterstring`\`Character to join array values within a single cell
Column Mappingcolumn-mapping[]Define custom column mappings with expressions. When configured, overrides Columns and Flatten settings.

Column Mapping Expressions

Custom mappings let you define exactly what each column contains:

Column: "Full Name"     Expression: "{{firstName}} {{lastName}}"
Column: "Age"           Expression: "{{age}}"
Column: "Location"      Expression: "{{city}}"

Use Cases

Data Export

  • Spreadsheet export: Convert JSON data to CSV for Excel or Google Sheets
  • Database import: Prepare CSV files for database bulk import
  • Report generation: Export filtered data as CSV reports

Data Transformation

  • Column selection: Export only relevant fields from large objects
  • Field combination: Merge first/last name into a single "Full Name" column
  • Nested flattening: Convert hierarchical data to flat CSV rows

Integration

  • Legacy systems: Convert JSON API data to CSV for legacy system import
  • Email tools: Prepare CSV contact lists for email marketing tools
  • Analytics platforms: Export data in CSV format for analytics tools

Configuration

NameTypeDefaultDescription
Delimiterenum,Character used to separate fields in the CSV output , ; \t |
Include HeadersbooleantrueAdd column names as the first row
Flatten Nested ObjectsbooleanfalseFlatten nested objects using dot notation keys (e.g. user.name)
Array Delimiterstring|Character to join array values within a single cell
Columnsjson[]JSON array of field names to include (empty = all fields)
Column Mapping (Advanced)column-mapping[]Define custom column mappings with expressions. When configured, overrides Columns and Flatten settings.

Examples

AI Prompt
Convert this JSON to CSV.
Input
1[
2  {
3    "name": "Alice",
4    "age": 30,
5    "city": "New York"
6  },
7  {
8    "name": "Bob",
9    "age": 25,
10    "city": "London"
11  }
12]
Config
Delimiter
,
Include Headers
ON
Flatten Nested Objects
OFF
Array Delimiter
|
Columns
1[]
↓
Output
1name,age,city

2Alice,30,New York

3Bob,25,London

API Usage

POST /api/v1/utilities/convert.json-to-csv
Example:
curl -X POST https://your-domain.com/api/v1/utilities/convert.json-to-csv \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"inputs":{"primary":[{"name":"Alice","age":30,"city":"New York"},{"name":"Bob","age":25,"city":"London"}]},"config":{"delimiter":",","includeHeaders":true,"columns":[],"flattenNested":false,"arrayDelimiter":"|"}}'
Response
1name,age,city

2Alice,30,New York

3Bob,25,London