{"id":33217,"date":"2025-01-13T15:08:08","date_gmt":"2025-01-13T08:08:08","guid":{"rendered":"https:\/\/helpmimosa.misa.vn\/2025\/?post_type=ht_kb&#038;p=33217"},"modified":"2026-10-02T16:31:30","modified_gmt":"2026-10-02T09:31:30","slug":"xuat-khau-du-lieu-ra-excel","status":"publish","type":"ht_kb","link":"https:\/\/helpmimosa.misa.vn\/2025\/kb\/xuat-khau-du-lieu-ra-excel\/","title":{"rendered":"Xu\u1ea5t kh\u1ea9u d\u1eef li\u1ec7u ra excel"},"content":{"rendered":"<h3>1. T\u1ed5ng quan<\/h3>\n<p>B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn anh\/ch\u1ecb th\u1ef1c hi\u1ec7n xu\u1ea5t kh\u1ea9u d\u1eef li\u1ec7u danh m\u1ee5c: <strong>T\u00e0i s\u1ea3n c\u1ed1 \u0111\u1ecbnh<\/strong>, <strong>C\u00f4ng c\u1ee5 d\u1ee5ng c\u1ee5<\/strong>, <strong>C\u00e1n b\u1ed9 <\/strong>t\u1eeb ph\u1ea7n m\u1ec1m ra t\u1ec7p Excel (.xls), ph\u1ee5c v\u1ee5 l\u01b0u tr\u1eef, \u0111\u1ed1i chi\u1ebfu ho\u1eb7c chuy\u1ec3n d\u1eef li\u1ec7u ra ngo\u00e0i ph\u1ea7n m\u1ec1m.t\u1eeb ph\u1ea7n m\u1ec1m ra t\u1ec7p excel.<\/p>\n<h3>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/h3>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> V\u00e0o<strong> T\u1ec7p<\/strong>, ch\u1ecdn<strong> Xu\u00e2\u0301t kh\u00e2\u0309u d\u01b0\u0303 li\u00ea\u0323u ra excel<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33219 size-full\" src=\"\/2025\/wp-content\/uploads\/2025\/01\/3-5.png\" alt=\"\" width=\"614\" height=\"480\" srcset=\"\/2025\/wp-content\/uploads\/2025\/01\/3-5.png 614w, \/2025\/wp-content\/uploads\/2025\/01\/3-5-300x235.png 300w, \/2025\/wp-content\/uploads\/2025\/01\/3-5-50x39.png 50w, \/2025\/wp-content\/uploads\/2025\/01\/3-5-60x47.png 60w, \/2025\/wp-content\/uploads\/2025\/01\/3-5-100x78.png 100w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn danh m\u1ee5c mu\u1ed1n xu\u1ea5t kh\u1ea9u d\u1eef li\u1ec7u l\u00e0 <strong>T\u00e0i s\u1ea3n c\u1ed1 \u0111\u1ecbnh<\/strong>,\u00a0<strong>C\u00f4ng c\u1ee5 d\u1ee5ng c\u1ee5\u00a0<\/strong>hay\u00a0<strong>C\u00e1n b\u1ed9<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng th\u01b0 m\u1ee5c \u0111\u1ec3 ch\u1ecdn \u0111\u01b0\u1eddng d\u1eabn l\u01b0u t\u1ec7p d\u1eef li\u1ec7u xu\u1ea5t kh\u1ea9u.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33221 size-full\" src=\"\/2025\/wp-content\/uploads\/2025\/01\/18-2.png\" alt=\"\" width=\"443\" height=\"268\" srcset=\"\/2025\/wp-content\/uploads\/2025\/01\/18-2.png 443w, \/2025\/wp-content\/uploads\/2025\/01\/18-2-300x181.png 300w, \/2025\/wp-content\/uploads\/2025\/01\/18-2-50x30.png 50w, \/2025\/wp-content\/uploads\/2025\/01\/18-2-60x36.png 60w, \/2025\/wp-content\/uploads\/2025\/01\/18-2-100x60.png 100w\" sizes=\"auto, (max-width: 443px) 100vw, 443px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Nh\u1ea5n <strong>Th\u1ef1c hi\u1ec7n<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> Khi xu\u1ea5t kh\u1ea9u ho\u00e0n t\u1ea5t, ph\u1ea7n m\u1ec1m hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o d\u1ea1ng: <em>&#8220;Xu\u1ea5t kh\u1ea9u th\u00e0nh c\u00f4ng [s\u1ed1] b\u1ea3n ghi. B\u1ea1n c\u00f3 mu\u1ed1n m\u1edf th\u01b0 m\u1ee5c ch\u1ee9a t\u1ec7p &lt;t\u00ean t\u1ec7p&gt; kh\u00f4ng?&#8221;<\/em><\/p>\n<ul class=\"[li_&amp;]:mb-0 [li_&amp;]:mt-1 [li_&amp;]:gap-1 [&amp;:not(:last-child)_ul]:pb-1 [&amp;:not(:last-child)_ol]:pb-1 list-disc flex flex-col gap-1 pl-8 mb-3\">\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\">Nh\u1ea5n <strong>C\u00f3<\/strong>: m\u1edf th\u01b0 m\u1ee5c ch\u1ee9a t\u1ec7p Excel v\u1eeba xu\u1ea5t kh\u1ea9u.<\/li>\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\">Nh\u1ea5n <strong>Kh\u00f4ng<\/strong>: k\u1ebft th\u00fac thao t\u00e1c xu\u1ea5t kh\u1ea9u, kh\u00f4ng m\u1edf th\u01b0 m\u1ee5c.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33223 size-full\" src=\"\/2025\/wp-content\/uploads\/2025\/01\/19-2.png\" alt=\"\" width=\"478\" height=\"174\" srcset=\"\/2025\/wp-content\/uploads\/2025\/01\/19-2.png 478w, \/2025\/wp-content\/uploads\/2025\/01\/19-2-300x109.png 300w, \/2025\/wp-content\/uploads\/2025\/01\/19-2-50x18.png 50w, \/2025\/wp-content\/uploads\/2025\/01\/19-2-60x22.png 60w, \/2025\/wp-content\/uploads\/2025\/01\/19-2-100x36.png 100w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\"><strong>L\u01b0u \u00fd: <\/strong>M\u1ed7i l\u1ea7n ch\u1ec9 xu\u1ea5t kh\u1ea9u \u0111\u01b0\u1ee3c 1 lo\u1ea1i danh m\u1ee5c (T\u00e0i s\u1ea3n c\u1ed1 \u0111\u1ecbnh, C\u00f4ng c\u1ee5 d\u1ee5ng c\u1ee5 ho\u1eb7c C\u00e1n b\u1ed9) \u2014 mu\u1ed1n xu\u1ea5t nhi\u1ec1u lo\u1ea1i ph\u1ea3i th\u1ef1c hi\u1ec7n l\u1eb7p l\u1ea1i c\u00e1c b\u01b0\u1edbc tr\u00ean cho t\u1eebng lo\u1ea1i.<\/p>\n<h3>3. L\u01b0u \u00fd<\/h3>\n<p>1. Hi\u1ec7n t\u1ea1i, ph\u1ea7n m\u1ec1m ch\u01b0a h\u1ed7 tr\u1ee3 xu\u1ea5t kh\u1ea9u danh m\u1ee5c kh\u00e1ch h\u00e0ng, nh\u00e0 cung c\u1ea5p theo h\u01b0\u1edbng d\u1eabn n\u00e0y. \u0110\u1ec3 xu\u1ea5t danh s\u00e1ch kh\u00e1ch h\u00e0ng, nh\u00e0 cung c\u1ea5p ra Excel, anh\/ch\u1ecb th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>V\u00e0o\u00a0<strong>Danh m\u1ee5c \u2192 Kh\u00e1ch h\u00e0ng, nh\u00e0 cung c\u1ea5p<\/strong>.<\/li>\n<li>Nh\u1ea5n\u00a0<strong>In<\/strong>.<\/li>\n<li>Nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng\u00a0<strong>Xu\u1ea5t kh\u1ea9u<\/strong>\u00a0\u1edf g\u00f3c tr\u00e1i ho\u1eb7c v\u00e0o\u00a0<strong>T\u1ec7p \u2192 Xu\u1ea5t kh\u1ea9u<\/strong>\u00a0\u0111\u1ec3 xu\u1ea5t danh s\u00e1ch ra Excel.<\/li>\n<li>Ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>Microsoft Excel Extend (*.xls)<\/strong>\u00a0\u0111\u1ec3 xu\u1ea5t \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin.<\/li>\n<\/ul>\n<p>Anh\/ch\u1ecb c\u00f3 th\u1ec3 xem\u00a0<strong>h\u01b0\u1edbng d\u1eabn xu\u1ea5t kh\u1ea9u chi ti\u1ebft <a href=\"https:\/\/helpmimosa.misa.vn\/2025\/kb\/lam-the-nao-de-xuat-khau-bao-cao-chung-tu-ra-excel\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y<\/a><\/strong>.<\/p>\n<p class=\"x1yc453h xma8rkl xgoqxah xutxfr x1fie51u xgyxj25 x1xobyvs x1elgs31 x1fv8qjw xcy5tzr x1ht4adc xnvauns x1c2l018 x14l7nz5 xuw7688 x1pjt2rx x160d6zm xrxpjvj\" dir=\"ltr\"><strong class=\"x7amdea\">2. Xu\u1ea5t ch\u1ee9ng t\u1eeb ra Excel<\/strong><\/p>\n<p class=\"x1yc453h xma8rkl xgoqxah xutxfr x1fie51u xgyxj25 x1xobyvs x1elgs31 x1fv8qjw xcy5tzr x1ht4adc xnvauns x1c2l018 x14l7nz5 xuw7688 x1pjt2rx x160d6zm xrxpjvj\" dir=\"ltr\">\u0110\u1ec3 xu\u1ea5t to\u00e0n b\u1ed9 ch\u1ee9ng t\u1eeb \u0111\u00e3 nh\u1eadp li\u1ec7u ra Excel, anh\/ch\u1ecb c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo m\u1ed9t trong hai c\u00e1ch:<\/p>\n<ul class=\"xonam98 x1epdd7z xemmon1 xn020vs xfl32do xluzp7q x1yc453h x38giro xat24cr x1xobyvs x1fv8qjw xdj266r xrxpjvj x1bxe5rh\">\n<li class=\"x1datfip xp5n6w9 x2xbuc6\">\n<p class=\"x1yc453h xma8rkl xgoqxah xutxfr x1fie51u xgyxj25 x1xobyvs x1elgs31 x1fv8qjw xcy5tzr x1ht4adc xnvauns x1c2l018 x14l7nz5 xuw7688 x1pjt2rx x160d6zm xrxpjvj\" dir=\"ltr\"><strong class=\"x7amdea\">C\u00e1ch 1:<\/strong> V\u00e0o <strong class=\"x7amdea\">T\u00ecm ki\u1ebfm ch\u1ee9ng t\u1eeb<\/strong> theo h\u01b0\u1edbng d\u1eabn <a href=\"https:\/\/helpmimosa.misa.vn\/2025\/kb\/tim-chung-tu\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y<\/a> \u2192 nh\u1ea5n <strong class=\"x7amdea\">Xu\u1ea5t kh\u1ea9u<\/strong> \u0111\u1ec3 xu\u1ea5t k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm ra Excel.<\/p>\n<\/li>\n<li class=\"x1datfip xp5n6w9 x2xbuc6\">\n<p class=\"x1yc453h xma8rkl xgoqxah xutxfr x1fie51u xgyxj25 x1xobyvs x1elgs31 x1fv8qjw xcy5tzr x1ht4adc xnvauns x1c2l018 x14l7nz5 xuw7688 x1pjt2rx x160d6zm xrxpjvj\" dir=\"ltr\"><strong class=\"x7amdea\">C\u00e1ch 2:<\/strong> M\u1edf <strong class=\"x7amdea\">B\u00e1o c\u00e1o<\/strong> t\u01b0\u01a1ng \u1ee9ng \u2192 xu\u1ea5t b\u00e1o c\u00e1o ra exel.<\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>1. T\u1ed5ng quan B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn anh\/ch\u1ecb th\u1ef1c hi\u1ec7n xu\u1ea5t kh\u1ea9u d\u1eef li\u1ec7u danh m\u1ee5c: T\u00e0i s\u1ea3n c\u1ed1 \u0111\u1ecbnh, C\u00f4ng c\u1ee5 d\u1ee5ng c\u1ee5, C\u00e1n b\u1ed9 t\u1eeb ph\u1ea7n m\u1ec1m ra t\u1ec7p Excel (.xls), ph\u1ee5c v\u1ee5 l\u01b0u tr\u1eef, \u0111\u1ed1i chi\u1ebfu ho\u1eb7c chuy\u1ec3n d\u1eef li\u1ec7u ra ngo\u00e0i ph\u1ea7n m\u1ec1m.t\u1eeb ph\u1ea7n m\u1ec1m ra&#8230;<\/p>\n","protected":false},"author":71,"template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"ht-kb-category":[963],"ht-kb-tag":[],"class_list":["post-33217","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-tep"],"_links":{"self":[{"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb\/33217","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/users\/71"}],"version-history":[{"count":5,"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb\/33217\/revisions"}],"predecessor-version":[{"id":58943,"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb\/33217\/revisions\/58943"}],"wp:attachment":[{"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/media?parent=33217"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb-category?post=33217"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb-tag?post=33217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}