Tools / Dataset & JSON to CSV / Excel Converter (Flatten, Pick Fields)

Dataset & JSON to CSV / Excel Converter (Flatten, Pick Fields)

Convert any Apify dataset or JSON/JSONL URL into a clean CSV, Excel (.xlsx) or JSONL file. Input: datasetId, jsonUrl. Output (JSON/CSV): one row per item with source, format, rowCount, columnCount, fileUrl, sizeKb.

Run it on Apify Store →

What it's for

Turn any scraper's nested JSON into an Excel sheet for a client
Pick and order columns for a CRM import
Convert a public JSON API response into CSV

Example input

{
 "jsonUrl": "https://jsonplaceholder.typicode.com/users",
 "format": "xlsx"
}

Example output

{
  "source": "https://jsonplaceholder.typicode.com/users",
  "format": "xlsx",
  "rowCount": 10,
  "columnCount": 15,
  "columns": [
    "id",
    "name",
    "username",
    "email",
    "…"
  ],
  "fileUrl": "https://api.apify.com/v2/key-value-stores/cm5hPObBv46oYPlne/records/export.xlsx",
  "sizeKb": 9
}

Input reference

Field	Type	Notes
`datasetId`	string	From any run in your account.
`jsonUrl`	string	Public URL returning an array or JSON lines.
`format`	string	Output format
`fields`	array	Columns to keep, in order (dot paths when flattened).
`flatten`	boolean	Flatten nested objects
`delimiter`	string	Use \t for TSV.
`maxItems`	integer	Max items

Pricing

Pay per event: Export file created $0.005, Row converted $2e-05. Plus Apify's small per-run start fee. Apify's free plan includes monthly credit to try it.

How to run

Open the Store page and click Try for free.
Fill in the input (or paste the example JSON in the JSON tab).
Click Start, then export results as CSV, Excel or JSON, or call it via the Apify API.
Optional: add a Schedule and a webhook/Slack/email integration for ongoing monitoring.

Open Dataset & JSON to CSV / Excel Converter (Flatten, Pick Fields) on Apify →