{"id":20501,"date":"2025-03-07T10:36:30","date_gmt":"2025-03-07T03:36:30","guid":{"rendered":"\/amis-kho-hang\/?post_type=ht_kb&#038;p=20501"},"modified":"2026-04-20T14:56:54","modified_gmt":"2026-04-20T07:56:54","slug":"nhap-khau-du-lieu-tu-excel","status":"publish","type":"ht_kb","link":"\/amis-kho-hang\/kb\/nhap-khau-du-lieu-tu-excel\/","title":{"rendered":"Nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb excel"},"content":{"rendered":"<h3 style=\"text-align: justify;\"><strong>1. T\u1ed5ng quan<\/strong><\/h3>\n<p style=\"text-align: justify;\">B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn v\u1ec1 c\u00e1ch <strong data-start=\"43\" data-end=\"73\">Nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb Excel<\/strong>, gi\u00fap ng\u01b0\u1eddi d\u00f9ng nhanh ch\u00f3ng \u0111\u01b0a d\u1eef li\u1ec7u danh m\u1ee5c, t\u1ed3n kho \u0111\u1ea7u k\u1ef3 v\u00e0 ch\u1ee9ng t\u1eeb v\u00e0o ph\u1ea7n m\u1ec1m.<\/p>\n<p style=\"text-align: justify;\"><strong>N\u1ed9i dung b\u00e0i vi\u1ebft bao g\u1ed3m:<\/strong><\/p>\n<ul style=\"list-style-type: disc; text-align: justify;\">\n<li>C\u00e1ch nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u v\u00e0o t\u1eeb Excel.<\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><strong>2. H\u01b0\u1edbng d\u1eabn th\u1ef1c hi\u1ec7n\u00a0<\/strong><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-family: Calibri, serif; font-size: 12pt;\"><span lang=\"en\"><div class=\"su-accordion su-u-trim\"><\/span><\/span><\/p>\n<p style=\"text-align: justify;\"><div class=\"su-accordion su-u-trim\"><\/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><strong>Nh\u1eadp kh\u1ea9u danh m\u1ee5c<\/strong><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> V\u00e0o menu <strong>Danh m\u1ee5c\\<\/strong> Ch\u1ecdn danh m\u1ee5c c\u1ea7n th\u1ef1c hi\u1ec7n khai b\u00e1o:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: disc;\">\n<li><strong>V\u1eadt t\u01b0 h\u00e0ng h\u00f3a<\/strong><\/li>\n<li><strong>V\u1ecb tr\u00ed v\u1eadt t\u01b0 h\u00e0ng h\u00f3a<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn ch\u1ee9c n\u0103ng <strong>Nh\u1eadp t\u1eeb excel<\/strong><\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-20861\" src=\"\/amis-kho-hang\/wp-content\/uploads\/2025\/03\/NK_3.png\" alt=\"\" width=\"1462\" height=\"514\" \/><\/p>\n<ul style=\"list-style-type: disc; text-align: justify;\">\n<li>Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd hi\u1ec3n th\u1ecb giao di\u1ec7n:<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-20865\" src=\"\/amis-kho-hang\/wp-content\/uploads\/2025\/03\/NK_4-1.png\" alt=\"\" width=\"1463\" height=\"615\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 3: <\/strong>Ch\u1ecdn <strong>t\u1ec7p ngu\u1ed3n<\/strong><\/p>\n<ul style=\"list-style-type: disc; text-align: justify;\">\n<li>Ch\u1ecdn file nh\u1eadp kh\u1ea9u <strong>t\u1eeb c\u00e1c file d\u1eef li\u1ec7u s\u1eb5n c\u00f3 tr\u00ean m\u00e1y t\u00ednh<\/strong> ho\u1eb7c <strong>c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu v\u1ec1 \u0111\u1ec3 t\u1ea1o file d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u<\/strong>.<\/li>\n<li>Ch\u1ecdn <strong>sheet c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp<\/strong> v\u00e0 <strong>l\u1ef1a ch\u1ecdn d\u00f2ng b\u1eaft \u0111\u1ea7u l\u1ea5y d\u1eef li\u1ec7u<\/strong>.<\/li>\n<li><strong>C\u00f3 3 l\u1ef1a ch\u1ecdn<\/strong> nh\u1eadp kh\u1ea9u th\u00f4ng tin:\n<ul>\n<li><strong>Th\u00eam m\u1edbi:<\/strong> S\u1ebd t\u1ea1o m\u1edbi c\u00e1c m\u00e3 trong danh m\u1ee5c VTHH, V\u1ecb tr\u00ed VTHH\u2026<\/li>\n<li><strong>C\u1eadp nh\u1eadt:<\/strong> S\u1ebd c\u1eadp nh\u1eadt, b\u1ed5 sung th\u00eam c\u00e1c th\u00f4ng tin c\u1ee7a c\u00e1c m\u00e3 \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o t\u1eeb tr\u01b0\u1edbc tr\u00ean danh m\u1ee5c.<\/li>\n<li><strong>Ghi \u0111\u00e8:<\/strong>\u00a0C\u1eadp nh\u1eadt d\u1eef li\u1ec7u theo th\u00f4ng tin m\u1edbi c\u1ee7a c\u00e1c m\u00e3 \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o t\u1eeb tr\u01b0\u1edbc tr\u00ean danh m\u1ee5c.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 4:<\/strong> \u1ea4n <strong>Ti\u1ebfp t\u1ee5c<\/strong><\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-20867\" src=\"\/amis-kho-hang\/wp-content\/uploads\/2025\/03\/NK_5.png\" alt=\"\" width=\"1336\" height=\"612\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 5: <\/strong>Gh\u00e9p<strong> d\u1eef li\u1ec7u<\/strong><\/p>\n<ul style=\"list-style-type: disc; text-align: justify;\">\n<li><strong>Tr\u01b0\u1eddng h\u1ee3p l\u1ea5y t\u1eeb file m\u1eabu<\/strong> th\u00ec ch\u01b0\u01a1ng tr\u00ecnh <strong>s\u1ebd t\u1ef1 \u0111\u1ed9ng gh\u00e9p c\u00e1c c\u1ed9t tr\u00ean file d\u1eef li\u1ec7u v\u00e0 c\u00e1c c\u1ed9t th\u00f4ng tin tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh<\/strong>:<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-20873\" src=\"\/amis-kho-hang\/wp-content\/uploads\/2025\/03\/NK_6-1.png\" alt=\"\" width=\"1346\" height=\"549\" \/><\/p>\n<ul style=\"list-style-type: disc; text-align: justify;\">\n<li><strong>Tr\u01b0\u1eddng h\u1ee3p l\u00e0 file t\u1ef1 t\u1ea1o<\/strong> kh\u00f4ng theo m\u1eabu ch\u01b0\u01a1ng tr\u00ecnh th\u00ec <strong>c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n gh\u00e9p c\u1ed9t th\u1ee7 c\u00f4ng<\/strong>:<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-20879\" src=\"\/amis-kho-hang\/wp-content\/uploads\/2025\/03\/NK_10.png\" alt=\"\" width=\"1340\" height=\"565\" \/><\/p>\n<p style=\"padding-left: 40px; text-align: justify;\"><em><strong>L\u01b0u \u00fd<\/strong>:<\/em><\/p>\n<ul style=\"list-style-type: disc; text-align: justify;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: disc;\">\n<li><em>T\u1ea1i d\u00f2ng\u00a0<strong>c\u00f3 t\u00edch ch\u1ecdn<\/strong>\u00a0\u201c<strong>B\u1eaft bu\u1ed9c gh\u00e9p c\u1ed9t v\u00e0 nh\u1eadp th\u00f4ng tin\u201d\u00a0<\/strong> th\u00ec ph\u1ea3i \u0111\u1ea3m b\u1ea3o c\u1ed9t tr\u00ean <strong>t\u1ec7p excel t\u01b0\u01a1ng \u1ee9ng c\u00f3 nh\u1eadp \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin<\/strong> li\u00ean quan.<\/em><\/li>\n<li><em>N\u1ebfu\u00a0<strong>kh\u00f4ng t\u00edch ch\u1ecdn<\/strong>\u00a0\u201c<strong>B\u1eaft bu\u1ed9c gh\u00e9p c\u1ed9t v\u00e0 nh\u1eadp th\u00f4ng tin\u201d<\/strong>, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd l\u1ea5y th\u00f4ng tin <strong>ng\u1ea7m \u0111\u1ecbnh<\/strong> ho\u1eb7c <strong>\u0111\u1ec3 tr\u1ed1ng theo y\u00eau c\u1ea7u c\u1ee7a t\u1eebng tr\u01b0\u1eddng d\u1eef li\u1ec7u<\/strong> theo t\u1eebng danh m\u1ee5c, ch\u1ee9ng t\u1eeb.<\/em><\/li>\n<\/ul>\n<\/li>\n<li><strong>Tr\u01b0\u1eddng h\u1ee3p mong mu\u1ed1n l\u1ea5y th\u00eam ho\u1eb7c b\u1ecf b\u1edbt c\u00e1c th\u00f4ng tin<\/strong> tr\u00ean c\u00e1c m\u00e3 danh m\u1ee5c c\u1ea7n nh\u1eadp kh\u1ea9u th\u00ec c\u00f3 th\u1ec3 ch\u1ecdn <strong>\u1ea8n\/hi\u1ec7n th\u00f4ng tin <\/strong>v\u00e0 t\u00edch ch\u1ecdn \u1ea8n\/hi\u1ec7n th\u00f4ng tin t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><em><strong>L\u01b0u \u00fd:<\/strong> Trong qu\u00e1 tr\u00ecnh nh\u1eadp kh\u1ea9u c\u00f3 c\u1ed9t th\u00f4ng tin tr\u00ean file excel nh\u01b0ng kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c c\u1ed9t th\u00f4ng tin \u0111\u00f3 tr\u00ean ph\u1ea7n m\u1ec1m \u0111\u1ec3 gh\u00e9p th\u00ec r\u1ea5t c\u00f3 th\u1ec3 c\u1ed9t th\u00f4ng tin \u0111\u00e3 b\u1ecb \u1ea9n \u0111i. C\u1ea7n truy c\u1eadp ph\u1ea7n \u1ea8n\/hi\u1ec7n th\u00f4ng tin t\u00edch l\u00ean v\u00e0 gh\u00e9p.<\/em><\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-20871\" src=\"\/amis-kho-hang\/wp-content\/uploads\/2025\/03\/NK_7.png\" alt=\"\" width=\"1338\" height=\"887\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 6:\u00a0Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong><\/p>\n<ul style=\"list-style-type: disc; text-align: justify;\">\n<li>Ch\u01b0\u01a1ng tr\u00ecnh <strong>s\u1ebd ki\u1ec3m tra to\u00e0n b\u1ed9 d\u1eef li\u1ec7u<\/strong> trong <strong>c\u00e1c c\u1ed9t v\u1edbi d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed3n t\u1ea1i<\/strong> tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh v\u00e0 <strong>hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o<\/strong>:<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-20875\" src=\"\/amis-kho-hang\/wp-content\/uploads\/2025\/03\/NK_8.png\" alt=\"\" width=\"1339\" height=\"740\" \/><\/p>\n<ul style=\"list-style-type: disc; text-align: justify;\">\n<li>Khi \u0111\u00f3 c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn:\n<ul>\n<li>Nh\u1ea5n\u00a0<strong>Th\u1ef1c hi\u1ec7n<\/strong>: ch\u01b0\u01a1ng tr\u00ecnh <strong>s\u1ebd b\u1ecf qua c\u00e1c m\u00e3 kh\u00f4ng h\u1ee3p l\u1ec7 v\u00e0 ch\u1ec9 nh\u1eadp l\u00ean h\u1ec7 th\u1ed1ng<\/strong> c\u00e1c m\u00e3 c\u00f3 <strong>t\u00ecnh tr\u1ea1ng h\u1ee3p l\u1ec7<\/strong>.<\/li>\n<li><strong>Ki\u1ec3m tra th\u00f4ng tin chi ti\u1ebft l\u1ed7i<\/strong> tr\u00ean giao di\u1ec7n ho\u1eb7c t\u1ea3i file k\u1ebft qu\u1ea3 \u0111\u1ec3 ki\u1ec3m tra l\u1ea1i. Sau \u0111\u00f3 <strong>c\u00f3 th\u1ec3 quay l\u1ea1i b\u01b0\u1edbc 1 \u0111\u1ec3 c\u1eadp nh\u1eadt l\u1ea1i file nh\u1eadp kh\u1ea9u<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 7:<\/strong> Ch\u01b0\u01a1ng tr\u00ecnh <strong>s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u00e1c m\u00e3 \u0111\u00e3 nh\u1eadp th\u00e0nh c\u00f4ng<\/strong> ho\u1eb7c <strong>kh\u00f4ng th\u00e0nh c\u00f4ng<\/strong> d\u1ef1a theo k\u1ebft qu\u1ea3 ki\u1ec3m tra.<\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-20877\" src=\"\/amis-kho-hang\/wp-content\/uploads\/2025\/03\/NK_9.png\" alt=\"\" width=\"1344\" height=\"734\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 8:<\/strong> Nh\u1ea5n <strong>\u0110\u00f3ng\u00a0<\/strong>ho\u1eb7c nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u\u00a0<strong>X<\/strong>\u00a0\u0111\u1ec3 ho\u00e0n th\u00e0nh nh\u1eadp kh\u1ea9u danh m\u1ee5c.<\/p>\n<p style=\"text-align: justify;\"><\/div><\/div>\n<p style=\"text-align: justify;\"><span style=\"font-family: Calibri, serif; font-size: 12pt;\"><span lang=\"vi-VN\"><\/div><\/span><\/span><\/p>\n<p style=\"text-align: justify;\"><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><strong>Nh\u1eadp kh\u1ea9u t\u1ed3n kho \u0111\u1ea7u k\u1ef3<\/strong><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> V\u00e0o menu <strong>H\u1ec7 th\u1ed1ng<\/strong>\\ Nh\u00f3m<strong> Ti\u1ec7n \u00edch\\ <\/strong>Ch\u1ecdn<strong>\u00a0T\u1ed3n kho \u0111\u1ea7u k\u1ef3<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> T\u1ea1i \u0111\u00e2y, ch\u1ecdn ch\u1ee9c n\u0103ng <strong>Nh\u1eadp t\u1eeb excel.<\/strong><\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" src=\"https:\/\/helpamis.misa.vn\/amis-kho-hang\/wp-content\/uploads\/2025\/03\/Tonkho_2.png\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 3: <\/strong>Ch\u1ecdn<strong> t\u1ec7p ngu\u1ed3n<\/strong>:<\/p>\n<ul style=\"list-style-type: disc; text-align: justify;\">\n<li>Ch\u1ecdn file nh\u1eadp kh\u1ea9u <strong>t\u1eeb c\u00e1c file d\u1eef li\u1ec7u s\u1eb5n c\u00f3 tr\u00ean m\u00e1y t\u00edn<\/strong>h ho\u1eb7c <strong>c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu v\u1ec1<\/strong> <strong>\u0111\u1ec3 t\u1ea1o file d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u<\/strong>.<\/li>\n<li>Ch\u1ecdn <strong>sheet c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp<\/strong> v\u00e0 <strong>l\u1ef1a ch\u1ecdn d\u00f2ng b\u1eaft \u0111\u1ea7u l\u1ea5y d\u1eef li\u1ec7u<\/strong>.<\/li>\n<li>Ph\u01b0\u01a1ng ph\u00e1p<strong> nh\u1eadp d\u1eef li\u1ec7u<\/strong> m\u1eb7c \u0111\u1ecbnh l\u00e0 <strong>Th\u00eam m\u1edbi.<\/strong><\/li>\n<li>C\u00f3 th\u1ec3 t\u00edch ch\u1ecdn &#8220;<strong>C\u1ed9ng g\u1ed9p c\u00e1c m\u1eb7t h\u00e0ng tr\u00f9ng nhau<\/strong>&#8221; ph\u1ea7n m\u1ec1m<strong> t\u1ef1 \u0111\u1ed9ng c\u1ed9ng s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a c\u00e1c d\u00f2ng v\u1eadt t\u01b0 gi\u1ed1ng nhau<\/strong> khi nh\u1eadp t\u1eeb Excel.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 4:<\/strong> Sau khi \u0111\u00e3 l\u1ef1a ch\u1ecdn xong, nh\u1ea5n <strong>Ti\u1ebfp t\u1ee5c<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 5:<\/strong>\u00a0<strong>Gh\u00e9p d\u1eef li\u1ec7u<\/strong>: C\u1ea7n gh\u00e9p \u0111\u01b0\u1ee3c c\u00e1c c\u1ed9t d\u1eef li\u1ec7u tr\u00ean<strong> file nh\u1eadp kh\u1ea9u v\u00e0 tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh.<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 6:<\/strong>\u00a0<strong>Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong>: Ch\u01b0\u01a1ng tr\u00ecnh<strong> s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u1eef li\u1ec7u h\u1ee3p l\u1ec7 ho\u1eb7c kh\u00f4ng h\u1ee3p l<\/strong>\u1ec7 tr\u00ean file d\u1eef li\u1ec7u \u0111\u1ec3 <strong>c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh<\/strong> ho\u1eb7c <strong>ti\u1ebfn h\u00e0nh nh\u1eadp d\u1eef li\u1ec7u lu\u00f4n<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><\/div><\/div>\n<p style=\"text-align: justify;\"><span style=\"font-family: Calibri, serif; font-size: 12pt;\"><span lang=\"vi-VN\"><\/div><\/span><\/span><\/p>\n<p style=\"text-align: justify;\"><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><strong>Nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb<\/strong><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn <strong>ph\u00e2n h\u1ec7 c\u1ea7n th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> T\u1ea1i danh s\u00e1ch <strong>lo\u1ea1i ch\u1ee9ng t\u1eeb c\u1ea7n nh\u1eadp kh\u1ea9u<\/strong> (L\u1ec7nh nh\u1eadp kho, L\u1ec7nh xu\u1ea5t kho, Phi\u1ebfu \u0111i\u1ec1u chuy\u1ec3n)\\ Ch\u1ecdn ch\u1ee9c n\u0103ng <strong>Nh\u1eadp t\u1eeb excel.<\/strong><\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-21295\" src=\"\/amis-kho-hang\/wp-content\/uploads\/2025\/03\/NK_11.png\" alt=\"\" width=\"1181\" height=\"486\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 3:\u00a0Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/strong>:<\/p>\n<ul style=\"list-style-type: disc; text-align: justify;\">\n<li>Ch\u1ecdn file nh\u1eadp kh\u1ea9u <strong>t\u1eeb c\u00e1c file d\u1eef li\u1ec7u s\u1eb5n c\u00f3 tr\u00ean m\u00e1y t\u00ednh<\/strong> ho\u1eb7c <strong>c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu v\u1ec1 \u0111\u1ec3 t\u1ea1o file d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u<\/strong>.<\/li>\n<li>Ch\u1ecdn <strong>sheet c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp<\/strong> v\u00e0 <strong>l\u1ef1a ch\u1ecdn d\u00f2ng b\u1eaft \u0111\u1ea7u l\u1ea5y d\u1eef li\u1ec7u<\/strong>.<\/li>\n<li>Ph\u01b0\u01a1ng ph\u00e1p<strong> nh\u1eadp d\u1eef li\u1ec7u<\/strong> m\u1eb7c \u0111\u1ecbnh l\u00e0 <strong>Th\u00eam m\u1edbi.<\/strong><\/li>\n<li>\u0110\u1ed1i v\u1edbi L\u1ec7nh nh\u1eadp kho, L\u1ec7nh xu\u1ea5t kho: C\u00f3 th\u1ec3 t\u00edch ch\u1ecdn &#8220;<strong>C\u1ed9ng g\u1ed9p c\u00e1c m\u1eb7t h\u00e0ng tr\u00f9ng nhau<\/strong>&#8221; ph\u1ea7n m\u1ec1m t<strong>\u1ef1 \u0111\u1ed9ng c\u1ed9ng s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a c\u00e1c d\u00f2ng v\u1eadt t\u01b0 gi\u1ed1ng nhau<\/strong> khi nh\u1eadp t\u1eeb Excel.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 4:<\/strong> Sau khi \u0111\u00e3 l\u1ef1a ch\u1ecdn xong, nh\u1ea5n <strong>Ti\u1ebfp t\u1ee5c.<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 5:<\/strong>\u00a0<strong>Gh\u00e9p d\u1eef li\u1ec7u<\/strong>: C\u1ea7n gh\u00e9p \u0111\u01b0\u1ee3c c\u00e1c c\u1ed9t d\u1eef li\u1ec7u tr\u00ean f<strong>ile nh\u1eadp kh\u1ea9u v\u00e0 tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh.<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 6:<\/strong>\u00a0<strong>Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong>: Ch\u01b0\u01a1ng tr\u00ecnh <strong>s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u1eef li\u1ec7u h\u1ee3p l\u1ec7 ho\u1eb7c kh\u00f4ng h\u1ee3p l\u1ec7<\/strong> tr\u00ean file d\u1eef li\u1ec7u \u0111\u1ec3 <strong>c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh<\/strong> ho\u1eb7c <strong>ti\u1ebfn h\u00e0nh nh\u1eadp d\u1eef li\u1ec7u lu\u00f4n<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone wp-image-23643 size-full\" style=\"border-width: 1px; border-style: groove;\" src=\"\/amis-kho-hang\/wp-content\/uploads\/2025\/03\/17.gif\" alt=\"\" width=\"1505\" height=\"903\" \/><\/p>\n<p><em><strong>L\u01b0u \u00fd:<\/strong> Anh\/ch\u1ecb c\u00f3 th\u1ec3 nh\u1eadp kh\u1ea9u nhanh t\u1eeb excel b\u1ea3ng h\u00e0ng h\u00f3a trong phi\u1ebfu ki\u1ec3m k\u00ea theo s\u1ed1 l\u00f4, h\u1ea1n s\u1eed d\u1ee5ng; Phi\u1ebfu ki\u1ec3m k\u00ea theo v\u1ecb tr\u00ed v\u00e0 s\u1ed1 l\u00f4, h\u1ea1n s\u1eed d\u1ee5ng b\u1eb1ng c\u00e1ch ch\u1ecdn ch\u1ee9c n\u0103ng <strong>Nh\u1eadp k\u1ebft qu\u1ea3 t\u1eeb Excel<\/strong> trong chi ti\u1ebft ch\u1ee9ng t\u1eeb.<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/helpamis.misa.vn\/amis-kho-hang\/wp-content\/uploads\/2026\/03\/KK_1.jpg\" \/><\/p>\n<p style=\"text-align: justify;\"><\/div><\/div>\n<p style=\"text-align: justify;\"><span style=\"font-family: Calibri, serif; font-size: 12pt;\"><span lang=\"vi-VN\"><\/div><\/span><\/span><\/p>\n<p style=\"text-align: justify;\">\n","protected":false},"excerpt":{"rendered":"<p>1. T\u1ed5ng quan B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn v\u1ec1 c\u00e1ch Nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb Excel, gi\u00fap ng\u01b0\u1eddi d\u00f9ng nhanh ch\u00f3ng \u0111\u01b0a d\u1eef li\u1ec7u danh m\u1ee5c, t\u1ed3n kho \u0111\u1ea7u k\u1ef3 v\u00e0 ch\u1ee9ng t\u1eeb v\u00e0o ph\u1ea7n m\u1ec1m. N\u1ed9i dung b\u00e0i vi\u1ebft bao g\u1ed3m: C\u00e1ch nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u v\u00e0o t\u1eeb Excel. 2&#8230;.<\/p>\n","protected":false},"author":107,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[207],"ht-kb-tag":[],"class_list":["post-20501","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-khac"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb excel - AMIS Kho h\u00e0ng<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"\/amis-kho-hang\/kb\/nhap-khau-du-lieu-tu-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb excel - AMIS Kho h\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"1. T\u1ed5ng quan B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn v\u1ec1 c\u00e1ch Nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb Excel, gi\u00fap ng\u01b0\u1eddi d\u00f9ng nhanh ch\u00f3ng \u0111\u01b0a d\u1eef li\u1ec7u danh m\u1ee5c, t\u1ed3n kho \u0111\u1ea7u k\u1ef3 v\u00e0 ch\u1ee9ng t\u1eeb v\u00e0o ph\u1ea7n m\u1ec1m. N\u1ed9i dung b\u00e0i vi\u1ebft bao g\u1ed3m: C\u00e1ch nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u v\u00e0o t\u1eeb Excel. 2....\" \/>\n<meta property=\"og:url\" content=\"\/amis-kho-hang\/kb\/nhap-khau-du-lieu-tu-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"AMIS Kho h\u00e0ng\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-20T07:56:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/helpamis.misa.vn\/amis-kho-hang\/wp-content\/uploads\/2025\/03\/Tonkho_2.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"8 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb excel - AMIS Kho h\u00e0ng","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"\/amis-kho-hang\/kb\/nhap-khau-du-lieu-tu-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"Nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb excel - AMIS Kho h\u00e0ng","og_description":"1. T\u1ed5ng quan B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn v\u1ec1 c\u00e1ch Nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb Excel, gi\u00fap ng\u01b0\u1eddi d\u00f9ng nhanh ch\u00f3ng \u0111\u01b0a d\u1eef li\u1ec7u danh m\u1ee5c, t\u1ed3n kho \u0111\u1ea7u k\u1ef3 v\u00e0 ch\u1ee9ng t\u1eeb v\u00e0o ph\u1ea7n m\u1ec1m. N\u1ed9i dung b\u00e0i vi\u1ebft bao g\u1ed3m: C\u00e1ch nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u v\u00e0o t\u1eeb Excel. 2....","og_url":"\/amis-kho-hang\/kb\/nhap-khau-du-lieu-tu-excel\/","og_site_name":"AMIS Kho h\u00e0ng","article_modified_time":"2026-04-20T07:56:54+00:00","og_image":[{"url":"https:\/\/helpamis.misa.vn\/amis-kho-hang\/wp-content\/uploads\/2025\/03\/Tonkho_2.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"\/amis-kho-hang\/kb\/nhap-khau-du-lieu-tu-excel\/","url":"\/amis-kho-hang\/kb\/nhap-khau-du-lieu-tu-excel\/","name":"Nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb excel - AMIS Kho h\u00e0ng","isPartOf":{"@id":"\/amis-kho-hang\/#website"},"datePublished":"2025-03-07T03:36:30+00:00","dateModified":"2026-04-20T07:56:54+00:00","breadcrumb":{"@id":"\/amis-kho-hang\/kb\/nhap-khau-du-lieu-tu-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["\/amis-kho-hang\/kb\/nhap-khau-du-lieu-tu-excel\/"]}]},{"@type":"BreadcrumbList","@id":"\/amis-kho-hang\/kb\/nhap-khau-du-lieu-tu-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"\/amis-kho-hang\/"},{"@type":"ListItem","position":2,"name":"Nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb excel"}]}]}},"_links":{"self":[{"href":"\/amis-kho-hang\/wp-json\/wp\/v2\/ht-kb\/20501","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/amis-kho-hang\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/amis-kho-hang\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/amis-kho-hang\/wp-json\/wp\/v2\/users\/107"}],"replies":[{"embeddable":true,"href":"\/amis-kho-hang\/wp-json\/wp\/v2\/comments?post=20501"}],"version-history":[{"count":5,"href":"\/amis-kho-hang\/wp-json\/wp\/v2\/ht-kb\/20501\/revisions"}],"predecessor-version":[{"id":25503,"href":"\/amis-kho-hang\/wp-json\/wp\/v2\/ht-kb\/20501\/revisions\/25503"}],"wp:attachment":[{"href":"\/amis-kho-hang\/wp-json\/wp\/v2\/media?parent=20501"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/amis-kho-hang\/wp-json\/wp\/v2\/ht-kb-category?post=20501"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/amis-kho-hang\/wp-json\/wp\/v2\/ht-kb-tag?post=20501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}