{"id":1260,"date":"2016-04-08T21:14:26","date_gmt":"2016-04-08T12:14:26","guid":{"rendered":"https:\/\/alaki.co.jp\/blog\/?p=1260"},"modified":"2026-09-14T17:25:24","modified_gmt":"2026-09-14T08:25:24","slug":"excel%e3%81%a7bom%e4%bb%98%e3%81%8d%e3%81%8c%e7%84%a1%e5%8f%8c%e3%81%99%e3%82%8bphp%e3%81%a7%e3%81%aecsv%e3%81%ae%e6%9b%b8%e3%81%8d%e5%87%ba%e3%81%97%e6%96%b9","status":"publish","type":"post","link":"https:\/\/alaki.co.jp\/blog\/?p=1260","title":{"rendered":"Excel\u3067BOM\u4ed8\u304d\u304c\u7121\u53cc\u3059\u308bPHP\u3067\u306eCSV\u306e\u66f8\u304d\u51fa\u3057\u65b9"},"content":{"rendered":"<p>\u3053\u3093\u3070\u3093\u306f\u3001Web\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u7be0\u7530\u3067\u3059\u3002<\/p>\n<p>\uff14\u6708\u306b\u5165\u308a\u3001\u6696\u304b\u304f\u306a\u3063\u3066\u304d\u307e\u3057\u305f\u306d\u3002\uff11\u5e74\u306e\u306a\u304b\u3067\u3082\u6d3b\u52d5\u3057\u3084\u3059\u3044\u5b63\u7bc0\u306b\u306a\u308a\u307e\u3057\u305f\u304c\u7761\u9b54\u3068\u306e\u6226\u3044\u304c\u6700\u3082\u6fc0\u3057\u3044\u5b63\u7bc0\u3067\u3082\u3042\u308a\u307e\u3059\u306d\u3002<br \/>\n\u307f\u306a\u3055\u3093\u3082\u7761\u9b54\u306b\u8ca0\u3051\u306a\u3044\u3088\u3046\u304a\u904e\u3054\u3057\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u3055\u3066\u3001\u524d\u56de\uff08\u79c1\u306e\u56de\u306e\uff09\u3054\u7d39\u4ecb\u3057\u305f\u300c<a href=\"https:\/\/alaki.co.jp\/blog\/?p=1236\" title=\"BOM\u306e\u5730\u96f7\u3092\u8e0f\u307f\u629c\u304b\u306a\u3044\u6b63\u3057\u3044\u6587\u5b57\u30b3\u30fc\u30c9\u3068\u306e\u63a5\u3057\u65b9\" target=\"_blank\">BOM\u306e\u5730\u96f7\u3092\u8e0f\u307f\u629c\u304b\u306a\u3044\u6b63\u3057\u3044\u6587\u5b57\u30b3\u30fc\u30c9\u3068\u306e\u63a5\u3057\u65b9<\/a>\u300d\u3067\u3054\u7d39\u4ecb\u3057\u305f\u300cBOM\u4ed8\u304dUTF-8\u300d\u304c\u7121\u53cc\u3059\u308b\u30b3\u30fc\u30c9\u3092\u3001\u3054\u7d39\u4ecb\u3057\u305f\u3044\u3068\u304a\u3082\u3044\u307e\u3059\u3002<\/p>\n<p><!--more--><\/p>\n<h2>\u300cBOM\u4ed8\u304dUTF-8\u300d\u306e\u7121\u53cc\uff08\uff1f\uff09\u306e\u30b3\u30fc\u30c9<\/h2>\n<p>\u3067\u306f\u65e9\u901f\u3001\u4e0b\u8a18\u306e\u30b3\u30fc\u30c9\u3067\u300cBOM\u4ed8\u304dUTF-8\u300d\u306eCSV\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"lang:php decode:true \" title=\"BOM\u4ed8\u304dUTF-8\u3067\u30d5\u30a1\u30a4\u30eb\u3092\u66f8\u304d\u51fa\u3059\u65b9\u6cd5\" >&lt;?php\r\n$view = \"\";\r\n    \r\n$list = array(\r\n    array(\r\n        '\u4e09\u77f3\u7434\u4e43',\r\n        '\u7530\u4e2d\u6566\u5b50',\r\n        '\u698a\u539f\u826f\u5b50',\r\n        '\u6c60\u7530\u660c\u5b50',\r\n    ),\r\n    array(\r\n        '\u9ad9\u6a4b\u5b5d\u6cbb',\r\n        '\u95a2\u4fca\u5f66',\r\n        '\u7530\u306e\u4e2d\u52c7',\r\n    ),\r\n);\r\n\r\nforeach ($list as $value) {\r\n    \/\/\u914d\u5217\u306e\u5185\u5bb9\u3092\u300c,\u300d\u533a\u5207\u308a\u3067\u9023\u7d50\u3059\u308b\r\n    $view .= implode(\",\", $value). \"\\r\\n\";\r\n}\r\n\r\n$view = pack('C*',0xEF,0xBB,0xBF). $view;\r\n\r\n\/\/\u300c$view\u300d\u3092\u300ckoe.csv\u300d\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304d\u51fa\u3057\u3059\u308b\r\nfile_put_contents(\"koe.csv\", $view);<\/pre>\n<p>\u3067\u306f\u3001\u30dd\u30a4\u30f3\u30c8\u3060\u3051\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n<h2>\u30b3\u30fc\u30c9\u89e3\u8aac\uff08\uff11\uff09<\/h2>\n<p>\u30dd\u30a4\u30f3\u30c8\u306f\u3001\u300cUTF-8\u300d\u306e\u300cBOM\u300d\u3067\u3042\u308b\u30b3\u30fc\u30c9\u300c0xEF\u300d\u300c0xBB\u300d\u300c0xBF\u300d\u3092\u30ab\u30f3\u30de\u533a\u5207\u308a\u306b\u3055\u308c\u305f\u6587\u5b57\u5217\u306e\u5148\u982d\u306b\u9023\u7d50\u3057\u307e\u3059\u3002<\/p>\n<p>\u300c0xEF\u300d\u300c0xBB\u300d\u300c0xBF\u300d\u306f\u7279\u6b8a\u306a\u30d0\u30a4\u30ca\u30ea\u6587\u5b57\u5217\u3068\u3057\u3066\u6271\u308f\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u305f\u3081\u901a\u5e38\u306e\u6587\u5b57\u9023\u7d50\u3067\u306f\u300cBOM\u300d\u3068\u3057\u3066\u8a8d\u8b58\u3057\u3066\u304f\u308c\u307e\u305b\u3093\u3002<\/p>\n<p>\u305d\u306e\u305f\u3081\u3001PHP\u95a2\u6570\u306e\u300cpack\u95a2\u6570\u300d\u3067\u30d0\u30a4\u30ca\u30ea\u6587\u5b57\u5217\u306b\u5909\u63db\u3057\u3066\u9023\u7d50\u3055\u305b\u307e\u3059\u3002<\/p>\n<p>\u300cpack\u95a2\u6570\u300d\u306e\u7b2c\uff11\u5f15\u6570\u306b\u3042\u308b\u300cC*\u300d\u306f\u300c\u7b26\u53f7\u306a\u3057char\u578b\u306e\u7e70\u308a\u8fd4\u3057\u300d\u3068\u3044\u3046\u610f\u5473\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u3053\u308c\u3067\u66f8\u304d\u3060\u3055\u308c\u305fCSV\u30d5\u30a1\u30a4\u30eb\u3092\u300cWindows\u7248 Microsoft Excel\u300d\u3067\u958b\u3044\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u7dba\u9e97\u306b\u8868\u793a\u3055\u308c\u305f\u306e\u3067\u306f\u306a\u3044\u3067\u3059\u304b\uff1f<br \/>\n\u203b\u7279\u6b8a\u6587\u5b57\u306e\u300c\u9ad9\uff08\u30cf\u30b7\u30b4\u305f\u304b\uff09\u300d\u3082\u7dba\u9e97\u306b\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u306d\u3002<\/p>\n<p>\u3081\u3067\u305f\u3057\u3001\u3081\u3067\u305f\u3057\u3002<\/p>\n<h2>\u3055\u3059\u304c\u300cMicrosoft Excel\u300d\u3068\u601d\u3044\u307e\u3057\u305f\uff01<\/h2>\n<p>\u306f\u3044\u3001\u3081\u3067\u305f\u304f\u306a\u304b\u3063\u305f\u65b9\u304c\u3044\u308b\u306e\u3067\u306f\u306a\u3044\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n<p>\u305d\u3046\u3001\u300cMac\u7248Microsoft Excel\u300d\u3067\u958b\u3044\u305f\u65b9\u306f\u6b8b\u5ff5\u306a\u7d50\u679c\u306b\u306a\u3063\u305f\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>\u3053\u308c\u306f\u5b8c\u5168\u306b\u76f2\u70b9\u3060\u3063\u305f\u306e\u3067\u3059\u304c\u3001\u3069\u3046\u3084\u3089Mac\u7248\u3068Windows\u7248\u3067\u306f\u540c\u3058Microsoft Excel\u3067\u3082\u6587\u5b57\u30b3\u30fc\u30c9\u306e\u6349\u3048\u65b9\u304c\u9055\u3046\u3088\u3046\u3067\u3059\u3002<\/p>\n<p>\u3055\u3059\u304c\u300cMicrosoft Excel\u300d\u4e00\u7b4b\u7e04\u3067\u306f\u3044\u304b\u306a\u3044\u3067\u3059\u306d\uff57\uff57<\/p>\n<p>\u89e3\u6c7a\u65b9\u6cd5\u306e\u30b3\u30fc\u30c9\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n<h2>\u300cMac\u7248Microsoft Excel\u300d\u3067\u8868\u793a\u3055\u305b\u308b<\/h2>\n<p>\u7d50\u8ad6\u304b\u3089\u3044\u3046\u3068\u300cBOM\u4ed8\u304dUTF-8\u300d\u3067\u306f\u7121\u7406\u3067\u3059\uff01\uff01\uff01<\/p>\n<p>\u300cMac\u7248Microsoft Excel\u300d\u3067\u8868\u793a\u3055\u305b\u308b\u305f\u3081\u306b\u306f\u300cBOM\u4ed8\u304dUTF-16LE\u300d\u3068\u3044\u3046\u6587\u5b57\u30b3\u30fc\u30c9\u3067\u304b\u3064\u300cTSV\u5f62\u5f0f\u300d\u3067\u306a\u3044\u3068Mac\u3001Windows\u4e21\u65b9\u3067\u8868\u793a\u53ef\u80fd\u306a\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n<p>\u3068\u3044\u3046\u308f\u3051\u3067\u4e0b\u8a18\u306e\u30b3\u30fc\u30c9\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n<pre class=\"lang:php decode:true \" title=\"Mac\u7248Microsoft Excel\u3067\u8868\u793a\u3055\u305b\u308b\u305f\u3081\u306e\u30b3\u30fc\u30c9\" >&lt;?php\r\n$view = \"\";\r\n    \r\n$list = array(\r\n    array(\r\n        '\u4e09\u77f3\u7434\u4e43',\r\n        '\u7530\u4e2d\u6566\u5b50',\r\n        '\u698a\u539f\u826f\u5b50',\r\n        '\u6c60\u7530\u660c\u5b50',\r\n    ),\r\n    array(\r\n        '\u9ad9\u6a4b\u5b5d\u6cbb',\r\n        '\u95a2\u4fca\u5f66',\r\n        '\u7530\u306e\u4e2d\u52c7',\r\n    ),\r\n);\r\n\r\nforeach ($list as $value) {\r\n    \/\/\u914d\u5217\u306e\u5185\u5bb9\u3092\u300c,\u300d\u533a\u5207\u308a\u3067\u9023\u7d50\u3059\u308b\r\n    $view .= implode(\"\\t\", $value). \"\\r\\n\";\r\n}\r\n\r\n$view = pack('C*',0xFE,0xFF). mb_convert_encoding($view, 'UTF-16LE', 'UTF-8');\r\n\r\n\/\/\u300c$view\u300d\u3092\u300ckoe.csv\u300d\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304d\u51fa\u3057\u3059\u308b\r\nfile_put_contents(\"koe.csv\", $view);<\/pre>\n<h2>\u30b3\u30fc\u30c9\u89e3\u8aac\uff08\uff12\uff09<\/h2>\n<p>\u30dd\u30a4\u30f3\u30c8\u306f\uff12\u7b87\u6240\u3067\u3059\u3002<\/p>\n<p>\u4f5c\u6210\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u304cUTF-8\u3067\u3042\u308b\u3053\u3068\u304c\u524d\u63d0\u3067\u3059\u304c\u3001PHP\u95a2\u6570\u300c<br \/>\nmb_convert_encoding\u300d\u3092\u4f7f\u3063\u3066\u300cUTF-16LE\u300d\u3068\u3044\u3046\u6587\u5b57\u30b3\u30fc\u30c9\u306b\u5909\u63db\u3057\u307e\u3059\u3002<\/p>\n<p>\u3082\u3046\u3053\u306e\u6bb5\u968e\u3067\u8ca0\u3051\u3066\u3044\u307e\u3059\u304c\u3002\u3002\u3002\u6c17\u306b\u305b\u305a\u6b21\u306b\u884c\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n<p>\u3042\u3068\u306f\u300cBOM\u300d\u3092\u4ed8\u3051\u3066\u3042\u3052\u308b\u3060\u3051\u306a\u306e\u3067\u3059\u304cUTF-8\u3068\u540c\u3058BOM\u3067\u306f\u52b9\u679c\u304c\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<p>\u6587\u5b57\u30b3\u30fc\u30c9\u3054\u3068\u306b\u300cBOM\u300d\u304c\u5909\u308f\u308a\u307e\u3059\u3002<\/p>\n<p>\u4eca\u56de\u306f\u300cUTF-16\u300d\u306e\u300cLE\uff08\u30ea\u30c8\u30eb\u30a8\u30f3\u30c7\u30a3\u30a2\u30f3\uff09\u300d\u306a\u306e\u3067BOM\u306f\u300c0xFF\u300d\u300c0xFE\u300d\u306b\u306a\u308a\u307e\u3059\u3002<br \/>\n\u203b\u300cLE\uff08\u30ea\u30c8\u30eb\u30a8\u30f3\u30c7\u30a3\u30a2\u30f3\uff09\u300d\u3064\u3044\u3066\u306f\u9577\u304f\u306a\u308b\u306e\u3067\u5272\u611b<\/p>\n<p>\u3061\u306a\u307f\u306b\u300cUTF-16\u306eLE\u300d\u3068\u300cUTF-16LE\u300d\u3068\u3044\u3046\u306e\u304c\u3042\u308b\u306e\u3067\u3059\u304c\u3053\u308c\u306f\u5206\u985e\u4e0a\u5225\u7269\u306b\u306a\u308a\u3001\u300cUTF-16LE\u300d\u306e\u65b9\u306f\u300cBOM\u300d\u304c\u4ed8\u3051\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n<p>\u305f\u3060\u3001\u3084\u3084\u3053\u3057\u3044\u306e\u304cPHP\u95a2\u6570\u300cmb_convert_encoding\u300d\u3067\u300cUTF-16\u306eLE\u300d\u3068\u3044\u3046\u306e\u304c\u300cUTF-16LE\u300d\u306b\u8a72\u5f53\u3057\u307e\u3059\u3002<br \/>\n\u203bPHP\u95a2\u6570\u300cmb_convert_encoding\u300d\u304c\u53d6\u308a\u6271\u3048\u308b\u6587\u5b57\u30b3\u30fc\u30c9\u306f<a href=\"http:\/\/php.net\/manual\/ja\/mbstring.supported-encodings.php\" target=\"_blank\">\u3053\u3061\u3089<\/a><\/p>\n<p>\u306a\u306e\u3067\u3001PHP\u95a2\u6570\u300cmb_convert_encoding\u300d\u3067\u5909\u63db\u3057\u305f\u300cUTF-16LE\u300d\u306e\u6587\u5b57\u5217\u306b\u300c<a href=\"https:\/\/ja.wikipedia.org\/wiki\/%E3%83%90%E3%82%A4%E3%83%88%E3%82%AA%E3%83%BC%E3%83%80%E3%83%BC%E3%83%9E%E3%83%BC%E3%82%AF\" target=\"_blank\">BOM<\/a>\u300d\u3092\u3064\u3051\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u3042\u3068\u306f\u3001CSV\u3067\u3042\u308b\u300c,\u300d\u3092\u30bf\u30d6\u3092\u8868\u3059\u300c\\t\u300d\u306b\u3057\u3066\u914d\u5217\u3092\u9023\u7d50\u3055\u305b\u307e\u3059\u3002<\/p>\n<p>\u51fa\u529b\u30d5\u30a1\u30a4\u30eb\u306e\u62e1\u5f35\u5b50\u306f\u300c.csv\u300d\u306e\u307e\u307e\u3067OK\u3067\u3059<br \/>\n\u203b\u53b3\u5bc6\u306b\u306f\u300c.tsv\u300d\u3067\u3059\u304c\u3001\u305d\u308c\u3067\u306fExcel\u304c\u53cd\u5fdc\u3057\u3066\u304f\u308c\u306a\u3044\u306e\u3067\u300c.csv\u300d\u3067\u507d\u88c5\u3057\u307e\u3059\u3002<\/p>\n<p>\u3055\u3041\u3001\u3053\u308c\u3067Mac\u3067\u3082\u7dba\u9e97\u306b\u8868\u793a\u3055\u308c\u308b\u306f\u305a\u3067\u3059\uff01\uff01<\/p>\n<h2>\u307e\u3068\u3081<\/h2>\n<p>\u3042\u307e\u308a\u5927\u304d\u306a\u58f0\u3067\u306f\u8a00\u3048\u307e\u305b\u3093\u304c\u3001\u3001\u3001\u300c\u4ed5\u69d8\u3092\u307e\u3068\u3081\u308b\u3053\u3068\u306f\u3067\u304d\u306a\u304b\u3063\u305f\u306e\u304b\uff01\uff1f\u300d\u3068\u58f0\u3092\u5927\u306b\u3057\u3066\u8a00\u3044\u305f\u3044\u3068\u3044\u3046\u304d\u3082\u3061\u3067\u3059\u304c\u3001\u80f8\u306b\u9589\u307e\u3063\u3066\u304a\u304d\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>\u691c\u8a3c\u306f\u3001Mac\u30fbWindows\u4e21\u65b9\u3067\u898b\u307e\u3057\u3087\u3046\uff01<br \/>\n\u203b\u3061\u306a\u307f\u306bOpenOffice\u3068\u304b\u3067\u52d5\u304b\u306a\u3044\u3068\u304b\u3067\u52d5\u304b\u306a\u3044\uff01\u3068\u3044\u3046\u30af\u30ec\u30fc\u30e0\u306f\u304a\u65ad\u308a\u3067\u3059\uff57<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u3093\u3070\u3093\u306f\u3001Web\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u7be0\u7530\u3067\u3059\u3002 \uff14\u6708\u306b\u5165\u308a\u3001\u6696\u304b\u304f\u306a\u3063\u3066\u304d&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":1151,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-1260","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-other"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u3053\u3093\u3070\u3093\u306f\u3001Web\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u7be0\u7530\u3067\u3059\u3002 \uff14\u6708\u306b\u5165\u308a\u3001\u6696\u304b\u304f\u306a\u3063\u3066\u304d\u307e\u3057\u305f\u306d\u3002\uff11\u5e74\u306e\u306a\u304b\u3067\u3082\u6d3b\u52d5\u3057\u3084\u3059\u3044\u5b63\u7bc0\u306b\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"sumi\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/alaki.co.jp\/blog\/?p=1260\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ja_JP\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ALAKI\u682a\u5f0f\u4f1a\u793e - \u3044\u3064\u307e\u3067\u3082\u4f7f\u3048\u308bTech\u60c5\u5831\u767a\u4fe1\u30d6\u30ed\u30b0\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Excel\u3067BOM\u4ed8\u304d\u304c\u7121\u53cc\u3059\u308bPHP\u3067\u306eCSV\u306e\u66f8\u304d\u51fa\u3057\u65b9 - ALAKI\u682a\u5f0f\u4f1a\u793e\" \/>\n\t\t<meta property=\"og:description\" content=\"\u3053\u3093\u3070\u3093\u306f\u3001Web\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u7be0\u7530\u3067\u3059\u3002 \uff14\u6708\u306b\u5165\u308a\u3001\u6696\u304b\u304f\u306a\u3063\u3066\u304d\u307e\u3057\u305f\u306d\u3002\uff11\u5e74\u306e\u306a\u304b\u3067\u3082\u6d3b\u52d5\u3057\u3084\u3059\u3044\u5b63\u7bc0\u306b\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/alaki.co.jp\/blog\/?p=1260\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2016-04-08T12:14:26+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-09-14T08:25:24+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Excel\u3067BOM\u4ed8\u304d\u304c\u7121\u53cc\u3059\u308bPHP\u3067\u306eCSV\u306e\u66f8\u304d\u51fa\u3057\u65b9 - ALAKI\u682a\u5f0f\u4f1a\u793e\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\u3053\u3093\u3070\u3093\u306f\u3001Web\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u7be0\u7530\u3067\u3059\u3002 \uff14\u6708\u306b\u5165\u308a\u3001\u6696\u304b\u304f\u306a\u3063\u3066\u304d\u307e\u3057\u305f\u306d\u3002\uff11\u5e74\u306e\u306a\u304b\u3067\u3082\u6d3b\u52d5\u3057\u3084\u3059\u3044\u5b63\u7bc0\u306b\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?p=1260#blogposting\",\"name\":\"Excel\\u3067BOM\\u4ed8\\u304d\\u304c\\u7121\\u53cc\\u3059\\u308bPHP\\u3067\\u306eCSV\\u306e\\u66f8\\u304d\\u51fa\\u3057\\u65b9 - ALAKI\\u682a\\u5f0f\\u4f1a\\u793e\",\"headline\":\"Excel\\u3067BOM\\u4ed8\\u304d\\u304c\\u7121\\u53cc\\u3059\\u308bPHP\\u3067\\u306eCSV\\u306e\\u66f8\\u304d\\u51fa\\u3057\\u65b9\",\"author\":{\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/01\\\/14800708_xl.jpg\",\"width\":3192,\"height\":3000},\"datePublished\":\"2016-04-08T21:14:26+09:00\",\"dateModified\":\"2026-09-14T17:25:24+09:00\",\"inLanguage\":\"ja\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?p=1260#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?p=1260#webpage\"},\"articleSection\":\"\\u305d\\u306e\\u4ed6\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?p=1260#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?cat=26#listItem\",\"name\":\"\\u305d\\u306e\\u4ed6\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?cat=26#listItem\",\"position\":2,\"name\":\"\\u305d\\u306e\\u4ed6\",\"item\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?cat=26\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?p=1260#listItem\",\"name\":\"Excel\\u3067BOM\\u4ed8\\u304d\\u304c\\u7121\\u53cc\\u3059\\u308bPHP\\u3067\\u306eCSV\\u306e\\u66f8\\u304d\\u51fa\\u3057\\u65b9\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?p=1260#listItem\",\"position\":3,\"name\":\"Excel\\u3067BOM\\u4ed8\\u304d\\u304c\\u7121\\u53cc\\u3059\\u308bPHP\\u3067\\u306eCSV\\u306e\\u66f8\\u304d\\u51fa\\u3057\\u65b9\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?cat=26#listItem\",\"name\":\"\\u305d\\u306e\\u4ed6\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/#organization\",\"name\":\"ALAKI\\u682a\\u5f0f\\u4f1a\\u793e\",\"description\":\"\\u3044\\u3064\\u307e\\u3067\\u3082\\u4f7f\\u3048\\u308bTech\\u60c5\\u5831\\u767a\\u4fe1\\u30d6\\u30ed\\u30b0\",\"url\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?author=1#author\",\"url\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?author=1\",\"name\":\"sumi\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?p=1260#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bd701e6e4a96c261286dd0ed67e756ebf6312aa5be02bac4313a2198f7b12611?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"sumi\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?p=1260#webpage\",\"url\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?p=1260\",\"name\":\"Excel\\u3067BOM\\u4ed8\\u304d\\u304c\\u7121\\u53cc\\u3059\\u308bPHP\\u3067\\u306eCSV\\u306e\\u66f8\\u304d\\u51fa\\u3057\\u65b9 - ALAKI\\u682a\\u5f0f\\u4f1a\\u793e\",\"description\":\"\\u3053\\u3093\\u3070\\u3093\\u306f\\u3001Web\\u30d7\\u30ed\\u30b0\\u30e9\\u30de\\u306e\\u7be0\\u7530\\u3067\\u3059\\u3002 \\uff14\\u6708\\u306b\\u5165\\u308a\\u3001\\u6696\\u304b\\u304f\\u306a\\u3063\\u3066\\u304d\\u307e\\u3057\\u305f\\u306d\\u3002\\uff11\\u5e74\\u306e\\u306a\\u304b\\u3067\\u3082\\u6d3b\\u52d5\\u3057\\u3084\\u3059\\u3044\\u5b63\\u7bc0\\u306b\",\"inLanguage\":\"ja\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?p=1260#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?author=1#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/01\\\/14800708_xl.jpg\",\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?p=1260\\\/#mainImage\",\"width\":3192,\"height\":3000},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/?p=1260#mainImage\"},\"datePublished\":\"2016-04-08T21:14:26+09:00\",\"dateModified\":\"2026-09-14T17:25:24+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/\",\"name\":\"ALAKI\\u682a\\u5f0f\\u4f1a\\u793e\",\"description\":\"\\u3044\\u3064\\u307e\\u3067\\u3082\\u4f7f\\u3048\\u308bTech\\u60c5\\u5831\\u767a\\u4fe1\\u30d6\\u30ed\\u30b0\",\"inLanguage\":\"ja\",\"publisher\":{\"@id\":\"https:\\\/\\\/alaki.co.jp\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Excel\u3067BOM\u4ed8\u304d\u304c\u7121\u53cc\u3059\u308bPHP\u3067\u306eCSV\u306e\u66f8\u304d\u51fa\u3057\u65b9 - ALAKI\u682a\u5f0f\u4f1a\u793e","description":"\u3053\u3093\u3070\u3093\u306f\u3001Web\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u7be0\u7530\u3067\u3059\u3002 \uff14\u6708\u306b\u5165\u308a\u3001\u6696\u304b\u304f\u306a\u3063\u3066\u304d\u307e\u3057\u305f\u306d\u3002\uff11\u5e74\u306e\u306a\u304b\u3067\u3082\u6d3b\u52d5\u3057\u3084\u3059\u3044\u5b63\u7bc0\u306b","canonical_url":"https:\/\/alaki.co.jp\/blog\/?p=1260","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/alaki.co.jp\/blog\/?p=1260#blogposting","name":"Excel\u3067BOM\u4ed8\u304d\u304c\u7121\u53cc\u3059\u308bPHP\u3067\u306eCSV\u306e\u66f8\u304d\u51fa\u3057\u65b9 - ALAKI\u682a\u5f0f\u4f1a\u793e","headline":"Excel\u3067BOM\u4ed8\u304d\u304c\u7121\u53cc\u3059\u308bPHP\u3067\u306eCSV\u306e\u66f8\u304d\u51fa\u3057\u65b9","author":{"@id":"https:\/\/alaki.co.jp\/blog\/?author=1#author"},"publisher":{"@id":"https:\/\/alaki.co.jp\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/alaki.co.jp\/blog\/wp-content\/uploads\/2016\/01\/14800708_xl.jpg","width":3192,"height":3000},"datePublished":"2016-04-08T21:14:26+09:00","dateModified":"2026-09-14T17:25:24+09:00","inLanguage":"ja","mainEntityOfPage":{"@id":"https:\/\/alaki.co.jp\/blog\/?p=1260#webpage"},"isPartOf":{"@id":"https:\/\/alaki.co.jp\/blog\/?p=1260#webpage"},"articleSection":"\u305d\u306e\u4ed6"},{"@type":"BreadcrumbList","@id":"https:\/\/alaki.co.jp\/blog\/?p=1260#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/alaki.co.jp\/blog\/#listItem","position":1,"name":"Home","item":"https:\/\/alaki.co.jp\/blog\/","nextItem":{"@type":"ListItem","@id":"https:\/\/alaki.co.jp\/blog\/?cat=26#listItem","name":"\u305d\u306e\u4ed6"}},{"@type":"ListItem","@id":"https:\/\/alaki.co.jp\/blog\/?cat=26#listItem","position":2,"name":"\u305d\u306e\u4ed6","item":"https:\/\/alaki.co.jp\/blog\/?cat=26","nextItem":{"@type":"ListItem","@id":"https:\/\/alaki.co.jp\/blog\/?p=1260#listItem","name":"Excel\u3067BOM\u4ed8\u304d\u304c\u7121\u53cc\u3059\u308bPHP\u3067\u306eCSV\u306e\u66f8\u304d\u51fa\u3057\u65b9"},"previousItem":{"@type":"ListItem","@id":"https:\/\/alaki.co.jp\/blog\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/alaki.co.jp\/blog\/?p=1260#listItem","position":3,"name":"Excel\u3067BOM\u4ed8\u304d\u304c\u7121\u53cc\u3059\u308bPHP\u3067\u306eCSV\u306e\u66f8\u304d\u51fa\u3057\u65b9","previousItem":{"@type":"ListItem","@id":"https:\/\/alaki.co.jp\/blog\/?cat=26#listItem","name":"\u305d\u306e\u4ed6"}}]},{"@type":"Organization","@id":"https:\/\/alaki.co.jp\/blog\/#organization","name":"ALAKI\u682a\u5f0f\u4f1a\u793e","description":"\u3044\u3064\u307e\u3067\u3082\u4f7f\u3048\u308bTech\u60c5\u5831\u767a\u4fe1\u30d6\u30ed\u30b0","url":"https:\/\/alaki.co.jp\/blog\/"},{"@type":"Person","@id":"https:\/\/alaki.co.jp\/blog\/?author=1#author","url":"https:\/\/alaki.co.jp\/blog\/?author=1","name":"sumi","image":{"@type":"ImageObject","@id":"https:\/\/alaki.co.jp\/blog\/?p=1260#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/bd701e6e4a96c261286dd0ed67e756ebf6312aa5be02bac4313a2198f7b12611?s=96&d=mm&r=g","width":96,"height":96,"caption":"sumi"}},{"@type":"WebPage","@id":"https:\/\/alaki.co.jp\/blog\/?p=1260#webpage","url":"https:\/\/alaki.co.jp\/blog\/?p=1260","name":"Excel\u3067BOM\u4ed8\u304d\u304c\u7121\u53cc\u3059\u308bPHP\u3067\u306eCSV\u306e\u66f8\u304d\u51fa\u3057\u65b9 - ALAKI\u682a\u5f0f\u4f1a\u793e","description":"\u3053\u3093\u3070\u3093\u306f\u3001Web\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u7be0\u7530\u3067\u3059\u3002 \uff14\u6708\u306b\u5165\u308a\u3001\u6696\u304b\u304f\u306a\u3063\u3066\u304d\u307e\u3057\u305f\u306d\u3002\uff11\u5e74\u306e\u306a\u304b\u3067\u3082\u6d3b\u52d5\u3057\u3084\u3059\u3044\u5b63\u7bc0\u306b","inLanguage":"ja","isPartOf":{"@id":"https:\/\/alaki.co.jp\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/alaki.co.jp\/blog\/?p=1260#breadcrumblist"},"author":{"@id":"https:\/\/alaki.co.jp\/blog\/?author=1#author"},"creator":{"@id":"https:\/\/alaki.co.jp\/blog\/?author=1#author"},"image":{"@type":"ImageObject","url":"https:\/\/alaki.co.jp\/blog\/wp-content\/uploads\/2016\/01\/14800708_xl.jpg","@id":"https:\/\/alaki.co.jp\/blog\/?p=1260\/#mainImage","width":3192,"height":3000},"primaryImageOfPage":{"@id":"https:\/\/alaki.co.jp\/blog\/?p=1260#mainImage"},"datePublished":"2016-04-08T21:14:26+09:00","dateModified":"2026-09-14T17:25:24+09:00"},{"@type":"WebSite","@id":"https:\/\/alaki.co.jp\/blog\/#website","url":"https:\/\/alaki.co.jp\/blog\/","name":"ALAKI\u682a\u5f0f\u4f1a\u793e","description":"\u3044\u3064\u307e\u3067\u3082\u4f7f\u3048\u308bTech\u60c5\u5831\u767a\u4fe1\u30d6\u30ed\u30b0","inLanguage":"ja","publisher":{"@id":"https:\/\/alaki.co.jp\/blog\/#organization"}}]},"og:locale":"ja_JP","og:site_name":"ALAKI\u682a\u5f0f\u4f1a\u793e - \u3044\u3064\u307e\u3067\u3082\u4f7f\u3048\u308bTech\u60c5\u5831\u767a\u4fe1\u30d6\u30ed\u30b0","og:type":"article","og:title":"Excel\u3067BOM\u4ed8\u304d\u304c\u7121\u53cc\u3059\u308bPHP\u3067\u306eCSV\u306e\u66f8\u304d\u51fa\u3057\u65b9 - ALAKI\u682a\u5f0f\u4f1a\u793e","og:description":"\u3053\u3093\u3070\u3093\u306f\u3001Web\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u7be0\u7530\u3067\u3059\u3002 \uff14\u6708\u306b\u5165\u308a\u3001\u6696\u304b\u304f\u306a\u3063\u3066\u304d\u307e\u3057\u305f\u306d\u3002\uff11\u5e74\u306e\u306a\u304b\u3067\u3082\u6d3b\u52d5\u3057\u3084\u3059\u3044\u5b63\u7bc0\u306b","og:url":"https:\/\/alaki.co.jp\/blog\/?p=1260","article:published_time":"2016-04-08T12:14:26+00:00","article:modified_time":"2026-09-14T08:25:24+00:00","twitter:card":"summary_large_image","twitter:title":"Excel\u3067BOM\u4ed8\u304d\u304c\u7121\u53cc\u3059\u308bPHP\u3067\u306eCSV\u306e\u66f8\u304d\u51fa\u3057\u65b9 - ALAKI\u682a\u5f0f\u4f1a\u793e","twitter:description":"\u3053\u3093\u3070\u3093\u306f\u3001Web\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u7be0\u7530\u3067\u3059\u3002 \uff14\u6708\u306b\u5165\u308a\u3001\u6696\u304b\u304f\u306a\u3063\u3066\u304d\u307e\u3057\u305f\u306d\u3002\uff11\u5e74\u306e\u306a\u304b\u3067\u3082\u6d3b\u52d5\u3057\u3084\u3059\u3044\u5b63\u7bc0\u306b"},"aioseo_meta_data":{"post_id":"1260","title":null,"description":null,"keywords":null,"keyphrases":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-10-06 10:30:49","updated":"2026-10-06 10:30:49"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/alaki.co.jp\/blog\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/alaki.co.jp\/blog\/?cat=26\" title=\"\u305d\u306e\u4ed6\">\u305d\u306e\u4ed6<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tExcel\u3067BOM\u4ed8\u304d\u304c\u7121\u53cc\u3059\u308bPHP\u3067\u306eCSV\u306e\u66f8\u304d\u51fa\u3057\u65b9\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/alaki.co.jp\/blog\/"},{"label":"\u305d\u306e\u4ed6","link":"https:\/\/alaki.co.jp\/blog\/?cat=26"},{"label":"Excel\u3067BOM\u4ed8\u304d\u304c\u7121\u53cc\u3059\u308bPHP\u3067\u306eCSV\u306e\u66f8\u304d\u51fa\u3057\u65b9","link":"https:\/\/alaki.co.jp\/blog\/?p=1260"}],"_links":{"self":[{"href":"https:\/\/alaki.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alaki.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alaki.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alaki.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alaki.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1260"}],"version-history":[{"count":6,"href":"https:\/\/alaki.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1260\/revisions"}],"predecessor-version":[{"id":4574,"href":"https:\/\/alaki.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1260\/revisions\/4574"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/alaki.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/media\/1151"}],"wp:attachment":[{"href":"https:\/\/alaki.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alaki.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alaki.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}