Using Canadian Postal Codes to Create a Map in Excel

If you have a list of postal codes and would like to those postal codes to create a map in Excel, you may be disappointed. If the program succeeds at giving you anything at all without the dreaded “Map charts need geographical data such as country/region, state/province, county or postal code.” message, you probably won’t be happy with the output. The message even suggests using postal codes, so why is it so hard to use them? I can’t say, but there is a data adjustment you can make for more satisfactory results.

Continue reading “Using Canadian Postal Codes to Create a Map in Excel”

Save Excel Table to JSON File using VBA and VBA-JSON

While importing JSON files to an Excel Table is easy using a Get and Transform query, going the other way and saving an Excel table as a JSON file is unfortunately not as simple. Luckily, with the code below, it’s easy to save the first Excel table in your sheet as a JSON file.

Continue reading “Save Excel Table to JSON File using VBA and VBA-JSON”