{"id":2962335,"date":"2026-04-09T18:08:27","date_gmt":"2026-04-10T01:08:27","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=2962335"},"modified":"2026-04-10T09:51:43","modified_gmt":"2026-04-10T16:51:43","slug":"calculating-distances-and-finding-routes-with-arcgis-for-excel","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/mapping\/calculating-distances-and-finding-routes-with-arcgis-for-excel","title":{"rendered":"Calculating Distances and Finding Routes with ArcGIS for Excel"},"author":252692,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[22941,430222,23351],"tags":[761562,781058,25721,781059,781060],"industry":[],"product":[766382,770122],"class_list":["post-2962335","blog","type-blog","status-publish","format-standard","hentry","category-mapping","category-retail","category-transportation","tag-arcgis-for-microsoft-365","tag-esrijson","tag-geojson","tag-json","tag-routing-with-arcgis-for-excel","product-arcgis-for-excel","product-microsoft-365"],"acf":{"show_article_image":false,"card_image":false,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/map_1920x1080_ExcelRoute.jpg","authors":[{"ID":252692,"user_firstname":"Gaurav","user_lastname":"Singh","nickname":"Gaurav Singh","user_nicename":"gsingh","display_name":"Gaurav Singh","user_email":"gsingh@esri.com","user_url":"","user_registered":"2021-07-16 23:07:37","user_description":"Sr. Product Engineer in the ArcGIS for Microsoft365 group.","user_avatar":""},{"ID":5101,"user_firstname":"Linda","user_lastname":"Beale","nickname":"Linda Beale","user_nicename":"lbeale","display_name":"Linda Beale","user_email":"LBeale@esri.com","user_url":"","user_registered":"2018-03-02 00:16:44","user_description":"Dr Linda Beale is the Group Lead for Location Analytics at Esri, with an interest in sharing the value of spatial analysis with an audience ranging from those new to the discipline to those who are seeking fresh approaches and techniques.\r\n\r\nA geographer by training, Linda gained her PhD in GIS, statistics and modelling, and led the geospatial health group in the Small Area Health Statistics Unit at Imperial College London. Linda has extensive experience in the field of spatial epidemiology and has worked closely with Health Departments, the World Health Organisation and Center for Disease Control. She developed the award winning Rapid Inquiry Facility program for chronic disease modelling and was co-author on the landmark Environment and Health Atlas for England and Wales.\r\n\r\nLinda is the author of the first Esri MOOC, Going Places with Spatial Analysis, and she has published numerous peer-reviewed papers, book chapters, and been invited to keynote, present and deliver workshops at national and international conferences. Linda has worked at Esri since 2011, where her experience helps shape location analytics to provide the community with better and more powerful tools, and where she helps teach best practices and sharing of knowledge to develop understanding across the wider community.","user_avatar":""}],"short_description":"Calculate driving distances and straight-line paths between your Excel data and ArcGIS layers without leaving Excel.","flexible_content":[{"acf_fc_layout":"content","content":"

With ArcGIS for Excel, you can calculate distances and draw routes between coordinates in your Excel worksheet and features in an ArcGIS layer on ArcGIS Online or Enterprise, all without leaving your\u00a0<\/span>worksheet<\/span>. In this article,\u00a0<\/span>you<\/span>‘ll<\/span>\u00a0use\u00a0<\/span><\/span>ArcGIS for Excel functions<\/span><\/span><\/a>\u00a0to calculate both driving distances for\u00a0<\/span>logistics<\/span>\u00a0planning and straight-line distances for proximity\u00a0<\/span>analysis.<\/span><\/span>\u00a0<\/span><\/p>\n

 <\/p>\n

In this article,\u00a0you\u2019ll\u00a0see two methods for calculating distances and\u00a0visualizing\u00a0those paths to the ArcGIS for Excel map \u2013\u00a0<\/span>\u00a0<\/span><\/p>\n