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

by

Posted on by

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

Using Data File Converter, a native GUI SQL to JSON lines converter for Windows, MacOS, and Linux, you can convert SQL to JSON lines (JSONL / NDJSON / LDJSON) easily 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, 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. Summary.

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.

2) Set scheduled task.

More about DataFileConverter – SQL to JSON lines (JSONL / NDJSON / LDJSON) Converter

Download DataFileConverterDownload DataFileConverter