CSV Tools

Convert CSV to JSONL

Convert CSV rows into JSONL — one JSON record per line, also known as NDJSON, JSON Lines, or newline-delimited JSON

Converting the other way? Use the JSONL to CSV converter. Need to convert another format? Search all of our CSV converters.

CSV Input

Try a sample:

JSON Lines

JSON Lines output will appear here...

Options

CSV Format

Conversion

How to Use This Tool

Use this tool when you need one JSON record per line instead of a single JSON array. JSONL — the same format is also called NDJSON, JSON Lines, or newline-delimited JSON — is a common format for logs, data pipelines, and streaming imports.

The converter accepts pasted CSV text, local files, or a CSV URL. It runs client-side in your browser and shows parse warnings when Papa Parse can recover from malformed rows.

  1. Step 1 — Paste CSV, drop a file, or fetch a URL in the CSV Input panel.
  2. Step 2 — Configure CSV parsing options like delimiter, headers, and dynamic types.
  3. Step 3 — Copy or save the JSONL output (.jsonl) for your downstream tool.

FAQ

4 questions
Are JSONL, NDJSON, and JSON Lines the same format?
Yes. JSONL (JSON Lines), NDJSON (newline-delimited JSON), and JSON Lines all name the same convention: one complete JSON value per line, separated by newlines. Files usually carry the .jsonl extension. Output from this tool works anywhere that accepts any of those names.
Does this CSV to JSONL converter upload my data?
No. The conversion runs entirely in your browser. Your CSV data stays on your device unless you choose to fetch a remote URL directly from your browser.
What does the output look like?
Each CSV row becomes one minified JSON value on its own line. With headers enabled, each line is a JSON object. With headers disabled, each line is a JSON array.
Can I parse numbers and booleans automatically?
Yes. Enable Dynamic types to have values like 42, 3.14, true, and false emitted as JSON numbers and booleans instead of strings.

More Convert File Formats Tools

22 tools

CSV to Excel

Export CSV data to .xlsx spreadsheets

Excel to CSV

Import .xlsx files and convert to CSV

CSV to JSON

Convert CSV files to clean, structured JSON

JSON to CSV

Convert JSON arrays to downloadable CSV

CSV to XML

Transform CSV into well-formed XML documents

XML to CSV

Convert XML data with repeating elements into CSV

CSV to TSV

Convert comma-separated values to tab-separated format

TSV to CSV

Convert tab-separated data into comma-separated CSV

CSV to HTML

Generate HTML tables from CSV data for easy web embedding

HTML to CSV

Extract table data from HTML and convert to CSV

CSV to YAML

Convert CSV to YAML — clean, readable documents

YAML to CSV

Convert YAML lists into CSV format

CSV to Markdown

Convert CSV to Markdown table format — GitHub-flavored, with aligned columns

Markdown to CSV

Convert Markdown tables into CSV format

JSONL to CSV

Convert JSONL (NDJSON / JSON Lines) data into CSV format

CSV to SQL

Generate SQL INSERT statements from CSV data

CSV to Fixed Width

Convert CSV data into fixed-width column format

Fixed Width to CSV

Convert fixed-width column data into CSV format

CSV to LaTeX

Generate LaTeX table markup from CSV data

Parquet to CSV

Convert Apache Parquet files to CSV format

Feather to CSV

Convert Apache Feather/Arrow files to CSV format

CSV to Parquet

Convert CSV into columnar Parquet format for efficient storage

More CSV Tools

115 tools

Add Header Row

Add a header row to a CSV that doesn't have one

Anonymize Columns

Anonymize CSV data by replacing sensitive column values with fake data

Compare Files

Compare two CSV files and highlight the differences

Column Counter

Count the number of columns in your CSV

CSV to Excel

Export CSV data to .xlsx spreadsheets

CSV to YNAB

Convert CSV bank statements into YNAB-compatible import format

CSV Viewer

View and explore CSV files in a sortable table

Extract Email Addresses

Find and extract all email addresses from your text or CSV

Filter Rows

Filter CSV online — keep only rows that match your criteria

GeoJSON to CSV

Convert GeoJSON features to CSV rows

Merge CSVs

Combine multiple CSV files into one

Remove Columns

Delete one or more columns from your CSV

Transpose CSV

Swap rows and columns in your CSV

Column Stats

Get data type, null count, unique count, and common values per column

CSV to Xero

Convert CSV bank statements into Xero-compatible import format

Excel to CSV

Import .xlsx files and convert to CSV

Extract Columns

Keep only the columns you need from your CSV

Extract Phone Numbers

Find and extract all phone numbers from your text or CSV

Find Missing Rows

Find rows in one file that are missing from another

KML to CSV

Extract placemarks from KML files into CSV

Redact Columns

Mask or remove sensitive values from selected columns

Remove Header Row

Remove the header row from your CSV

Sort CSV

Sort CSV online — order rows by any column, ascending or descending

Split CSV

Break large CSVs into smaller chunks

Calculate Dimensions

Get the row count, column count, and size of your CSV

Change Header Case

Switch headers between camelCase, snake_case, kebab-case, and more

CSV to JSON

Convert CSV files to clean, structured JSON

CSV to QBO

Convert CSV bank transactions into QuickBooks format

Extract URLs

Find and extract all URLs from your text or CSV

Find Common Rows

Find rows that appear in both CSV files

KMZ to CSV

Convert zipped KMZ map files to CSV

Remove Duplicates

Find and eliminate duplicate rows

Rename Columns

Change the header names of your CSV columns

Split by Column Value

Split a CSV into multiple files based on column values

GPX to CSV

Convert GPX waypoints and tracks to CSV

JSON to CSV

Convert JSON arrays to downloadable CSV

QBO to CSV

Export QBO to CSV — convert QuickBooks Web Connect files into clean CSV

Remove Empty Rows

Delete rows that are completely empty

Reorder Columns

Rearrange the column order in your CSV

Row Counter

Quick count of rows, columns, and empty cells

Sample Rows

Pick a random sample of rows from your CSV

Add Column

Add a new column with a default value to your CSV

Count Values

Count the number of non-empty values in each column

CSV to QFX

Convert CSV to Quicken QFX format for direct import

CSV to XML

Transform CSV into well-formed XML documents

Fill Missing Values

Replace empty cells with a default value

First N Rows

Extract the first N rows from your CSV

Shapefile to CSV

Convert zipped shapefiles to CSV with attributes and coordinates

CSV to GeoJSON

Convert CSV coordinates to GeoJSON features

Find and Replace

Search for values in your CSV and replace them

Last N Rows

Extract the last N rows from your CSV

One-Hot Encode Column

Convert categorical values into binary columns

QFX to CSV

Convert Quicken QFX files into CSV format

Summary Statistics

Get count, mean, min, max, and percentiles for numeric columns

XML to CSV

Convert XML data with repeating elements into CSV

CSV to KML

Generate KML placemarks from CSV coordinates

CSV to OFX

Convert CSV financial data into Open Financial Exchange format

CSV to TSV

Convert comma-separated values to tab-separated format

Extract Date Parts

Pull year, month, day, and more from date columns

Slice Rows

Extract a range of rows by start and end position

Split Column

Split one column into two columns by a delimiter

Sum Column

Calculate the total of all values in each numeric column

Trim Whitespace

Remove leading and trailing spaces from all cells

Add Row Numbers

Add a sequential row number column to your CSV

Average Column

Calculate the average of all values in each numeric column

CSV to KMZ

Create compressed KMZ map files from CSV coordinates

Merge Columns

Combine two columns into one using coalesce logic

OFX to CSV

Convert OFX financial files into CSV format

Remove HTML Tags

Strip HTML tags from cell values in your CSV

TSV to CSV

Convert tab-separated data into comma-separated CSV

Count Unique

Count the number of distinct values in each column

CSV to GPX

Convert CSV coordinates to GPX waypoints for GPS devices

CSV to HTML

Generate HTML tables from CSV data for easy web embedding

CSV to QIF

Convert CSV financial data into Quicken Interchange Format

Map Column Values

Replace column values using a visual mapping table

Remove Comments

Remove comment lines from your CSV

Reverse Rows

Reverse the order of rows in your CSV

HTML to CSV

Extract table data from HTML and convert to CSV

QIF to CSV

Convert Quicken QIF files into CSV format

Remove Whitespace

Strip all unnecessary whitespace from your CSV

Running Total

Add a cumulative sum column to your CSV

Shuffle Rows

Randomly reorder all rows in your CSV

Uppercase Column

Convert all values in a column to uppercase

Compress CSV

Minify your CSV by removing unnecessary whitespace and formatting

CSV to YAML

Convert CSV to YAML — clean, readable documents

Lowercase Column

Convert all values in a column to lowercase

Percentage of Total

Add a column showing each row's share of the total

QFX to QBO

Convert QFX files into QBO format for QuickBooks

CSV Validator

Check your CSV for formatting errors and structural issues

QBO to QFX

Convert QBO files into QFX format for Quicken

Rolling Average

Calculate a moving average over a sliding window of rows

Swap Column Data

Swap the data between two columns in your CSV

YAML to CSV

Convert YAML lists into CSV format

CSV to Markdown

Convert CSV to Markdown table format — GitHub-flavored, with aligned columns

Duplicate Column

Create a copy of an existing column

OFX to QBO

Convert OFX files into QBO format for QuickBooks

Parquet Viewer

View parquet files online — sortable table plus full schema, types, and row counts

Markdown to CSV

Convert Markdown tables into CSV format

QBO to OFX

Convert QBO files into OFX format for most finance apps

OFX to QFX

Convert OFX files into QFX format for Quicken

JSONL to CSV

Convert JSONL (NDJSON / JSON Lines) data into CSV format

QFX to OFX

Convert QFX files into OFX format for most finance apps

CSV to SQL

Generate SQL INSERT statements from CSV data

QFX to QIF

Convert QFX files into QIF format for older Quicken versions and legacy apps

CSV to Fixed Width

Convert CSV data into fixed-width column format

QIF to QFX

Convert legacy QIF files into QFX format for Quicken

Fixed Width to CSV

Convert fixed-width column data into CSV format

QBO to QIF

Convert QBO files into QIF format for older Quicken versions and legacy apps

CSV to LaTeX

Generate LaTeX table markup from CSV data

QIF to QBO

Convert legacy QIF files into QBO format for QuickBooks

OFX to QIF

Convert OFX files into QIF format for older Quicken versions and legacy apps

QIF to OFX

Convert legacy QIF files into OFX format for most finance apps

Parquet to CSV

Convert Apache Parquet files to CSV format

Feather to CSV

Convert Apache Feather/Arrow files to CSV format

CSV to Parquet

Convert CSV into columnar Parquet format for efficient storage