CSV Import of a list of retail stores

Questions
1

Hi, this may have been posted in the wrong category - its my first post here.

I’m in the process of creating a Store Finder facility which reads a list of stores within Umbraco and plots them on a map.

All is working fine. However, I’m having to manually add each store. As the list of stores is approaching 600+, this is going to put me into an early grave!

Is there a simple way of importing a CSV list of all stores and have the columns match up to the corresponding properties in my DocType?

My structure is as follows:

StoresList (Doctype: 'StoresList')
    Store 1 (DocType: 'StoreDetails')
        Name
        Address
        Postcode
        Latitude
        Longitude
    Store 2
        ...

So for each row in the CSV I want to create a new Store under StoresList

I have SQL access.

Any help would be greatly appreciated.

This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/69858-csv-import-of-a-list-of-retail-stores