Importing

LOAD CSV

The Cypher clause that reads a CSV file row by row, so those rows can be written into the graph.

Example

One (:Movie) node for every row in the file.

cypher
LOAD CSV WITH HEADERS FROM 'https://data.neo4j.com/importing-fundamentals/movies.csv' AS row
MERGE (m:Movie {movieId: row.movieId})
SET m.title = row.title,
    m.year = toInteger(row.year)

WITH HEADERS makes row a map keyed by the column names, so row.title reads that column. Every value in it arrives as a string, and toInteger(row.year) stores year as a number.

Lessons that use this term

The lesson and course links below open in a new tab.

No published lesson uses this term yet.

All glossary terms