{"id":32323,"date":"2023-09-18T16:38:50","date_gmt":"2023-09-18T09:38:50","guid":{"rendered":"http:\/\/helpsme.misa.vn\/2023\/?post_type=ht_kb&#038;p=32323"},"modified":"2025-11-03T09:22:02","modified_gmt":"2025-11-03T02:22:02","slug":"toi-nhap-khau-tu-excel-nhung-thong-tin-can-nhap-khau-khong-co-cot-san-tren-file-excel-lam-the-nao","status":"publish","type":"ht_kb","link":"https:\/\/helpsme.misa.vn\/2023\/kb\/toi-nhap-khau-tu-excel-nhung-thong-tin-can-nhap-khau-khong-co-cot-san-tren-file-excel-lam-the-nao\/","title":{"rendered":"T\u00f4i nh\u1eadp kh\u1ea9u t\u1eeb excel nh\u01b0ng th\u00f4ng tin c\u1ea7n nh\u1eadp kh\u1ea9u kh\u00f4ng c\u00f3 c\u1ed9t s\u1eb5n tr\u00ean file excel l\u00e0m th\u1ebf n\u00e0o?"},"content":{"rendered":"<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>1. T\u1ed5ng quan<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p style=\"text-align: justify;\"><strong>M\u1ee5c \u0111\u00edch:<\/strong> B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn c\u00e1ch b\u1ed5 sung v\u00e0 gh\u00e9p c\u00e1c c\u1ed9t th\u00f4ng tin ch\u01b0a c\u00f3 s\u1eb5n tr\u00ean file Excel m\u1eabu khi nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u v\u00e0o ph\u1ea7n m\u1ec1m, gi\u00fap \u0111\u1ea3m b\u1ea3o \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin c\u1ea7n thi\u1ebft cho ch\u1ee9ng t\u1eeb.<\/p>\n<p style=\"text-align: justify;\"><strong>N\u1ed9i dung b\u00e0i vi\u1ebft g\u1ed3m:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>C\u00e1ch th\u00eam c\u1ed9t th\u00f4ng tin m\u1edbi v\u00e0o file Excel m\u1eabu<\/li>\n<li>H\u01b0\u1edbng d\u1eabn gh\u00e9p d\u1eef li\u1ec7u gi\u1eefa file Excel v\u00e0 ph\u1ea7n m\u1ec1m<\/li>\n<li>L\u01b0u \u00fd v\u1ec1 t\u00ean c\u1ed9t v\u00e0 thao t\u00e1c hi\u1ec3n th\u1ecb khi nh\u1eadp kh\u1ea9u<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/strong>\u00a0D\u00e0nh cho ng\u01b0\u1eddi d\u00f9ng nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb t\u1eeb Excel v\u00e0o ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n.<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p style=\"text-align: justify;\">Khi nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb t\u1eeb excel nh\u01b0ng c\u00f3 nh\u1eefng th\u00f4ng tin c\u1ea7n theo d\u00f5i tr\u00ean file m\u1eabu excel kh\u00f4ng c\u00f3 s\u1eb5n \u0111\u1ec3 \u0111i\u1ec1n th\u00f4ng tin<\/p>\n<p style=\"text-align: justify;\">V\u00ed d\u1ee5: Nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb mua h\u00e0ng kh\u00f4ng qua kho, mu\u1ed1n th\u1ed1ng k\u00ea nh\u1eadp c\u1ed9t c\u00f4ng tr\u00ecnh nh\u01b0ng tr\u00ean file m\u1eabu t\u1ea3i v\u1ec1 kh\u00f4ng c\u00f3 tr\u01b0\u1eddng \u0111\u1ec3 nh\u1eadp.<\/p>\n<p>B\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Tr\u00ean file m\u1eabu excel \u0111\u01a1n v\u1ecb ch\u1ee7 \u0111\u1ed9ng th\u1ef1c hi\u1ec7n th\u00eam c\u1ed9t <strong>C\u00f4ng tr\u00ecnh\u00a0<\/strong>tr\u00ean file excel m\u1eabu<\/p>\n<ul style=\"list-style-type: circle;\">\n<li>\u0110i\u1ec1n th\u00f4ng tin c\u1ea7n nh\u1eadp kh\u1ea9u v\u00e0o c\u1ed9t t\u01b0\u01a1ng \u1ee9ng<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-32326 size-full\" src=\"\/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-18-50.png\" alt=\"\" width=\"816\" height=\"218\" srcset=\"\/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-18-50.png 816w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-18-50-700x187.png 700w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-18-50-800x214.png 800w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-18-50-768x205.png 768w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-18-50-50x13.png 50w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-18-50-60x16.png 60w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-18-50-100x27.png 100w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><\/p>\n<ul style=\"list-style-type: circle;\">\n<li>Khi nh\u1eadp kh\u1ea9u, \u0111\u01a1n v\u1ecb th\u1ef1c hi\u1ec7n thao t\u00e1c nh\u01b0 nh\u1eadp kh\u1ea9u excel th\u00f4ng th\u01b0\u1eddng t\u01b0\u01a1ng t\u1ef1 h\u01b0\u1edbng d\u1eabn <a href=\"https:\/\/helpsme.misa.vn\/2023\/kb\/html_10050000\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y<\/a>.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: T\u1ea1i b\u01b0\u1edbc <strong>Gh\u00e9p d\u1eef li\u1ec7u<\/strong> n\u1ebfu c\u1ed9t v\u1eeba th\u00eam kh\u00f4ng hi\u1ec3n th\u1ecb tr\u00ean giao di\u1ec7n, ch\u1ecdn <strong>\u1ea8n hi\u1ec7n th\u00f4ng tin<\/strong>\\<strong>Th\u00f4ng tin chi ti\u1ebft ho\u1eb7c Th\u00f4ng tin chung<\/strong>\\k\u00e9o chu\u1ed9t t\u00ecm \u0111\u1ebfn c\u1ed9t c\u1ea7n hi\u1ec3n th\u1ecb t\u00edch hi\u1ec3n th\u1ecb\\ nh\u1ea5n <strong>\u0110\u1ed3ng \u00fd<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-32330 size-full\" src=\"\/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-29-06.png\" alt=\"\" width=\"1186\" height=\"704\" srcset=\"\/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-29-06.png 1186w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-29-06-700x416.png 700w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-29-06-800x475.png 800w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-29-06-768x456.png 768w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-29-06-50x30.png 50w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-29-06-60x36.png 60w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-29-06-100x59.png 100w\" sizes=\"auto, (max-width: 1186px) 100vw, 1186px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 3:<\/strong> Th\u1ef1c hi\u1ec7n gh\u00e9p c\u1ed9t tr\u00ean file m\u1eabu v\u00e0 c\u1ed9t tr\u00ean ph\u1ea7n m\u1ec1m b\u1eb1ng c\u00e1ch ch\u1ecdn \u0111\u00fang th\u00f4ng tin c\u1ed9t tr\u00ean file m\u1eabu t\u1ea1i <strong>C\u1ed9t tr\u00ean t\u1ec7p d\u1eef li\u1ec7u<\/strong><\/p>\n<ul style=\"list-style-type: circle;\">\n<li style=\"text-align: justify;\">N\u1ebfu tr\u00ean file m\u1eabu, c\u1ed9t m\u1edbi th\u00eam \u0111i\u1ec1n gi\u1ed1ng t\u00ean c\u1ed9t tr\u00ean ph\u1ea7n m\u1ec1m th\u00ec t\u1ea1i b\u01b0\u1edbc n\u00e0y ph\u1ea7n m\u1ec1m s\u1ebd t\u1ef1 l\u1ea5y \u0111\u00fang th\u00f4ng tin<\/li>\n<li style=\"text-align: justify;\">N\u1ebfu tr\u00ean file m\u1eabu, c\u1ed9t m\u1edbi th\u00eam \u0111\u1eb7t t\u00ean kh\u00e1c tr\u00ean ph\u1ea7n m\u1ec1m th\u00ec \u0111\u01a1n v\u1ecb ch\u1ee7 \u0111\u1ed9ng ch\u1ecdn l\u1ea1i \u0111\u00fang th\u00f4ng tin c\u1ed9t c\u1ea7n gh\u00e9p<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-32331 size-full\" src=\"\/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-32-05.png\" alt=\"\" width=\"924\" height=\"699\" srcset=\"\/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-32-05.png 924w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-32-05-700x530.png 700w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-32-05-800x605.png 800w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-32-05-768x581.png 768w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-32-05-50x38.png 50w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-32-05-60x45.png 60w, \/2023\/wp-content\/uploads\/2023\/09\/2023-09-18_16-32-05-100x76.png 100w\" sizes=\"auto, (max-width: 924px) 100vw, 924px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Nh\u1ea5n <strong>Ti\u1ebfp theo <\/strong>v\u00e0 th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u ti\u1ebfp t\u1ee5c nh\u01b0 th\u00f4ng th\u01b0\u1eddng.<\/p>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":128,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[3359],"ht-kb-tag":[4829,4831],"class_list":["post-32323","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cau-hoi-thuong-gap-chung-2","ht_kb_tag-nhap-khau-excel","ht_kb_tag-them-cot-thong-tin"],"_links":{"self":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/32323","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/users\/128"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/comments?post=32323"}],"version-history":[{"count":4,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/32323\/revisions"}],"predecessor-version":[{"id":50525,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/32323\/revisions\/50525"}],"wp:attachment":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/media?parent=32323"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-category?post=32323"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-tag?post=32323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}