Neo4J (5.14.0): add labels based on values in CSV file

Question

I'm trying to create nodes with one set label (:object) and two additional labels that are based on values in the following CSV file:

Object_ID	Classification	Hierarchy_name	Object_type
O0010	visual_works	sculpture	sculpture
O0011	components	book_jackets	book

I thought it would be possible to add dynamic labels based on the values in the spreadsheet using the $ expression, but I cannot find information about how to use this in relation to loading information from a CSV file.

Currently, my faulty script looks like this:

LOAD CSV WITH HEADERS FROM 'file:///classification.csv' AS row
CREATE (o:object:$(row.Hierarchy_name):$(row.Classification){ID: row.Object_ID, Type: row.Type});

Christophe Willemsen · Accepted Answer · 2025-08-05 10:30:04Z

0

Dynamic labels in SET clauses was introduced in Neo4j 5.24, so you must upgrade to that version at a minimum.

LOAD CSV WITH HEADERS 
FROM 'file:///classification.csv' AS row
CREATE (o:Object {ID: row.Object_ID, Type: row.Type})
SET o:$(row.`Hierarchy_name`)
SET o:$(row.`Classification`);

answered Aug 5 at 10:30

Christophe Willemsen

20.2k2 gold badges33 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jaap Aug 5 at 10:56

Works as a charm, thanks a lot!!

Collectives™ on Stack Overflow

Neo4J (5.14.0): add labels based on values in CSV file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related