Welcome! – Hire Excel Programmer

To Hire me for custom Excel and VBA Programming please email vinnie@googlescrapersoftware.com

Distance Between Zip Codes Calculator in ExcelView Demo
Use this tool built in Excel to Calculate Distance between Addresses or Zip Codes from a list of locations. Click a button and the tool will generate the results for you using the Google Maps API.

Convert Addresses To Latitude Longitude in BulkView Demo
This file takes a list of up to 5000 addresses and converts them into latitude / longitude coordinates in Excel.

Combine Multiple Excel Files into One Master File
In cases where you get similar data outputs with the same headers, with the click of a button you can combine them all into one file. View Demo

Standardize/Validate Business and Residential Address in Excel
Use this tool to Standardize and Validate and Cleanse your list of addresses all within Excel. It uses Google API to process your incomplete or incorrect client list. It works for both commercial and residential Addresses.  View Demo

Import Folder Contents and File Names into ExcelView Demo
By selecting a folder in the file dialog, all subfolders names and file names download into a searchable, filterable hierarchy in Excel.

Track Round Trip Mileage Using Outlook Calendar AppointmentsView Demo
Simply by putting in an address as your appointment location, you can download your Outlook calendar into Excel and automatically generate your round trip mileage.

Display US Supply Chain / Logistics in ExcelView Demo
Excel-based Supply Chain Map is generated using your product starting location and destination. Mileage and travel time for your product is displayed along with a map plotting the volume of goods transferred.

Store Locator in Excel – Find the closest Store for each of your clientsView Demo
This Tool allows the user to find the Closest Store (from a list of predetermined locations) for each customer (from a customer list). It can be used if creating servicing assignments (find closest contractor for each client) and many other functions.

Maintain YOUR Do Not Contact Email List in ExcelView Demo
This file cleans your email list against the email addresses of people that have requested to no longer receive mail from you.

 Maintain YOUR Do Not Call List in ExcelView Demo
Compares a list of phone numbers against your list of numbers that you don’t want to call. You must enter the DNC numbers in a separate column.

 Maintain a One Time Use Email List in ExcelView Demo
After dumping email addresses into a column, this removes email addresses that have already been used and adds the remainder to the list so they won’t be used in the future.

Any of this logic can be implemented in your sheet. Email vinnie@googlescrapersoftware.com to hire Excel and web programmers.