How to import a CSV file in Neo4j?

1 year ago
Jackson Davis
2 minutes

To import CSV files into Neo4j, you can use Cypher statements. The specific steps are as follows:

  1. Prepare the CSV file: Ensure that the CSV file is properly prepared with the correct columns and data.
  2. Open the Neo4j browser interface: Access the Neo4j interface through your browser.
  3. Execute import statement: Enter the following Cypher query into the browser’s input box to import the CSV file.
LOAD CSV WITH HEADERS FROM "file:///path/to/your/csv/file.csv" AS row
CREATE (:Label {property1: row.column1, property2: row.column2, ...})

Please replace “/path/to/your/csv/file.csv” with the actual CSV file path, “Label” with the node label, and “property1”, “property2”, etc. with the actual property names in the corresponding columns of the CSV file.

  1. Execution statement: Click the run button or press Ctrl+Enter to execute the import statement.
  2. Waiting for the import to complete: Waiting for Neo4j to finish importing the CSV file.

By following these steps, you can successfully import a CSV file into Neo4j. Keep in mind that if the CSV file is large, the import process may take some time. Additionally, there are other options available to customize the import process, such as setting unique constraints on nodes or relationships, using the MERGE statement for updates, and more. For more information, refer to the official documentation provided by Neo4j.

bannerAds