# Error in CSV importing procedure with CYPHER

**URL:** <https://community.neo4j.com/t/error-in-csv-importing-procedure-with-cypher/15224>\
**Category:** Import / Export\
**Created:** [March 2, 2020, 8:39am UTC](https://community.neo4j.com/t/error-in-csv-importing-procedure-with-cypher/15224 "2020-03-02T08:39:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![pavlo](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/pavlo/32/9054_2.png) [@pavlo](https://community.neo4j.com/u/pavlo)\
**Post date:** [March 2, 2020, 8:39am UTC](https://community.neo4j.com/t/error-in-csv-importing-procedure-with-cypher/15224/1 "2020-03-02T08:39:58Z")

</div>

I'm trying to import CSV with the CYPHER console.

I found example on this URL

> **[Tutorial: Import CSV data using LOAD CSV - Getting Started](https://neo4j.com/docs/getting-started/data-import/csv-import/)**
>
> This tutorial shows how to use the command LOAD CSV to import small to medium datasets in CSV format into Neo4j using Aura and on-premise deployments.

Example:  
LOAD CSV FROM '[https://neo4j.com/docs/cypher-manual/3.5/csv/artists.csv](https://neo4j.com/docs/cypher-manual/3.5/csv/artists.csv)'

## When I try to call this command with any kind of input file (local or with URL) I got this error

## Neo.ClientError.Statement.SyntaxError Unexpected end of input: expected whitespace, '.', node labels, '[', "=~", IN, STARTS, ENDS, CONTAINS, IS, '^', '\*', '/', '%', '+', '-', '=', '~', "\<\>", "!=", '\<', '\>', "\<=", "\>=", AND, XOR, OR or AS (line 1, column 79 (offset: 78)) "LOAD CSV WITH HEADERS FROM "[http://srv.sidelov.com:8000/20200228-FULL-1\_1.csv](http://srv.sidelov.com:8000/20200228-FULL-1_1.csv)"" ^

Even when I try to run example without any changes from sample  
LOAD CSV FROM '[https://neo4j.com/docs/cypher-manual/3.5/csv/artists.csv](https://neo4j.com/docs/cypher-manual/3.5/csv/artists.csv)'

I got the same error  
Unexpected end of input: expected whitespace, '.', node labels, '[', "=~", IN, STARTS, ENDS, CONTAINS, IS, '^', '\*', '/', '%', '+', '-', '=', '~', "\<\>", "!=", '\<', '\>', "\<=", "\>=", AND, XOR, OR or AS (line 1, column 73 (offset: 72))  
"LOAD CSV FROM '[https://neo4j.com/docs/cypher-manual/3.5/csv/artists.csv](https://neo4j.com/docs/cypher-manual/3.5/csv/artists.csv)'"

What wrong with CSV importing syntaxis?

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![pilar.saez](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/pilar.saez/32/3913_2.png) [@pilar.saez](https://community.neo4j.com/u/pilar.saez)\
**Post date:** [March 2, 2020, 9:23am UTC](https://community.neo4j.com/t/error-in-csv-importing-procedure-with-cypher/15224/2 "2020-03-02T09:23:08Z")

</div>

Hi Pavlo,

Can you try this?

LOAD CSV FROM '[https://neo4j.com/docs/cypher-manual/3.5/csv/artists.csv](https://neo4j.com/docs/cypher-manual/3.5/csv/artists.csv)' AS line  
RETURN line

---

<div class="post-metadata">

**Author:** ![jeffdyke](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/jeffdyke/32/16483_2.png) [@jeffdyke](https://community.neo4j.com/u/jeffdyke)\
**Post date:** [February 2, 2021, 5:01am UTC](https://community.neo4j.com/t/error-in-csv-importing-procedure-with-cypher/15224/3 "2021-02-02T05:01:30Z")

</div>

I know this is old, but its also incredibly helpful. I wish this would be in the documentation....thanks

---

<div class="post-metadata">

**Author:** ![ryan.saxton](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ryan.saxton/32/4171_2.png) [@ryan.saxton](https://community.neo4j.com/u/ryan.saxton)\
**Post date:** [April 1, 2021, 1:35am UTC](https://community.neo4j.com/t/error-in-csv-importing-procedure-with-cypher/15224/4 "2021-04-01T01:35:21Z")

</div>

Hi all. Trying to import a .csv via a public google drive file using the following cypher, but getting an errror msg (also shown below). My first time at this - any help very much welcomed:

LOAD CSV WITH HEADERS FROM '[Pipelines - Google Sheets](https://docs.google.com/spreadsheets/d/1dGwRA2NN7EDBkVmAT90MKxpe0vu1XRM_6DymoNfyMhI/edit#gid=0l)' AS csvLine

CREATE (p:Pipeline {id: toInteger(csvLine.id), name: csvLine.pipelinename, capacity: csvLine.capacity, operator: csvLine.operator, commodity: csvLine.commodity})

Error msg:  
Invalid input ' ': expected "CSV" (line 1, column 5 (offset: 4))  
"LOAD csv WITH HEADERS FROM '[Pipelines - Google Sheets](https://docs.google.com/spreadsheets/d/1dGwRA2NN7EDBkVmAT90MKxpe0vu1XRM_6DymoNfyMhI/edit#gid=0l)' AS csvLine"