Add or update records in your database by importing a CSV file.

Use this guide to get started with the data management features of Ginkgo. You can use this dataset to demo the import features of the platform in this walkthrough:

Manhattan Ave merchants Citiesense demo.csv

<aside> 💡 Download a copy of the "Manhattan Ave merchants" spreadsheet above to try out the features in the following steps.

</aside>

1) Find the Table you are adding your records to

Once logged in, navigate to the Tables interface: https://app.ginkgo.city/tables

This interface is designed for desktop screen sizes.

For this walkthrough, we'll import a spreadsheet of Business records into our account for Manhattan Avenue in Greenpoint, Brooklyn.

2) Select the tab for the Table you want to work with

You can import your records into any of the following tables for your account.

There are currently 10 different Tables available for us to work with in Ginkgo. Select the one you're looking for.

<aside> 💡 For this walkthrough we need to select "Tenants". This is where we can manage our Business records.

</aside>

3) Import an existing spreadsheet as a .csv file of your records

Once you've selected the tab (in this case, we selected "Tenants"), you can click the blue import button to open the importer. Either select your file, or drag and drop it directly into the importer to begin the import.

<aside> 💡 Ginkgo will only recognize specific field names in your spreadsheet. Be sure to Download the template to make sure you're using the field names available for that table.

</aside>

  1. Review your data import

The import process may take a while depending on how many records you're importing. If there are errors, an error message will appear describing the error and the line that it occurred for so that you can retry for those records.

<aside> 💡 Geocoding your records correctly - In our example with the Manhattan Ave merchants, the records already have mapping coordinates assigned to them. Ginkgo utilizes geographic coordinates written as decimal degrees when analyzing your data from a field called the_geom. Decimal degrees is the most common geographic coordinate format used for web mapping applications. Ginkgo stores the coordinates in a single field called the_geom. In most cases, you will need a complete address in the address field for all your records in order to geo-locate your records on the map correctly. (ie: street name, city, state, zip code)

</aside>