Dataset Transform: JSON to CSV, Flatten, Filter, Rename
Pricing
from $0.46 / 1,000 output rows
Dataset Transform: JSON to CSV, Flatten, Filter, Rename
Returns a flat CSV, JSON or JSONL file with a download link, made from nested JSON in Apify datasets or pasted JSON: flatten, pick and rename columns, convert types, filter and sort. Start with no input for a free demo on 4 sample orders.
Pricing
from $0.46 / 1,000 output rows
Rating
0.0
(0)
Developer
Actor Factory
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
a day ago
Last modified
Categories
Features
Share
JSON to CSV for Apify datasets: nested JSON in, a flat table and a CSV download link out
| orderId | placedAt | company | country | total | status | tags |
|---|---|---|---|---|---|---|
| A-1004 | 2026-03-05T08:40:00Z | Initech | IN | 2075 | shipped | priority |
| A-1001 | 2026-03-02T10:15:00Z | Northwind Traders | US | 1249.5 | shipped | priority; gift |
| A-1003 | 2026-03-04 | Globex GmbH | DE | 310 | pending | wholesale |
(real output of the free demo on 2026-11-04, also saved as export.csv with a download link; the _demo marker column is left out here) — made from 4 nested sample orders like
{"orderId": "A-1001", "placedAt": "2026-03-02T10:15:00Z", "customer": {"company": "Northwind Traders", "country": "US"}, "total": "$1,249.50", "tags": ["priority", "gift"], …}:
customer.company flattened and renamed to company, the price text turned into a number, a Unix timestamp turned into a date,
the cancelled order filtered out, and the rows sorted by total.
For anyone whose scraper output is nested, messy JSON and who needs a clean table — a CSV for Excel or Google Sheets, a flat file for a database, or tidy rows for the next step of a workflow. Point this Actor at an Apify dataset (or paste rows), say which columns you want, and get clean rows plus a CSV / JSONL / JSON file with a download link. No scraping, no external requests, no API keys.
Try it: press Start with the input as it is (no dataset, no pasted rows). You get the free demo above in a few seconds:
3 rows in the dataset, export.csv in the key-value store and its link in STATS. Not charged (rows carry _demo: true).
Price: from $0.455 per 1,000 output rows on Apify's paid plans (the price shown on this page); $0.65 per 1,000 on the free plan. Reading, flattening and filtering are free; rows removed by your filters are not charged.
What it does
- Flatten nested JSON:
{"address": {"city": "Austin"}}becomes the columnaddress.city(up to 20 levels, your own separator) - Arrays your way: keep as JSON, join values (
a; b; c), one column per item (tags.0,tags.1), first item only, or item count - Select, order, omit and rename columns (selecting
addresskeeps every column under it) - Convert types: text to number (
$1,234.50,(12),1.234,50), integer, boolean (yes/no/true/1), ISO 8601 date (from ISO text or Unix seconds/milliseconds), or to text - Filter rows: equals, contains, greater than, in a list, exists and more, combined with AND or OR
- Sort (numbers first, empty values last), skip and limit
- Save a file next to the dataset: CSV (delimiter, UTF-8 BOM for Excel, formula-injection protection), JSONL or JSON, with a link in the run statistics
- Works on any dataset: Google Maps, jobs, SERP, e-commerce, your own runs
Input example
{"datasetIds": ["WkzbQMuFYuamGv3YF"],"select": ["title", "address.city", "rating", "reviews"],"rename": {"address.city": "city"},"coerce": {"rating": "number", "reviews": "integer"},"filters": [{"field": "rating", "op": "gte", "value": 4.5}],"sortBy": "reviews","sortOrder": "desc","limit": 500,"exportFormat": "csv","csvBom": true}
With no dataset and no pasted rows, the Actor runs the free demo on 4 sample orders (3 rows out, not charged, rows carry _demo: true) so you can see flattening, type conversion, filtering, sorting and the CSV link before using your own data.
Order of processing
- Flatten (depth, arrays) and optional text trimming
- Convert types (
coerce) - Filter rows, then sort
- Keep / omit columns, then rename, then cut over-long cells
- Skip and limit; write the dataset rows; save the file
Column names in coerce, filters, sortBy, select and omit are the flattened names before renaming (for example address.city).
Output
- Dataset: the transformed rows. Use Apify's own export buttons for Excel/XML/RSS, or the API.
- File: saved in the run's key-value store as
<fileName>.csv(or.jsonl/.json). The link is in theSTATSrecord asfileUrl. It uses Apify's signed public link, so you can share it without sharing your token; if no link can be created, the file is still in the key-value store underfileKey. - STATS (key-value store):
{"rowsRead": 12034, "rowsFilteredOut": 9120, "rowsWritten": 2914,"coercionFailures": {"price": 3}, "cellsTruncated": 0,"columns": ["title", "city", "rating", "reviews"],"fileKey": "export.csv", "fileFormat": "csv", "fileRows": 2914, "fileUrl": "https://api.apify.com/v2/key-value-stores/…/records/export.csv?signature=…"}
Limits (cannot be raised by input)
- 1,000,000 output rows per run, 1,000 columns per row, 50,000 pasted rows (use a dataset for more)
- Sorting holds matching rows in memory: up to 500,000 rows (the run stops with a clear message, before any charge, if there are more)
- Files are capped at 150 MB (the dataset still gets every row;
fileTruncatedtells you) - Text cells are cut at 32,000 characters by default (Excel's limit is 32,767); set
maxCellCharsto change or0to disable - Empty rows (all values empty after your column choice) are skipped and not charged
- Rows that are not objects (a plain number or text) become
{"value": …}
Use cases
- Turn a Google Maps / jobs / e-commerce scraper dataset into a flat CSV for a spreadsheet
- Keep only the 6 columns your CRM import needs and rename them to its field names
- Convert price and date text into real numbers and ISO dates before loading to a database
- Filter and sort a dataset (top-rated, cheapest, newest) and hand the top 100 to the next Actor
Pricing
| Event | Free plan | Paid plans (Store discount tiers Bronze / Silver / Gold) |
|---|---|---|
| Output row (one transformed row written to the dataset and the file) | $0.65 per 1,000 | $0.585 / $0.52 / $0.455 per 1,000 |
The price on this page ("from $0.455") is the Gold tier price. Set a maximum charge per run to cap spend; the Actor stops cleanly when it is reached. On the Apify Free plan, the $5 of monthly platform credit covers about 7,600 rows a month — enough to try it on real data.
FAQ
Does it change my source dataset? No. It only reads it and writes a new dataset.
Why are my numbers still text? Add the column to coerce as number or integer. Values that cannot be read become empty and are counted in coercionFailures.
Excel shows broken characters. Turn on csvBom.
Is the file link private? Anyone holding the signed link can download the file; the link does not give access to anything else in your account.
If this Actor saved you time, a rating on the Store helps others find it.
More tools from the same developer
- CSV to Excel Converter — convert CSV, TSV, Excel XLSX, JSON and NDJSON files or Apify datasets into each other
- Google Sheets Export — export an Apify dataset to Google Sheets
- Remove Duplicates — merge Apify datasets and remove duplicates by the fields you choose
- Dataset Change Detector — compare two runs of any scraper: only added, removed and changed items
- Job Postings Normalizer — unify fields, salaries and dates from any job scraper and remove duplicates