Save cypher-shell or neo4j command-line output to CSV

Neo4j Graph Platform Import / Export
1

I have a query that returns many rows and want to save results in comma- or tab-delimited format for easy ingestion outside neo4j.

Current approach is to feed query to cypher-shell and save output to file:

cat myfile.cql | cypher-shell -u user -p password --format plain > output_file

Query results are not tab- or comma-delimited. How can I make this happen? Is there an alternative approach other than opening the browser, running the query from there, then exporting as CSV?

2

Consider using the apoc library and its export to csv procedure:
https://neo4j-contrib.github.io/neo4j-apoc-procedures/#export-csv

3

That looks like the very thing I wanted. Will execute. You are a scholar and a gentleman, Brant, and I think you.

1 Like