{"id":25740,"date":"2026-08-05T14:47:52","date_gmt":"2026-08-05T05:47:52","guid":{"rendered":"https:\/\/ardent.jp\/rentoffice-consultation-center\/?p=25740"},"modified":"2026-08-05T14:47:52","modified_gmt":"2026-08-05T05:47:52","slug":"spreadsheet-importrange","status":"publish","type":"post","link":"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/","title":{"rendered":"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u5225\u30b7\u30fc\u30c8\u30fb\u5225\u30d5\u30a1\u30a4\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u96c6\u7d04\u3059\u308b\u65b9\u6cd5\uff5cIMPORTRANGE\u00d7QUERY\u3067\u81ea\u52d5\u96c6\u8a08"},"content":{"rendered":"<p>\u300c\u5e97\u8217\u3054\u3068\u30fb\u90e8\u9580\u3054\u3068\u306b\u5225\u3005\u306e\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6570\u5b57\u3092\u7ba1\u7406\u3057\u3066\u3044\u3066\u3001\u6708\u672b\u306b\u672c\u90e8\u304c\u5168\u90e8\u30b3\u30d4\u30da\u3067\u96c6\u8a08\u3057\u3066\u3044\u308b\u300d\u2014\u2014\u305d\u3093\u306a\u624b\u4f5c\u696d\u306b\u5fc3\u5f53\u305f\u308a\u306f\u3042\u308a\u307e\u305b\u3093\u304b\u3002\u7d50\u8ad6\u304b\u3089\u8a00\u3046\u3068\u3001<strong>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e<code>IMPORTRANGE<\/code>\u95a2\u6570\u3092\u4f7f\u3048\u3070\u3001\u5225\u306e\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff08\u5225\u30d5\u30a1\u30a4\u30eb\uff09\u306b\u3042\u308b\u30c7\u30fc\u30bf\u3092\u81ea\u52d5\u3067\u53c2\u7167\u3057\u30661\u304b\u6240\u306b\u96c6\u3081\u3089\u308c\u307e\u3059<\/strong>\u3002\u3055\u3089\u306b<code>QUERY<\/code>\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u308c\u3070\u3001\u96c6\u3081\u306a\u304c\u3089\u300c\u5e97\u8217\u5225\u306b\u5408\u8a08\u300d\u3068\u3044\u3063\u305f\u96c6\u8a08\u307e\u3067\u6570\u5f0f1\u672c\u3067\u5b8c\u7d50\u3057\u307e\u3059\u3002\u8ffd\u52a0\u30c4\u30fc\u30eb\u3082\u30de\u30af\u30ed\u3082\u4e0d\u8981\u3001\u7121\u6599\u3067\u59cb\u3081\u3089\u308c\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u4e2d\u5c0f\u4f01\u696d\u306e\u7d4c\u55b6\u8005\u30fb\u60c5\u30b7\u30b9\u62c5\u5f53\u30fb\u4e8b\u52d9\u62c5\u5f53\u306e\u65b9\u306b\u5411\u3051\u3066\u3001IMPORTRANGE\u306e\u57fa\u672c\u306e\u4f7f\u3044\u65b9\u304b\u3089\u3001\u8907\u6570\u30d5\u30a1\u30a4\u30eb\u30921\u3064\u306b\u96c6\u7d04\u3059\u308b\u5fdc\u7528\u3001\u3088\u304f\u3042\u308b\u30a8\u30e9\u30fc\u306e\u5bfe\u51e6\u3001\u305d\u3057\u3066\u60c5\u30b7\u30b9\u304c\u62bc\u3055\u3048\u3066\u304a\u304d\u305f\u3044\u6a29\u9650\u30fb\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u6ce8\u610f\u70b9\u307e\u3067\u3092\u3001\u5b9f\u52d9\u76ee\u7dda\u3067\u307e\u3068\u3081\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<div style=\"height: 20px;\"><\/div>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_77 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u76ee\u6b21<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#IMPORTRANGE%E9%96%A2%E6%95%B0%E3%81%A8%E3%81%AF%EF%BC%9F%E5%88%A5%E3%82%B7%E3%83%BC%E3%83%88%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E8%87%AA%E5%8B%95%E3%81%A7%E6%8C%81%E3%81%A3%E3%81%A6%E3%81%8F%E3%82%8B%E9%96%A2%E6%95%B0\" >IMPORTRANGE\u95a2\u6570\u3068\u306f\uff1f\u5225\u30b7\u30fc\u30c8\u306e\u30c7\u30fc\u30bf\u3092\u81ea\u52d5\u3067\u6301\u3063\u3066\u304f\u308b\u95a2\u6570<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#IMPORTRANGE%E3%81%AE%E5%9F%BA%E6%9C%AC%E7%9A%84%E3%81%AA%E4%BD%BF%E3%81%84%E6%96%B9%E3%81%AF%EF%BC%9F%EF%BC%883%E3%82%B9%E3%83%86%E3%83%83%E3%83%97%EF%BC%89\" >IMPORTRANGE\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u306f\uff1f\uff083\u30b9\u30c6\u30c3\u30d7\uff09<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#%E8%A4%87%E6%95%B0%E3%82%B7%E3%83%BC%E3%83%88%E3%83%BB%E8%A4%87%E6%95%B0%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%921%E3%81%A4%E3%81%AB%E9%9B%86%E7%B4%84%E3%81%99%E3%82%8B%E3%81%AB%E3%81%AF%EF%BC%9F%EF%BC%88QUERY%E3%81%A8%E7%B5%84%E3%81%BF%E5%90%88%E3%82%8F%E3%81%9B%EF%BC%89\" >\u8907\u6570\u30b7\u30fc\u30c8\u30fb\u8907\u6570\u30d5\u30a1\u30a4\u30eb\u30921\u3064\u306b\u96c6\u7d04\u3059\u308b\u306b\u306f\uff1f\uff08QUERY\u3068\u7d44\u307f\u5408\u308f\u305b\uff09<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#%E8%A4%87%E6%95%B0%E3%81%AE%E7%AF%84%E5%9B%B2%E3%82%92%E7%B8%A6%E3%81%AB%E7%A9%8D%E3%82%80%EF%BC%88%E6%B3%A2%E3%81%8B%E3%81%A3%E3%81%93%EF%BC%8B%E3%82%BB%E3%83%9F%E3%82%B3%E3%83%AD%E3%83%B3%EF%BC%89\" >\u8907\u6570\u306e\u7bc4\u56f2\u3092\u7e26\u306b\u7a4d\u3080\uff08\u6ce2\u304b\u3063\u3053\uff0b\u30bb\u30df\u30b3\u30ed\u30f3\uff09<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#QUERY%E3%81%A7%E3%80%8C%E9%9B%86%E3%82%81%E3%81%AA%E3%81%8C%E3%82%89%E9%9B%86%E8%A8%88%E3%80%8D%E3%81%BE%E3%81%A71%E5%BC%8F%E3%81%A7%E5%AE%8C%E7%B5%90\" >QUERY\u3067\u300c\u96c6\u3081\u306a\u304c\u3089\u96c6\u8a08\u300d\u307e\u30671\u5f0f\u3067\u5b8c\u7d50<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#%E3%83%9E%E3%82%B9%E3%82%BF%E3%83%BC%E8%A1%A8%E3%81%8B%E3%82%89%E5%8D%98%E4%BE%A1%E3%82%92%E8%87%AA%E5%8B%95%E5%8F%96%E5%BE%97%E3%81%99%E3%82%8B%EF%BC%88VLOOKUP%C3%97IMPORTRANGE%EF%BC%89\" >\u30de\u30b9\u30bf\u30fc\u8868\u304b\u3089\u5358\u4fa1\u3092\u81ea\u52d5\u53d6\u5f97\u3059\u308b\uff08VLOOKUP\u00d7IMPORTRANGE\uff09<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#IMPORTRANGE%E3%81%A7%E3%82%88%E3%81%8F%E3%81%82%E3%82%8B%E3%82%A8%E3%83%A9%E3%83%BC%E3%81%A8%E5%AF%BE%E5%87%A6%E6%B3%95%E3%81%AF%EF%BC%9F\" >IMPORTRANGE\u3067\u3088\u304f\u3042\u308b\u30a8\u30e9\u30fc\u3068\u5bfe\u51e6\u6cd5\u306f\uff1f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#%E6%83%85%E3%82%B7%E3%82%B9%E3%81%8C%E6%B3%A8%E6%84%8F%E3%81%99%E3%81%B9%E3%81%8D%E6%A8%A9%E9%99%90%E3%83%BB%E3%82%BB%E3%82%AD%E3%83%A5%E3%83%AA%E3%83%86%E3%82%A3%E3%81%AE%E3%83%9D%E3%82%A4%E3%83%B3%E3%83%88%E3%81%AF%EF%BC%9F\" >\u60c5\u30b7\u30b9\u304c\u6ce8\u610f\u3059\u3079\u304d\u6a29\u9650\u30fb\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u30dd\u30a4\u30f3\u30c8\u306f\uff1f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#IMPORTRANGE%E3%81%AE%E9%99%90%E7%95%8C%E3%81%A8%E3%80%8C%E5%8D%92%E6%A5%AD%E3%80%8D%E3%81%AE%E3%82%B5%E3%82%A4%E3%83%B3%E3%81%AF%EF%BC%9F\" >IMPORTRANGE\u306e\u9650\u754c\u3068\u300c\u5352\u696d\u300d\u306e\u30b5\u30a4\u30f3\u306f\uff1f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#Gemini%E3%81%AB%E6%95%B0%E5%BC%8F%E3%82%92%E4%BD%9C%E3%81%A3%E3%81%A6%E3%82%82%E3%82%89%E3%81%86%E3%81%93%E3%81%A8%E3%82%82%E3%81%A7%E3%81%8D%E3%82%8B%EF%BC%9F\" >Gemini\u306b\u6570\u5f0f\u3092\u4f5c\u3063\u3066\u3082\u3089\u3046\u3053\u3068\u3082\u3067\u304d\u308b\uff1f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#%E3%82%88%E3%81%8F%E3%81%82%E3%82%8B%E8%B3%AA%E5%95%8F%EF%BC%88FAQ%EF%BC%89\" >\u3088\u304f\u3042\u308b\u8cea\u554f\uff08FAQ\uff09<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#Q_IMPORTRANGE%E3%81%AFExcel%E3%81%A7%E3%82%82%E4%BD%BF%E3%81%88%E3%81%BE%E3%81%99%E3%81%8B%EF%BC%9F\" >Q. IMPORTRANGE\u306fExcel\u3067\u3082\u4f7f\u3048\u307e\u3059\u304b\uff1f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#Q_%E5%8F%82%E7%85%A7%E5%85%83%E3%82%92%E7%B7%A8%E9%9B%86%E3%81%99%E3%82%8B%E3%81%A8%E3%80%81%E3%83%AA%E3%82%A2%E3%83%AB%E3%82%BF%E3%82%A4%E3%83%A0%E3%81%A7%E5%8F%8D%E6%98%A0%E3%81%95%E3%82%8C%E3%81%BE%E3%81%99%E3%81%8B%EF%BC%9F\" >Q. \u53c2\u7167\u5143\u3092\u7de8\u96c6\u3059\u308b\u3068\u3001\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u53cd\u6620\u3055\u308c\u307e\u3059\u304b\uff1f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#Q_%E7%84%A1%E6%96%99%E3%81%AE%E5%80%8B%E4%BA%BAGoogle%E3%82%A2%E3%82%AB%E3%82%A6%E3%83%B3%E3%83%88%E3%81%A7%E3%82%82%E4%BD%BF%E3%81%88%E3%81%BE%E3%81%99%E3%81%8B%EF%BC%9F\" >Q. \u7121\u6599\u306e\u500b\u4ebaGoogle\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u3082\u4f7f\u3048\u307e\u3059\u304b\uff1f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#Q_%E5%8F%82%E7%85%A7%E5%85%83%E3%81%AE%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%92%E5%89%8A%E9%99%A4%E3%83%BB%E7%A7%BB%E5%8B%95%E3%81%97%E3%81%9F%E3%82%89%E3%81%A9%E3%81%86%E3%81%AA%E3%82%8A%E3%81%BE%E3%81%99%E3%81%8B%EF%BC%9F\" >Q. \u53c2\u7167\u5143\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\u30fb\u79fb\u52d5\u3057\u305f\u3089\u3069\u3046\u306a\u308a\u307e\u3059\u304b\uff1f<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-importrange\/#%E3%81%BE%E3%81%A8%E3%82%81%EF%BC%9A%E3%81%BE%E3%81%9A%E3%81%AF1%E3%81%A4%E3%81%AE%E3%82%B7%E3%83%BC%E3%83%88%E3%82%92%E2%80%9D%E9%9B%86%E3%82%81%E3%82%8B%E2%80%9D%E3%81%93%E3%81%A8%E3%81%8B%E3%82%89\" >\u307e\u3068\u3081\uff1a\u307e\u305a\u306f1\u3064\u306e\u30b7\u30fc\u30c8\u3092&#8221;\u96c6\u3081\u308b&#8221;\u3053\u3068\u304b\u3089<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"IMPORTRANGE%E9%96%A2%E6%95%B0%E3%81%A8%E3%81%AF%EF%BC%9F%E5%88%A5%E3%82%B7%E3%83%BC%E3%83%88%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E8%87%AA%E5%8B%95%E3%81%A7%E6%8C%81%E3%81%A3%E3%81%A6%E3%81%8F%E3%82%8B%E9%96%A2%E6%95%B0\"><\/span><span class=\"ez-toc-section\" id=\"s1\"><\/span>IMPORTRANGE\u95a2\u6570\u3068\u306f\uff1f\u5225\u30b7\u30fc\u30c8\u306e\u30c7\u30fc\u30bf\u3092\u81ea\u52d5\u3067\u6301\u3063\u3066\u304f\u308b\u95a2\u6570<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>IMPORTRANGE\u95a2\u6570\u3068\u306f\u3001\u5225\u306eGoogle\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u3001\u6307\u5b9a\u3057\u305f\u7bc4\u56f2\u306e\u30c7\u30fc\u30bf\u3092\u81ea\u52d5\u3067\u8aad\u307f\u8fbc\u3093\u3067\u8868\u793a\u3059\u308b\u305f\u3081\u306e\u95a2\u6570<\/strong>\u3067\u3059\u3002Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u72ec\u81ea\u306e\u6a5f\u80fd\u3067\u3001\u53c2\u7167\u5143\u306e\u30c7\u30fc\u30bf\u304c\u66f4\u65b0\u3055\u308c\u308c\u3070\u3001\u53c2\u7167\u5148\u306b\u3082\u81ea\u52d5\u3067\u53cd\u6620\u3055\u308c\u307e\u3059\u3002Excel\u306b\u306f\u306a\u3044\u3001\u30af\u30e9\u30a6\u30c9\u8868\u8a08\u7b97\u306a\u3089\u3067\u306f\u306e\u95a2\u6570\u3067\u3059\u3002<\/p>\n<p>\u4e2d\u5c0f\u4f01\u696d\u306e\u73fe\u5834\u3067\u306f\u3001\u3053\u3093\u306a\u300c\u3042\u308b\u3042\u308b\u300d\u3092\u89e3\u6c7a\u3067\u304d\u307e\u3059\u3002<\/p>\n<ul>\n<li><strong>\u62e0\u70b9\u30fb\u5e97\u8217\u3054\u3068\u306b\u30d5\u30a1\u30a4\u30eb\u304c\u5206\u304b\u308c\u3066\u3044\u308b<\/strong>\uff1a\u5404\u5e97\u304c\u5165\u529b\u3057\u305f\u58f2\u4e0a\u30b7\u30fc\u30c8\u3092\u3001\u672c\u90e8\u304c1\u3064\u306e\u96c6\u8a08\u30b7\u30fc\u30c8\u306b\u81ea\u52d5\u3067\u96c6\u3081\u308b\u3002<\/li>\n<li><strong>\u30de\u30b9\u30bf\u30fc\u30921\u3064\u306b\u3057\u305f\u3044<\/strong>\uff1a\u5546\u54c1\u4fa1\u683c\u3084\u53d6\u5f15\u5148\u306e\u300c\u30de\u30b9\u30bf\u30fc\u8868\u300d\u30921\u30d5\u30a1\u30a4\u30eb\u3067\u7ba1\u7406\u3057\u3001\u898b\u7a4d\u66f8\u30b7\u30fc\u30c8\u306a\u3069\u304b\u3089\u53c2\u7167\u3059\u308b\u30021\u304b\u6240\u76f4\u305b\u3070\u5168\u90e8\u304c\u6700\u65b0\u306b\u306a\u308b\u3002<\/li>\n<li><strong>\u8ee2\u8a18\u30df\u30b9\u3092\u306a\u304f\u3057\u305f\u3044<\/strong>\uff1a\u624b\u3067\u30b3\u30d4\u30da\u3057\u306a\u3044\u306e\u3067\u3001\u8cbc\u308a\u9593\u9055\u3044\u30fb\u8cbc\u308a\u5fd8\u308c\u3068\u3044\u3063\u305f\u4eba\u70ba\u30df\u30b9\u304c\u30bc\u30ed\u306b\u306a\u308b\u3002<\/li>\n<\/ul>\n<p>\u3064\u307e\u308aIMPORTRANGE\u306f\u3001<strong>\u300c\u30c7\u30fc\u30bf\u306e\u4e8c\u91cd\u7ba1\u7406\u300d\u3068\u300c\u6708\u672b\u306e\u624b\u96c6\u8a08\u300d\u304b\u3089\u89e3\u653e\u3057\u3066\u304f\u308c\u308b\u95a2\u6570<\/strong>\u3067\u3059\u3002\u306a\u304a\u3001\u30cd\u30c3\u30c8\u4e0a\u306eWeb\u30da\u30fc\u30b8\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u8fbc\u3080<code>IMPORTXML<\/code>\u3068\u306f\u7528\u9014\u304c\u307e\u3063\u305f\u304f\u7570\u306a\u308a\u307e\u3059\uff08IMPORTXML\u306fHTML\u306e\u53d6\u5f97\u3001IMPORTRANGE\u306f\u5225\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u53c2\u7167\uff09\u3002\u6df7\u540c\u3057\u3084\u3059\u3044\u306e\u3067\u3001Web\u53d6\u5f97\u3092\u3057\u305f\u3044\u65b9\u306f\u4e0b\u306e\u95a2\u9023\u8a18\u4e8b\u3092\u3054\u89a7\u304f\u3060\u3055\u3044\u3002<\/p>\n<div style=\"border: 1px solid #f0d6d8; border-left: 5px solid #c8161d; background: #fdf5f5; padding: 14px 18px; margin: 16px 0; border-radius: 4px;\">\n<div style=\"font-size: 12px; color: #8b5a5d; margin-bottom: 6px; font-weight: bold; letter-spacing: 0.05em;\">\u25bc \u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/div>\n<p><a href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/importxml\/\" style=\"color: #8a0e15; text-decoration: none; font-weight: bold; font-size: 15px; line-height: 1.5;\">\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u95a2\u6570\uff1aIMPORTXML\u3067Web\u306e\u30c7\u30fc\u30bf\u3092\u81ea\u52d5\u53d6\u5f97\u3059\u308b\u65b9\u6cd5 &#x27a1;<\/a>\n<\/div>\n<p>&nbsp;<\/p>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"IMPORTRANGE%E3%81%AE%E5%9F%BA%E6%9C%AC%E7%9A%84%E3%81%AA%E4%BD%BF%E3%81%84%E6%96%B9%E3%81%AF%EF%BC%9F%EF%BC%883%E3%82%B9%E3%83%86%E3%83%83%E3%83%97%EF%BC%89\"><\/span><span class=\"ez-toc-section\" id=\"s2\"><\/span>IMPORTRANGE\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u306f\uff1f\uff083\u30b9\u30c6\u30c3\u30d7\uff09<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u307e\u305a\u306f1\u3064\u306e\u5225\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u3092\u5f15\u3063\u5f35\u3063\u3066\u304f\u308b\u3001\u57fa\u672c\u5f62\u3092\u899a\u3048\u307e\u3057\u3087\u3046\u3002\u6570\u5f0f\u306e\u69cb\u6587\u306f\u3068\u3066\u3082\u30b7\u30f3\u30d7\u30eb\u3067\u3059\u3002<\/p>\n<p style=\"text-align:center;\"><code>=IMPORTRANGE(\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eURL\u307e\u305f\u306f\u30ad\u30fc\", \"\u30b7\u30fc\u30c8\u540d!\u7bc4\u56f2\")<\/code><\/p>\n<p>2\u3064\u306e\u5f15\u6570\u306e\u610f\u5473\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<thead>\n<tr>\n<th style=\"background-color: #296b91; color: #ffffff; padding: 10px; border: 1px solid #ccc; font-weight: bold; text-align: left;\">\u5f15\u6570<\/th>\n<th style=\"background-color: #296b91; color: #ffffff; padding: 10px; border: 1px solid #ccc; font-weight: bold; text-align: center;\">\u4f55\u3092\u5165\u308c\u308b\uff1f<\/th>\n<th style=\"background-color: #296b91; color: #ffffff; padding: 10px; border: 1px solid #ccc; font-weight: bold; text-align: center;\">\u5177\u4f53\u4f8b<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u7b2c1\u5f15\u6570\uff08URL\/\u30ad\u30fc\uff09<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u53c2\u7167\u5143\u30d5\u30a1\u30a4\u30eb\u306eURL\u3001\u307e\u305f\u306fURL\u5185\u306e\u30ad\u30fc\uff08\u82f1\u6570\u5b57\u306e\u9577\u3044\u6587\u5b57\u5217\uff09<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">&#8220;https:\/\/docs.google.com\/spreadsheets\/d\/xxxx\/edit&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u7b2c2\u5f15\u6570\uff08\u7bc4\u56f2\uff09<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u53d6\u308a\u8fbc\u307f\u305f\u3044\u30b7\u30fc\u30c8\u540d\u3068\u30bb\u30eb\u7bc4\u56f2<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">&#8220;\u58f2\u4e0a!A1:D100&#8221;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u5b9f\u969b\u306e\u624b\u9806\u306f\u6b21\u306e3\u30b9\u30c6\u30c3\u30d7\u3067\u3059\u3002<\/p>\n<ol>\n<li><strong>\u53c2\u7167\u5143\u306eURL\u3092\u30b3\u30d4\u30fc<\/strong>\uff1a\u30c7\u30fc\u30bf\u3092\u6301\u3063\u3066\u304d\u305f\u3044\u5143\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304d\u3001\u30d6\u30e9\u30a6\u30b6\u306e\u30a2\u30c9\u30ec\u30b9\u30d0\u30fc\u304b\u3089URL\u3092\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002<\/li>\n<li><strong>\u96c6\u8a08\u5074\u306e\u30bb\u30eb\u306b\u6570\u5f0f\u3092\u5165\u529b<\/strong>\uff1a\u30c7\u30fc\u30bf\u3092\u8868\u793a\u3057\u305f\u3044\u30bb\u30eb\u306b\u3001\u4e0a\u306e\u69cb\u6587\u3067\u6570\u5f0f\u3092\u5165\u529b\u3057\u307e\u3059\uff08URL\u306f&#8221;\uff08\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c8\uff09\u3067\u56f2\u307f\u307e\u3059\uff09\u3002<\/li>\n<li><strong>\u300c\u30a2\u30af\u30bb\u30b9\u3092\u8a31\u53ef\u300d\u3092\u30af\u30ea\u30c3\u30af<\/strong>\uff1a\u6700\u521d\u306f<code>#REF!<\/code>\u3068\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u305d\u306e\u30bb\u30eb\u306b\u30de\u30a6\u30b9\u3092\u5408\u308f\u305b\u308b\u3068\u51fa\u3066\u304f\u308b<strong>\u300c\u30a2\u30af\u30bb\u30b9\u3092\u8a31\u53ef\u300d\u30dc\u30bf\u30f3\u30921\u56de\u62bc\u3059<\/strong>\u3068\u3001\u30c7\u30fc\u30bf\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li>\n<\/ol>\n<p>\u3053\u306e\u300c\u30a2\u30af\u30bb\u30b9\u3092\u8a31\u53ef\u300d\u306f\u30012\u3064\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u521d\u3081\u3066\u3064\u306a\u3050\u3068\u304d\u306e1\u56de\u3060\u3051\u5fc5\u8981\u306a\u64cd\u4f5c\u3067\u3059\u3002&nbsp;\u4e00\u5ea6\u8a31\u53ef\u3059\u308c\u3070\u3001\u4ee5\u964d\u306f\u53c2\u7167\u5143\u304c\u66f4\u65b0\u3055\u308c\u308b\u305f\u3073\u306b\u81ea\u52d5\u3067\u53cd\u6620\u3055\u308c\u307e\u3059\u3002&nbsp;\u306a\u304a\u3001\u7bc4\u56f2\u306f<code>\"\u58f2\u4e0a!A1:D\"<\/code>\u306e\u3088\u3046\u306b\u884c\u756a\u53f7\u3092\u7701\u304f\u3068\u300c\u305d\u306e\u5217\u306e\u6700\u7d42\u884c\u307e\u3067\u300d\u3092\u610f\u5473\u3057\u3001\u884c\u304c\u5897\u3048\u3066\u3082\u6570\u5f0f\u3092\u76f4\u3059\u5fc5\u8981\u304c\u306a\u304f\u306a\u308b\u306e\u3067\u4fbf\u5229\u3067\u3059\u3002<\/p>\n<p>1\u70b9\u3060\u3051\u899a\u3048\u3066\u304a\u304d\u305f\u3044\u306e\u306f\u3001<strong>IMPORTRANGE\u3067\u53d6\u308a\u8fbc\u3093\u3060\u30c7\u30fc\u30bf\u306f\u300c\u8aad\u307f\u53d6\u308a\u5c02\u7528\u300d\u3067\u3001\u9023\u643a\u306f\u4e00\u65b9\u5411\u3060<\/strong>\u3068\u3044\u3046\u70b9\u3067\u3059\u3002\u53c2\u7167\u5148\uff08\u96c6\u8a08\u5074\uff09\u306e\u30bb\u30eb\u3092\u76f4\u63a5\u66f8\u304d\u63db\u3048\u308b\u3053\u3068\u306f\u3067\u304d\u305a\u3001\u4fee\u6b63\u306f\u5fc5\u305a\u53c2\u7167\u5143\u306e\u30d5\u30a1\u30a4\u30eb\u3067\u304a\u3053\u306a\u3044\u307e\u3059\u3002\u96c6\u8a08\u5074\u306f\u300c\u898b\u308b\u3060\u3051\u30fb\u96c6\u3081\u308b\u3060\u3051\u300d\u3068\u8003\u3048\u3066\u304a\u304f\u3068\u6df7\u4e71\u3057\u307e\u305b\u3093\u3002<\/p>\n<p align=\"center\"><img decoding=\"async\" data-src=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-content\/uploads\/2026\/07\/importrange_2.png\" alt=\"\u5225\u30b7\u30fc\u30c8\u53c2\u7167\" width=\"480\" height=\"320\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 480px; --smush-placeholder-aspect-ratio: 480\/320;\" \/><\/p>\n<p>&nbsp;<\/p>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%E8%A4%87%E6%95%B0%E3%82%B7%E3%83%BC%E3%83%88%E3%83%BB%E8%A4%87%E6%95%B0%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%921%E3%81%A4%E3%81%AB%E9%9B%86%E7%B4%84%E3%81%99%E3%82%8B%E3%81%AB%E3%81%AF%EF%BC%9F%EF%BC%88QUERY%E3%81%A8%E7%B5%84%E3%81%BF%E5%90%88%E3%82%8F%E3%81%9B%EF%BC%89\"><\/span><span class=\"ez-toc-section\" id=\"s3\"><\/span>\u8907\u6570\u30b7\u30fc\u30c8\u30fb\u8907\u6570\u30d5\u30a1\u30a4\u30eb\u30921\u3064\u306b\u96c6\u7d04\u3059\u308b\u306b\u306f\uff1f\uff08QUERY\u3068\u7d44\u307f\u5408\u308f\u305b\uff09<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u57fa\u672c\u5f62\u306f\u300c1\u3064\u306e\u7bc4\u56f2\u3092\u6301\u3063\u3066\u304f\u308b\u300d\u3060\u3051\u3067\u3059\u304c\u3001\u5b9f\u52d9\u3067\u3084\u308a\u305f\u3044\u306e\u306f<strong>\u300c\u8907\u6570\u306e\u5e97\u8217\u30fb\u90e8\u9580\u306e\u30c7\u30fc\u30bf\u30921\u304b\u6240\u306b\u7a4d\u307f\u4e0a\u3052\u3066\u3001\u96c6\u8a08\u3059\u308b\u300d<\/strong>\u3053\u3068\u306e\u306f\u305a\u3002\u3053\u3053\u3067\u6d3b\u304d\u308b\u306e\u304c<code>QUERY<\/code>\u95a2\u6570\u3068\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u3059\u3002\u3053\u308c\u306fIMPORTRANGE\u306e\u4f7f\u3044\u65b9\u306e\u4e2d\u3067\u3082\u3001\u3082\u3063\u3068\u3082\u5b9f\u52d9\u983b\u5ea6\u304c\u9ad8\u3044\u30d1\u30bf\u30fc\u30f3\u3067\u3059\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%E8%A4%87%E6%95%B0%E3%81%AE%E7%AF%84%E5%9B%B2%E3%82%92%E7%B8%A6%E3%81%AB%E7%A9%8D%E3%82%80%EF%BC%88%E6%B3%A2%E3%81%8B%E3%81%A3%E3%81%93%EF%BC%8B%E3%82%BB%E3%83%9F%E3%82%B3%E3%83%AD%E3%83%B3%EF%BC%89\"><\/span>\u8907\u6570\u306e\u7bc4\u56f2\u3092\u7e26\u306b\u7a4d\u3080\uff08\u6ce2\u304b\u3063\u3053\uff0b\u30bb\u30df\u30b3\u30ed\u30f3\uff09<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u6ce2\u304b\u3063\u3053<code>{ }<\/code>\u306e\u4e2d\u3067\u3001\u5404\u30c7\u30fc\u30bf\u7bc4\u56f2\u3092<strong>\u30bb\u30df\u30b3\u30ed\u30f3<code>;<\/code><\/strong>\u3067\u533a\u5207\u308b\u3068\u3001\u30c7\u30fc\u30bf\u3092\u7e26\u65b9\u5411\u306b\u7a4d\u307f\u91cd\u306d\u3089\u308c\u307e\u3059\uff08\u6a2a\u306b\u4e26\u3079\u305f\u3044\u3068\u304d\u306f\u30ab\u30f3\u30de<code>,<\/code>\uff09\u3002\u5225\u30d5\u30a1\u30a4\u30eb\u306a\u3089IMPORTRANGE\u3092\u30bb\u30df\u30b3\u30ed\u30f3\u3067\u3064\u306a\u304e\u307e\u3059\u3002<\/p>\n<p style=\"text-align:center;\"><code>={IMPORTRANGE(\"A\u5e97URL\",\"\u58f2\u4e0a!A2:C\") ; IMPORTRANGE(\"B\u5e97URL\",\"\u58f2\u4e0a!A2:C\")}<\/code><\/p>\n<h3><span class=\"ez-toc-section\" id=\"QUERY%E3%81%A7%E3%80%8C%E9%9B%86%E3%82%81%E3%81%AA%E3%81%8C%E3%82%89%E9%9B%86%E8%A8%88%E3%80%8D%E3%81%BE%E3%81%A71%E5%BC%8F%E3%81%A7%E5%AE%8C%E7%B5%90\"><\/span>QUERY\u3067\u300c\u96c6\u3081\u306a\u304c\u3089\u96c6\u8a08\u300d\u307e\u30671\u5f0f\u3067\u5b8c\u7d50<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u7a4d\u307f\u4e0a\u3052\u305f\u5168\u30c7\u30fc\u30bf\u3092<code>QUERY<\/code>\u3067\u56f2\u3081\u3070\u3001SQL\u306e\u3088\u3046\u306a\u547d\u4ee4\u3067\u96c6\u8a08\u3067\u304d\u307e\u3059\u3002\u305f\u3068\u3048\u3070\u300c\u5e97\u8217\u540d\u3054\u3068\u306b\u58f2\u4e0a\u3092\u5408\u8a08\u3059\u308b\u300d\u306a\u3089\u3001\u6b21\u306e\u3088\u3046\u306b\u66f8\u304d\u307e\u3059\u3002<\/p>\n<p style=\"text-align:center;\"><code>=QUERY({IMPORTRANGE(\"A\u5e97URL\",\"\u58f2\u4e0a!A2:C\") ; IMPORTRANGE(\"B\u5e97URL\",\"\u58f2\u4e0a!A2:C\")}, \"select Col1, sum(Col3) group by Col1 label Col1 '\u5e97\u8217', sum(Col3) '\u58f2\u4e0a\u5408\u8a08'\", 0)<\/code><\/p>\n<p>\u3053\u308c\u3060\u3051\u3067\u3001\u5404\u5e97\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304f\u3053\u3068\u306a\u304f\u3001\u672c\u90e8\u306e\u30b7\u30fc\u30c8\u306b<strong>\u5e97\u8217\u5225\u306e\u58f2\u4e0a\u5408\u8a08\u304c\u81ea\u52d5\u3067\u4e26\u3073\u307e\u3059<\/strong>\u3002&nbsp;\u5404\u5e97\u304c\u81ea\u5206\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u5165\u529b\u3059\u308b\u3060\u3051\u3067\u3001\u672c\u90e8\u306e\u96c6\u8a08\u8868\u306f\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306b\u6700\u65b0\u5316\u3055\u308c\u308b\u306e\u3067\u3001\u300c\u6708\u672b\u306b\u5168\u5e97\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u3044\u3066\u624b\u96c6\u8a08\u300d\u3068\u3044\u3046\u4f5c\u696d\u305d\u306e\u3082\u306e\u304c\u6d88\u3048\u307e\u3059\u3002&nbsp;\u3055\u3089\u306b\u3001\u96c6\u7d04\u3057\u305f\u30c7\u30fc\u30bf\u3092<strong>Looker Studio\uff08\u7121\u6599\u306eBI\u30c4\u30fc\u30eb\uff09<\/strong>\u306b\u3064\u306a\u3052\u3070\u3001\u7d4c\u55b6\u8005\u5411\u3051\u306e\u30b0\u30e9\u30d5\u30fb\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u3068\u3057\u3066\u53ef\u8996\u5316\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n<p align=\"center\"><img decoding=\"async\" data-src=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-content\/uploads\/2026\/07\/importrange_3.png\" alt=\"\u96c6\u8a08\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\" width=\"480\" height=\"320\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 480px; --smush-placeholder-aspect-ratio: 480\/320;\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"%E3%83%9E%E3%82%B9%E3%82%BF%E3%83%BC%E8%A1%A8%E3%81%8B%E3%82%89%E5%8D%98%E4%BE%A1%E3%82%92%E8%87%AA%E5%8B%95%E5%8F%96%E5%BE%97%E3%81%99%E3%82%8B%EF%BC%88VLOOKUP%C3%97IMPORTRANGE%EF%BC%89\"><\/span>\u30de\u30b9\u30bf\u30fc\u8868\u304b\u3089\u5358\u4fa1\u3092\u81ea\u52d5\u53d6\u5f97\u3059\u308b\uff08VLOOKUP\u00d7IMPORTRANGE\uff09<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u96c6\u7d04\u3068\u4e26\u3093\u3067\u3088\u304f\u4f7f\u3046\u306e\u304c\u3001<strong>\u5225\u30d5\u30a1\u30a4\u30eb\u306e\u300c\u5546\u54c1\u30de\u30b9\u30bf\u30fc\u300d\u304b\u3089\u5358\u4fa1\u3084\u5546\u54c1\u540d\u3092\u81ea\u52d5\u3067\u5f15\u3063\u5f35\u3063\u3066\u304f\u308b<\/strong>\u4f7f\u3044\u65b9\u3067\u3059\u3002\u30de\u30b9\u30bf\u30fc\u8868\u30921\u3064\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u307e\u3068\u3081\u3066\u304a\u304d\u3001\u898b\u7a4d\u66f8\u3084\u53d7\u6ce8\u30b7\u30fc\u30c8\u304b\u3089<code>VLOOKUP<\/code>\uff08\u307e\u305f\u306fXLOOKUP\uff09\u3068IMPORTRANGE\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u53c2\u7167\u3057\u307e\u3059\u3002<\/p>\n<p style=\"text-align:center;\"><code>=VLOOKUP(A2, IMPORTRANGE(\"\u30de\u30b9\u30bf\u30fcURL\",\"\u5546\u54c1!A:C\"), 3, false)<\/code><\/p>\n<p>\u3053\u306e\u5f0f\u306a\u3089\u3001\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u5165\u308c\u308b\u3060\u3051\u3067\u5358\u4fa1\u304c\u81ea\u52d5\u3067\u8868\u793a\u3055\u308c\u3001\u4fa1\u683c\u6539\u5b9a\u306e\u3068\u304d\u3082<strong>\u30de\u30b9\u30bf\u30fc\u8868\u30921\u304b\u6240\u76f4\u3059\u3060\u3051\u3067\u3001\u53c2\u7167\u3057\u3066\u3044\u308b\u3059\u3079\u3066\u306e\u30b7\u30fc\u30c8\u306b\u53cd\u6620<\/strong>\u3055\u308c\u307e\u3059\u3002&nbsp;\u300c\u53e4\u3044\u5358\u4fa1\u306e\u307e\u307e\u898b\u7a4d\u3082\u308a\u3092\u51fa\u3057\u3066\u3057\u307e\u3063\u305f\u300d\u3068\u3044\u3063\u305f\u4fa1\u683c\u306e\u66f4\u65b0\u6f0f\u308c\u3092\u3001\u4ed5\u7d44\u307f\u3067\u9632\u3052\u308b\u306e\u304c\u5927\u304d\u306a\u30e1\u30ea\u30c3\u30c8\u3067\u3059\u3002<\/p>\n<p>\u95a2\u6570\u3092\u3082\u3063\u3068\u5e45\u5e83\u304f\u4f7f\u3044\u3053\u306a\u3057\u305f\u3044\u65b9\u306f\u3001\u3053\u3061\u3089\u306e\u95a2\u6570\u307e\u3068\u3081\u3082\u3042\u308f\u305b\u3066\u3069\u3046\u305e\u3002<\/p>\n<div style=\"border: 1px solid #f0d6d8; border-left: 5px solid #c8161d; background: #fdf5f5; padding: 14px 18px; margin: 16px 0; border-radius: 4px;\">\n<div style=\"font-size: 12px; color: #8b5a5d; margin-bottom: 6px; font-weight: bold; letter-spacing: 0.05em;\">\u25bc \u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/div>\n<p><a href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/google-spreadsheet-kansuu\/\" style=\"color: #8a0e15; text-decoration: none; font-weight: bold; font-size: 15px; line-height: 1.5;\">Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u304a\u3059\u3059\u3081\u306e\u95a2\u657011\u9078\uff01 &#x27a1;<\/a>\n<\/div>\n<p>&nbsp;<\/p>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"IMPORTRANGE%E3%81%A7%E3%82%88%E3%81%8F%E3%81%82%E3%82%8B%E3%82%A8%E3%83%A9%E3%83%BC%E3%81%A8%E5%AF%BE%E5%87%A6%E6%B3%95%E3%81%AF%EF%BC%9F\"><\/span><span class=\"ez-toc-section\" id=\"s4\"><\/span>IMPORTRANGE\u3067\u3088\u304f\u3042\u308b\u30a8\u30e9\u30fc\u3068\u5bfe\u51e6\u6cd5\u306f\uff1f<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>IMPORTRANGE\u306f\u4fbf\u5229\u306a\u53cd\u9762\u3001\u3064\u307e\u305a\u304d\u30dd\u30a4\u30f3\u30c8\u3082\u6c7a\u307e\u3063\u3066\u3044\u307e\u3059\u3002\u4ee3\u8868\u7684\u306a\u30a8\u30e9\u30fc\u3068\u5bfe\u51e6\u6cd5\u3092\u8868\u306b\u307e\u3068\u3081\u307e\u3057\u305f\u3002<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<thead>\n<tr>\n<th style=\"background-color: #296b91; color: #ffffff; padding: 10px; border: 1px solid #ccc; font-weight: bold; text-align: left;\">\u75c7\u72b6<\/th>\n<th style=\"background-color: #296b91; color: #ffffff; padding: 10px; border: 1px solid #ccc; font-weight: bold; text-align: center;\">\u4e3b\u306a\u539f\u56e0<\/th>\n<th style=\"background-color: #296b91; color: #ffffff; padding: 10px; border: 1px solid #ccc; font-weight: bold; text-align: center;\">\u5bfe\u51e6\u6cd5<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\"><code>#REF!<\/code>\uff08\u30a2\u30af\u30bb\u30b9\u304c\u5fc5\u8981\uff09<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">2\u3064\u306e\u30d5\u30a1\u30a4\u30eb\u306e\u63a5\u7d9a\u8a31\u53ef\u304c\u307e\u3060<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u30bb\u30eb\u306e\u300c\u30a2\u30af\u30bb\u30b9\u3092\u8a31\u53ef\u300d\u30921\u56de\u30af\u30ea\u30c3\u30af<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\"><code>#REF!<\/code>\uff08\u7bc4\u56f2\u304c\u4e0d\u6b63\uff09<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u30b7\u30fc\u30c8\u540d\u306e\u9593\u9055\u3044\u30fb\u5168\u89d2\u8a18\u53f7\u30fb\u5b58\u5728\u3057\u306a\u3044\u7bc4\u56f2<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u30b7\u30fc\u30c8\u540d\u3068\u7bc4\u56f2\u3092\u534a\u89d2\u3067\u6b63\u78ba\u306b\u3002\u7bc4\u56f2\u306f&#8221;\u30b7\u30fc\u30c8\u540d!A1:B&#8221;\u5f62\u5f0f<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\"><code>#N\/A<\/code> \/ \u300c\u7d50\u679c\u304c\u5927\u304d\u3059\u304e\u307e\u3059\u300d<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u53d6\u308a\u8fbc\u3080\u7bc4\u56f2\u304c\u5e83\u3059\u304e\u308b\u30fb\u8cbc\u308a\u4ed8\u3051\u5148\u306b\u30b9\u30da\u30fc\u30b9\u4e0d\u8db3<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u5fc5\u8981\u306a\u7bc4\u56f2\u3060\u3051\u306b\u7d5e\u308b\u3002\u6570\u5f0f\u30bb\u30eb\u306e\u53f3\u30fb\u4e0b\u3092\u7a7a\u3051\u3066\u304a\u304f<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u300c\u8aad\u307f\u8fbc\u3093\u3067\u3044\u307e\u3059\u300d\u304c\u7d42\u308f\u3089\u306a\u3044\u30fb\u91cd\u3044<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">IMPORTRANGE\u3092\u4f55\u6bb5\u3082\u9023\u9396\uff08\u30c1\u30a7\u30fc\u30f3\uff09\u30fb\u6570\u5f0f\u304c\u591a\u3059\u304e<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u9023\u9396\u3092\u6e1b\u3089\u3059\u3002\u96c6\u7d04\u306f1\u968e\u5c64\u306b\u307e\u3068\u3081\u308b\u3002\u4e0d\u8981\u306a\u6570\u5f0f\u3092\u524a\u9664<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u53c2\u7167\u5143\u3092\u76f4\u3057\u305f\u306e\u306b\u53cd\u6620\u3055\u308c\u306a\u3044<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u66f4\u65b0\u306b\u6570\u5206\u306e\u30bf\u30a4\u30e0\u30e9\u30b0\u304c\u3042\u308b<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u5c11\u3057\u5f85\u3064\u3002\u6025\u3050\u5834\u5408\u306f\u30bb\u30eb\u3092\u518d\u5165\u529b\u3057\u3066\u518d\u8a08\u7b97<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u6025\u306b\u30c7\u30fc\u30bf\u304c\u6d88\u3048\u305f<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u53c2\u7167\u5143\u30d5\u30a1\u30a4\u30eb\u306e\u524a\u9664\u30fb\u79fb\u52d5\u30fbURL\u5909\u66f4<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u53c2\u7167\u5143\u306f\u5171\u6709\u30c9\u30e9\u30a4\u30d6\u3067\u56fa\u5b9a\u7ba1\u7406\u3002\u5b89\u6613\u306b\u79fb\u52d5\u30fb\u524a\u9664\u3057\u306a\u3044<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u7279\u306b\u591a\u3044\u306e\u304c\u6700\u521d\u306e<code>#REF!<\/code>\u3067\u3059\u3002&nbsp;\u300c\u30a8\u30e9\u30fc\u304c\u51fa\u305f\uff1d\u5931\u6557\u300d\u3067\u306f\u306a\u304f\u3001\u300c\u63a5\u7d9a\u306e\u8a31\u53ef\u3092\u6c42\u3081\u3089\u308c\u3066\u3044\u308b\u300d\u3060\u3051\u306e\u3053\u3068\u304c\u307b\u3068\u3093\u3069\u306a\u306e\u3067\u3001\u3042\u308f\u3066\u305a\u30bb\u30eb\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u5408\u308f\u305b\u3066\u8a31\u53ef\u30dc\u30bf\u30f3\u3092\u63a2\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>&nbsp;<\/p>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%E6%83%85%E3%82%B7%E3%82%B9%E3%81%8C%E6%B3%A8%E6%84%8F%E3%81%99%E3%81%B9%E3%81%8D%E6%A8%A9%E9%99%90%E3%83%BB%E3%82%BB%E3%82%AD%E3%83%A5%E3%83%AA%E3%83%86%E3%82%A3%E3%81%AE%E3%83%9D%E3%82%A4%E3%83%B3%E3%83%88%E3%81%AF%EF%BC%9F\"><\/span><span class=\"ez-toc-section\" id=\"s5\"><\/span>\u60c5\u30b7\u30b9\u304c\u6ce8\u610f\u3059\u3079\u304d\u6a29\u9650\u30fb\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u30dd\u30a4\u30f3\u30c8\u306f\uff1f<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>IMPORTRANGE\u3092\u793e\u5185\u3067\u4f7f\u3046\u3068\u304d\u3001\u60c5\u30b7\u30b9\u62c5\u5f53\u304c\u5fc5\u305a\u62bc\u3055\u3048\u3066\u304a\u304d\u305f\u3044\u306e\u304c<strong>\u300c\u5171\u6709\u7bc4\u56f2\u306e\u8003\u3048\u65b9\u300d<\/strong>\u3067\u3059\u3002\u3053\u3053\u3092\u8aa4\u89e3\u3059\u308b\u3068\u3001\u610f\u56f3\u3057\u306a\u3044\u60c5\u5831\u6f0f\u3048\u3044\u306b\u3064\u306a\u304c\u308a\u307e\u3059\u3002<\/p>\n<p>\u6700\u91cd\u8981\u30dd\u30a4\u30f3\u30c8\u306f\u3001<strong>IMPORTRANGE\u3067\u63a5\u7d9a\u3092\u8a31\u53ef\u3059\u308b\u3068\u3001\u53c2\u7167\u5148\u30d5\u30a1\u30a4\u30eb\u3092\u898b\u3089\u308c\u308b\u4eba\u306f\u3001\u5b9f\u8cea\u7684\u306b\u53c2\u7167\u5143\u306e\u30c7\u30fc\u30bf\u3082\u898b\u3089\u308c\u308b\u72b6\u614b\u306b\u306a\u308b<\/strong>\u3068\u3044\u3046\u70b9\u3067\u3059\u3002\u300c\u96c6\u8a08\u30d5\u30a1\u30a4\u30eb\u3060\u3051\u5168\u793e\u306b\u5171\u6709\u3057\u305f\u3064\u3082\u308a\u304c\u3001\u5404\u5e97\u306e\u5143\u30c7\u30fc\u30bf\u307e\u3067\u898b\u3048\u3066\u3057\u307e\u3046\u300d\u3068\u3044\u3046\u4e8b\u6545\u304c\u8d77\u304d\u304c\u3061\u3067\u3059\u3002\u6b21\u306e\u70b9\u3092\u904b\u7528\u30eb\u30fc\u30eb\u306b\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<thead>\n<tr>\n<th style=\"background-color: #296b91; color: #ffffff; padding: 10px; border: 1px solid #ccc; font-weight: bold; text-align: left;\">\u89b3\u70b9<\/th>\n<th style=\"background-color: #296b91; color: #ffffff; padding: 10px; border: 1px solid #ccc; font-weight: bold; text-align: center;\">\u3084\u308b\u3079\u304d\u3053\u3068<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u5171\u6709\u7bc4\u56f2<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u96c6\u8a08\u30d5\u30a1\u30a4\u30eb\u306e\u5171\u6709\u76f8\u624b\u304c\u3001\u5143\u30c7\u30fc\u30bf\u3092\u898b\u3066\u3088\u3044\u4eba\u304b\u3092\u5fc5\u305a\u78ba\u8a8d\u3059\u308b<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u898b\u305b\u305f\u304f\u306a\u3044\u5217<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u5143\u30c7\u30fc\u30bf\u306b\u7d66\u4e0e\u306a\u3069\u6a5f\u5fae\u60c5\u5831\u304c\u3042\u308b\u5834\u5408\u3001\u53c2\u7167\u7bc4\u56f2\u3092\u5fc5\u8981\u306a\u5217\u3060\u3051\u306b\u7d5e\u308b<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u30d5\u30a1\u30a4\u30eb\u7ba1\u7406<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u53c2\u7167\u5143\u306f\u500b\u4eba\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u306a\u304f\u5171\u6709\u30c9\u30e9\u30a4\u30d6\u306b\u7f6e\u304d\u3001\u9000\u8077\u8005\u4f9d\u5b58\u3092\u306a\u304f\u3059<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u91cd\u8981\u306a\u96c6\u8a08\u306f\u5b9a\u671f\u7684\u306b\u300c\u5024\u306e\u307f\u30b3\u30d4\u30fc\u300d\u3067\u65ad\u9762\u3092\u6b8b\u3059<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u7279\u306b\u300c\u53c2\u7167\u5143\u3092\u500b\u4eba\u306e\u30de\u30a4\u30c9\u30e9\u30a4\u30d6\u306b\u7f6e\u3044\u305f\u307e\u307e\u62c5\u5f53\u8005\u304c\u9000\u8077\u3057\u3001\u30d5\u30a1\u30a4\u30eb\u3054\u3068\u6d88\u3048\u3066\u96c6\u8a08\u304c\u5168\u6ec5\u3057\u305f\u300d\u3068\u3044\u3046\u76f8\u8ac7\u306f\u5c11\u306a\u304f\u3042\u308a\u307e\u305b\u3093\u3002&nbsp;\u696d\u52d9\u3067\u4f7f\u3046\u30d5\u30a1\u30a4\u30eb\u306f\u3001\u5fc5\u305a\u7d44\u7e54\u3067\u7ba1\u7406\u3067\u304d\u308b<strong>\u5171\u6709\u30c9\u30e9\u30a4\u30d6<\/strong>\u306b\u7f6e\u304f\u306e\u304c\u9244\u5247\u3067\u3059\u3002\u5171\u6709\u30c9\u30e9\u30a4\u30d6\u306e\u6a29\u9650\u8a2d\u8a08\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3061\u3089\u3082\u3054\u89a7\u304f\u3060\u3055\u3044\u3002<\/p>\n<div style=\"border: 1px solid #f0d6d8; border-left: 5px solid #c8161d; background: #fdf5f5; padding: 14px 18px; margin: 16px 0; border-radius: 4px;\">\n<div style=\"font-size: 12px; color: #8b5a5d; margin-bottom: 6px; font-weight: bold; letter-spacing: 0.05em;\">\u25bc \u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/div>\n<p><a href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/google-workspace-syosinsya\/\" style=\"color: #8a0e15; text-decoration: none; font-weight: bold; font-size: 15px; line-height: 1.5;\">Google Workspace\u521d\u5fc3\u8005\u30ac\u30a4\u30c9\uff5c\u4e2d\u5c0f\u4f01\u696d\u306e\u59cb\u3081\u65b9\u30fb\u6599\u91d1\u30fb\u4f7f\u3044\u65b9 &#x27a1;<\/a>\n<\/div>\n<p>&nbsp;<\/p>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"IMPORTRANGE%E3%81%AE%E9%99%90%E7%95%8C%E3%81%A8%E3%80%8C%E5%8D%92%E6%A5%AD%E3%80%8D%E3%81%AE%E3%82%B5%E3%82%A4%E3%83%B3%E3%81%AF%EF%BC%9F\"><\/span><span class=\"ez-toc-section\" id=\"s6\"><\/span>IMPORTRANGE\u306e\u9650\u754c\u3068\u300c\u5352\u696d\u300d\u306e\u30b5\u30a4\u30f3\u306f\uff1f<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>IMPORTRANGE\u306f\u7121\u6599\u3067\u5f37\u529b\u3067\u3059\u304c\u3001\u4e07\u80fd\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u30c7\u30fc\u30bf\u91cf\u3084\u95a2\u308f\u308b\u4eba\u304c\u5897\u3048\u308b\u3068\u3001\u6b21\u306e\u3088\u3046\u306a\u300c\u9650\u754c\u306e\u30b5\u30a4\u30f3\u300d\u304c\u51fa\u3066\u304d\u307e\u3059\u3002<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<thead>\n<tr>\n<th style=\"background-color: #296b91; color: #ffffff; padding: 10px; border: 1px solid #ccc; font-weight: bold; text-align: left;\">\u6bb5\u968e<\/th>\n<th style=\"background-color: #296b91; color: #ffffff; padding: 10px; border: 1px solid #ccc; font-weight: bold; text-align: center;\">\u5411\u3044\u3066\u3044\u308b\u72b6\u614b<\/th>\n<th style=\"background-color: #296b91; color: #ffffff; padding: 10px; border: 1px solid #ccc; font-weight: bold; text-align: center;\">\u6b21\u3078\u306e\u4e57\u308a\u63db\u3048\u30b5\u30a4\u30f3<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u624b\u4f5c\u696d\u30b3\u30d4\u30da<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u67081\u56de\u30fb\u6570\u30d5\u30a1\u30a4\u30eb\u7a0b\u5ea6<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u8ee2\u8a18\u30df\u30b9\u30fb\u96c6\u8a08\u6f0f\u308c\u304c\u51fa\u306f\u3058\u3081\u305f<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">IMPORTRANGE\uff0bQUERY<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u6570\u5e97\u8217\u301c\u5341\u6570\u30d5\u30a1\u30a4\u30eb\u306e\u81ea\u52d5\u96c6\u8a08<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u52d5\u4f5c\u304c\u91cd\u3044\u30fb\u6570\u5f0f\u304c\u8907\u96d1\u3067\u8ab0\u3082\u76f4\u305b\u306a\u3044<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u30ce\u30fc\u30b3\u30fc\u30c9\uff0f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u5165\u529b\u30fb\u627f\u8a8d\u30fb\u96c6\u8a08\u3092\u4ed5\u7d44\u307f\u5316\u3057\u305f\u3044<\/td>\n<td style=\"text-align: center; background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u6a29\u9650\u7ba1\u7406\u3084\u5165\u529b\u30c1\u30a7\u30c3\u30af\u307e\u3067\u5fc5\u8981\u306b\u306a\u3063\u305f<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u300c\u6570\u5f0f\u304c\u91cd\u304f\u3066\u958b\u304f\u306e\u306b\u6642\u9593\u304c\u304b\u304b\u308b\u300d\u300c\u4f5c\u3063\u305f\u672c\u4eba\u3057\u304b\u76f4\u305b\u306a\u3044\u30d6\u30e9\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u306b\u306a\u3063\u305f\u300d\u2014\u2014\u3053\u3046\u306a\u3063\u305f\u3089\u3001<strong>kintone\u3084AppSheet\u306e\u3088\u3046\u306a\u30ce\u30fc\u30b3\u30fc\u30c9\u30c4\u30fc\u30eb\u3001\u3042\u308b\u3044\u306f\u5c02\u7528\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u79fb\u884c\u3059\u308b\u30b5\u30a4\u30f3<\/strong>\u3067\u3059\u3002\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u9867\u5ba2\u7ba1\u7406\u3092\u59cb\u3081\u305f\u5834\u5408\u306e\u300c\u5352\u696d\u30e9\u30a4\u30f3\u300d\u306b\u3064\u3044\u3066\u306f\u3001\u6b21\u306e\u8a18\u4e8b\u3067\u3082\u5177\u4f53\u7684\u306b\u89e3\u8aac\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<div style=\"border: 1px solid #f0d6d8; border-left: 5px solid #c8161d; background: #fdf5f5; padding: 14px 18px; margin: 16px 0; border-radius: 4px;\">\n<div style=\"font-size: 12px; color: #8b5a5d; margin-bottom: 6px; font-weight: bold; letter-spacing: 0.05em;\">\u25bc \u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/div>\n<p><a href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-kokyaku-kanri\/\" style=\"color: #8a0e15; text-decoration: none; font-weight: bold; font-size: 15px; line-height: 1.5;\">Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u9867\u5ba2\u7ba1\u7406\u3059\u308b\u65b9\u6cd5\uff5c\u7121\u6599\u30c6\u30f3\u30d7\u30ec\u3068&#8221;\u5352\u696d&#8221;\u306e\u898b\u6975\u3081 &#x27a1;<\/a>\n<\/div>\n<p>\u3053\u3046\u3057\u305f\u30c7\u30fc\u30bf\u96c6\u8a08\u57fa\u76e4\u3084\u30ce\u30fc\u30b3\u30fc\u30c9\u30c4\u30fc\u30eb\u3078\u306e\u79fb\u884c\u306f\u3001<strong>\u30c7\u30b8\u30bf\u30eb\u5316\u30fbAI\u5c0e\u5165\u88dc\u52a9\u91d1<\/strong>\u3092\u6d3b\u7528\u3057\u3066\u5c0e\u5165\u30b3\u30b9\u30c8\u3092\u6291\u3048\u3089\u308c\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\u88dc\u52a9\u91d1\u306e\u8981\u4ef6\u306f\u5e74\u5ea6\u3067\u5909\u308f\u308b\u305f\u3081\u3001\u6d3b\u7528\u3092\u691c\u8a0e\u3059\u308b\u969b\u306f\u516c\u52df\u8981\u9818\u306e\u78ba\u8a8d\u3084\u5c02\u9580\u5bb6\u3078\u306e\u76f8\u8ac7\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002\u30a2\u30fc\u30c7\u30f3\u30c8\u3067\u306f\u3001\u88dc\u52a9\u91d1\u306e\u6d3b\u7528\u3082\u542b\u3081\u305f\u696d\u52d9\u30c7\u30b8\u30bf\u30eb\u5316\u306e\u3054\u76f8\u8ac7\u3092\u627f\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n<p style=\"margin-top:18px;\">Google Workspace\u306e\u5c0e\u5165\u30fb\u6d3b\u7528\u652f\u63f4\u306b\u3064\u3044\u3066\u306f\u3001\u30a2\u30fc\u30c7\u30f3\u30c8\u306e\u30b5\u30fc\u30d3\u30b9\u7d39\u4ecb\u30da\u30fc\u30b8\u3082\u3054\u89a7\u304f\u3060\u3055\u3044\u3002<\/p>\n<p align=\"center\">\n<a href=\"https:\/\/aclouds.ardent.jp\/groupware\/googleworkspac\/\" target=\"_blank\" rel=\"noopener\" class=\"q_button bt_red\">Google Workspace \u306e\u3054\u6848\u5185\u3092\u898b\u308b &#x27a1;<\/a>\n<\/p>\n<p>&nbsp;<\/p>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Gemini%E3%81%AB%E6%95%B0%E5%BC%8F%E3%82%92%E4%BD%9C%E3%81%A3%E3%81%A6%E3%82%82%E3%82%89%E3%81%86%E3%81%93%E3%81%A8%E3%82%82%E3%81%A7%E3%81%8D%E3%82%8B%EF%BC%9F\"><\/span><span class=\"ez-toc-section\" id=\"s7\"><\/span>Gemini\u306b\u6570\u5f0f\u3092\u4f5c\u3063\u3066\u3082\u3089\u3046\u3053\u3068\u3082\u3067\u304d\u308b\uff1f<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u300cQUERY\u306e\u547d\u4ee4\u6587\uff08SQL\u306e\u3088\u3046\u306a\u90e8\u5206\uff09\u304c\u96e3\u3057\u304f\u3066\u66f8\u3051\u306a\u3044\u300d\u3068\u3044\u3046\u65b9\u306f\u3001Google Workspace\u306eAI\u300cGemini\u300d\u306b\u983c\u308b\u306e\u3082\u624b\u3067\u3059\u3002&nbsp;Gemini in Sheets\u304c\u4f7f\u3048\u308b\u74b0\u5883\u306a\u3089\u3001\u300cA\u5e97\u3068B\u5e97\u306e\u58f2\u4e0a\u30b7\u30fc\u30c8\u3092\u5e97\u8217\u5225\u306b\u5408\u8a08\u3059\u308b\u6570\u5f0f\u3092\u4f5c\u3063\u3066\u300d\u3068<strong>\u65e5\u672c\u8a9e\u3067\u983c\u3080\u3060\u3051\u3067\u3001IMPORTRANGE\u3084QUERY\u3092\u542b\u3080\u6570\u5f0f\u3092\u63d0\u6848\u3057\u3066\u304f\u308c\u307e\u3059<\/strong>\u3002\u95a2\u6570\u3092\u4e38\u6697\u8a18\u3057\u306a\u304f\u3066\u3082\u3001\u3084\u308a\u305f\u3044\u3053\u3068\u3092\u8a00\u8449\u3067\u4f1d\u3048\u308c\u3070\u5f62\u306b\u3067\u304d\u308b\u6642\u4ee3\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n<div style=\"border: 1px solid #f0d6d8; border-left: 5px solid #c8161d; background: #fdf5f5; padding: 14px 18px; margin: 16px 0; border-radius: 4px;\">\n<div style=\"font-size: 12px; color: #8b5a5d; margin-bottom: 6px; font-weight: bold; letter-spacing: 0.05em;\">\u25bc \u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/div>\n<p><a href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/gemini-for-google-workspace\/\" style=\"color: #8a0e15; text-decoration: none; font-weight: bold; font-size: 15px; line-height: 1.5;\">Google Workspace with Gemini\u3068\u306f\uff1f\u4e2d\u5c0f\u4f01\u696d\u306e\u6d3b\u7528\u6cd5 &#x27a1;<\/a>\n<\/div>\n<p>&nbsp;<\/p>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%E3%82%88%E3%81%8F%E3%81%82%E3%82%8B%E8%B3%AA%E5%95%8F%EF%BC%88FAQ%EF%BC%89\"><\/span><span class=\"ez-toc-section\" id=\"s8\"><\/span>\u3088\u304f\u3042\u308b\u8cea\u554f\uff08FAQ\uff09<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Q_IMPORTRANGE%E3%81%AFExcel%E3%81%A7%E3%82%82%E4%BD%BF%E3%81%88%E3%81%BE%E3%81%99%E3%81%8B%EF%BC%9F\"><\/span>Q. IMPORTRANGE\u306fExcel\u3067\u3082\u4f7f\u3048\u307e\u3059\u304b\uff1f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>A. \u3044\u3044\u3048\u3002IMPORTRANGE\u306fGoogle\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u5c02\u7528\u306e\u95a2\u6570\u3067\u3001Excel\u306b\u306f\u3042\u308a\u307e\u305b\u3093\u3002Excel\u3067\u4f3c\u305f\u3053\u3068\u3092\u3057\u305f\u3044\u5834\u5408\u306f\u300cPower Query\u300d\u3084\u300c\u5916\u90e8\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u8fbc\u307f\u300d\u6a5f\u80fd\u3092\u4f7f\u3044\u307e\u3059\u304c\u3001\u30af\u30e9\u30a6\u30c9\u4e0a\u3067\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306b\u5225\u30d5\u30a1\u30a4\u30eb\u3092\u53c2\u7167\u3059\u308b\u624b\u8efd\u3055\u306f\u3001Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306a\u3089\u3067\u306f\u306e\u5f37\u307f\u3067\u3059\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q_%E5%8F%82%E7%85%A7%E5%85%83%E3%82%92%E7%B7%A8%E9%9B%86%E3%81%99%E3%82%8B%E3%81%A8%E3%80%81%E3%83%AA%E3%82%A2%E3%83%AB%E3%82%BF%E3%82%A4%E3%83%A0%E3%81%A7%E5%8F%8D%E6%98%A0%E3%81%95%E3%82%8C%E3%81%BE%E3%81%99%E3%81%8B%EF%BC%9F\"><\/span>Q. \u53c2\u7167\u5143\u3092\u7de8\u96c6\u3059\u308b\u3068\u3001\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u53cd\u6620\u3055\u308c\u307e\u3059\u304b\uff1f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>A. \u81ea\u52d5\u3067\u53cd\u6620\u3055\u308c\u307e\u3059\u3002\u305f\u3060\u3057\u66f4\u65b0\u306b\u306f\u6570\u5206\u7a0b\u5ea6\u306e\u30bf\u30a4\u30e0\u30e9\u30b0\u304c\u51fa\u308b\u3053\u3068\u304c\u3042\u308a\u3001\u53c2\u7167\u3059\u308b\u30b7\u30fc\u30c8\u3084\u30d5\u30a1\u30a4\u30eb\u306e\u6570\u304c\u591a\u3044\u307b\u3069\u9045\u304f\u306a\u308b\u50be\u5411\u304c\u3042\u308a\u307e\u3059\u3002\u6025\u3044\u3067\u53cd\u6620\u3057\u305f\u3044\u3068\u304d\u306f\u3001\u6570\u5f0f\u306e\u30bb\u30eb\u3092\u3082\u3046\u4e00\u5ea6\u5165\u529b\u3057\u76f4\u3059\u3068\u518d\u8a08\u7b97\u3055\u308c\u307e\u3059\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q_%E7%84%A1%E6%96%99%E3%81%AE%E5%80%8B%E4%BA%BAGoogle%E3%82%A2%E3%82%AB%E3%82%A6%E3%83%B3%E3%83%88%E3%81%A7%E3%82%82%E4%BD%BF%E3%81%88%E3%81%BE%E3%81%99%E3%81%8B%EF%BC%9F\"><\/span>Q. \u7121\u6599\u306e\u500b\u4ebaGoogle\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u3082\u4f7f\u3048\u307e\u3059\u304b\uff1f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>A. \u4f7f\u3048\u307e\u3059\u3002IMPORTRANGE\u81ea\u4f53\u306f\u7121\u6599\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u3082\u5229\u7528\u53ef\u80fd\u3067\u3059\u3002\u305f\u3060\u3057\u696d\u52d9\u3067\u4f7f\u3046\u5834\u5408\u306f\u3001\u9000\u8077\u3084\u60c5\u5831\u6f0f\u3048\u3044\u306e\u30ea\u30b9\u30af\u3092\u907f\u3051\u308b\u305f\u3081\u3001\u30d5\u30a1\u30a4\u30eb\u306f\u500b\u4eba\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u306f\u306a\u304fGoogle Workspace\u306e\u5171\u6709\u30c9\u30e9\u30a4\u30d6\u3067\u7ba1\u7406\u3059\u308b\u3053\u3068\u3092\u5f37\u304f\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q_%E5%8F%82%E7%85%A7%E5%85%83%E3%81%AE%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%92%E5%89%8A%E9%99%A4%E3%83%BB%E7%A7%BB%E5%8B%95%E3%81%97%E3%81%9F%E3%82%89%E3%81%A9%E3%81%86%E3%81%AA%E3%82%8A%E3%81%BE%E3%81%99%E3%81%8B%EF%BC%9F\"><\/span>Q. \u53c2\u7167\u5143\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\u30fb\u79fb\u52d5\u3057\u305f\u3089\u3069\u3046\u306a\u308a\u307e\u3059\u304b\uff1f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>A. \u30c7\u30fc\u30bf\u304c\u53d6\u5f97\u3067\u304d\u306a\u304f\u306a\u308a\u3001<code>#REF!<\/code>\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u3002\u30d5\u30a1\u30a4\u30eb\u306eURL\uff08\u30ad\u30fc\uff09\u304c\u5909\u308f\u308b\u3068\u63a5\u7d9a\u304c\u5207\u308c\u308b\u305f\u3081\u3067\u3059\u3002\u96c6\u8a08\u306e\u5143\u306b\u306a\u308b\u30d5\u30a1\u30a4\u30eb\u306f\u3001\u3080\u3084\u307f\u306b\u79fb\u52d5\u30fb\u524a\u9664\u305b\u305a\u3001\u5171\u6709\u30c9\u30e9\u30a4\u30d6\u306e\u6c7a\u307e\u3063\u305f\u5834\u6240\u3067\u56fa\u5b9a\u7684\u306b\u7ba1\u7406\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>&nbsp;<\/p>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%E3%81%BE%E3%81%A8%E3%82%81%EF%BC%9A%E3%81%BE%E3%81%9A%E3%81%AF1%E3%81%A4%E3%81%AE%E3%82%B7%E3%83%BC%E3%83%88%E3%82%92%E2%80%9D%E9%9B%86%E3%82%81%E3%82%8B%E2%80%9D%E3%81%93%E3%81%A8%E3%81%8B%E3%82%89\"><\/span><span class=\"ez-toc-section\" id=\"s9\"><\/span>\u307e\u3068\u3081\uff1a\u307e\u305a\u306f1\u3064\u306e\u30b7\u30fc\u30c8\u3092&#8221;\u96c6\u3081\u308b&#8221;\u3053\u3068\u304b\u3089<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>IMPORTRANGE\u95a2\u6570\u3092\u4f7f\u3048\u3070\u3001<strong>\u30d0\u30e9\u30d0\u30e9\u3060\u3063\u305f\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30c7\u30fc\u30bf\u3092\u3001\u7121\u6599\u3067\u30fb\u81ea\u52d5\u3067\u30fb1\u304b\u6240\u306b\u96c6\u7d04<\/strong>\u3067\u304d\u307e\u3059\u3002QUERY\u3068\u7d44\u307f\u5408\u308f\u305b\u308c\u3070\u3001\u96c6\u8a08\u307e\u3067\u6570\u5f0f1\u672c\u3067\u5b8c\u7d50\u3057\u3001\u6708\u672b\u306e\u624b\u96c6\u8a08\u3084\u8ee2\u8a18\u30df\u30b9\u304b\u3089\u89e3\u653e\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u307e\u305a\u306f\u300c\u672c\u90e8\u304c\u6bce\u6708\u624b\u3067\u96c6\u3081\u3066\u3044\u308b\u6570\u5b57\u300d\u30921\u3064\u9078\u3073\u3001IMPORTRANGE\u3067\u81ea\u52d5\u5316\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002&nbsp;\u305d\u306e\u4e00\u65b9\u3067\u3001\u793e\u5185\u306b\u5171\u6709\u3059\u308b\u3068\u304d\u306f<strong>\u300c\u53c2\u7167\u5148\u3092\u898b\u3089\u308c\u308b\u4eba\u306f\u5143\u30c7\u30fc\u30bf\u3082\u898b\u3089\u308c\u308b\u300d<\/strong>\u3068\u3044\u3046\u70b9\u3060\u3051\u306f\u5fd8\u308c\u305a\u306b\u3001\u5171\u6709\u7bc4\u56f2\u3092\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002\u30c7\u30fc\u30bf\u304c\u5897\u3048\u3066\u91cd\u304f\u306a\u3063\u3066\u304d\u305f\u3089\u3001\u30ce\u30fc\u30b3\u30fc\u30c9\u3084\u5c02\u7528\u30c4\u30fc\u30eb\u3078\u306e\u79fb\u884c\u3092\u691c\u8a0e\u3059\u308b\u30bf\u30a4\u30df\u30f3\u30b0\u3067\u3059\u3002\u8a73\u3057\u3044\u4ed5\u69d8\u306fGoogle\u516c\u5f0f\u30d8\u30eb\u30d7\u3082\u3042\u308f\u305b\u3066\u3054\u78ba\u8a8d\u304f\u3060\u3055\u3044\u3002<\/p>\n<p align=\"center\">\n<a href=\"https:\/\/support.google.com\/docs\/answer\/3093340?hl=ja\" target=\"_blank\" rel=\"noopener\" class=\"q_button bt_red\">IMPORTRANGE \u516c\u5f0f\u30d8\u30eb\u30d7 &#x27a1;<\/a>\n<\/p>\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u306e\u30c7\u30fc\u30bf\u96c6\u7d04\u30fb\u96c6\u8a08\u306e\u81ea\u52d5\u5316\u304b\u3089\u3001\u88dc\u52a9\u91d1\u3092\u6d3b\u7528\u3057\u305f\u30ce\u30fc\u30b3\u30fc\u30c9\u30fb\u30c7\u30fc\u30bf\u57fa\u76e4\u306e\u5c0e\u5165\u307e\u3067\u3001\u696d\u52d9\u306e\u30c7\u30b8\u30bf\u30eb\u5316\u306b\u3064\u3044\u3066\u3054\u76f8\u8ac7\u3057\u305f\u3044\u65b9\u306f\u3001\u304a\u6c17\u8efd\u306b\u304a\u554f\u3044\u5408\u308f\u305b\u304f\u3060\u3055\u3044\u3002<\/p>\n<p align=\"center\"><a href=\"https:\/\/ardent.jp\/ict-soudanshitu-form\/\" class=\"q_button bt_red\">\u304a\u554f\u5408\u305b\u306f\u3053\u3061\u3089&#x27a1;<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u5225\u30b7\u30fc\u30c8\u30fb\u5225\u30d5\u30a1\u30a4\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u81ea\u52d5\u3067\u96c6\u7d04\u3059\u308b\u65b9\u6cd5\u3092\u89e3\u8aac\u3002IMPORTRANGE\u95a2\u6570\u306e\u57fa\u672c\u304b\u3089QUERY\u3068\u7d44\u307f\u5408\u308f\u305b\u305f\u5e97\u8217\u5225\u96c6\u8a08\u3001\u3088\u304f\u3042\u308b\u30a8\u30e9\u30fc\u5bfe\u51e6\u3001\u60c5\u30b7\u30b9\u304c\u6ce8\u610f\u3059\u3079\u304d\u5171\u6709\u6a29\u9650\u306e\u843d\u3068\u3057\u7a74\u307e\u3067\u3001\u4e2d\u5c0f\u4f01\u696d\u5411\u3051\u306b\u5b9f\u52d9\u76ee\u7dda\u3067\u307e\u3068\u3081\u307e\u3057\u305f\u3002","protected":false},"author":11,"featured_media":25737,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70],"tags":[51],"class_list":["post-25740","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-microsoft","tag-google-work-space"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-content\/uploads\/2026\/07\/importrange_1.png","_links":{"self":[{"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/posts\/25740","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/comments?post=25740"}],"version-history":[{"count":1,"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/posts\/25740\/revisions"}],"predecessor-version":[{"id":25741,"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/posts\/25740\/revisions\/25741"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/media\/25737"}],"wp:attachment":[{"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/media?parent=25740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/categories?post=25740"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/tags?post=25740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}