How to Get City & State from ZIP Code in Excel with Power Query & Free Web API
File Download: https://www.excel-university.com/yt_w...
📍 Zip Code Lookup in Excel with Power Query + Free API Integration! 🔍
💰🎓 Get confident in Excel fast with our full online course, try it free for 7 days 🔥 👉 https://www.excel-university.com/yt
Want to enrich your Excel data with city, state, and location info just by using ZIP codes? In this hands-on tutorial, Jeff shows you how to connect Excel to a free web API using Power Query – no coding required!
By the end of the video, you’ll know how to:
✅ Use Power Query to retrieve ZIP code data from an external API
✅ Dynamically return city, state, and geo-coordinates based on ZIP codes
✅ Convert a query into a custom function that scales with your dataset
✅ Handle leading zeros in ZIP codes and preserve text formatting
✅ Automatically refresh results when your source data updates
Perfect for Excel users working with customer data, logistics, or geographic analysis. This method is ideal for small to mid-size datasets, and it's a great introduction to Power Query's API capabilities!
📌 Works with Excel 365 and Excel 2019
📌 Uses Power Query + JSON API response parsing
👉 Ready to supercharge your ZIP code tables? Hit play and follow along!
👍 Like, subscribe, and explore our full training program for more Excel automation magic.
Chapters in this video:
00:00 Introduction
00:16 Exercise 1
01:35 Exercise 2
02:24 Exercise 3