You can use your favorite spreadsheet software like Google Docs, Microsoft Excel or Openoffice Calc to generate a spreadsheet routes you want to calculate. The spreadsheet should have the following format
your first origin
your first destination
your second origin
your second destination
your nth origin
your nth destination
Every origin or every destination can be the same in every row. If you want to calculate distances between a single origin to different destinations (or vice versa) you should copy&paste that value to every field in a row.
If you're using Google Docs as your preferred spreadsheet tool you can see a Google Docs template here or Excel template to import here. Instead of exporting your Google Docs spreadsheet to XLSX and uploading it you can use the Google Docs ID to import your data directly:
If Excel from Microsoft Office suite is your preferred spreadsheet software you can see a Microsoft Excel template here.
If Calc from Openoffice.org suite is your preferred spreadsheet application you can see a Openoffice.org template here.
Origin and Destination can contain the following data
Country, city or region
Postal codes (you need to specify the country code)
IATA airport codes
To calculate the distance between your inputs we need to translate names into coordinates. This process is called geocoding. Read more about geocoding here:
Due to availability of multiple results for the same input (such as Venice, Italy or Venice, Los Angeles) it is highly recommended to specify country and region of your input if available. Otherwise it is not guaranteed that the process hits the correct value.
If you want to calculate distances between postal or zip codes you need to specify the country code with its iso-3166-1 alpha-3 code.
To calculate distances between coordinates use latitude and longitude to define coordinates on the earth's surface. The format should be
If you're done with the data generation you need to export your spreadsheet to the XLSX or CSV format.
You should easily export or save your spreadsheet to the XLSX format. This format is supported from all major spreadsheet vendors.
If you're done with the data generation you need to export your spreadsheet to the CSV format. You can see an example CSV file here.