Data Import

These guides and tutorials are designed to help you understand how to import various types of data into Neo4j. From JSON to APIs to another database, you can retrieve data from nearly any source and use it to populate your graph.

Importing CSV files

One of the most common formats of data is in rows and columns on flat files. This spreadsheet format is used for a variety of imports and exports to/from relational databases, so it is easy to retrieve existing data this way.

You can also use this format of data for Neo4j! The LOAD CSV command in Cypher allows us to specify a filepath, headers or not, different value delimiters, and the Cypher statements for how we want to model that tabular data in a graph.

We will walk through the details of how to take any CSV file and import the data into Neo4j easily and quickly.

Import CSV from any URL
Neo4j Desktop: Import CSV Files

Importing API data

There are now many data sources that use an API to expose data via a URL - many of these in JSON format. You can also import this type of data into Neo4j using the APOC standard extension library and executing the commands in the Neo4j Browser command line or in a script.

The apoc.load.json command allows us to specify a URL path and any necessary parameters, followed by Cypher statements to model that tree-like data in a graph.

This guide shows us how to retrieve data from a JSON-based REST API and import it into Neo4j.

Importing API Data

Import: RDBMS to Graph

Many existing systems store data in relational or tabular types of formats. Knowing how to translate and migrate this data into graph data for analyzing the relationships can seem complex.

There are a variety of tools for migrating data from relational formats into graphs. In this guide, we want to discuss all of the options and why you can or should choose some over others for your use case.

Importing Relational Data to a Graph

Tutorial: Importing Data - Northwind

This guide will use a common relational data set (Northwind) and walk us through how to transform and import data from a relational database to Neo4j graph database.

You will learn what steps are needed to retrieve the data from the relational data store and import the same data as a graph in Neo4j, as well as how to take the relational data model and convert it to graph in the process.

Tutorial: Import Northwind Data

Example Data Sets

We want to provide some of our favorite data sets for you to practice your skills and learn more about importing and querying data in Neo4j! This guide shows a variety of open-source data sets that you can access and easily import. Happy learning!

Example Data Sets