# CSV to JSON Converter — Bulk (`hipersoft/csv-to-json`) Actor

Convert CSV to clean JSON (and JSON back to CSV) with delimiter detection, header handling and automatic type inference for numbers, booleans and dates. Ready for APIs, no-code tools and pipelines.

- **URL**: https://apify.com/hipersoft/csv-to-json.md
- **Developed by:** [hiper soft](https://apify.com/hipersoft) (community)
- **Categories:** Developer tools, Other
- **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet

## Pricing

from $0.005 / file converted

This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.
Since this Actor supports Apify Store discounts, the price gets lower the higher subscription plan you have.

Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event

## What's an Apify Actor?

Actors are web data automations that power AI and operations. They run on the Apify platform to scrape websites, process data, connect APIs, and automate workflows.
In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours,
and optionally produces a well-defined JSON output, datasets with results, or files in key-value store.
In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server.
Actors are written with capital "A".

## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.
The best way to integrate Actors is as follows.

- **AI agents and MCP clients** — the [Apify MCP server](https://docs.apify.com/integrations/mcp.md) at `https://mcp.apify.com` (remote, streamable HTTP, OAuth on first use).
- **Agentic workflows and local Actor development** — [Agent Skills](https://apify.com/.well-known/agent-skills/index.json) with the [Apify CLI](https://docs.apify.com/cli/docs.md): `npm install -g apify-cli`, then `apify login`.
- **JavaScript/TypeScript projects** — the official [JS/TS client](https://docs.apify.com/api/client/js/docs.md): `npm install apify-client`.
- **Python projects** — the official [Python client](https://docs.apify.com/api/client/python/docs.md): `pip install apify-client`.
- **Any other language** — the [REST API](https://docs.apify.com/api/v2.md).

For usage examples, see the [API](#api) section below.

For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt).

# README

## CSV to JSON Converter — Bulk (and JSON to CSV)

**Convert CSV to clean JSON — or JSON back to CSV — in bulk.** Automatic delimiter handling, header detection and type inference for numbers, booleans and dates, so the output is ready for APIs, no-code tools, spreadsheets and data pipelines. Paste your data or point to a file URL.

### What it does

- **CSV → JSON**: parse CSV into a clean JSON array, with optional type inference.
- **JSON → CSV**: flatten a JSON array into a CSV file.
- Handles custom **delimiters**, **headers** and large files.

### Use cases

- **API integration** — turn CSV exports into JSON to POST to an API.
- **No-code tools** — get data into the shape a tool expects.
- **Spreadsheets** — convert JSON back to CSV for Excel/Sheets.

### Input

```json
{ "mode": "csv-to-json", "csvText": "name,age,active\nAda,36,true\nAlan,41,false", "header": true, "dynamicTyping": true }
```

| Field | Type | Description |
|---|---|---|
| `mode` | string | `csv-to-json` or `json-to-csv`. |
| `csvText` | string | CSV to convert (or use `fileUrl`). |
| `jsonText` | string | JSON array to convert (for JSON → CSV). |
| `fileUrl` | string | Optional file URL instead of pasting. |
| `delimiter` | string | Column delimiter (auto-detected if blank). |
| `header` | boolean | First CSV row is a header. |
| `dynamicTyping` | boolean | Infer numbers/booleans (CSV → JSON). |

### Output

A summary row, plus the full converted file at `result.json` / `result.csv` in your key-value store.

```json
{ "rows": 2, "columns": 3, "resultUrl": "https://api.apify.com/v2/key-value-stores/.../records/result.json" }
```

#### Output schema

| Field | Type | Description |
|---|---|---|
| `rows` | integer | Number of rows converted. |
| `columns` | integer | Number of columns. |
| `resultUrl` | string (URL) | Link to the converted file. |

### FAQ

**Where's the converted data?** In the `result.json` / `result.csv` file in the run's key-value store.

**Can I automate it?** Yes — via [integrations on the Apify platform](https://apify.com/integrations) and the [Apify API](https://docs.apify.com/api/v2).

### Notes

Original clean-room implementation.

# Actor input Schema

## `mode` (type: `string`):

Which way to convert.

## `csvText` (type: `string`):

Paste CSV here (for CSV → JSON). Leave empty to use a file URL.

## `jsonText` (type: `string`):

Paste a JSON array here (for JSON → CSV). Leave empty to use a file URL.

## `fileUrl` (type: `string`):

Optional link to a CSV or JSON file to convert instead of pasting.

## `delimiter` (type: `string`):

Column delimiter (leave blank to auto-detect for CSV, defaults to comma for output).

## `header` (type: `boolean`):

Treat the first CSV row as column names.

## `dynamicTyping` (type: `boolean`):

Convert numbers and booleans automatically (CSV → JSON).

## Actor input object example

```json
{
  "mode": "csv-to-json",
  "csvText": "name,age,active\nAda,36,true\nAlan,41,false",
  "header": true,
  "dynamicTyping": true
}
```

# Actor output Schema

## `results` (type: `string`):

The results as dataset items.

# API

You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup.

## JavaScript example

```javascript
import { ApifyClient } from 'apify-client';

// Initialize the ApifyClient with your Apify API token
// Replace the '<YOUR_API_TOKEN>' with your token
const client = new ApifyClient({
    token: '<YOUR_API_TOKEN>',
});

// Prepare Actor input
const input = {
    "csvText": `name,age,active
Ada,36,true
Alan,41,false`
};

// Run the Actor and wait for it to finish
const run = await client.actor("hipersoft/csv-to-json").call(input);

// Fetch and print Actor results from the run's dataset (if any)
console.log('Results from dataset');
console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
items.forEach((item) => {
    console.dir(item);
});

// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

```

## Python example

```python
from apify_client import ApifyClient

# Initialize the ApifyClient with your Apify API token
# Replace '<YOUR_API_TOKEN>' with your token.
client = ApifyClient("<YOUR_API_TOKEN>")

# Prepare the Actor input
run_input = { "csvText": """name,age,active
Ada,36,true
Alan,41,false""" }

# Run the Actor and wait for it to finish
run = client.actor("hipersoft/csv-to-json").call(run_input=run_input)

# Fetch and print Actor results from the run's dataset (if there are any)
print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
for item in client.dataset(run.default_dataset_id).iterate_items():
    print(item)

# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

```

## CLI example

```bash
echo '{
  "csvText": "name,age,active\\nAda,36,true\\nAlan,41,false"
}' |
apify call hipersoft/csv-to-json --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "type": "http",
            "url": "https://mcp.apify.com/?tools=fetch-actor-details,hipersoft/csv-to-json"
        }
    }
}

```

The hosted server signs you in with OAuth on first connect, so no API token belongs in this config. Clients without OAuth support can send an `Authorization: Bearer <APIFY_API_TOKEN>` header instead, using a token from API & Integrations in Apify Console (https://console.apify.com/settings/integrations).

## OpenAPI specification

Download the OpenAPI definition: https://api.apify.com/v2/actors/ca1EIfkifrLQgYgHX/builds/bezTNaH2VgQigphF2/openapi.json