Load a CSV file

LOAD CSV streams the rows of a CSV file into a query. Unlike LOAD JSONL / LOAD GML (which build a whole graph from a file), LOAD CSV is a reading statement that yields one row at a time, bound to a variable you can reference in RETURN, MATCH, or CREATE. The file must live in the data subdirectory of the TuringDB working directory (set by -turing-dir, default $HOME/.turing).

Syntax

LOAD CSV "<file>" [WITH HEADERS] [ON ERROR SKIP | ON ERROR FAIL] AS <row>

Clause	Description
`WITH HEADERS`	Treat the first line as column names; access columns as `row.<name>`. Without it, access columns by 0-based index `row[0]`, `row[1]`, …
`ON ERROR SKIP`	Skip malformed rows
`ON ERROR FAIL`	Abort on the first malformed row (the default)
`AS <row>`	Variable bound to each row

All values come back as strings — wrap them in toInteger(...) / toFloat(...) if you need numbers.

With headers

LOAD CSV "people.csv" WITH HEADERS AS row
RETURN row.name AS name, row.age AS age, row.city AS city

Without headers (index access)

LOAD CSV "people.csv" AS row
RETURN row[0] AS name, row[1] AS age
LIMIT 5

Building a graph from CSV

Because LOAD CSV yields rows, you can drive CREATE from it inside a change:

change = client.new_change()
client.checkout(change=change)
client.query('LOAD CSV "people.csv" WITH HEADERS AS row CREATE (:Person {name: row.name, age: toInteger(row.age)})')
client.query("COMMIT")
client.query("CHANGE SUBMIT")
client.checkout()

LOAD CSV followed by MATCH in the same read statement is not yet supported.

JSONL Neo4j

⌘I

Get Started

Concepts

Benchmarks

Query Language

Importing data

Graph Development

Vector Search

Graph Algorithms

Tutorials

Python SDK

Troubleshooting

Syntax

With headers

Without headers (index access)

Building a graph from CSV

​Syntax

​With headers

​Without headers (index access)

​Building a graph from CSV

Syntax

With headers

Without headers (index access)

Building a graph from CSV