Extracting lat lon of points from list of postal codes

Question

I have scraped a list of postal codes for which I want to extract (lat, lon) data.

• extracted postal codes

In Postal Codes Germany, I was able to extract lat lon for the postal code by is there a way I can for a list of postal codes all at a time?

• postal code

Answer 1

The answer to your question is “absolutely, yes”. Let me explain one way to do it.

First, you will need to prepare an “MS-Excel.csv” file or text file with your postal code data. Within that file, next to each postal code, add the country for those pieces of data.

Note: That step is usually optional if all postal codes are residing in the same region (country) but for the sake of clarity and to make sure the data is absolutely going to be considered only from Germany, this is a good step. So, let’s explore the list: 38440, DEU 66121, DEU 83700, DEU 66706, DEU 54518, DEU 18586, DEU 67146, DEU 83317, DEU 65205, DEU 97688, DEU

Next, save this data on your computer as an “MS-Excel.csv” or just ".csv" type file if you prefer to work with a file for many data lines.

You could experiment with just entering single line or a small list in the white box labeled “Paste/type your content . . . “, but for large files, you will be well advised to upload that data into the orange box labeled “Browse or Drop CSV File Here”. Drop the file there or simply copy paste the content of the zip codes.

Now, import that “MS-Excel.csv” file into the orange box on the front of CSV2GEO app and you should see a window open-up similar the window here:

Across the top line, you will need to classify each element of the address to instruct the geocoding algorithm to process the data.

In this example, the column starting 38440, select “zip” code, in the next column showing “DEU” select “country”. Don’t worry about data usage. CSV2GEO provides up to 100 free geocode data transformations daily and is very reasonably priced for large data files.

Note: If your original file had contained only postal codes without an identified country/region, you could have clicked on “Show Advance Settings” and select the desired country, assuming all data was from the same country.

Once you have all known data elements (tokens) classified, simple click “Process data”. In this case, the first column selected is “zip code” and the second is “country”.

Now, the first ten rows of data will be processed to provide a sense-check. From this, you will be able to dry-run the validity of the batch to see if it appears to make sense before processing a huge data file. This should provide confidence or time to correct if necessary. Once you get sensible initial results, you are ready to go.

Next, click on “Next Step – Get All Data” button. Depending on the size of your batch, it may ask you to pay (if over 100 elements) or continue for free (with a smaller batch file).

Note: If you were not already logged in with email and password, the app will ask you to do that so there is someplace to send your data. Otherwise, your task will be processed and placed inside your work history location where you can download it as a file.

Once here, you are given a couple of useful options:

• download your data and enjoy using this data in a file form.
• download your data and use the “Map it” button.

These options will provide you with either a flat file or open CSV2GEO interactive map system that will show you the results from geocoding. These options are both available to you and free for the first 100 rows each day as a CSV2GEO subscriber. Other map manipulations are also possible if the basics of this app are of interest. Please, feel free to ask about specific interest and intent.

Disclaimer: Founded CSV2GEO Batch Geocoder