Load a Tab Delimited File into Neo4j

Neo4j is a popular graph database which provides an easy way to import text files using the Cypher query language and a LOAD CSV clause. LOAD CSV by default expects files to be delimited by commas. In order to specify another field delimiter, add FIELDTERMINATOR to the LOAD CSV clause. For example:

The statement above loads the tab separated twitter_relationships_top_100.txt file (with headers) into the database, creating User labels/nodes with a username property for each record. A small sample of this file can be seen below:

For a more detailed description of the LOAD CSV clause, please refer to the Neo4j documentation at the Neo4j LOAD CSV page.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">