Pricing

from $0.15 / 1,000 row converteds

Try for free

Go to Apify Store

Spreadsheet Converter: Excel to JSON and CSV

Try for free

Convert Excel to JSON, CSV to JSON, JSON to CSV and Excel to CSV. Reads XLSX, XLS, ODS, CSV, TSV, JSON and Apify datasets. Writes CSV, XLSX, JSON, JSON Lines or dataset rows. Detects headers, numbers and dates, flattens nested JSON, picks sheets and removes duplicates.

Pricing

from $0.15 / 1,000 row converteds

Rating

0.0

(0)

Developer

Malik Said

Actor stats

Bookmarked

Total users

Monthly active users

4 days ago

Last modified

Categories

Developer tools

Automation

Integrations

File URLs

fileUrls

Optional

Links to the files to convert, one per line. XLSX, XLS, ODS, XLSB, CSV, TSV, JSON and JSON Lines work. The Actor reads robots.txt on each host and skips files it does not allow. Leave empty to convert only the key-value store, datasets or pasted data below.

Type:array

Key-value store with files

keyValueStoreId

Optional

Optional. Pick one of your key-value stores that holds uploaded spreadsheet files. The Actor only reads this store.

Type:string

Record keys

keyValueStoreKeys

Optional

Optional. Convert only these records of the store. Leave empty to convert every spreadsheet record in the store.

Type:array

Default:

[]

Datasets to convert

datasetIds

Optional

Optional. Pick Apify datasets, for example the results of another Actor. Each dataset becomes one CSV, XLSX, JSON or JSON Lines file.

Type:array

Pasted data

pastedData

Optional

Optional. Paste CSV, TSV, JSON or JSON Lines text, or a base64 file of any supported format, for example from n8n, Make or an API call. Up to 4 MB. For larger files, use a URL or a key-value store. The format is detected like a downloaded file.

Type:string

Pasted data file name

pastedFileName

Optional

Name for the pasted data in the results and output files. The Actor adds the detected extension.

Type:string

Default:pasted

Output format

outputFormat

Optional

Dataset rows: each row becomes one dataset item, which you can export from Apify in any format. The file formats save one file per sheet (XLSX: one workbook per input file) in the run's key-value store.

Type:string

Default:dataset

Options:

datasetcsvtsvxlsxjsonjsonl

Merge all files into one output

mergeIntoOneFile

Optional

Append the rows of every file and sheet into one output with the union of all columns. Turn on 'Add source columns' to see where each row came from.

Type:boolean

Default:false

Add a byte order mark to CSV and TSV files

csvBom

Optional

Turn on when you open the CSV in Excel and the file has accents or non-Latin text, such as Arabic or Chinese. Excel then reads it as UTF-8.

Type:boolean

Default:false

Maximum rows per file

maxRowsPerFile

Optional

Stop reading a file after this many saved rows. 0 means all rows.

Type:integer

Minimum:0

Default:0

Maximum files

maxFiles

Optional

Convert at most this many files in one run. The Actor converts at most 1,000 files per run.

Type:integer

Minimum:1

Maximum:1000

Default:1000

Sheets

sheets

Optional

Sheet names or tab numbers (1 is the first tab) to convert. Leave empty to convert every sheet.

Type:array

Default:

[]

Header row

headerMode

Optional

Auto finds the first full row of text labels in the first 10 rows and skips title rows above it. First row uses row 1. None names columns column_1, column_2 and so on. Row number uses the row you set below.

Type:string

Default:auto

Options:

autofirstRownonerowNumber

Header row number

headerRowNumber

Optional

Used only when Header row is 'Row number below'. Row 1 is the first row of the sheet.

Type:integer

Minimum:1

Default:1

Input format

inputFormat

Optional

Auto reads the file's first bytes, so a wrong file extension does not matter. Set a format only when auto-detection picks the wrong one.

Type:string

Default:auto

Options:

autocsvtsvxlsxxlsodsjsonjsonl

CSV delimiter

delimiter

Optional

Auto picks comma, semicolon, tab or pipe from the first lines. Type one character to force it. Type 'tab' for a tab.

Type:string

Default:auto

Text encoding

encoding

Optional

For CSV and TSV files. Auto reads a byte order mark, then checks for UTF-8, then falls back to Latin-1.

Type:string

Default:auto

Options:

autoutf8latin1utf16le

JSON path to the records

jsonPath

Optional

For JSON files whose records sit inside an object, for example 'data.items'. Leave empty to use a top-level list or the first list inside the object.

Type:string

Default:

Detect numbers, dates and true/false

inferTypes

Optional

Turn CSV text such as '12.5', '1,200' and 'true' into numbers and booleans, and ISO dates into dates. Codes with leading zeros, such as '008', stay text. Spreadsheet cells keep the type they have in the file.

Type:boolean

Default:true

Numbers use a decimal comma

decimalComma

Optional

Turn on for European CSV files where '1.234,5' means one thousand two hundred thirty-four and a half.

Type:boolean

Default:false

Day and month order in text dates

dateOrder

Optional

Convert text dates such as '03/04/2026' to ISO dates. Choose the order your file uses. 'Leave as text' keeps them unchanged.

Type:string

Default:none

Options:

noneDMYMDY

Keep only these columns

columns

Optional

Column names to keep, in this order. Use the names in the file (nested JSON fields as 'parent.child'). Leave empty to keep every column.

Type:array

Default:

[]

Rename columns

renameColumns

Optional

Map old column names to new ones, for example {"Entity": "country"}.

Type:object

Default:

{}

Remove duplicates by

dedupeBy

Optional

Keep only the first row for each value of these columns. Use * to remove rows that are identical in every column. Leave empty to keep duplicates.

Type:array

Default:

[]

Keep only rows that match

filters

Optional

Keep only rows that match. One rule per line: column, operator, value, for example "Price >= 10" or "Country = Jordan". Operators: =, !=, <, <=, >, >=, contains, starts with, is empty, is not empty. Numbers compare as numbers; text compares ignore case. Filtered rows are free.

Type:array

Default:

[]

Rows must match

filterMode

Optional

Keep a row when it matches all rules, or any one rule.

Type:string

Default:all

Options:

allany

Sort by

sortBy

Optional

Sort rows by these columns. Add " desc" after a name for largest first, for example "Price desc". Sorting holds the rows in memory: up to about 1,000,000 short rows at 512 MB. A row limit applies before sorting.

Type:array

Default:

[]

Flatten nested JSON

flattenNested

Optional

Turn nested objects into 'parent.child' columns. Auto flattens for CSV, TSV and XLSX outputs and keeps nesting for JSON, JSON Lines and dataset outputs.

Type:string

Default:auto

Options:

autoalwaysnever

Lists inside JSON records

arrayMode

Optional

How flattening handles lists. Join puts simple lists in one cell, separated by '; '. Index makes one column per position ('tags.0', 'tags.1'). JSON keeps the list as JSON text.

Type:string

Default:join

Options:

joinindexjson

Skip empty rows

skipEmptyRows

Optional

Drop rows where every cell is empty.

Type:boolean

Default:true

Trim spaces

trimValues

Optional

Remove spaces at the start and end of text cells. Cells that become empty are saved as empty.

Type:boolean

Default:true

Add source columns

addSourceColumns

Optional

Add _file, _sheet and _row to each row, so you can trace every row back to its file, sheet and row number.

Type:boolean

Default:false

Maximum file size (MB)

maxFileMegabytes

Optional

Skip files larger than this. CSV, TSV, JSON Lines and XLSX are read as streams. XLS, ODS, XLSB and JSON are read whole and have a lower limit that depends on the run memory (32 MB at 512 MB).

Type:integer

Minimum:1

Maximum:500

Default:100

TOON to JSON (converter)

room_js/toon-to-json-converter

This actor allows you to convert TOON format to JSON

JavaScript Room

JSON to CSV Converter

eloquent_mountain/json-to-csv-converter

JSON to CSV Converter. Effortlessly transform JSON data into CSV with our Apify actor. Handle nested structures, expand lists into rows, and customize separators and delimiters. Input via URL or paste JSON text. Ideal for data analysis and reporting!

Paco

File Converter All-in-one

tufantoksoz/file-converter

Convert files between popular formats at scale on Apify. Transform documents, spreadsheets, and images with professional-grade quality and performance. Convert word to pdf, jpeg to png and more

Tufan Toksöz

Pdf To Jpg Converter

programmersoham/pdf-to-jpg-converter

Convert PDF documents into high-quality JPEG images. Supports batch processing, customizable resolution (72-300 DPI), page ranges, and flexible output (URLs, ZIP, or both). Perfect for web developers, content creators, e-commerce, education, and marketing teams.

Soham Purohit

URL to PDF Converter

lexis-solutions/url-to-pdf-converter

Convert any webpage into professional PDF documents—archive websites, generate reports, and create print-ready versions. Automatically save to your Apify key-value store with sanitized filenames. Fast, reliable, and perfect for archiving, reporting, and compliance workflows.

Lexis Solutions

5.0

(1)

JSON ↔ CSV Converter

web.harvester/json-csv-converter

Convert between JSON and CSV bidirectionally. Flatten nested objects to dot notation. Handle arrays with stringify, join, or first element. Custom delimiters (comma, semicolon, tab, pipe). Parse types automatically. Upload files, provide URLs, or load from Apify Datasets.

Web Harvester

Excel Converter — XLSX to CSV & JSON (and back)

hipersoft/excel-converter

Convert Excel workbooks to CSV or JSON (all sheets or one), or build a styled XLSX from JSON. The spreadsheet glue for no-code and n8n automation pipelines.

hiper soft

JSON to TOON (converter)

room_js/json-to-toon-converter

This Actor allows you to convert any JSON document to TOON format

JavaScript Room

Data Format Converter: JSON, XML, YAML, CSV and TSV

examsens.ai/data-format-converter

Converts JSON, JSON Lines, XML, YAML, CSV and TSV files, URLs, pasted text or Apify datasets to any of the other formats, with nested object flattening, record path selection and type detection. Returns a download link for each file.

Ed Rayyis

Excel, CSV & JSON Converter and Cleaner

divinxxii/spreadsheet-converter

Convert Excel (xlsx, xls), CSV, TSV, JSON and JSON Lines files to JSON, CSV or XLSX and clean them: trim, drop empty rows and columns, snake_case headers, remove duplicates, detect numbers and dates. Every row lands in the dataset.