You can access the Excel & CSV Merger: Consolidate, Pivot & Batch Convert programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4# Replace '<YOUR_API_TOKEN>' with your token.
5client = ApifyClient("<YOUR_API_TOKEN>")
6
7# Prepare the Actor input
8run_input = {
9    "operation": "consolidate",
10    "files": [
11        { "url": "https://raw.githubusercontent.com/eschaq/dws-spreadsheet-samples/main/north.csv" },
12        { "url": "https://raw.githubusercontent.com/eschaq/dws-spreadsheet-samples/main/south.xlsx" },
13        { "url": "https://raw.githubusercontent.com/eschaq/dws-spreadsheet-samples/main/west.xls" },
14    ],
15    "consolidate": {
16        "strategy": "stack_rows",
17        "addSourceColumn": True,
18    },
19    "pivot": {
20        "groupBy": ["Region"],
21        "values": ["Revenue"],
22        "aggregations": ["sum"],
23    },
24}
25
26# Run the Actor and wait for it to finish
27run = client.actor("dws_build/excel-csv-merger-consolidate-pivot-batch-convert").call(run_input=run_input)
28
29# Fetch and print Actor results from the run's dataset (if there are any)
30print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
31for item in client.dataset(run.default_dataset_id).iterate_items():
32    print(item)
33
34# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

Excel & CSV Merger: Consolidate, Pivot & Batch Convert API in Python

The Apify API client for Python is the official library that allows you to use Excel & CSV Merger: Consolidate, Pivot & Batch Convert API in Python, providing convenience functions and automatic retries on errors.

Install the apify-client

$pip install apify-client

Other API clients include:

Excel & CSV Merger: Consolidate, Pivot & Batch Convert API in JavaScript

Excel & CSV Merger: Consolidate, Pivot & Batch Convert API through CLI

Excel & CSV Merger: Consolidate, Pivot & Batch Convert OpenAPI definition

Excel & CSV Merger: Consolidate, Pivot & Batch Convert API

Dataset Aggregate, Group By & Pivot

nerolabs/dataset-aggregate-pivot

Returns GROUP BY and pivot tables for any Apify dataset, file or Google Sheet by URL, or JSON array: count, sum, average, min, max, median per group, date buckets, pivot columns. Exports CSV/Excel, appends to a named dataset, posts to a webhook. Agent-ready: pay per event (x402, MCP), per input row.

Adam Pearce

Video Converter & Compressor – MP4, MP3, WebM, GIF (FFmpeg)

gazidev/media-converter

Video converter, video compressor and audio converter for media file URLs: MP4/WebM/MOV, compress to a target size or 1080p/720p/480p, MP4 to MP3, WAV/FLAC/M4A/OGG/Opus, video to GIF, trim, mute, normalize loudness. Public download links. From $0.03 per video minute.

Cemal Atakli

Free Large Video Converter

lukaskrivka/audio-video-converter

Flexible and powerful conversion tool using the popular ffmpeg program ideal for very large video and audio files. Convert any audio or video file to a different format and adjust any settings. Automatically recognizes the source format.

Lukáš Křivka

174

Currency Converter

accelerationengg/currency-converter

Currency converter APIs have two major issues: - Some gap between the free and min paid tier (like 100 vs 5000) - Free tiers provide static rates To overcome them, we made this converter. Initially, we made it for our internal use, but seeing its application, it's now public.

Acceleration

Audio format converter MP3 WAV FLAC

akash9078/audio-file-converter

Convert audio files between 10+ formats including messaging platform optimized formats. Supports Telegram (OGG), WhatsApp (AMR), Discord (OPUS), plus MP3, WAV, FLAC, AAC, M4A, 3GP, WebM. Perfect for voice messages, podcasts, and cross-platform audio compatibility.

Akash Kumar Naik

133

5.0

(2)

Excel to JSON: XLSX, CSV & TSV files from URLs

glistening_film/spreadsheet-to-json

Convert XLSX, CSV and TSV files from URLs into clean JSON — one dataset item per spreadsheet row — with all sheets included and types preserved. $0.01 per successfully converted file, no start fee. Failed, unsupported or corrupt files are reported but never charged.

Yodesla

HTML to PDF Converter

automation-lab/html-to-pdf-converter

Convert HTML content or web pages to PDF documents. Supports raw HTML strings, single URLs, and bulk URL lists. Full control over page size, margins, orientation, headers, and footers.

Automation Lab

CSV/JSON Data Cleaner & Converter

m3web/scraped-data-cleaner-rental

Clean and organize scraped .json or .csv data — no coding required. Remove duplicates, empty rows, unwanted columns, and sort by any field. Cleaned results are pushed to your Apify dataset. Perfect for marketers, researchers, and no-code workflows.

M3Web

5.0

(1)

JSON to Excel Converter - JSON to XLSX, by URL or Bulk

eliai/json-to-excel

Converts JSON to Excel from a .json URL, one file or bulk: records become XLSX rows, keys become the header row, column widths are sized, one sheet per key for object-of-arrays. Returns a downloadable .xlsx per file. Failures are free. For analysts, ops engineers and no-code builders.

Broke to Built

Unit Converter Input

moving_beacon-owner1/unit-converter-input

A versatile tool to **convert numeric values between different units**, with support for **single and batch conversions**. Works for length, weight, temperature, volume, and more.