Convert a CSV file to JSON or JSON Lines

Created by

Michael Costa

Actor

Dataset Transformer: Filter, Dedupe, JSON to CSV

Load a CSV from a URL and get it as a dataset you can download as JSON, Excel or XML, plus a JSON Lines file, with the columns renamed the way you want. This example converts the U.S. Treasury's daily Debt to the Penny figures. Swap in your own CSV link.

Try for free

Dataset Transformer: Filter, Dedupe, JSON to CSVhumble-echidna/dataset-transform

Date

Total debt (USD)

Held by the public

Intragovernmental

Input

Or: file URL or upload (CSV, JSON, JSONL or Excel):https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v2/accounting/od/debt_to_penny?format=csv&sort=-record_date&page[size]=10

Fields to keep (and rename):record_date -> date+3

Also save as a file:jsonl

Output fields

Date

Total debt (USD)

Held by the public

Intragovernmental

How it works

Sign up on Apify or log in

The Dataset Transformer: Filter, Dedupe, JSON to CSV Actor is ready to run with the inputs already set for "Convert a CSV file to JSON or JSON Lines". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "Convert a CSV file to JSON or JSON Lines" task

The Dataset Transformer: Filter, Dedupe, JSON to CSV Actor will start running based on the input automatically. You can also change all the input fields, like or: file url or upload (csv, json, jsonl or excel), fields to keep (and rename), and more, to match your specific use case.

Receive the "Convert a CSV file to JSON or JSON Lines" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as date, total debt (usd), held by the public, and more.

Integrate into your workflow

The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow. You can also run the "Convert a CSV file to JSON or JSON Lines" task via API.