{"id":6772,"date":"2025-01-13T05:05:41","date_gmt":"2025-01-13T05:05:41","guid":{"rendered":"https:\/\/howtogeek.blog\/ko\/?p=6772"},"modified":"2025-01-13T05:05:41","modified_gmt":"2025-01-13T05:05:41","slug":"cleaning-and-importing-data-with-power-query-in-excel-a-stepbystep-guide","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/ko\/cleaning-and-importing-data-with-power-query-in-excel-a-stepbystep-guide\/","title":{"rendered":"Excel\uc5d0\uc11c Power Query\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130 \uc815\ub9ac \ubc0f \uac00\uc838\uc624\uae30: \ub2e8\uacc4\ubcc4 \uac00\uc774\ub4dc"},"content":{"rendered":"<h3>\ube60\ub978 \ub9c1\ud06c<\/h3>\n<p>Power Query\ub294 Excel\uc5d0\uc11c \ucc98\uc74c \uc120\ubcf4\uc778 \uc774\ub798\ub85c \uc804\ubb38\uac00\uac00 \ub370\uc774\ud130 \uad00\ub9ac\ub97c \ucc98\ub9ac\ud558\ub294 \ubc29\uc2dd\uc744 \ubcc0\ud654\uc2dc\ucf30\uc2b5\ub2c8\ub2e4. Power Query\ub294 \uc6d0\ub798 2010\ub144\uc5d0 \ucd94\uac00 \uae30\ub2a5\uc73c\ub85c \ub3c4\uc785\ub418\uc5c8\uc9c0\ub9cc 2016\ub144 \uc774\ud6c4\ub85c Excel\uc5d0\uc11c \uc5c6\uc5b4\uc11c\ub294 \uc548 \ub420 \uae30\ubcf8 \uc81c\uacf5 \uae30\ub2a5\uc774 \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc8fc\uc694 \uae30\ub2a5\uc740? \ub370\uc774\ud130 \uc815\ub9ac, \uac00\uc838\uc624\uae30 \ubc0f \uc7ac\uad6c\uc131 \ud504\ub85c\uc138\uc2a4\ub97c \uac04\uc18c\ud654\ud558\uc5ec \uc2dc\uac04\ubfd0\ub9cc \uc544\ub2c8\ub77c \ucd94\uac00\uc801\uc778 \uc88c\uc808\uac10\uc744 \uc904\uc774\ub294 \uac83\uc785\ub2c8\ub2e4. Power Query\ub294 \ub370\uc774\ud130\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uc900\ube44\ud558\ub294 \ub370 \uc9d1\uc911\ud568\uc73c\ub85c\uc368 \ubd84\uc11d\uacfc \ud1b5\ucc30\ub825\uc5d0 \uc9d1\uc911\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4.<\/p>\n<h2 id=\"what-is-power-query\">\ud30c\uc6cc \ucffc\ub9ac\ub780?<\/h2>\n<p>Power Query\ub294 \ubcf8\uc9c8\uc801\uc73c\ub85c \ub370\uc774\ud130 \ubcc0\ud658\uc744 \uc704\ud574 \uc124\uacc4\ub41c Excel \ub0b4\uc758 \ub3c4\uad6c\uc785\ub2c8\ub2e4. \ub2e4\uc591\ud55c \uc18c\uc2a4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud558\uace0, \uc815\ub9ac\ud558\uace0, \ubd84\uc11d\uc744 \uc704\ud574 \uc900\ube44\ud558\ub294 \uac04\ub2e8\ud558\uba74\uc11c\ub3c4 \uac15\ub825\ud55c \ubc29\ubc95\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. Power Query\ub294 \ub370\uc774\ud130 \ud0ed\uc758 &#8220;\ub370\uc774\ud130 \uac00\uc838\uc624\uae30 \ubc0f \ubcc0\ud658&#8221; \uc139\uc158\uc5d0 \uc788\uc5b4 \ubaa8\ub4e0 \uae30\uc220 \uc218\uc900\uc758 \uc0ac\uc6a9\uc790\uac00 \uc27d\uac8c \uc561\uc138\uc2a4\ud560 \uc218 \uc788\ub3c4\ub85d \ubcf4\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Excel\uc758 \ub370\uc774\ud130 \ud0ed\uc5d0\uc11c Power Query \ub3c4\uad6c\uc758 \uc704\uce58\" class=\"wp-image\" decoding=\"async\" height=\"243\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/the-data-tab-in-excel-with-the-get-and-transform-data-group-highlighted.webp\" title=\"Excel\uc758 \ub370\uc774\ud130 \ud0ed\uc5d0\uc11c Power Query \ub3c4\uad6c\uc758 \uc704\uce58\" width=\"750\"\/><\/figure>\n<p>Power Query\uc758 \uc2e4\uc6a9\uc801\uc778 \uc0ac\uc6a9\ubc95\uc744 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uba74\uc11c \ub370\uc774\ud130\ub97c \uc815\ub9ac\ud558\uace0 \uac00\uc838\uc624\uace0 \uad6c\uc131\ud558\ub294 \ubc29\ubc95\uc744 \uc775\ud600\ubcf4\uc138\uc694.<\/p>\n<h2 id=\"cleaning-excel-data-using-power-query\">Power Query\ub97c \uc0ac\uc6a9\ud558\uc5ec Excel \ub370\uc774\ud130 \uc815\ub9ac<\/h2>\n<p>\uc81c\uac00 Power Query\ub97c \uc790\uc8fc \uc0ac\uc6a9\ud558\ub294 \ubd84\uc57c \uc911 \ud558\ub098\ub294 \ub370\uc774\ud130 \uc815\ub9ac\uc785\ub2c8\ub2e4. Outlook \uc774\uba54\uc77c\uc758 CC \ud544\ub4dc\uc5d0\uc11c \uc774\uba54\uc77c \uc8fc\uc18c \ubaa9\ub85d\uc744 Excel \uc2dc\ud2b8\uc5d0 \ubd99\uc5ec\ub123\uc5c8\ub2e4\uace0 \uc0c1\uc0c1\ud574 \ubcf4\uc138\uc694. \uc5ec\ub7ec\ubd84\uc758 \uc784\ubb34\ub294? \uadf8 \uc9c0\uc800\ubd84\ud55c \ub370\uc774\ud130\ub97c \uc774\ub984, \uc131, \uc774\uba54\uc77c \uc8fc\uc18c\uac00 \ub4e4\uc5b4 \uc788\ub294 \uae54\ub054\ud55c \ud45c\ub85c \ubc14\uafb8\ub294 \uac83\uc785\ub2c8\ub2e4. Excel \ud568\uc218\ub85c \uc774\ub97c \ub2ec\uc131\ud560 \uc218 \uc788\uc9c0\ub9cc, Power Query\ub294 \ucd5c\uc18c\ud55c\uc758 \ub178\ub825\uc73c\ub85c \uc6d0\ud65c\ud55c \ud658\uacbd\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Excel\uc5d0\uc11c \uc138\ubbf8\ucf5c\ub860\uc73c\ub85c \uad6c\ubd84\ub41c \uc774\uba54\uc77c \uc8fc\uc18c \ubaa9\ub85d\" class=\"wp-image\" decoding=\"async\" height=\"147\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/a-list-of-email-addresses-in-cell-a1-of-an-excel-spreadsheet-each-separated-by-a-semicolon.webp\" title=\"Excel\uc5d0\uc11c \uc138\ubbf8\ucf5c\ub860\uc73c\ub85c \uad6c\ubd84\ub41c \uc774\uba54\uc77c \uc8fc\uc18c \ubaa9\ub85d\" width=\"750\"\/><\/figure>\n<p>\uc2dc\uc791\ud558\ub824\uba74 \ub2e4\uc74c \ub2e8\uacc4\ub97c \ub530\ub974\uc138\uc694.<\/p>\n<ul>\n<li><strong>Power Query\ub97c \uc5fd\ub2c8\ub2e4.<\/strong> &#8220;\ub370\uc774\ud130&#8221; \ud0ed\uc744 \ud074\ub9ad\ud55c \ub2e4\uc74c &#8220;\ud45c\/\ubc94\uc704\uc5d0\uc11c&#8221;\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4. \uc774 \ucc3d\uc5d0\uc11c\ub294 \uc120\ud0dd\ud55c \ub370\uc774\ud130\uc5d0\uc11c \ud45c\ub97c \ub9cc\ub4e4\ub77c\ub294 \uba54\uc2dc\uc9c0\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/li>\n<li><strong>\ub370\uc774\ud130 \uc120\ud0dd:<\/strong> \uc62c\ubc14\ub978 \ubc94\uc704\uac00 \uc120\ud0dd\ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud558\uace0, \ub370\uc774\ud130\uc5d0 \ud5e4\ub354\uac00 \uc5c6\ub294 \uacbd\uc6b0 &#8220;\ud655\uc778&#8221;\uc744 \ud074\ub9ad\ud558\uae30 \uc804\uc5d0 \ud5e4\ub354 \uc635\uc158\uc744 \uc120\ud0dd\ud558\uc9c0 \uc54a\uc740 \uc0c1\ud0dc\ub85c \ub461\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>&#8220;\ud655\uc778&#8221;\uc744 \ud074\ub9ad\ud558\uba74 Power Query \ud3b8\uc9d1\uae30\uac00 \uc5f4\ub9ac\uace0 \ub370\uc774\ud130 \ubcc0\ud658\uc744 \uc704\ud55c \ub2e8\uacc4\uac00 \uc124\uc815\ub429\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c \uc791\uc5c5\uc740? \uc774\uba54\uc77c \uc8fc\uc18c\ub97c \uac1c\ubcc4 \ud589\uc73c\ub85c \ub098\ub204\uc138\uc694:<\/p>\n<ul>\n<li><strong>\uc5f4 \ubd84\ud560:<\/strong> \uc5f4 \uba38\ub9ac\uae00\uc744 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uace0 &#8220;\uc5f4 \ubd84\ud560&#8221; \uc704\uc5d0 \ub9c8\uc6b0\uc2a4\ub97c \uc62c\ub824\ub193\uace0 &#8220;\uad6c\ubd84 \uae30\ud638\ubcc4&#8221;\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4. \uad6c\ubd84 \uae30\ud638\ub85c &#8220;\uc138\ubbf8\ucf5c\ub860&#8221;\uc744 \uc120\ud0dd\ud558\uace0 \uace0\uae09 \uc635\uc158 \ub300\ud654 \uc0c1\uc790\uc5d0\uc11c &#8220;\ud589&#8221;\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>\ud655\uc778 \ud6c4, \uac01 \uc774\uba54\uc77c \uc8fc\uc18c\uac00 \ubcc4\ub3c4 \ud589\uc73c\ub85c \uae54\ub054\ud558\uac8c \uc815\ub9ac\ub41c \uac83\uc744 \ubcf4\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Power Query Editor\uc5d0\uc11c \uc5ec\ub7ec \ud589\uc73c\ub85c \uad6c\ubd84\ub41c \uc774\uba54\uc77c \uc8fc\uc18c\" class=\"wp-image\" decoding=\"async\" height=\"254\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/a-list-of-email-addresses-in-excel-s-power-query-editor.webp\" title=\"Power Query Editor\uc5d0\uc11c \uc5ec\ub7ec \ud589\uc73c\ub85c \uad6c\ubd84\ub41c \uc774\uba54\uc77c \uc8fc\uc18c\" width=\"750\"\/><\/figure>\n<p>\uc774\uc81c \uc774\ub984\uacfc \uc131\uc744 \ucd94\ucd9c\ud560 \uc2dc\uac04\uc785\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574 &#8220;\uc608\uc81c\uc5d0\uc11c \uc5f4 \ucd94\uac00&#8221; \uae30\ub2a5\uc744 \ud65c\uc6a9\ud558\uc138\uc694.<\/p>\n<ul>\n<li><strong>\uc774\ub984 \ucd94\ucd9c:<\/strong> \uc5f4 \uba38\ub9ac\uae00\uc744 \ub450 \ubc88 \ud074\ub9ad\ud558\uace0 \ud328\ud134\uc744 \ubcf5\uc81c\ud560 \uc774\ub984\uc774\ub098 \uc9c1\ud568\uc744 \uc785\ub825\ud569\ub2c8\ub2e4. Power Query\uac00 \ub098\uba38\uc9c0 \ud56d\ubaa9\uc744 \uc790\ub3d9\uc73c\ub85c \uc81c\uc548\ud569\ub2c8\ub2e4!<\/li>\n<li><strong>\uc5f4 \uc774\ub984 \ubc14\uafb8\uae30:<\/strong> \uc5f4 \uc774\ub984\uc744 \uc801\uc808\ud558\uac8c \ubc14\uafb8\uc138\uc694(\uc608: &#8220;\uc774\ub984&#8221;, &#8220;\uc131&#8221;, &#8220;\uc774\uba54\uc77c \uc8fc\uc18c&#8221;).<\/li>\n<li><strong>\ub9c8\uc9c0\ub9c9 \uc791\uc5c5:<\/strong> \uc6d0\ud558\ub294 \uc704\uce58\ub85c \uc5f4 \uc21c\uc11c\ub97c \ub04c\uc5b4\ub2e4 \ub193\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>\ub370\uc774\ud130\uac00 \uae54\ub054\ud558\uace0 \uccb4\uacc4\uc801\uc73c\ub85c \uc815\ub9ac\ub418\uba74 \ud1b5\ud569 \ubb38\uc11c\ub97c \ub2eb\uace0 \ub370\uc774\ud130\ub97c \ub2e4\uc2dc \ub85c\ub4dc\ud558\uae30 \uc804\uc5d0 \ucffc\ub9ac\uc5d0 \uc758\ubbf8 \uc788\ub294 \uc774\ub984\uc744 \uc9c0\uc815\ud558\ub294 \uac83\uc744 \uc78a\uc9c0 \ub9c8\uc138\uc694.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Power Query \ud3b8\uc9d1\uae30\uc5d0\uc11c \ucffc\ub9ac \uc774\ub984 \uc9c0\uc815\" class=\"wp-image\" decoding=\"async\" height=\"218\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/a-table-in-excel-s-power-query-editor-being-given-the-name-heroicemails.webp\" title=\"Power Query \ud3b8\uc9d1\uae30\uc5d0\uc11c \ucffc\ub9ac \uc774\ub984 \uc9c0\uc815\" width=\"750\"\/><\/figure>\n<h2 id=\"importing-and-reorganizing-data-with-power-query\">Power Query\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130 \uac00\uc838\uc624\uae30 \ubc0f \uc7ac\uad6c\uc131<\/h2>\n<p>Power Query\ub294 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\ub97c \ub118\uc5b4 PDF\ub098 \uc6f9\uc0ac\uc774\ud2b8\uc640 \uac19\uc740 \ub2e4\uc591\ud55c \uc18c\uc2a4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc62c \ub54c \ube5b\uc744 \ubc1c\ud569\ub2c8\ub2e4. \ub2e4\uc74c \uc139\uc158\uc5d0\uc11c\ub294 \uae30\uc874 Excel \ud1b5\ud569 \ubb38\uc11c\uc5d0\uc11c \ud2b9\uc815 \ub370\uc774\ud130\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \ucd94\ucd9c\ud558\uace0 \uc7ac\uad6c\uc131\ud558\ub294 \ubc29\ubc95\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n<p>\uba3c\uc800, \ub2e4\uc2dc &#8220;\ub370\uc774\ud130&#8221; \ud0ed\uc73c\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4.<\/p>\n<ul>\n<li><strong>\uac00\uc838\uc624\uae30 \uc2dc\uc791:<\/strong> &#8220;\ub370\uc774\ud130 \uac00\uc838\uc624\uae30&#8221;&gt; &#8220;\ud30c\uc77c\uc5d0\uc11c&#8221;&gt; &#8220;Excel \ud1b5\ud569 \ubb38\uc11c\uc5d0\uc11c&#8221;\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ud30c\uc77c \uc120\ud0dd:<\/strong> \ub370\uc774\ud130\ub97c \uac00\uc838\uc62c \ud30c\uc77c\uc744 \ucc3e\uc740 \ub2e4\uc74c &#8220;\uac00\uc838\uc624\uae30&#8221;\ub97c \ud074\ub9ad\ud55c \ub2e4\uc74c &#8220;\ub370\uc774\ud130 \ubcc0\ud658&#8221;\uc744 \ud074\ub9ad\ud558\uc5ec Power Query \ud3b8\uc9d1\uae30\uc5d0 \uc561\uc138\uc2a4\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uac00\uc838\uc624\uae30\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ub370\uc774\ud130\ub97c \ud45c\uc2dc\ud558\ub294 \ud0d0\uc0c9\uae30 \ucc3d\" class=\"wp-image\" decoding=\"async\" height=\"700\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/excel-s-navigator-window-that-shows-the-data-it-will-import-from-another-worksheet-and-the-transform-data-button-is-selected.webp\" title=\"\uac00\uc838\uc624\uae30\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ub370\uc774\ud130\ub97c \ud45c\uc2dc\ud558\ub294 \ud0d0\uc0c9\uae30 \ucc3d\" width=\"880\"\/><\/figure>\n<p>Power Query \ud3b8\uc9d1\uae30\uc5d0\uc11c:<\/p>\n<ul>\n<li><strong>\ud589\uc744 \uba38\ub9ac\uae00\ub85c \uc2b9\uaca9:<\/strong> &#8220;\uccab \ubc88\uc9f8 \ud589\uc744 \uba38\ub9ac\uae00\ub85c \uc0ac\uc6a9&#8221;\uc744 \ud074\ub9ad\ud558\uba74 \uccab \ubc88\uc9f8 \ud589\uc774 \uc989\uc2dc \uc5f4 \uba38\ub9ac\uae00\ub85c \uc9c0\uc815\ub429\ub2c8\ub2e4.<\/li>\n<li><strong>\ub370\uc774\ud130 \ud53c\ubc97 \ud574\uc81c:<\/strong> \uace0\uc720\ud55c \ubcc0\uc218\ub97c \ub098\ud0c0\ub0b4\ub294 \uc5f4\uc744 \uc120\ud0dd\ud558\uace0 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc5ec &#8220;\ub2e4\ub978 \uc5f4 \ud53c\ubc97 \ud574\uc81c&#8221;\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \ub808\uc774\uc544\uc6c3\uc774 \ubcc0\ud658\ub418\uc5b4 \uac01 \uace0\uc720\ud55c \uac12\uc774 \ubcc4\ub3c4\uc758 \ud589\uc5d0 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uae54\ub054\ud55c \ub808\uc774\uc544\uc6c3\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ud53c\ubc97\ub418\uc9c0 \uc54a\uc740 \ub370\uc774\ud130\" class=\"wp-image\" decoding=\"async\" height=\"311\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/a-table-in-power-query-editor-in-excel-containing-five-columns-that-have-been-transformed-using-the-tool-s-mechanisms.webp\" title=\"\uae54\ub054\ud55c \ub808\uc774\uc544\uc6c3\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ud53c\ubc97\ub418\uc9c0 \uc54a\uc740 \ub370\uc774\ud130\" width=\"749\"\/><\/figure>\n<p>\uc7ac\uad6c\uc131\ub41c \ud45c\ub97c \ud1b5\ud569 \ubb38\uc11c\ub85c \ub2e4\uc2dc \ub85c\ub4dc\ud558\uae30 \uc804\uc5d0 \uc5f4 \uc774\ub984\uc744 \uc138\ubd80\uc801\uc73c\ub85c \uc870\uc815\ud558\uace0 \uc62c\ubc14\ub978 \ub370\uc774\ud130 \uc720\ud615\uc744 \uc815\uc758\ud558\uc5ec \ub370\uc774\ud130 \ubb34\uacb0\uc131\uc744 \uc720\uc9c0\ud558\ub294 \uac83\uc744 \uc78a\uc9c0 \ub9c8\uc138\uc694.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Power Query Editor\uc5d0\uc11c Month \uc5f4\uc5d0 \ub300\ud55c \ub370\uc774\ud130 \uc720\ud615 \uc124\uc815\" class=\"wp-image\" decoding=\"async\" height=\"413\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/a-table-in-excel-s-power-query-editor-with-a-column-being-renamed-month-and-the-data-type-symbol-representing-a-calendar.webp\" title=\"Power Query Editor\uc5d0\uc11c Month \uc5f4\uc5d0 \ub300\ud55c \ub370\uc774\ud130 \uc720\ud615 \uc124\uc815\" width=\"750\"\/><\/figure>\n<p>\ubcc0\ud658\uc744 \ub9c8\uce58\uba74 &#8220;\ub2eb\uae30 \ubc0f \ub85c\ub4dc&#8221;&gt; &#8220;\ub2eb\uae30 \ubc0f \ub85c\ub4dc \uc704\uce58&#8221;\ub97c \ub20c\ub7ec Excel\uc5d0\uc11c \ub370\uc774\ud130\uac00 \uc5b4\ub514\uc5d0 \ub098\ud0c0\ub0a0\uc9c0 \uacb0\uc815\ud569\ub2c8\ub2e4.<\/p>\n<p>Power Query\uc758 \ud798\uc740 \ub370\uc774\ud130 \uc18c\uc2a4\uc5d0 \ub300\ud55c \ub3d9\uc801 \ub9c1\ud06c\ub97c \uc720\uc9c0\ud558\ub294 \ub2a5\ub825\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc6d0\ub798 \ub370\uc774\ud130 \uc138\ud2b8\uac00 \ubcc0\uacbd\ub418\uba74 \uc0c8 \ud14c\uc774\ube14\uc744 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uace0 &#8220;\uc0c8\ub85c \uace0\uce68&#8221;\uc744 \uc120\ud0dd\ud558\uc5ec \uc6d0\ud65c\ud558\uac8c \uc5c5\ub370\uc774\ud2b8\ud569\ub2c8\ub2e4.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Power Query \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \uc0c8\ub85c \uace0\uce68\" class=\"wp-image\" decoding=\"async\" height=\"390\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/the-refresh-option-in-excel-for-updating-a-table-created-through-a-power-query.webp\" title=\"Power Query \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \uc0c8\ub85c \uace0\uce68\" width=\"750\"\/><\/figure>\n<p>\uc774 \uae30\ub2a5\uc744 \ud1b5\ud574 Power Query\ub294 \ub3d9\uc801 \ub370\uc774\ud130 \ubd84\uc11d\uc5d0 \uc788\uc5b4 \ud68d\uae30\uc801\uc778 \uc804\ud658\uc810\uc744 \ub9c8\ub828\ud558\uc5ec \uc218\ub3d9\uc73c\ub85c \ubcf5\uc0ac\ud558\uc5ec \ubd99\uc5ec\ub123\uc9c0 \uc54a\uace0\ub3c4 \ub370\uc774\ud130 \uc138\ud2b8\ub97c \ucd5c\uc2e0 \uc0c1\ud0dc\ub85c \uc720\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub370\uc774\ud130 \uad00\ub9ac \uae30\uc220\uc744 \ud55c \ub2e8\uacc4 \uc5c5\uadf8\ub808\uc774\ub4dc\ud560 \uc900\ube44\uac00 \ub418\uc168\ub098\uc694? \uc6f9\uc5d0\uc11c \ud14c\uc774\ube14\ub85c \uc791\uc5c5\ud558\uace0 \ub2e4\uc591\ud55c \uac00\uc838\uc624\uae30 \uae30\ub2a5\uc744 \uc9c1\uc811 \uccb4\ud5d8\ud558\uc5ec Power Query\ub97c \ub354 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694. \uc774 \ub3c4\uad6c\uac00 \uae08\uc138 \uc0dd\uc0b0\uc131\uacfc \uc815\ud655\uc131\uc744 \ub192\uc5ec\uc900\ub2e4\ub294 \uac83\uc744 \uc54c\uac8c \ub420 \uac81\ub2c8\ub2e4!<\/p>\n<h3>\ucd94\uac00 \ud1b5\ucc30\ub825<\/h3>\n<h4><strong>1. Power Query\uc5d0\uc11c \uc5b4\ub5a4 \uc720\ud615\uc758 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub098\uc694?<\/strong><\/h4>\n<p>Power Query\ub294 Excel \ud30c\uc77c, CSV \ud30c\uc77c, \uc6f9 \ud398\uc774\uc9c0, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub4f1 \ub2e4\uc591\ud55c \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc774\ub294 \ub370\uc774\ud130 \uac00\uc838\uc624\uae30 \ubc0f \ubcc0\ud658 \uc791\uc5c5\uc5d0 \ub9e4\uc6b0 \ub2e4\uc7ac\ub2e4\ub2a5\ud558\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\uac8c \ud574\uc90d\ub2c8\ub2e4.<\/p>\n<h4><strong>2. Power Query\ub97c \ud1b5\ud574 \uac00\uc838\uc628 \ub370\uc774\ud130\ub97c \uc790\ub3d9\uc73c\ub85c \uc0c8\ub85c \uace0\uce60 \uc218 \uc788\ub098\uc694?<\/strong><\/h4>\n<p>\ub124, Power Query \ub370\uc774\ud130 \uc138\ud2b8\uc5d0 \ub300\ud55c \uc790\ub3d9 \uc0c8\ub85c \uace0\uce68\uc744 \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Excel\uc5d0\uc11c\ub294 \uc0c8\ub85c \uace0\uce68 \uac04\uaca9\uc744 \uad6c\uc131\ud558\uc5ec \uc218\ub3d9 \uac1c\uc785 \uc5c6\uc774\ub3c4 \ub370\uc774\ud130\ub97c \ucd5c\uc2e0 \uc0c1\ud0dc\ub85c \uc720\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h4><strong>3. Power Query\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac00\uc838\uc62c \uc218 \uc788\ub294 \ub370\uc774\ud130 \uc591\uc5d0 \uc81c\ud55c\uc774 \uc788\uc2b5\ub2c8\uae4c?<\/strong><\/h4>\n<p>Power Query\ub294 \ub300\uc6a9\ub7c9 \ub370\uc774\ud130 \uc138\ud2b8\ub97c \ucc98\ub9ac\ud560 \uc218 \uc788\uc9c0\ub9cc, \ud2b9\ud788 Excel\uc758 \ud589 \uc81c\ud55c\uc778 1,048,576\uc744 \ucd08\uacfc\ud558\ub294 \uacbd\uc6b0 \uc9c0\ub098\uce58\uac8c \ud070 \uc138\ud2b8\ub85c \uc778\ud574 \uc131\ub2a5\uc774 \uc800\ud558\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ucc98\ub9ac \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub824\uba74 \uac00\uc838\uc624\uae30 \uc804\uc5d0 \ub370\uc774\ud130\ub97c \ud544\ud130\ub9c1\ud558\uac70\ub098 \uc694\uc57d\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n<p><a class=\"xiaomi\" href=\"https:\/\/www.howtogeek.com\/how-to-clean-up-and-import-data-using-power-query-in-excel\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">\ucd9c\ucc98 \ubc0f \uc774\ubbf8\uc9c0<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ube60\ub978 \ub9c1\ud06c Power Query\ub294 Excel\uc5d0\uc11c \ucc98\uc74c \uc120\ubcf4\uc778 \uc774\ub798\ub85c \uc804\ubb38\uac00\uac00 \ub370\uc774\ud130 \uad00\ub9ac\ub97c \ucc98\ub9ac\ud558\ub294 \ubc29\uc2dd\uc744 \ubcc0\ud654\uc2dc\ucf30\uc2b5\ub2c8\ub2e4. Power Query\ub294 \uc6d0\ub798 2010\ub144\uc5d0 \ucd94\uac00 \uae30\ub2a5\uc73c\ub85c \ub3c4\uc785\ub418\uc5c8\uc9c0\ub9cc 2016\ub144 \uc774\ud6c4\ub85c Excel\uc5d0\uc11c \uc5c6\uc5b4\uc11c\ub294 \uc548 \ub420 \uae30\ubcf8 \uc81c\uacf5 \uae30\ub2a5\uc774 \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc8fc\uc694 \uae30\ub2a5\uc740? \ub370\uc774\ud130 \uc815\ub9ac, \uac00\uc838\uc624\uae30 \ubc0f \uc7ac\uad6c\uc131 \ud504\ub85c\uc138\uc2a4\ub97c \uac04\uc18c\ud654\ud558\uc5ec \uc2dc\uac04\ubfd0\ub9cc \uc544\ub2c8\ub77c \ucd94\uac00\uc801\uc778 \uc88c\uc808\uac10\uc744 \uc904\uc774\ub294 \uac83\uc785\ub2c8\ub2e4. Power Query\ub294 \ub370\uc774\ud130\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uc900\ube44\ud558\ub294 \ub370 \uc9d1\uc911\ud568\uc73c\ub85c\uc368 \ubd84\uc11d\uacfc \ud1b5\ucc30\ub825\uc5d0 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[130,286,9],"class_list":["post-6772","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-microsoft","tag-microsoft-excel","tag-windows"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/6772","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/comments?post=6772"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/6772\/revisions"}],"predecessor-version":[{"id":6773,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/6772\/revisions\/6773"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/media?parent=6772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/categories?post=6772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/tags?post=6772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}