# How to import NULL values

**URL:** <https://community.neo4j.com/t/how-to-import-null-values/73366>\
**Category:** Cypher\
**Tags:** cypher, import, neo4j-import, errors\
**Created:** [April 4, 2025, 1:29pm UTC](https://community.neo4j.com/t/how-to-import-null-values/73366 "2025-04-04T13:29:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![TornadoJoe](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/tornadojoe/32/34589_2.png) [@TornadoJoe](https://community.neo4j.com/u/TornadoJoe)\
**Post date:** [April 4, 2025, 1:29pm UTC](https://community.neo4j.com/t/how-to-import-null-values/73366/1 "2025-04-04T13:29:52Z")

</div>

Hi there,  
I try to import the following:

 ![Bildschirm­foto 2025-04-04 um 15.24.25](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/3X/3/4/341a4e5c8c43fcaa72fba44b82362dbf6e07a0a9.png)  
Im having a hard time to just having the "name" displayed without using coalesce as a placeholder or skipping rows with a where clause: WITH row WHERE row.country IS NOT NULL.

I´m stuck at this. Maybe someone has an idea.

LOAD CSV WITH HEADERS FROM 'file:///csv/organization.csv' AS row  
MERGE (n:Organization {  
abbreviation: row.abbreviation,  
name: row.name,  
city: row.city,  
country: row.country,  
province: row.province,  
established: datetime(replace(row.established, '-', '') + 'T00:00:00')  
});

---

<div class="post-metadata">

**Author:** ![joshcornejo](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/joshcornejo/32/34171_2.png) [@joshcornejo](https://community.neo4j.com/u/joshcornejo)\
**Post date:** [April 4, 2025, 1:38pm UTC](https://community.neo4j.com/t/how-to-import-null-values/73366/2 "2025-04-04T13:38:09Z")

</div>

Something like this:

```auto
LOAD CSV WITH HEADERS FROM 'file:///csv/organization.csv'' AS row
CREATE (n:Node)
SET n.property1 = CASE WHEN row.column1 IS NOT NULL AND row.column1 <> '' THEN row.column1 ELSE NULL END,
    n.property2 = CASE WHEN row.column2 IS NOT NULL AND row.column2 <> '' THEN row.column2 ELSE NULL END

```