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

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?

Consider using the apoc library and its export to csv procedure:

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

1 Like