Pricing

from $0.0025 / json transformed

JSON Flatten & Unflatten

Flatten nested JSON into dot-path keys or rebuild nested JSON from flat keys. Perfect for turning deep API data into flat columns for CSV, SQL and BI tools.

Pricing

from $0.0025 / json transformed

Rating

0.0

(0)

Developer

hiper soft

Actor stats

Bookmarked

Total users

Monthly active users

8 days ago

Last modified

What it does

Flatten: { "user": { "name": "Ada" } } → { "user.name": "Ada" }.
Unflatten: { "user.name": "Ada" } → { "user": { "name": "Ada" } }.
Custom key delimiter and optional max depth.
Emits one key/value row per path (perfect for CSV/Excel) and the full JSON as a file.

Use cases

Data engineering — flatten nested JSON before loading into a spreadsheet, SQL table or BI tool.
Config management — convert between flat env-style keys and nested config.
API prep — reshape deep responses into flat records.

Input

{ "jsonText": "{ \"user\": { \"name\": \"Ada\", \"address\": { \"city\": \"London\" } } }", "mode": "flatten", "delimiter": "." }

Field	Type	Description
`jsonText`	string	The JSON to transform (as text).
`mode`	string	`flatten` or `unflatten`.
`delimiter`	string	Character joining nested keys. Default `.`.
`maxDepth`	integer	Stop flattening beyond this depth (0 = no limit).

Output

JSON Flatten & Unflatten output — the results as a clean dataset

Key/value rows in the dataset, plus the full transformed JSON at result.json in your key-value store.

{ "key": "user.address.city", "value": "London", "resultUrl": "https://api.apify.com/v2/key-value-stores/.../records/result.json" }

Output schema

Field	Type	Description
`key`	string	Flattened key path (or `(result)` for unflatten).
`value`	string	Value at that key.
`resultUrl`	string (URL)	Link to the full transformed JSON file.

FAQ

Can I paste an array? Yes — arrays and objects are both supported.

Where's the full result? Saved as result.json in the run's key-value store (link in every row).

Can I automate it? Yes — via integrations on the Apify platform and the Apify API.

Notes

Original clean-room implementation.

JSON to CSV Converter — Flatten Nested Data

junipr/json-to-csv-converter

Convert JSON arrays, objects, API responses, and nested data into CSV or TSV with flattening, field selection, and file exports.

junipr

JSON to CSV Converter

maximedupre/json-to-csv-converter

Turn a JSON object or collection into a CSV or TSV file. Use direct JSON, a URL, or an Apify dataset, then flatten nested fields, choose columns, and get the complete file with structured rows.

Maxime Dupré

Dataset Flatten and Field Mapper

eager_vitamin/apify-dataset-flatten-field-mapper

Flatten nested JSON, rename and drop fields, and coerce simple types in Apify datasets without writing transformation code.

Lau Kuan Ee

Public JSON to CSV Feed

convenient_yarn/public-json-to-csv-feed

Flatten inline JSON or public HTTPS JSON into Excel-safe CSV with stable export URLs for automation workflows.

Travis Berman

XML to CSV and Excel Converter

automation-lab/xml-to-csv-excel-converter

Flatten XML text, uploaded files, and public XML URLs into CSV- and Excel-ready rows with record selection, namespaces, attributes, nested fields, columns, and parse errors.

Stas Persiianenko

Business Intelligence Data Converter

m3web/business-intelligence-data-converter

Business Intelligence Data Converter transforms any Apify dataset into BI‑ready tables. Flatten nested fields, normalize rows, and export clean CSV/XLSX for Excel, Power BI, or Tableau — a universal converter tool, no coding required.

M3Web

JSON ↔ CSV Converter

web.harvester/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.

Web Harvester

Json Tools API

vivid_astronaut/json-tools

BRAINIALL Team

JSON to CSV Converter

eloquent_mountain/json-to-csv-converter

JSON to CSV Converter. Effortlessly transform JSON data into CSV with our Apify actor. Handle nested structures, expand lists into rows, and customize separators and delimiters. Input via URL or paste JSON text. Ideal for data analysis and reporting!

Paco

Reddit Ultimate Scraper

signalqub/reddit-ultimate-scraper

Fast, 5-in-1 Reddit scraper. Extract nested comments, subreddit timelines, metadata, and track global keyword mentions. Export to JSON/CSV without Reddit API keys or proxies.