UK Address sanitizer in Excel 365
This article will shortly describe the tool I needed to develop recently. It is aimed at addressing cleansing. The general lists of addresses are often messy. It means, that the components of the address...
Tagged: VBA Excel
Quick transfer the QGIS legend from print layout to Excel
Maybe you were wondering about the possibility of transferring the legend from the QGIS print layout to Excel? This short text shows you how to do it, especially for the simple legend, which won’t...
Opening Google Street View in VBA Excel
Opening websites programmatically at their certain addresses is quite a straightforward thing regardless of the programming language. Previously I dealt with launching Google Maps from the Excel document with the Google Chrome browser. Now...
Batch import PDF document to Google Sheets – random data
Importing PDF documents directly to Google Sheets still remains a tricky issue. The first stop at this conversion route is using Google Docs, where you can extract the PDF content nicely. One more thing...
Populating multiple Excel sheet stuff in QGIS
Today I would like to discuss the process of how can we plot bulk data located in multiple Excel worksheets to QGIS and display them as the point layer. I definitely mean the situation,...
Clever way of batch converting Latitude/Longitude to Ordnance Survey XY in Excel
The Ordnance Survey grid conversion is usually required when dealing with some projects across the UK. Usually, along with the standard WGS 84 datum, we need to define X (Easting) and Y (Northing) coordinates....
The Astropixels.com ephemeris data extractor
I would like to introduce the new tool, whose goal is to extract the ephemeris data from the Astropixels.com service. Before I start to describe the major features of my program I would express...
Good way to sanitizing a bulk address list, part 1 – Excel & VBA
When you work with any Excel data, probably you experienced sometimes, that the spreadsheet input looks messy. I personally deal with the address data predominantly, which you could notice by reading my previous articles...
Reverse geocoding in Excel without loosing money
The previous 3 articles concentrated on the geocoding process in Excel for free. I considered the Google Sheets option and also the VBA Excel tools applicable to Bing, Nominatim, and others. Now it’s the...
The costless way to geocoding addresses in Excel – part 3, bulk data geocoding with Nominatim and other geocoding tools
The 3rd part of this vast article about geocoding is slated for discussion about another free geocoding tool for MS Excel, namely the OpenStreetMap Nominatim geocoding and other remaining tools, which could be worth...
The costless way to geocoding addresses in Excel – part 2, via Bing Maps API
It’s been a while since the previous part of this article when I showed you the way of geocoding the addresses via Google Sheets. Here you will get the knowledge of geocoding straight from...
Smart way of unlocking the Excel VBA project and workbook
Probably experienced a sad situation when the password for your Excel workbook is lost or forgotten. Head up, because it’s not the end of the world. Nowadays we can easily break down the forgotten...
Launching Google Maps from Excel with Chrome browser
The work with addresses is quite often in our Excel spreadsheet. Today I would like to demonstrate to you how to parse the address string in the Excel cell in order to make it...
The costless way to geocoding addresses in Excel – part1, via Google Sheets
Address geocoding is a very desired tool nowadays. This is because we might need to know the location of many places at once. If for example, you want to have about 500 exact coordinates...
How to show the coordinate grids in Google Earth and Google Maps?
There are a few ways to show the coordinate grids on Google Earth. The easiest way to show the coordinate grids in Google Earth is to select “Grids” from the “Tools” options. Then you...