No code required: Tools for Excel, Sheets, QGIS - batch address verification & geocoding made simple

If you work with large address lists, this session should really be played on repeat.
In this deep-dive walkthrough, Spencer Powell demonstrates how to run batch address verification and batch geocoding without relying on engineering resources. Whether you’re cleaning mailing lists, improving address data quality, or mapping locations with rooftop accuracy, you’ll see how to streamline everything using simple tools you already know.
You’ll learn how to:
• Run batch address verification in seconds using the bulk upload tool
• Perform high-precision batch geocoding with rooftop-level coordinates
• Validate addresses directly inside Excel and Google Sheets
• Plot thousands of geocoded points inside QGIS
• Standardize, clean, and enrich US and international address data
• Use no-code workflows to eliminate manual copying and pasting forever
This session covers real examples, including how to handle international formats, understand match rates, check secondaries, and export full metadata for analytics or GIS projects.
If you’ve been looking for a fast, accurate, no-code path to batch address verification and batch geocoding, this walkthrough gives you everything you need to get started.

00:00 Intro
00:40 The problem with address validation APIs and non-programmers
02:01 Web tools
20:14 Excel and Sheets plugins for validating addresses
23:56 The QGIS plugin for mapping
29:07 Partner integrations - Guidewire and more
30:54 Command Line Interface (CLI) for processing addresses
37:25 Q&A

Resources:
Effortless address validation in Excel: No coding needed
https://www.smarty.com/blog/effortles...

Bulk validation tool: US address list output fields
https://www.smarty.com/docs/plugins/s...

Bulk address validation tool
https://www.smarty.com/products/list

US Rooftop Geocoding
https://www.smarty.com/products/us-ro...

Processing multiple requests at once
https://www.smarty.com/docs/processin...

How to batch geocode and validate addresses in Excel
https://www.smarty.com/articles/batch...

Bulk address validation interfaces
https://www.smarty.com/docs/plugins/s...

Smarty speed
https://www.smarty.com/docs/ludicrous...

International Address Validation
https://www.smarty.com/products/inter...

US Address Validation
https://www.smarty.com/products/us-ad...

QGIS Geocoding Plugin - US Address
https://www.smarty.com/plugins/qgis-g...

Google Sheets Address Validation
https://www.smarty.com/plugins/google...

Microsoft Excel Address Validation
https://www.smarty.com/plugins/excel-...