Using Load CSV to Import data from Google SpreadsheetMy colleague Rickard recently did a great graphgist on Elite:Dangerous trading. When I read his post, the first thing that struck me was that he had found a great clever way to import data into Neo4j. And since I have been into data imports for a while, I decided to take it for a spin, and write it up for you. The mechanism uses two fundamental capabilities:
- Google Spreadsheets have a great capability to export the data into a CSV format. That export capability generates a unique URI that you can download the CSV of a specific sheet in the spreadsheet from.
- Neo4j’s Load CSV capability can leverage data that is located at **any** URI. The data does not have to be local – it can be anywhere on the network.
About the Author
Rik Van Bruggen, Regional VP & Neo4j Advocate
Rik Van Bruggen brings 10 years experience in sales, specifically in web-based application development and security/identity management to his work at Neo Technology. Previously with Courion and Imprivata, Rik has managed sales and strived for customer success across Europe. Rik is a Belgian technology addict with a passion for sales, family, friends, music, travel, and of course, good food and even better, beer. Rik also runs the Graphistania podcast on graph databases.