Getting distance between two cities into spreadsheet by putting down their names

Hello, I am currently working on a carbon footprint Excel file for a university project. My main issue is that I would like to automatically get the distance between two points by typing them in the Excel file instead of having to look it up online and then enter it in the spreadsheet. I have looked online, but all the solutions I found cost money, and I would like something free. If there is also a way to differentiate how the travel would be, I would appreciate it as well, but the important thing for me is getting the distance.