{"id":8946,"date":"2026-11-10T03:00:00","date_gmt":"2026-11-09T18:00:00","guid":{"rendered":"https:\/\/chankorogashi.com\/?p=8946"},"modified":"2026-11-06T23:46:16","modified_gmt":"2026-11-06T14:46:16","slug":"ck-manual-20261106-03","status":"publish","type":"post","link":"https:\/\/chankorogashi.com\/?p=8946","title":{"rendered":"Excel\u3067CSV\u306e\u5148\u982d\u306e\u30bc\u30ed\u304c\u6d88\u3048\u308b\u3068\u304d\u306e\u5bfe\u51e6\u6cd5\uff5c\u4f1a\u54e1\u756a\u53f7\u3092\u6587\u5b57\u5217\u3067\u53d6\u308a\u8fbc\u3080"},"content":{"rendered":"<p>CSV\u306e\u4f1a\u54e1\u756a\u53f7\u304cExcel\u3067 <code>000731<\/code> \u304b\u3089 <code>731<\/code> \u306b\u306a\u3063\u305f\u3089\u3001\u307e\u305a\u5143\u306eCSV\u306b\u30bc\u30ed\u304c\u6b8b\u3063\u3066\u3044\u308b\u304b\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<strong>\u5143\u306eCSV\u306b\u6b8b\u3063\u3066\u3044\u308c\u3070\u3001\u4f1a\u54e1\u756a\u53f7\u306e\u5217\u3092\u6587\u5b57\u5217\u3068\u3057\u3066\u53d6\u308a\u8fbc\u307f\u76f4\u3059<\/strong>\u3068\u3001\u6841\u3092\u4fdd\u3066\u307e\u3059\u3002<\/p>\n<p>Windows\u7248\u306e\u30c7\u30b9\u30af\u30c8\u30c3\u30d7Excel\u3067\u3001\uff3b\u30c6\u30ad\u30b9\u30c8\/CSV\u304b\u3089\uff3d\u304c\u4f7f\u3048\u308b\u74b0\u5883\u3092\u5bfe\u8c61\u306b\u3057\u307e\u3059\u3002\u30e1\u30cb\u30e5\u30fc\u540d\u306f\u30d0\u30fc\u30b8\u30e7\u30f3\u3084\u66f4\u65b0\u72b6\u6cc1\u306b\u3088\u3063\u3066\u7570\u306a\u308a\u307e\u3059\u3002<a href=\"https:\/\/support.microsoft.com\/ja-jp\/excel\/keeping-leading-zeros-and-large-numbers\">Microsoft \u30b5\u30dd\u30fc\u30c8\uff5c\u5148\u982d\u306e\u30bc\u30ed\u304a\u3088\u3073\u5927\u304d\u3044\u6570\u5024\u306e\u4fdd\u6301<\/a><\/p>\n<h2 id=\"\u5143\u306ecsv\u306b\u30bc\u30ed\u304c\u6b8b\u3063\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3059\u308b\">\u5143\u306eCSV\u306b\u30bc\u30ed\u304c\u6b8b\u3063\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3059\u308b<\/h2>\n<p>\u5143\u306eCSV\u306f\u305d\u306e\u307e\u307e\u6b8b\u3057\u3001\u30e1\u30e2\u5e33\u306a\u3069\u306e\u30c6\u30ad\u30b9\u30c8\u30a8\u30c7\u30a3\u30bf\u30fc\u3067\u958b\u304d\u307e\u3059\u3002\u4f8b\u306f\u6b21\u306e\u3088\u3046\u306a\u3001\u4f1a\u54e1\u756a\u53f7\u3068\u8cfc\u5165\u70b9\u6570\u3092\u4e26\u3079\u305f\u67b6\u7a7a\u306eCSV\u3067\u3059\u3002<\/p>\n<pre class=\"csv\"><code>member_id,quantity\n000731,12\n000058,4<\/code><\/pre>\n<p>\u30c6\u30ad\u30b9\u30c8\u30a8\u30c7\u30a3\u30bf\u30fc\u3067 <code>000731<\/code> \u3068\u8aad\u3081\u308b\u306a\u3089\u3001\u5143\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u30bc\u30ed\u304c\u6b8b\u3063\u3066\u3044\u307e\u3059\u3002Excel\u5074\u3067\u6570\u5b57\u3060\u3051\u306e\u5217\u304c\u6570\u5024\u3068\u5224\u5b9a\u3055\u308c\u3001\u5024\u304c <code>731<\/code> \u306b\u306a\u3063\u3066\u3044\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\u4f1a\u54e1\u756a\u53f7\u306f\u6587\u5b57\u5217\u3001\u8cfc\u5165\u70b9\u6570\u306f\u5408\u8a08\u306b\u4f7f\u3046\u6570\u5024\u3068\u3057\u3066\u5206\u3051\u3066\u53d6\u308a\u8fbc\u307f\u307e\u3059\u3002<\/p>\n<h2 id=\"\u4f1a\u54e1\u756a\u53f7\u306e\u5217\u3092\u6587\u5b57\u5217\u3068\u3057\u3066\u53d6\u308a\u8fbc\u3080\">\u4f1a\u54e1\u756a\u53f7\u306e\u5217\u3092\u6587\u5b57\u5217\u3068\u3057\u3066\u53d6\u308a\u8fbc\u3080<\/h2>\n<ol type=\"1\">\n<li>Excel\u3067\u65b0\u3057\u3044\u30d6\u30c3\u30af\u3092\u958b\u304d\u307e\u3059\u3002\uff3b\u30c7\u30fc\u30bf\uff3d\u306e\uff3b\u30c6\u30ad\u30b9\u30c8\/CSV\u304b\u3089\uff3d\u3092\u9078\u3073\u3001\u5143\u306eCSV\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u30ea\u30dc\u30f3\u306b\u3088\u3063\u3066\u306f\uff3b\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\uff3d\u2192\uff3b\u30d5\u30a1\u30a4\u30eb\u304b\u3089\uff3d\u306e\u4e0b\u306b\u3042\u308a\u307e\u3059\u3002<\/li>\n<li>\u30d7\u30ec\u30d3\u30e5\u30fc\u3067\u5217\u306e\u533a\u5207\u308a\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\u30c7\u30fc\u30bf\u578b\u3092\u691c\u51fa\u3057\u306a\u3044\u9078\u629e\u80a2\u304c\u3042\u308c\u3070\u9078\u3073\u3001\uff3b\u30c7\u30fc\u30bf\u306e\u5909\u63db\uff3d\uff08\u8868\u793a\u306b\u3088\u3063\u3066\u306f\uff3b\u7de8\u96c6\uff3d\uff09\u3067Power Query\u30a8\u30c7\u30a3\u30bf\u30fc\u3092\u958b\u304d\u307e\u3059\u3002<a href=\"https:\/\/learn.microsoft.com\/ja-jp\/power-query\/connectors\/text-csv\">Microsoft Learn\uff5c\u30c6\u30ad\u30b9\u30c8\/CSV \u30b3\u30cd\u30af\u30bf<\/a><\/li>\n<li>\u4f1a\u54e1\u756a\u53f7\u306e\u5217\u898b\u51fa\u3057\u6a2a\u306b\u3042\u308b\u578b\u306e\u30a2\u30a4\u30b3\u30f3\u304b\u3089\uff3b\u30c6\u30ad\u30b9\u30c8\uff3d\u3092\u9078\u3073\u307e\u3059\u3002\u8cfc\u5165\u70b9\u6570\u306f\uff3b\u6574\u6570\uff3d\u306b\u3057\u307e\u3059\u3002\u4f1a\u54e1\u756a\u53f7\u304c\u3059\u3067\u306b <code>731<\/code> \u306a\u3089\u3001\u53f3\u5074\u306e\uff3b\u9069\u7528\u3057\u305f\u30b9\u30c6\u30c3\u30d7\uff3d\u3067\u81ea\u52d5\u8ffd\u52a0\u3055\u308c\u305f\uff3b\u5909\u66f4\u3055\u308c\u305f\u578b\uff3d\u3088\u308a\u524d\u306e\u30d7\u30ec\u30d3\u30e5\u30fc\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\u305d\u3053\u3067\u30bc\u30ed\u304c\u6b8b\u3063\u3066\u3044\u308c\u3070\u3001\u65b0\u898f\u53d6\u308a\u8fbc\u307f\u306e\u81ea\u52d5\u578b\u5909\u63db\u3092\u5916\u3057\u3066\u304b\u3089\u3001\u5217\u3054\u3068\u306e\u578b\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<a href=\"https:\/\/learn.microsoft.com\/ja-jp\/power-query\/data-types\">Microsoft Learn\uff5cPower Query \u306e\u30c7\u30fc\u30bf\u578b<\/a><\/li>\n<li><code>000731<\/code> \u3068 <code>000058<\/code> \u304c\u30d7\u30ec\u30d3\u30e5\u30fc\u306b\u6b8b\u3063\u3066\u3044\u308b\u3053\u3068\u3092\u898b\u3066\u304b\u3089\u3001\uff3b\u9589\u3058\u3066\u8aad\u307f\u8fbc\u3080\uff3d\u3092\u9078\u3073\u307e\u3059\u3002\u8aad\u307f\u8fbc\u307f\u5f8c\u306f\u3001\u70b9\u6570\u306e\u5408\u8a08\u304c <code>16<\/code> \u306b\u306a\u308b\u3053\u3068\u3082\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002\u4f5c\u696d\u7528\u306e\u30d6\u30c3\u30af\u306f\u3001\u5143\u306eCSV\u3068\u306f\u5225\u306b <code>.xlsx<\/code> \u3067\u4fdd\u5b58\u3057\u307e\u3059\u3002<\/li>\n<\/ol>\n<h2 id=\"\u3059\u3067\u306b\u30bc\u30ed\u304c\u6d88\u3048\u305f\u3068\u304d\u306e\u5224\u65ad\">\u3059\u3067\u306b\u30bc\u30ed\u304c\u6d88\u3048\u305f\u3068\u304d\u306e\u5224\u65ad<\/h2>\n<table>\n<thead>\n<tr class=\"header\">\n<th>\u624b\u5143\u306e\u72b6\u614b<\/th>\n<th>\u6b21\u306b\u3059\u308b\u3053\u3068<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr class=\"odd\">\n<td>\u5143\u306eCSV\u306b <code>000731<\/code> \u304c\u3042\u308b<\/td>\n<td>\u5143\u306eCSV\u304b\u3089\u3001\u4f1a\u54e1\u756a\u53f7\u3092\u30c6\u30ad\u30b9\u30c8\u3068\u3057\u3066\u53d6\u308a\u8fbc\u307f\u76f4\u3059<\/td>\n<\/tr>\n<tr class=\"even\">\n<td>\u5143\u306eCSV\u304c <code>731<\/code> \u3060\u304c\u3001\u756a\u53f7\u304c\u3059\u3079\u30666\u6841\u3068\u78ba\u8a8d\u3067\u304d\u308b<\/td>\n<td>\u5225\u306e\u5217\u3067\u30bc\u30ed\u3092\u88dc\u3044\u3001\u5143\u306e\u7ba1\u7406\u53f0\u5e33\u3068\u7167\u5408\u3059\u308b<\/td>\n<\/tr>\n<tr class=\"odd\">\n<td>\u5143\u306eCSV\u304c <code>731<\/code> \u3067\u3001\u5143\u306e\u6841\u6570\u304c\u5206\u304b\u3089\u306a\u3044<\/td>\n<td>\u767a\u884c\u5143\u304b\u3089\u518d\u53d6\u5f97\u3059\u308b\u304b\u3001\u5143\u306e\u7ba1\u7406\u53f0\u5e33\u3067\u7167\u5408\u3059\u308b<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u305f\u3068\u3048\u3070\u3001\u4f1a\u54e1\u756a\u53f7\u304c\u5fc5\u305a6\u6841\u3067\u3001A2\u306e\u6570\u5024\u304c <code>731<\/code> \u3068\u78ba\u8a8d\u3067\u304d\u308b\u306a\u3089\u3001\u5225\u306e\u30bb\u30eb\u306b <code>=TEXT(A2,\"000000\")<\/code> \u3068\u5165\u529b\u3059\u308b\u3068\u3001\u6587\u5b57\u5217\u306e <code>000731<\/code> \u306b\u306a\u308a\u307e\u3059\u3002\u6841\u6570\u304c\u6df7\u5728\u3059\u308b\u5834\u5408\u306f\u3001<code>731<\/code> \u3060\u3051\u304b\u3089\u5143\u306e\u30bc\u30ed\u306e\u500b\u6570\u3092\u5224\u65ad\u3067\u304d\u307e\u305b\u3093\u3002<a href=\"https:\/\/support.microsoft.com\/ja-jp\/excel\/functions\/text-function\">Microsoft \u30b5\u30dd\u30fc\u30c8\uff5cTEXT \u95a2\u6570<\/a><\/p>\n<p>Excel\u4e0a\u306e\u8868\u793a\u3060\u3051\u30926\u6841\u306b\u6574\u3048\u308b\u65b9\u6cd5\u3082\u3042\u308a\u307e\u3059\u3002\u5225\u306e\u30b7\u30b9\u30c6\u30e0\u306b\u6e21\u3059\u756a\u53f7\u306a\u3089\u3001\u8aad\u307f\u8fbc\u307f\u5f8c\u306e\u898b\u305f\u76ee\u306b\u52a0\u3048\u3066\u3001\u51fa\u529b\u3057\u305fCSV\u3092\u30c6\u30ad\u30b9\u30c8\u30a8\u30c7\u30a3\u30bf\u30fc\u3067\u958b\u304d\u3001\u5024\u306b\u30bc\u30ed\u304c\u6b8b\u3063\u3066\u3044\u308b\u3068\u3053\u308d\u307e\u3067\u78ba\u304b\u3081\u3066\u304f\u3060\u3055\u3044\u3002<a href=\"https:\/\/support.microsoft.com\/ja-jp\/excel\/keeping-leading-zeros-and-large-numbers\">Microsoft \u30b5\u30dd\u30fc\u30c8\uff5c\u5148\u982d\u306e\u30bc\u30ed\u304a\u3088\u3073\u5927\u304d\u3044\u6570\u5024\u306e\u4fdd\u6301<\/a><\/p>\n<p>\u8907\u6570\u306eGoogle\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30bf\u30d6\u3092\u307e\u3068\u3081\u3066Excel\u5f62\u5f0f\u3067\u53d7\u3051\u6e21\u3059\u5834\u5408\u306f\u3001\u3053\u3061\u3089\u3067\u64cd\u4f5c\u3092\u7d39\u4ecb\u3057\u3066\u3044\u307e\u3059\u3002<a href=\"https:\/\/chankorogashi.com\/?p=8469\">\u8907\u6570\u30b7\u30fc\u30c8\u3092\u4e00\u62ec\u3067Excel\u5f62\u5f0f\u306b\u3059\u308b\u65b9\u6cd5<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel\u3067CSV\u3092\u958b\u304f\u3068\u300c000731\u300d\u304c\u300c731\u300d\u306b\u306a\u308b\u3068\u304d\u306f\u3001\u5143\u306eCSV\u3092\u78ba\u8a8d\u3057\u3001\u4f1a\u54e1\u756a\u53f7\u306e\u5217\u3092\u6587\u5b57\u5217\u3068\u3057\u3066\u53d6\u308a\u8fbc\u307f\u307e\u3059\u3002\u30bc\u30ed\u304c\u3059\u3067\u306b\u6d88\u3048\u305f\u5834\u5408\u306e\u5224\u65ad\u3068\u30016\u6841\u3068\u5206\u304b\u3063\u3066\u3044\u308b\u756a\u53f7\u306e\u88dc\u3044\u65b9\u3082\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"author":4,"featured_media":8945,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_ck_article_kind":"guide","_ck_summary":"\u5143\u306eCSV\u3092\u30c6\u30ad\u30b9\u30c8\u30a8\u30c7\u30a3\u30bf\u30fc\u3067\u958b\u304d\u3001\u4f1a\u54e1\u756a\u53f7\u306e\u5148\u982d\u306e\u30bc\u30ed\u304c\u6b8b\u3063\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3057\u307e\u3059\u3002\nWindows\u7248Excel\u306e\uff3b\u30c6\u30ad\u30b9\u30c8\/CSV\u304b\u3089\uff3d\u3067\u53d6\u308a\u8fbc\u307f\u3001\u756a\u53f7\u306f\u30c6\u30ad\u30b9\u30c8\u3001\u6570\u91cf\u306f\u6574\u6570\u306b\u3057\u307e\u3059\u3002\n\u5143\u306eCSV\u306b\u3082\u30bc\u30ed\u304c\u306a\u3051\u308c\u3070\u3001\u5143\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u76f4\u3057\u307e\u3059\u3002\u6841\u6570\u304c\u78ba\u5b9a\u3057\u3066\u3044\u308b\u756a\u53f7\u306b\u9650\u308a\u3001\u30bc\u30ed\u57cb\u3081\u3067\u88dc\u3048\u307e\u3059\u3002","_ck_source_urls":"https:\/\/support.microsoft.com\/ja-jp\/excel\/keeping-leading-zeros-and-large-numbers\nhttps:\/\/learn.microsoft.com\/ja-jp\/power-query\/connectors\/text-csv\nhttps:\/\/learn.microsoft.com\/ja-jp\/power-query\/data-types\nhttps:\/\/support.microsoft.com\/ja-jp\/excel\/functions\/text-function","_ck_checked_at":"2026-11-06","_ck_cta_label":"","_ck_cta_url":"","_ck_comparison_id":0,"footnotes":""},"categories":[150],"tags":[],"class_list":["post-8946","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-work-ai"],"_links":{"self":[{"href":"https:\/\/chankorogashi.com\/index.php?rest_route=\/wp\/v2\/posts\/8946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chankorogashi.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chankorogashi.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chankorogashi.com\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/chankorogashi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8946"}],"version-history":[{"count":1,"href":"https:\/\/chankorogashi.com\/index.php?rest_route=\/wp\/v2\/posts\/8946\/revisions"}],"predecessor-version":[{"id":8947,"href":"https:\/\/chankorogashi.com\/index.php?rest_route=\/wp\/v2\/posts\/8946\/revisions\/8947"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chankorogashi.com\/index.php?rest_route=\/wp\/v2\/media\/8945"}],"wp:attachment":[{"href":"https:\/\/chankorogashi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chankorogashi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chankorogashi.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}