Integration · Files and transfer

CSV to JSON converter, free and private

Describe a CSV once, map its columns, and download the rows as JSON. On a server the same mapping can push JSON or JSON Lines to an API.

CSV, TSV or Excel → JSON

What you need

Modules. Free in the browser. Transfer for delivery and Flow for schedules on a Server.

Edition. Free browser edition, Desktop or Server.

Pricing and what each edition includes.

Limits, stated plainly
  • Input files are CSV, TSV, Excel and custom-delimiter files. JSON is an output format, and what an HTTP source reads from an API.
  • Free edition limits: CSV and TSV up to 10 MB, Excel up to 5 MB, 100,000 rows.
Steps

How it works.

Each step names the feature as it appears in the product.

  1. Step 1

    File template

    Describe the input: delimiter, header row, column names and types.

  2. Step 2

    Field mapping

    Rename columns to the property names your API or app expects, and clean values on the way.

  3. Step 3

    Transform Data

    Run the file and download the result as JSON. Errors are listed by row and column.

  4. Step 4

    Validate File

    Check a file against its template first, so bad rows are found before the JSON is made.

  5. Step 5

    On a server

    A Push results step can deliver JSON or JSON Lines to an HTTP endpoint, an SFTP server or cloud storage on a schedule.

Questions

Common questions.

Can DataBridge read a JSON file?

Not as a file template. HTTP sources read JSON from an API, using a records path to find the array of records.

Is JSON Lines supported?

Yes for delivery. A Push results step can write JSON, JSON Lines, CSV or TSV.

Keep reading

Related use cases and integrations.

QuickBooks, Sage 100, NetSuite, Salesforce, HubSpot, Dynamics 365, Shopify and Amazon are trademarks of their respective owners. Names are used only to say which system a connection, layout or file is for. ExtensibilityCo is not affiliated with or endorsed by any of them.

Next step

Try the parts that are free today.

The free browser edition needs no sign-in and never uploads your files.