Convert SQL to JSON lines (JSONL / NDJSON / LDJSON)

by

Posted on by

Want to convert SQL to JSON lines (JSONL / NDJSON / LDJSON)?

Try Withdata Data File Converter, a desktop SQL to JSON converter for Windows, MacOS, and Linux, Convert SQL to JSON lines, Easy and Fast.

  • Can run in GUI mode, Step by Step, just a few mouse clicks.
  • Can run in Command line, for Scheduled Tasks and Streams.
  • Convert files locally and privately, avoid uploading large SQL file(s) to online services.

Download DataFileConverter Download DataFileConverter

JSON Lines text format (JSONL), also called Newline-delimited JSON (NDJSON), or Line-delimited JSON (LDJSON). JSON Lines files may be saved with the file extension .jsonl, *.ndjson, *.ldjson.

Convert SQL to JSON lines (JSONL / NDJSON / LDJSON)

Choose SQL file -> Set target JSON Lines (JSONL / NDJSON / LDJSON) file -> Convert SQL to JSON lines (JSONL / NDJSON / LDJSON)

Click “Start a New Convert” at task dialog.

Convert SQL to JSONL - task window

then show the wizard.

Select source/target file type.

Convert SQL to JSONL - select type

1. Open a SQL file.

Convert SQL to NDSQL - open JSON lines file

The SQL content:

Convert SQL to NDSQL - JSON lines content

2. Config target JSON Lines (JSONL / NDJSON / LDJSON) file.

Convert SQL to LDSQL - config SQL file

3. Set rows options.

Convert SQL to JSONL - summary

4. Convert SQL to JSON lines (JSONL / NDJSON / LDJSON).

Convert SQL to NDJSON - convert

See JSON lines file

Convert SQL to LDJSON - view JSON lines file

Convert SQL to JSON lines (JSONL / NDJSON / LDJSON) in command line

Save “SQL to JSON Lines” session, then you can:

Set scheduled tasks for converting SQL to JSON lines (JSONL / NDJSON / LDJSON)

You can schedule and automate this converting task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “SQL to JSON lines” conversion.
  2. Set scheduled task for “SQL to JSON lines” conversion.

FAQ

More tools for JSONL / NDJSON / LDJSON.