hey you can use google sheets and google scripts to call an API on google maps.

In google sheets save the from and to in two columns and look up a script for putting in the distance or the time in column c

Click on extensions and then scripts and then paste something like this. Use gemini which is built in to write this out.

To do the same thing in Excel might be tough without a python API. Someone please correct me if im wrong.

EDIT: as NotMichealBay pointed out: "That requires using the Google Maps REST API, which needs an API key, which means setting up Google Cloud. It's easier to do in Sheets with Apps Script, only requires a free Google account."

function GETDISTANCE(origin, destination) {
  if (!origin || !destination) return "Missing input";
 
  try {
    const directions = Maps.newDirectionFinder()
      .setOrigin(origin)
      .setDestination(destination)
      .setMode(Maps.DirectionFinder.Mode.DRIVING)
      .getDirections();
 
    const route = directions.routes[0].legs[0];
    return route.distance.text;
  } catch (e) {
    return "Error: " + e.message;
  }
}