Auto-Fill City & State from ZIP Code in Excel — No More Manual Entry!
File Download: https://www.excel-university.com/yt_r...
🚀 Turn ZIP Codes into City & State Instantly in Excel! 📍
In this step-by-step tutorial, you’ll learn three powerful ways to automatically return city and state info from a ZIP code—no copy-paste required! Whether you're using the latest version and have a Copilot license, diving into Power Query, or sticking with traditional Excel formulas, this video has a method for every user.
👉 What You’ll Learn:
How to use `=WEBSERVICE()` to pull live ZIP code data
Automate location lookups with Excel COPILOT function
Create dynamic ZIP code queries with Power Query and custom functions
Avoid common issues like leading zeros in ZIP codes
Build a live customer form that auto-populates city/state
💡 Perfect for data analysts, sales teams, or anyone working with customer addresses in Excel.
🔗 API used: Free public ZIP code service
👍 Like this video if you found it helpful
🧠 Subscribe for more practical Excel magic
💬 Got questions? Drop them in the comments!
#Excel #ZipCodeLookup #PowerQuery #ExcelCoPilot #ExcelTips #ExcelFormulas #DataAutomation #Microsoft365 #ExcelTutorial #ExcelMagic
00:00 Introduction
00:24 COPILOT 1
04:10 Power Query 2
09:06 Formulas 3