Working with data import and export
APOC allows us to load data from various file formats, including CSV, JSON, Excel, XML, HTML, and GraphML. It can also export graph data as CSV or JSON. We will take a look at how to import data in each format.
First, we will take a look at importing CSV data.
Importing CSV data
We can use the apoc.load.csv method to load CSV data into a graph. It is very similar to the LOAD CSV command, but it provides a lot more options and is more tolerant of failures.
It provides these extra options when loading CSV files:
- It provides line numbers so that we can trace issues
- Both map and list representations for each CSV line are available
- The data is automatically converted to the correct data type and the data can be split into arrays as needed
- It is also possible to keep the original string-formatted values they are in the file
- There is an option to ignore fields, thus making it easier to assign a full line as properties...
