{"id":16491,"date":"2024-12-03T19:28:52","date_gmt":"2024-12-03T10:28:52","guid":{"rendered":"https:\/\/84office.jp\/?p=16491"},"modified":"2024-12-03T19:28:53","modified_gmt":"2024-12-03T10:28:53","slug":"googlesheets-map-linkage","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/googlesheets-map-linkage\/","title":{"rendered":"Google Sheets + Google Maps: Automatically Generate Map Links from Addresses"},"content":{"rendered":"<div class=\"codoc-evacuations\" style=\"display:none;\" data-shortcode=\"\"><\/div>\n<p>Google Maps links are useful, but does it take a lot of time to display each one if there are many places you want to check?<\/p>\n\n\n\n<p>In particular, if you have addresses that you use frequently or locations that you want to list and manage, being able to create links together makes access easy and facilitates your work.<\/p>\n\n\n\n<p>Therefore, this article introduces an efficient way to utilize spreadsheets to automatically generate map links from addresses.<\/p>\n\n\n\n<p>Simply enter an address and a link will be generated, allowing you to manage multiple points and routes at once, facilitating business and daily operations.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Completion Image<\/h2>\n\n\n\n<p><strong>Map links for each location<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-50\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"398\" height=\"206\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-14.png\" alt=\"\" class=\"wp-image-16494\" style=\"width:518px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-14.png 398w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-14-300x155.png 300w\" sizes=\"(max-width: 398px) 100vw, 398px\" \/><\/figure>\n<\/div>\n\n\n<p><strong>Route link between two points<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"644\" height=\"178\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-21.png\" alt=\"\" class=\"wp-image-16501\" style=\"width:800px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-21.png 644w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-21-300x83.png 300w\" sizes=\"(max-width: 644px) 100vw, 644px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list has-border -border02 u-mb-ctrl u-mb-60 has-swl-pale-03-background-color has-background\">\n<li><strong>When an address is entered, a link is generated by a mathematical formula.<\/strong><\/li>\n\n\n\n<li>Used to keep track of addresses to be visited, lists to check routes for business trips, etc.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">How Google Maps Links Work<\/h2>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"529\" height=\"214\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/2a67824d805f30ac31ed827f7791b452.png\" alt=\"\" class=\"wp-image-16506\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/2a67824d805f30ac31ed827f7791b452.png 529w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/2a67824d805f30ac31ed827f7791b452-300x121.png 300w\" sizes=\"(max-width: 529px) 100vw, 529px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40\">In Google Maps, simply include an address in the URL query to create a link that will search for and display that address.<\/p>\n\n\n\n<p>For example, use the following URL<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"https:\/\/www.google.com\/maps\/search\/?api=1&amp;query=Address\n\" style=\"color:#000000;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki light-plus\" style=\"background-color: #FFFFFF\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #000000\">https:<\/span><span style=\"color: #008000\">\/\/www.google.com\/maps\/search\/?api=1&amp;query=Address<\/span><\/span>\n<span class=\"line\"><\/span><\/code><\/pre><\/div>\n\n\n\n<p>By putting a specific address in the \u201cAddress\u201d section here, a link will be created that will allow you to view that location on Google Maps.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60\">This mechanism is used to automatically generate links from address data on a spreadsheet.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Map Link Generation for Each Location<\/h2>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"398\" height=\"206\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-14.png\" alt=\"\" class=\"wp-image-16494\" style=\"width:568px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-14.png 398w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-14-300x155.png 300w\" sizes=\"(max-width: 398px) 100vw, 398px\" \/><\/figure>\n<\/div>\n\n\n<p><strong><span class=\"swl-fz u-fz-l\">Procedure<\/span><\/strong><\/p>\n\n\n\n<div class=\"swell-block-step u-mb-ctrl u-mb-50\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Prepare address data in Google sheets<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"395\" height=\"204\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-15.png\" alt=\"\" class=\"wp-image-16495\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-15.png 395w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-15-300x155.png 300w\" sizes=\"(max-width: 395px) 100vw, 395px\" \/><\/figure>\n<\/div>\n\n\n<p>Prepare address data in a spreadsheet.<\/p>\n\n\n\n<p>For example, set up<strong> column A<\/strong> to enter an address.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-30\">In each cell, enter the address of the respective visit or destination.<\/p>\n\n\n\n<div class=\"swell-block-capbox cap_box is-style-onborder_ttl u-mb-ctrl u-mb-40\"><div class=\"cap_box_ttl\"><span><span class=\"swl-fz u-fz-l\">Input Examples<\/span><\/span><\/div><div class=\"cap_box_content\">\n<ul class=\"wp-block-list\">\n<li>A2: Tokyo Station<\/li>\n\n\n\n<li>A3: Tokyo Tower<\/li>\n\n\n\n<li>A4: Imperial Palace<\/li>\n\n\n\n<li>A5: Haneda Airport<\/li>\n\n\n\n<li>A6: Osaka Station<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p>Next, prepare a column to display the map link.<\/p>\n\n\n\n<p>Set <strong>column B<\/strong> as \u201cMap Link\u201d and use it to generate a Google Map link based on the address in column A.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Enter formula for URL generation<\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-full u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"809\" height=\"208\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-16.png\" alt=\"\" class=\"wp-image-16496\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-16.png 809w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-16-300x77.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-16-768x197.png 768w\" sizes=\"(max-width: 809px) 100vw, 809px\" \/><\/figure>\n\n\n\n<p>In column B, enter a formula that generates a Google Map link based on the address in column A.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-30\">The formula is as follows:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"=HYPERLINK(&quot;https:\/\/www.google.com\/maps\/search\/?api=1&amp;query=&quot; &amp; ENCODEURL(A2), A2 &amp; &quot; map link&quot;)\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F92672\">=<\/span><span style=\"color: #A6E22E\">HYPERLINK<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #E6DB74\">&quot;https:\/\/www.google.com\/maps\/search\/?api=1&amp;query=&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(A2), A2 <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot; map link&quot;<\/span><span style=\"color: #F8F8F2\">)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<div class=\"swell-block-accordion u-mb-ctrl u-mb-50\">\n<details class=\"swell-block-accordion__item\" data-swl-acc=\"wrapper\"><summary class=\"swell-block-accordion__title\" data-swl-acc=\"header\"><span class=\"swell-block-accordion__label\">Formula Details<\/span><span class=\"swell-block-accordion__icon c-switchIconBtn\" data-swl-acc=\"icon\" aria-hidden=\"true\" data-opened=\"false\"><i class=\"__icon--closed icon-caret-down\"><\/i><i class=\"__icon--opened icon-caret-up\"><\/i><\/span><\/summary><div class=\"swell-block-accordion__body\" data-swl-acc=\"body\">\n<dl class=\"swell-block-dl\">\n<dt class=\"swell-block-dl__dt\">HYPERLINK<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>Function to generate links.<\/li>\n\n\n\n<li>Set the URL of the link as the first argument and the display name of the link (\u201cmap link\u201d) as the second argument.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\">ENCODEURL<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>Encodes spaces and Japanese characters in addresses and converts them into a format that can be used as a URL.<\/li>\n<\/ul>\n<\/dd>\n<\/dl>\n<\/div><\/details>\n<\/div>\n\n\n\n<p>Enter the above formula in cell B2 and copy it down to generate a link corresponding to the address or facility name in each row.<\/p>\n\n\n\n<p>You will now see the auto-generated Google Map link on the spreadsheet.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<p>Formula input results (map link for each location)<\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"398\" height=\"206\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-14.png\" alt=\"\" class=\"wp-image-16494\" style=\"width:592px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-14.png 398w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-14-300x155.png 300w\" sizes=\"(max-width: 398px) 100vw, 398px\" \/><\/figure>\n<\/div>\n\n\n<p><strong>Google Map<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"553\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-17-1024x553.png\" alt=\"\" class=\"wp-image-16497\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-17-1024x553.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-17-300x162.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-17-768x415.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-17.png 1397w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60\">When the link is opened, a Google map of the location entered in column A will be displayed.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Route link generation from starting point and destination<\/h2>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"653\" height=\"170\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-19.png\" alt=\"\" class=\"wp-image-16499\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-19.png 653w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-19-300x78.png 300w\" sizes=\"(max-width: 653px) 100vw, 653px\" \/><\/figure>\n<\/div>\n\n\n<p>By entering a starting point and a destination, we will also show you how to automatically generate a link that displays the route between the two points.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">If you generate route links in a spreadsheet, you can easily navigate between two points.<\/p>\n\n\n\n<p><strong><span class=\"swl-fz u-fz-l\">Procedure<\/span><\/strong><\/p>\n\n\n\n<div class=\"swell-block-step u-mb-ctrl u-mb-50\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Prepare Google Sheets<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"572\" height=\"166\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-18.png\" alt=\"\" class=\"wp-image-16498\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-18.png 572w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-18-300x87.png 300w\" sizes=\"(max-width: 572px) 100vw, 572px\" \/><\/figure>\n<\/div>\n\n\n<p>As an example, enter \u201c<strong>Origin<\/strong>\u201d in <strong>column A<\/strong> and \u201c<strong>Destination<\/strong>\u201d in <strong>column B<\/strong>.<\/p>\n\n\n\n<p>Column C contains the formula for the route link.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Route Map Formula<\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-full u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"840\" height=\"169\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-20.png\" alt=\"\" class=\"wp-image-16500\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-20.png 840w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-20-300x60.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-20-768x155.png 768w\" sizes=\"(max-width: 840px) 100vw, 840px\" \/><\/figure>\n\n\n\n<p>Enter the following formula in column C<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-30\">A route map link is generated based on the contents of columns A and B.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"=HYPERLINK(&quot;https:\/\/www.google.com\/maps\/dir\/?api=1&amp;origin=&quot; &amp; ENCODEURL(A2) &amp; &quot;&amp;destination=&quot; &amp; ENCODEURL(B2), &quot;Route from &quot; &amp; A2 &amp; &quot; to &quot; &amp; B2)\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F92672\">=<\/span><span style=\"color: #A6E22E\">HYPERLINK<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #E6DB74\">&quot;https:\/\/www.google.com\/maps\/dir\/?api=1&amp;origin=&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(A2) <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot;&amp;destination=&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(B2), <\/span><span style=\"color: #E6DB74\">&quot;Route from &quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> A2 <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot; to &quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> B2)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<div class=\"swell-block-accordion u-mb-ctrl u-mb-40\">\n<details class=\"swell-block-accordion__item\" data-swl-acc=\"wrapper\"><summary class=\"swell-block-accordion__title\" data-swl-acc=\"header\"><span class=\"swell-block-accordion__label\">Formula Details<\/span><span class=\"swell-block-accordion__icon c-switchIconBtn\" data-swl-acc=\"icon\" aria-hidden=\"true\" data-opened=\"false\"><i class=\"__icon--closed icon-caret-down\"><\/i><i class=\"__icon--opened icon-caret-up\"><\/i><\/span><\/summary><div class=\"swell-block-accordion__body\" data-swl-acc=\"body\">\n<dl class=\"swell-block-dl\">\n<dt class=\"swell-block-dl__dt\"><code>HYPERLINK(url, \u8868\u793a\u540d)<\/code><\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd u-mb-ctrl u-mb-50\">\n<ul class=\"wp-block-list\">\n<li>By specifying \u201corigin\u201d and \u201cdestination\u201d in the URL portion, the route between two points is displayed on Google Maps.<\/li>\n\n\n\n<li>The display name is labeled as \u201cRoute from origin to destination\u201d with a link to be found on the Google Sheets.<\/li>\n<\/ul>\n<\/dd>\n<\/dl>\n<\/div><\/details>\n<\/div>\n\n\n\n<p>Enter the above formula in cell C2 and copy it down to generate a link corresponding to the address or facility name in each row.<\/p>\n\n\n\n<p>The route map link between the two points will now be displayed.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<p><strong>Formula input result <\/strong>(route map)<\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"644\" height=\"178\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-21.png\" alt=\"\" class=\"wp-image-16501\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-21.png 644w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-21-300x83.png 300w\" sizes=\"(max-width: 644px) 100vw, 644px\" \/><\/figure>\n<\/div>\n\n\n<p>Google Maps (route)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-60\"><img decoding=\"async\" width=\"1024\" height=\"626\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-22-1024x626.png\" alt=\"\" class=\"wp-image-16502\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-22-1024x626.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-22-300x184.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-22-768x470.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-22.png 1365w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Route map link generation with additional waypoints<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large is-resized u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"182\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/10\/image-109-1024x182.png\" alt=\"\" class=\"wp-image-15456\" style=\"width:852px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/10\/image-109-1024x182.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/10\/image-109-300x53.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/10\/image-109-768x136.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/10\/image-109.png 1070w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Google Maps also allows you to add \u201cvia locations\u201d and create detailed routes along the order of visits.<\/p>\n\n\n\n<p>In addition to origin and destination, one or more transit points can be specified.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">The following is the procedure for adding two transit points and displaying routes for multiple points.<\/p>\n\n\n\n<p><strong><span class=\"swl-fz u-fz-l\">Procedure<\/span><\/strong><\/p>\n\n\n\n<div class=\"swell-block-step u-mb-ctrl u-mb-50\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Prepare Google Sheets<\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"181\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/10\/image-110-1024x181.png\" alt=\"\" class=\"wp-image-15457\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/10\/image-110-1024x181.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/10\/image-110-300x53.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/10\/image-110-768x136.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/10\/image-110.png 1072w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>As an example, enter the following<\/p>\n\n\n\n<ul class=\"wp-block-list u-mb-ctrl u-mb-30\">\n<li><strong>Column A \u201cDeparture point\u201d<\/strong><\/li>\n\n\n\n<li><strong>Column B. \u201cWaypoint 1.\u201d<\/strong><\/li>\n\n\n\n<li><strong>Column C, \u201cWaypoint 2.\u201d<\/strong><\/li>\n\n\n\n<li><strong>Column D \u201cDestination\u201d<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Enter the formula for the root map link in column E.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Formula for Route Map Links (two waypoints)<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"258\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-25-1024x258.png\" alt=\"\" class=\"wp-image-16505\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-25-1024x258.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-25-300x76.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-25-768x193.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-25.png 1179w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>Enter the following formula in column E<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-30\">A route link is generated based on the contents of columns A and B.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"=HYPERLINK(&quot;https:\/\/www.google.com\/maps\/dir\/?api=1&amp;origin=&quot; &amp; ENCODEURL(A2) &amp; &quot;&amp;destination=&quot; &amp; ENCODEURL(D2) &amp; &quot;&amp;waypoints=&quot; &amp; ENCODEURL(B2) &amp; &quot;%7C&quot; &amp; ENCODEURL(C2), &quot;Route from &quot; &amp; A2 &amp; &quot; to &quot; &amp; D2 &amp; &quot; (via: &quot; &amp; B2 &amp; &quot;, &quot; &amp; C2 &amp; &quot;)&quot;)\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F92672\">=<\/span><span style=\"color: #A6E22E\">HYPERLINK<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #E6DB74\">&quot;https:\/\/www.google.com\/maps\/dir\/?api=1&amp;origin=&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(A2) <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot;&amp;destination=&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(D2) <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot;&amp;waypoints=&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(B2) <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot;%7C&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(C2), <\/span><span style=\"color: #E6DB74\">&quot;Route from &quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> A2 <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot; to &quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> D2 <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot; (via: &quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> B2 <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot;, &quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> C2 <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot;)&quot;<\/span><span style=\"color: #F8F8F2\">)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<div class=\"swell-block-accordion u-mb-ctrl u-mb-40\">\n<details class=\"swell-block-accordion__item\" data-swl-acc=\"wrapper\"><summary class=\"swell-block-accordion__title\" data-swl-acc=\"header\"><span class=\"swell-block-accordion__label\">Formula Details<\/span><span class=\"swell-block-accordion__icon c-switchIconBtn\" data-swl-acc=\"icon\" aria-hidden=\"true\" data-opened=\"false\"><i class=\"__icon--closed icon-caret-down\"><\/i><i class=\"__icon--opened icon-caret-up\"><\/i><\/span><\/summary><div class=\"swell-block-accordion__body\" data-swl-acc=\"body\">\n<dl class=\"swell-block-dl\">\n<dt class=\"swell-block-dl__dt\">origin<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>Specify the origin entered in column A.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\">destination<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>Specify the destination entered in column D.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\">waypoints<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>The transit points in columns B and C are specified as multiple transit points, separated by \u201c|\u201d.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong><code>%7C<\/code><\/strong><\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p>It means the \u201c|\u201d (pipe) symbol in URL encoding format.<\/p>\n<\/dd>\n<\/dl>\n<\/div><\/details>\n<\/div>\n\n\n\n<p>This formula generates a link with the display name \u201cRoute from origin to destination (via: waypoint 1, waypoint 2)\u201d.<\/p>\n\n\n\n<p>When you click on the link, the route through the two specified transit points will be displayed on Google Maps.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<p>Formula input result (with route map link and waypoint)<\/p>\n\n\n\n<figure class=\"wp-block-image size-full u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"998\" height=\"300\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-23.png\" alt=\"\" class=\"wp-image-16503\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-23.png 998w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-23-300x90.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-23-768x231.png 768w\" sizes=\"(max-width: 998px) 100vw, 998px\" \/><\/figure>\n\n\n\n<p>Google Maps (with routes and waypoints)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"588\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-24-1024x588.png\" alt=\"\" class=\"wp-image-16504\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-24-1024x588.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-24-300x172.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-24-768x441.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-24.png 1457w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Route map links with multiple transit points are automatically generated from the spreadsheet.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60\">Open the link to easily see the schedule through multiple locations.<\/p>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-30\">Conclusion<\/h2>\n\n\n\n<p><strong>Formula to generate map links for each location<\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro u-mb-ctrl u-mb-50\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"=HYPERLINK(&quot;https:\/\/www.google.com\/maps\/search\/?api=1&amp;query=&quot; &amp; ENCODEURL(A2), A2 &amp; &quot; map link&quot;)\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F92672\">=<\/span><span style=\"color: #A6E22E\">HYPERLINK<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #E6DB74\">&quot;https:\/\/www.google.com\/maps\/search\/?api=1&amp;query=&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(A2), A2 <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot; map link&quot;<\/span><span style=\"color: #F8F8F2\">)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><strong>Formula to generate route map links from origin and destination<\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro u-mb-ctrl u-mb-50\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"=HYPERLINK(&quot;https:\/\/www.google.com\/maps\/dir\/?api=1&amp;origin=&quot; &amp; ENCODEURL(A2) &amp; &quot;&amp;destination=&quot; &amp; ENCODEURL(B2), &quot;Route from &quot; &amp; A2 &amp; &quot; to &quot; &amp; B2)\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F92672\">=<\/span><span style=\"color: #A6E22E\">HYPERLINK<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #E6DB74\">&quot;https:\/\/www.google.com\/maps\/dir\/?api=1&amp;origin=&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(A2) <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot;&amp;destination=&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(B2), <\/span><span style=\"color: #E6DB74\">&quot;Route from &quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> A2 <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot; to &quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> B2)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><strong>Formula to add waypoints and generate a route link<\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro u-mb-ctrl u-mb-50\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"=HYPERLINK(&quot;https:\/\/www.google.com\/maps\/dir\/?api=1&amp;origin=&quot; &amp; ENCODEURL(A2) &amp; &quot;&amp;destination=&quot; &amp; ENCODEURL(D2) &amp; &quot;&amp;waypoints=&quot; &amp; ENCODEURL(B2) &amp; &quot;%7C&quot; &amp; ENCODEURL(C2), &quot;Route from &quot; &amp; A2 &amp; &quot; to &quot; &amp; D2 &amp; &quot; (via: &quot; &amp; B2 &amp; &quot;, &quot; &amp; C2 &amp; &quot;)&quot;)\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F92672\">=<\/span><span style=\"color: #A6E22E\">HYPERLINK<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #E6DB74\">&quot;https:\/\/www.google.com\/maps\/dir\/?api=1&amp;origin=&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(A2) <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot;&amp;destination=&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(D2) <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot;&amp;waypoints=&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(B2) <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot;%7C&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(C2), <\/span><span style=\"color: #E6DB74\">&quot;Route from &quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> A2 <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot; to &quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> D2 <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot; (via: &quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> B2 <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot;, &quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> C2 <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot;)&quot;<\/span><span style=\"color: #F8F8F2\">)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>If you open Google Maps directly to search, you need to display one at a time, but from a spreadsheet, you can easily create multiple map links at once.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-50\">If there are a number of points or routes to be checked, this formula can be used to manage them efficiently.<\/p>\n\n\n<div class=\"swell-block-postLink u-mb-ctrl u-mb-50\"><\/div>\n\n<div class=\"p-postListWrap u-mb-ctrl u-mb-50\"><ul class=\"p-postList -type-card -pc-col3 -sp-col1\"><li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/gas%ef%bd%b0send-email\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__thumb c-postThumb\">\n\t<figure class=\"c-postThumb__figure\">\n\t\t<img decoding=\"async\" width=\"1024\" height=\"538\"  src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/1d36b191b935e2fb6a033cb4e78d867a-1024x538.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/1d36b191b935e2fb6a033cb4e78d867a-1024x538.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/1d36b191b935e2fb6a033cb4e78d867a-300x158.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/1d36b191b935e2fb6a033cb4e78d867a-768x403.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/1d36b191b935e2fb6a033cb4e78d867a.png 1200w\" sizes=\"auto, (min-width: 960px) 400px, 100vw\" loading=\"lazy\" >\t<\/figure>\n\t\t\t<span class=\"c-postThumb__cat icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t<\/div>\n\t\t\t\t\t<div class=\"p-postList__body\">\n\t\t\t\t<h2 class=\"p-postList__title\">Boost Productivity: Automate Gmail to Multiple Recipients with Google Sheets and Apps Script<\/h2>\t\t\t\t\t\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2024-11-15\" aria-label=\"\u516c\u958b\u65e5\">2024\u5e7411\u670815\u65e5<\/time><\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/googlesheets-map-linkage\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__thumb c-postThumb\">\n\t<figure class=\"c-postThumb__figure\">\n\t\t<img decoding=\"async\" width=\"1024\" height=\"538\"  src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/c79a346b2ddab646e17282bf7501e204-1024x538.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/c79a346b2ddab646e17282bf7501e204-1024x538.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/c79a346b2ddab646e17282bf7501e204-300x158.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/c79a346b2ddab646e17282bf7501e204-768x403.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/c79a346b2ddab646e17282bf7501e204.png 1200w\" sizes=\"auto, (min-width: 960px) 400px, 100vw\" loading=\"lazy\" >\t<\/figure>\n\t\t\t<span class=\"c-postThumb__cat icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t<\/div>\n\t\t\t\t\t<div class=\"p-postList__body\">\n\t\t\t\t<h2 class=\"p-postList__title\">Google Sheets + Google Maps: Automatically Generate Map Links from Addresses<\/h2>\t\t\t\t\t\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2024-12-03\" aria-label=\"\u516c\u958b\u65e5\">2024\u5e7412\u67083\u65e5<\/time><\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/gas-pop-up\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__thumb c-postThumb\">\n\t<figure class=\"c-postThumb__figure\">\n\t\t<img decoding=\"async\" width=\"1024\" height=\"538\"  src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f7db322d686e3090883637bf91b1d3ac-1024x538.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f7db322d686e3090883637bf91b1d3ac-1024x538.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f7db322d686e3090883637bf91b1d3ac-300x158.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f7db322d686e3090883637bf91b1d3ac-768x403.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f7db322d686e3090883637bf91b1d3ac.png 1200w\" sizes=\"auto, (min-width: 960px) 400px, 100vw\" loading=\"lazy\" >\t<\/figure>\n\t\t\t<span class=\"c-postThumb__cat icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t<\/div>\n\t\t\t\t\t<div class=\"p-postList__body\">\n\t\t\t\t<h2 class=\"p-postList__title\">Enhance User Interaction with Google Apps Script: How to Add Confirmation Pop-Ups to Prevent Mistakes<\/h2>\t\t\t\t\t\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2024-12-31\" aria-label=\"\u516c\u958b\u65e5\">2024\u5e7412\u670831\u65e5<\/time><\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<\/a>\n<\/li>\n<\/ul><\/div>\n\n\n<p class=\"is-style-emboss_box has-swl-pale-02-background-color has-background\">Our company offers support for improving work efficiency through the use of Google Apps Script. <br>If you need assistance with Google Apps Script customization or error resolution, please feel free to contact us. <br>We are fully committed to supporting your business improvements.<br><br><a href=\"https:\/\/84office.jp\/contact\/\">Contact us here<br><\/a><\/p>\n\n\n\n<script src=\"https:\/\/codoc.jp\/js\/cms.js\" data-css=\"rainbow\" data-usercode=\"pQLZofrBiA\" charset=\"UTF-8\" defer><\/script>\n <div id=\"codoc-entry-9lNr9PuMXQ\" class=\"codoc-entries\" data-without-body=\"1\" data-support-button-text=\"Support with a Tip\" data-support-message=\"We will keep offering tools and information to boost work efficiency. Your support helps us provide even better content.\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Google Maps links are useful, but does it take a lot of time to display each one if there are many places you  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":16508,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","_locale":"en_US","_original_post":"https:\/\/84office.jp\/?p=15435","footnotes":""},"categories":[12],"tags":[],"class_list":["post-16491","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-12","en-US"],"_links":{"self":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/16491","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/comments?post=16491"}],"version-history":[{"count":3,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/16491\/revisions"}],"predecessor-version":[{"id":16509,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/16491\/revisions\/16509"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media\/16508"}],"wp:attachment":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media?parent=16491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/categories?post=16491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/tags?post=16491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}