From Address to ETA: Calculate Drive Time Across Your Spreadsheet

If you've ever found yourself frustrated by the limitations of traditional spreadsheets, you're not alone.

3 min readMicrosoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

A Reddit user's frustration captures a frustration we hear constantly. A user, self-described as an "Excel MORON," asks a deceptively simple question: how to calculate drive time from a list of addresses. The answer, in the world of traditional spreadsheets, is that you cannot. Not without a maze of APIs, scripts, and third-party plugins that turn a straightforward task into a weekend project. That gap, between what users need and what legacy tools deliver, is exactly where our thinking begins.

The user's self-deprecation is telling. It is not a lack of intelligence that makes this task hard; it is the tool. Spreadsheets were designed for static numbers in rigid cells. They were never built to understand that "123 Main St" refers to a physical location, or that "Chicago, IL" has a distance and a travel time attached to it. Asking a traditional spreadsheet to calculate ETA is like asking a calculator to brew coffee. The user is not the problem. The technology is. And that distinction matters, because it points toward a better solution: a spreadsheet that treats addresses as live data, not inert text.

What this user needs is not a workaround or a tutorial. They need a fundamental shift in how the spreadsheet thinks. An AI-native spreadsheet can recognize a column of addresses as geographic data, query real-time traffic and routing information, and return a drive time in the next cell. No formulas. No API keys. No feeling like a "MORON." The transformation is not about adding more features to an old model; it is about rethinking the model itself so that the tool meets the user where they are.

This is what we mean by an accessible, human-centered approach to data. The user's goal was simple: get an ETA from a list. The technology should make that simple, not expose the complexity underneath. When a spreadsheet can understand context, location, time, distance, it stops being a grid of numbers and becomes a partner in planning. For anyone who has ever stared at a column of addresses and wondered how to turn them into actionable information, the message is clear: you are not the moron. The spreadsheet has been holding you back. It is time to explore a tool that finally understands the question you are asking.

From Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

First let me admit I am an excel MORON. Is there a way to calculate drive time from a column of addresses in a workbook to a city/state in another column?

Read the original at Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community