geo_vba VS VBA-CSV-interface

Apart from the mentioned solutions, you can try this code I wrote a while ago: https://github.com/krijnsent/geo_vba

As u/Grey_Patagonia_Vest describes: you could add some more information like a postal code to the address. If you're looking for "main street", that will give tons of hits, if you add a postal code and/or city there is a higher chance you get to your desired location/city. I've built this toolkit, based on OpenStreetMap / Nominatim to transform addresses to lat/long -> https://github.com/krijnsent/geo_vba , using the geo_nom_search function, you could give it a try.

Not sure if it is of any use to you, but OSM has quite some data too. I have some code in a repository that could be of assistance: https://github.com/krijnsent/geo_vba

During this process, I also thought about how to offer the users of the tool a help channel where they can receive help, since the code project is currently maintained by a single person. This is why I decided to create the r/CSVinterface community, whose main objective is to serve as a help channel for CSV Interface users.

To prove that we are capable to unlocks some performance limitations from traditional file processing approach, I decided to develop the CSVTextStream to gain advantage over native VBA's I/O functionalities, boosting the efficiency of text file reading up to 2 GB in size by use a buffered text stream technique. You can download the latest version from here.

This is by no means all the functionality that CSV Interface can provide. If you want to know more details, I invite you to read the documentation.

Your requirements are according to RFC-4180 specifications. There is no standard CSV format. This situation has led to the proliferation of CSV variations such as DSV, TSV... Creating a custom library to solve your problem can be a solution, you can also use other already developed and well tested libraries such as CSV Interface, a library that supports CSV according to RFC-4180 specifications and also DSV files using the Unix style scape sequence.

VBA can solve, literally, every problem you can face in your daily routine. You can automate repetitive task and also expand the language to create complete utilities and offer others a solution to a common issue. For example, I created VBA CSV Interface to help users deal with data from CSV files.

With CSV Interface this task can be done with easy. The library has a MergeField method that performs this specific task. Also you can shift fields and rearrange them as you wish.

As usual, at the end of the year, a new version of VBA CSV Interface is available. However, this time it is a major revision focused on refactoring code and increasing the usability of the tool.

This is a great use case of VBA CSV interface. Using the library you can split your file on related data and filter it out by column/field content.

Save your data as CSV and manage it from CSV Interface.