JSON ↔ CSV Converter avatar
JSON ↔ CSV Converter

Pricing

$3.00/month + usage

Go to Apify Store
JSON ↔ CSV Converter

JSON ↔ CSV Converter

Convert between JSON and CSV bidirectionally. Flatten nested objects to dot notation. Handle arrays with stringify, join, or first element. Custom delimiters (comma, semicolon, tab, pipe). Parse types automatically. Upload files, provide URLs, or load from Apify Datasets.

Pricing

$3.00/month + usage

Rating

0.0

(0)

Developer

Web Harvester

Web Harvester

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

9 days ago

Last modified

Share

🔄 Bidirectional conversion between JSON and CSV formats. Flatten nested objects, handle arrays, customize delimiters.

Apify Actor License: MIT

🎯 What This Actor Does

Convert between JSON and CSV in either direction:

  • JSON → CSV - Flatten nested objects, handle arrays
  • CSV → JSON - Parse types, preserve structure
  • Flexible Input - Upload files, URLs, or Apify Datasets
  • Custom Delimiters - Comma, semicolon, tab, pipe
  • Smart Handling - Numbers, booleans, nested data

🚀 Use Cases

Use CaseDescription
Data ExportConvert scraped JSON to CSV for Excel
Data ImportConvert CSV uploads to JSON for APIs
IntegrationBridge different system formats
ReportingPrepare data for business tools
MigrationMove data between platforms

📥 Input Examples

JSON to CSV

{
"mode": "json-to-csv",
"datasetId": "abc123",
"flatten": true,
"delimiter": ","
}

CSV to JSON

{
"mode": "csv-to-json",
"fileUrl": "https://example.com/data.csv",
"parseNumbers": true,
"parseBooleans": true
}

⚙️ Configuration

ParameterTypeDefaultDescription
modestringjson-to-csvConversion direction
filestring-Upload a file
fileUrlstring-URL to file
datasetIdstring-Load from Apify Dataset
flattenbooleantrueFlatten nested objects to dot notation
arrayHandlingstringstringifyHow to handle arrays: stringify, first, join
delimiterstring,CSV column separator
includeHeadersbooleantrueInclude headers in CSV
parseNumbersbooleantrueParse numeric strings
parseBooleansbooleantrueParse true/false strings

📤 Output

Conversion Result

{
"status": "success",
"inputFormat": "JSON",
"outputFormat": "CSV",
"rowCount": 1500,
"columnCount": 12,
"downloadUrl": "https://api.apify.com/v2/..."
}

Nested Object Flattening

Input JSON:

{
"name": "John",
"address": {
"city": "NYC",
"zip": "10001"
}
}

Output CSV:

name,address.city,address.zip
John,NYC,10001

💰 Cost Estimation

RowsApprox. TimeCompute Units
1,000~5 seconds~0.005
10,000~15 seconds~0.02
100,000~1 minute~0.1

🔧 Technical Details

  • Language: TypeScript / Node.js 22
  • Memory: 256MB-512MB
  • Speed: 50K+ rows/second

📄 License

MIT License - see LICENSE for details.