How to export csv file of large resultset using cypher in Neo4j in the browser?

You can also use my shell extensions to export cypher results to CSV.

See here: https://github.com/jexp/neo4j-shell-tools#cypher-import

Just provide an -o output.csv file to the import-cypher command.


Well, I just used linux shell to do all the job.

neo4j-shell -file query.cql | sed 's/|/;/g' > myfile.csv

In my case, I had also to convert from UTF-8 to ISO-8859-1 so I typed:

neo4j-shell -file query.cql | sed 's/|/;/g' | iconv -f UTF-8 -t ISO-8859-1 -o myfile.csv

PS: sed performs the replace: 's/|/;/g' means, substitute (s) all "|" to ";" even though there is more than one per line (g)

Hope this can help.
Regards


We followed the approach below using mentioned. It works very well for us. data is formatted properly in csv format.

https://github.com/jexp/neo4j-shell-tools#cypher-import

import-cypher command from neo4J shell.

neo4j-sh (?)$ import-cypher -o test.csv MATCH (m:TDSP) return m.name

Tags:

Neo4J

Cypher