File Converter & Data Profiler: CSV, Excel, JSON, Parquet avatar

File Converter & Data Profiler: CSV, Excel, JSON, Parquet

Pricing

$2.00 / 1,000 file processeds

Go to Apify Store
File Converter & Data Profiler: CSV, Excel, JSON, Parquet

File Converter & Data Profiler: CSV, Excel, JSON, Parquet

Convert tabular files between CSV, TSV, Excel, JSON, JSONL and Parquet, and profile every column: types, nulls, uniques, min/max/mean, top values and date detection. URL or inline data.

Pricing

$2.00 / 1,000 file processeds

Rating

0.0

(0)

Developer

Tudor Lane

Tudor Lane

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

12 hours ago

Last modified

Categories

Features

Limited permissions

Share

Use when: a data or ops agent is handed a spreadsheet or data dump and needs it in another format (CSV, Excel, JSON, JSONL or Parquet), plus a column profile of types, nulls, stats and top values.

Try this input (also the default, just click Start)

{"requests": [{"url": "https://raw.githubusercontent.com/mwaskom/seaborn-data/master/penguins.csv", "to": "json", "max_rows": 1000}]}

Sample output (real run, 11 Nov 2026, trimmed)

{"source": "https://raw.githubusercontent.com/mwaskom/seaborn-data/master/penguins.csv", "detected_format": "csv", "rows": 344, "columns": 7, "duplicate_rows": 0, "column_profile": [{"name": "species", "dtype": "str", "nulls": 0, "unique": 3, "top_values": [{"value": "Adelie", "count": 152}, {"value": "Gentoo", "count": 124}, {"value": "Chinstrap", "count": 68}]}, {"name": "bill_length_mm", "dtype": "float64", "nulls": 2, "null_pct": 0.58, "unique": 164, "min": 32.1, "max": 59.6, "mean": 43.92193, "median": 44.45}], "converted_to": "json", "file_bytes": 49387, "file_url": "https://api.apify.com/v2/key-value-stores/.../records/converted-c9ff42760b.json?signature=...", "error": null}

Options

  • Reads CSV (delimiter sniffed), TSV, Excel (.xlsx, optional sheet), JSON, JSONL and Parquet from a url or inline data.
  • Writes any of those (to: json, jsonl, csv, tsv, xlsx, parquet, or none to profile only). The converted file gets a download file_url.
  • Column profile: type, nulls, unique count, min/max/mean/median/std, top values and date detection; also row count, duplicate rows and sample rows.
  • Up to 50 MB per file; max_rows caps how many rows are read. No API key needed.

Pricing: pay per event, $0.002 per file processed (one file read, profiled and optionally converted). Errors are not charged. No subscription.

Limits & failure modes

  • Converted files live in the run's key-value store and expire with Apify retention; download them if you need them long-term.
  • Private, local or non-http(s) URLs are rejected (SSRF protection). Empty or unreadable input returns an uncharged error.
  • Default example is Palmer Penguins (CC0). Libraries: pandas (BSD), openpyxl (MIT), pyarrow (Apache 2.0).

Last tested: 11 Nov 2026.

Use from AI agents (MCP)

  • Apify MCP server: add https://mcp.apify.com/?tools=tudorlane/file-convert-profile to Claude, Cursor, ChatGPT, VS Code or any MCP client.
  • REST: POST https://api.apify.com/v2/acts/tudorlane~file-convert-profile/run-sync-get-dataset-items?token=YOUR_TOKEN with the input JSON.