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/effortless-address-validation-in-exel-without-coding

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

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

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

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

How to batch geocode and validate addresses in Excel
https://www.smarty.com/articles/batch-address-validation-geocoding-excel

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

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

International Address Validation
https://www.smarty.com/products/international-address-verification

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

QGIS Geocoding Plugin - US Address
https://www.smarty.com/plugins/qgis-geocoding-plugin-us-address

Google Sheets Address Validation
https://www.smarty.com/plugins/google-sheets-address-validation-geocoding

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

Видео No code required: Tools for Excel, Sheets, QGIS - batch address verification & geocoding made simple канала Smarty