# CSV to Excel & JSON to CSV Converter API (`ferrolark/data-convert`) Actor

CSV to Excel, JSON to CSV and XLSX converter: convert between CSV, TSV, JSON, NDJSON and Excel XLSX from URLs, base64 or inline JSON. Delimiter and encoding detection, nested JSON flattening, typed cells. For n8n, Make and AI agents. $0.003 per file.

- **URL**: https://apify.com/ferrolark/data-convert.md
- **Developed by:** [Ferrolark](https://apify.com/ferrolark) (community)
- **Categories:** Developer tools, Automation, Integrations
- **Features:** Limited permissions
- **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet

## Pricing

$3.00 / 1,000 file converteds

This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.

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

## What's an Apify Actor?

An Actor is a serverless cloud program that runs on the Apify platform. It has two run modes.
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.

Apify vocabulary and the platform model are defined once, in the agent quickstart at https://apify.com/agents.md.

## 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.

Do not guess an integration path. Every one of them is in the agent quickstart at https://apify.com/agents.md: the Apify MCP server, Agent Skills with the Apify CLI, the JavaScript and Python clients, the REST API, and the account-free path for an agent with no human to sign in. It also carries the rule on stating cost before the first paid run.

For examples already wired to this Actor's own input schema, see the [API](#api) section below.

Each client library has reference documentation the quickstart does not restate: [JavaScript/TypeScript](https://docs.apify.com/api/client/js/docs.md) (`npm install apify-client`) and [Python](https://docs.apify.com/api/client/python/docs.md) (`pip install apify-client`).

# README

## CSV to Excel, JSON to CSV and XLSX Converter API (Data Convert)

Convert tabular data between CSV, TSV, JSON, NDJSON (JSON Lines) and Excel XLSX with one API call.

- **Reads anything messy:** delimiter detection (comma, semicolon, tab, pipe), UTF-8 or Windows-1252 encoding, files without a header row.
- **Typed cells:** numbers and booleans become real numbers in Excel, while zip codes and IDs with leading zeros stay text.
- **Nested JSON flattening:** `{"user": {"name": ...}}` becomes a `user.name` column; arrays stay JSON or spread into columns.
- **Excel you can use:** bold header, frozen first row, auto-filter and sensible column widths. Formulas in data are stored as text, never executed.
- **Inline rows** from a previous n8n node, plus URLs and base64 files.

### Real example

A CSV with spaces after commas, plus two nested JSON rows sent inline, both to Excel:

```json
{
  "fileUrls": [
    "https://people.sc.fsu.edu/~jburkardt/data/csv/biostats.csv"
  ],
  "data": [
    {
      "sku": "A-1",
      "qty": 3,
      "meta": {
        "color": "red",
        "tags": [
          "x",
          "y"
        ]
      }
    },
    {
      "sku": "B-2",
      "qty": 1,
      "meta": {
        "color": "blue"
      }
    }
  ],
  "dataFileName": "inventory",
  "outputFormat": "xlsx"
}
```

- Run time: 3.8 s on Apify at 1,024 MB.
- Platform usage: $0.0006.
- Your cost: 2 files × $0.003 = **$0.006**.

| Output | From | Rows | Columns | Bytes |
|---|---|---|---|---|
| `biostats.xlsx` | CSV | 18 | 5 | 5,615 |
| `inventory.xlsx` | JSON | 2 | 4 | 5,090 |

The JSON rows became the columns `sku`, `qty`, `meta.color` and `meta.tags`.

### Price and limits

- **$0.003 per file converted** (the inline data counts as one file). The ZIP is free.
- Invalid files are listed in `OUTPUT.errors` and not charged.
- Limits: 20 files and 50 MB per run, 500,000 rows per file, 2,000 columns.

### Input

| Field | Default | What it does |
|---|---|---|
| `fileUrls` | none | CSV, TSV, JSON, NDJSON or XLSX URLs. |
| `files` | none | Base64 files. |
| `data` | none | Inline rows as JSON. |
| `outputFormat` | `xlsx` | `xlsx`, `csv`, `tsv`, `json`, `ndjson`. |
| `inputFormat` | `auto` | Force the input format. |
| `inputDelimiter`, `hasHeader` | auto, `true` | CSV reading. |
| `sheet` | first | XLSX sheet to read. |
| `jsonPath` | auto | Path to the rows, for example `data.items`. |
| `inferTypes` | `true` | Numbers and booleans from CSV. |
| `flatten`, `arrays` | `true`, `json` | Nested JSON handling. |
| `columns` | none | Column order. |
| `outputDelimiter` | `,` | Use `;` for European Excel. |
| `prettyJson` | `false` | Indented JSON. |
| `createShareableUrl` | `false` | Also return signed links that work without an Apify token. |

### Call it from code, n8n or an AI agent

**API (synchronous):**

```bash
curl -X POST "https://api.apify.com/v2/acts/ferrolark~data-convert/run-sync-get-dataset-items?maxTotalChargeUsd=0.1" \
  -H "Authorization: Bearer $APIFY_TOKEN" -H "Content-Type: application/json" \
  -d '{"fileUrls": ["https://example.com/orders.csv"], "outputFormat": "json"}'
```

**n8n:** paste this workflow on the canvas (Ctrl+V). Add a Header Auth credential with the name `Authorization` and the value `Bearer <your Apify token>`, and use it in both HTTP nodes. The second node downloads the file as an n8n binary, ready for Gmail, Drive or Slack.

```json
{
  "name": "Ferrolark data-convert",
  "nodes": [
    {
      "parameters": {},
      "name": "When clicking Test workflow",
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [
        0,
        0
      ]
    },
    {
      "parameters": {
        "method": "POST",
        "url": "https://api.apify.com/v2/acts/ferrolark~data-convert/run-sync-get-dataset-items?maxTotalChargeUsd=0.05",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendBody": true,
        "specifyBody": "json",
        "jsonBody": "{\"data\": [{\"sku\": \"A-1\", \"qty\": 3}, {\"sku\": \"B-2\", \"qty\": 1}], \"outputFormat\": \"xlsx\"}",
        "options": {
          "timeout": 300000
        }
      },
      "name": "Run Actor",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        220,
        0
      ]
    },
    {
      "parameters": {
        "url": "={{ $json.downloadUrl }}",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "options": {
          "response": {
            "response": {
              "responseFormat": "file"
            }
          }
        }
      },
      "name": "Download file",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        440,
        0
      ]
    }
  ],
  "connections": {
    "When clicking Test workflow": {
      "main": [
        [
          {
            "node": "Run Actor",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run Actor": {
      "main": [
        [
          {
            "node": "Download file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
```

**AI agents (MCP):** add the Apify MCP server (`https://mcp.apify.com`) to Claude, Cursor or any MCP client and allow `ferrolark/data-convert`. The agent gets a typed tool with the input above.

### FAQ

**Does it keep leading zeros?**

Yes. `02134` stays text; `2134` becomes a number. Turn `inferTypes` off to keep everything as text.

**Is it safe to open the Excel files?**

Yes. Values starting with `=` are stored as text cells, so no formula from the data runs.

### More Ferrolark tools

- [Brand Name Availability Checker](https://apify.com/ferrolark/brand-name-checker): domains, GitHub, npm, PyPI and more in one report.
- [Domain Intelligence Report](https://apify.com/ferrolark/domain-intelligence-report): WHOIS, DNS, email security, SSL and hosting for any domain.
- [Launch Asset Pack](https://apify.com/ferrolark/launch-asset-pack): favicons, PWA icons, OG image and head tags from one logo.
- [Live Deploy QA](https://apify.com/ferrolark/live-deploy-qa): meta tags, canonical, robots, OG image and favicon of your deployed routes, with diffs between deploys.
- [Sitemap Delta](https://apify.com/ferrolark/sitemap-delta): new, removed and broken URLs in any sitemap since the last run.
- [RSS Delta](https://apify.com/ferrolark/rss-delta): only new RSS, Atom and JSON Feed items, de-duplicated.
- [PDF Merge API](https://apify.com/ferrolark/pdf-merge-api): merge PDFs from URLs or base64 with page ranges and a SHA-256 manifest.
- [PDF Split API](https://apify.com/ferrolark/pdf-split-api): split a PDF by page ranges or every N pages, or extract pages, with a ZIP and manifest.
- [Image Convert](https://apify.com/ferrolark/image-convert): PNG, JPG, WebP, AVIF and HEIC conversion (SVG input too) from URLs or base64.
- [Image Compress & Resize](https://apify.com/ferrolark/image-compress-resize): resize images and compress them to a target size in KB, WebP or AVIF.
- [PDF to Image](https://apify.com/ferrolark/pdf-to-image): PDF pages to PNG, JPG or WebP at the DPI you choose.
- [Image to PDF](https://apify.com/ferrolark/image-to-pdf): JPG, PNG, HEIC and WebP images to one PDF, JPEGs embedded without recompression.
- [PDF Compress](https://apify.com/ferrolark/pdf-compress): smaller PDFs, lossless or with image downsampling; charged only when smaller.
- [HTML to PDF & URL to PDF](https://apify.com/ferrolark/html-to-pdf): web pages or raw HTML to PDF with headless Chrome.
- [Markdown to PDF](https://apify.com/ferrolark/markdown-to-pdf): Markdown with tables, code and footnotes to a clean PDF.
- [DOCX to PDF](https://apify.com/ferrolark/docx-to-pdf): Word, Excel, PowerPoint and ODT to PDF with LibreOffice.

***

*Built by Ferrolark.*

# Actor input Schema

## `fileUrls` (type: `array`):

Public CSV, TSV, JSON, NDJSON/JSONL or XLSX files. Up to 20 files and 50 MB per run (500,000 rows per file).

## `files` (type: `array`):

For n8n/Make binaries: a list of {"base64": "...", "name": "orders.csv"} objects.

## `data` (type: `array`):

Rows as JSON, for example the output of a previous n8n node: \[{"sku": "A-1", "qty": 3}].

## `dataFileName` (type: `string`):

Output file name (without extension) for the inline data.

## `outputFormat` (type: `string`):

Target format.

## `inputFormat` (type: `string`):

Auto detects from the content.

## `inputDelimiter` (type: `string`):

Empty = auto-detect (comma, semicolon, tab or pipe). Use \t for tab.

## `hasHeader` (type: `boolean`):

Turn off for files without a header row; columns are then named column_1, column_2, ...

## `sheet` (type: `string`):

Sheet to read. Default: the first one.

## `jsonPath` (type: `string`):

For example data.items. By default a single top-level array of objects is found automatically.

## `inferTypes` (type: `boolean`):

Numbers become numbers; values with leading zeros (zip codes, IDs) stay text.

## `flatten` (type: `boolean`):

For CSV/XLSX output: {"user": {"name": ...}} becomes a user.name column.

## `arrays` (type: `string`):

How lists are written.

## `columns` (type: `array`):

Put these columns first, in this order. Other columns follow.

## `outputDelimiter` (type: `string`):

Use ; for European Excel.

## `sheetName` (type: `string`):

Default: Sheet1 (or the input sheet's name).

## `prettyJson` (type: `boolean`):

Indent JSON output.

## `createZip` (type: `boolean`):

Bundle all outputs in one ZIP (free).

## `createShareableUrl` (type: `boolean`):

Also return signed links that work without an Apify token. Anyone with a link can download that file.

## Actor input object example

```json
{
  "fileUrls": [
    "https://people.sc.fsu.edu/~jburkardt/data/csv/biostats.csv"
  ],
  "files": [],
  "dataFileName": "data",
  "outputFormat": "xlsx",
  "inputFormat": "auto",
  "hasHeader": true,
  "inferTypes": true,
  "flatten": true,
  "arrays": "json",
  "outputDelimiter": ",",
  "prettyJson": false,
  "createZip": true,
  "createShareableUrl": false
}
```

# Actor output Schema

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

No description

## `files` (type: `string`):

No description

# 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 = {
    "fileUrls": [
        "https://people.sc.fsu.edu/~jburkardt/data/csv/biostats.csv"
    ],
    "files": []
};

// Run the Actor and wait for it to finish
const run = await client.actor("ferrolark/data-convert").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 = {
    "fileUrls": ["https://people.sc.fsu.edu/~jburkardt/data/csv/biostats.csv"],
    "files": [],
}

# Run the Actor and wait for it to finish
run = client.actor("ferrolark/data-convert").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 '{
  "fileUrls": [
    "https://people.sc.fsu.edu/~jburkardt/data/csv/biostats.csv"
  ],
  "files": []
}' |
apify call ferrolark/data-convert --silent --output-dataset

```

## MCP server setup

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

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/VNtbAubdAhGvXQgOz/builds/SjJGmrhuPYpqVae8Z/openapi.json
