{"id":19301,"date":"2025-09-17T15:52:34","date_gmt":"2025-09-17T08:52:34","guid":{"rendered":"\/amis-san-xuat\/?post_type=ht_kb&p=19301"},"modified":"2025-11-18T11:41:03","modified_gmt":"2025-11-18T04:41:03","slug":"nhap-khau-du-lieu-tu-excel","status":"publish","type":"ht_kb","link":"\/amis-san-xuat\/kb\/nhap-khau-du-lieu-tu-excel\/","title":{"rendered":"Nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb Excel"},"content":{"rendered":"

1. T\u1ed5ng quan<\/strong><\/h3>\n
Ch\u01b0\u01a1ng tr\u00ecnh cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng nh\u1eadp nhanh d\u1eef li\u1ec7u t\u1eeb t\u1ec7p Excel v\u00e0o ph\u1ea7n m\u1ec1m.<\/p>\n
2. H\u01b0\u1edbng d\u1eabn chi ti\u1ebft<\/strong><\/h3>\n
<\/span><\/p>\n
Nh\u1eadp kh\u1ea9u danh m\u1ee5c<\/strong><\/h4>\n
<\/div>
\n
1. V\u00e0o menu Danh m\u1ee5c<\/strong>, ch\u1ecdn danh m\u1ee5c c\u1ea7n th\u1ef1c hi\u1ec7n khai b\u00e1o (Vd: V\u1eadt t\u01b0 h\u00e0ng h\u00f3a, Nh\u00f3m v\u1eadt t\u01b0 h\u00e0ng h\u00f3a, nguy\u00ean v\u1eadt li\u1ec7u thay th\u1ebf,Ti\u00eau ch\u00ed ch\u1ea5t l\u01b0\u1ee3ng,…).<\/em><\/p>\n
2. Ch\u1ecdn ch\u1ee9c n\u0103ng Nh\u1eadp t\u1eeb excel<\/strong><\/p>\n
$\"\"$ <\/p>\n
3. Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd hi\u1ec3n th\u1ecb giao di\u1ec7n:<\/p>\n
$\"\"$ <\/p>\n
B\u01b0\u1edbc 1:<\/u>\u00a0Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/strong><\/h5>\n
\n
Anh\/ch\u1ecb ch\u1ecdn file nh\u1eadp kh\u1ea9u t\u1eeb c\u00e1c file d\u1eef li\u1ec7u s\u1eb5n c\u00f3 tr\u00ean m\u00e1y t\u00ednh ho\u1eb7c c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu v\u1ec1 \u0111\u1ec3 t\u1ea1o file d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u<\/li>\n
Ch\u1ecdn sheet c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp v\u00e0 l\u1ef1a ch\u1ecdn d\u00f2ng b\u1eaft \u0111\u1ea7u l\u1ea5y d\u1eef li\u1ec7u.<\/li>\n
Ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u: Th\u00eam m\u1edbi d\u1eef li\u1ec7u ch\u01b0a c\u00f3, kh\u00f4ng c\u1eadp nh\u1eadt d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed3n t\u1ea1i.<\/li>\n<\/ol>\n
$\"\"$ <\/p>\n
B\u01b0\u1edbc 2:<\/u>\u00a0Gh\u00e9p d\u1eef li\u1ec7u<\/strong><\/h5>\n
1. Tr\u01b0\u1eddng h\u1ee3p l\u1ea5y t\u1eeb file m\u1eabu th\u00ec ch\u01b0\u01a1ng tr\u00ecnh 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.<\/p>\n
2. Tr\u01b0\u1eddng h\u1ee3p l\u00e0 file do ng\u01b0\u1eddi d\u00f9ng t\u1ef1 t\u1ea1o kh\u00f4ng theo m\u1eabu ch\u01b0\u01a1ng tr\u00ecnh th\u00ec ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n gh\u00e9p c\u1ed9t th\u1ee7 c\u00f4ng.<\/p>\n
3. Nh\u1ea5n Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 chuy\u1ec3n sang b\u01b0\u1edbc ti\u1ebfp theo.<\/p>\n
$\"\"$ <\/p>\n
L\u01b0u \u00fd<\/strong>:<\/em><\/p>\n
\n
T\u1ea1i d\u00f2ng\u00a0c\u00f3 t\u00edch ch\u1ecdn<\/strong>\u00a0\u201cB\u1eaft bu\u1ed9c gh\u00e9p c\u1ed9t v\u00e0 nh\u1eadp th\u00f4ng tin\u201d\u00a0<\/strong>\u00a0th\u00ec ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i \u0111\u1ea3m b\u1ea3o c\u1ed9t tr\u00ean t\u1ec7p excel t\u01b0\u01a1ng \u1ee9ng c\u00f3 nh\u1eadp \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin li\u00ean quan.<\/em><\/li>\n
N\u1ebfu\u00a0kh\u00f4ng t\u00edch ch\u1ecdn<\/strong>\u00a0\u201cB\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 ng\u1ea7m \u0111\u1ecbnh ho\u1eb7c \u0111\u1ec3 tr\u1ed1ng theo y\u00eau c\u1ea7u c\u1ee7a t\u1eebng tr\u01b0\u1eddng d\u1eef li\u1ec7u theo t\u1eebng danh m\u1ee5c, ch\u1ee9ng t\u1eeb.<\/em><\/li>\n<\/ul>\n
4. Tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1eddi d\u00f9ng mong mu\u1ed1n l\u1ea5y th\u00eam ho\u1eb7c b\u1ecf b\u1edbt c\u00e1c th\u00f4ng tin tr\u00ean c\u00e1c m\u00e3 danh m\u1ee5c c\u1ea7n nh\u1eadp kh\u1ea9u th\u00ec c\u00f3 th\u1ec3 ch\u1ecdn \u1ea8n\/hi\u1ec7n th\u00f4ng tin <\/strong>v\u00e0 t\u00edch ch\u1ecdn \u1ea8n\/hi\u1ec7n th\u00f4ng tin t\u01b0\u01a1ng \u1ee9ng.<\/p>\n
$\"\"$ <\/p>\n
B\u01b0\u1edbc 3:<\/u>\u00a0Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong><\/h5>\n
1. Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd ki\u1ec3m tra to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t v\u1edbi d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh v\u00e0 hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o cho ng\u01b0\u1eddi d\u00f9ng n\u1eafm \u0111\u01b0\u1ee3c:<\/p>\n
$\"\"$ <\/p>\n
2. Khi \u0111\u00f3 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn:<\/p>\n
\n
Nh\u1ea5n\u00a0Th\u1ef1c hi\u1ec7n<\/strong>: ch\u01b0\u01a1ng tr\u00ecnh 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 c\u00e1c m\u00e3 c\u00f3 t\u00ecnh tr\u1ea1ng h\u1ee3p l\u1ec7.<\/li>\n
Ki\u1ec3m tra th\u00f4ng tin chi ti\u1ebft l\u1ed7i tr\u00ean giao di\u1ec7n ho\u1eb7c t\u1ea3i file k\u1ebft qu\u1ea3 \u0111\u1ec3 ki\u1ec3m tra l\u1ea1i. Sau \u0111\u00f3 NSD c\u00f3 th\u1ec3 quay l\u1ea1i b\u01b0\u1edbc 1 \u0111\u1ec3 c\u1eadp nh\u1eadt l\u1ea1i file nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n
3. Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u00e1c m\u00e3 \u0111\u00e3 nh\u1eadp th\u00e0nh c\u00f4ng ho\u1eb7c kh\u00f4ng th\u00e0nh c\u00f4ng d\u1ef1a theo k\u1ebft qu\u1ea3 ki\u1ec3m tra<\/p>\n
$\"\"$ <\/p>\n
4. Nh\u1ea5n \u0110\u00f3ng\u00a0<\/strong>ho\u1eb7c nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u\u00a0X<\/strong>\u00a0\u0111\u1ec3 ho\u00e0n th\u00e0nh nh\u1eadp kh\u1ea9u danh m\u1ee5c.<\/p>\n
5. N\u1ebfu c\u1ea7n anh ch\u1ecb c\u00f3 th\u1ec3 nh\u1ea5n “T\u1ea3i t\u1ec7p ki\u1ec3m tra<\/strong>” \u0111\u1ec3 xem l\u1ea1i chi ti\u1ebft c\u00e1c d\u00f2ng d\u1eef li\u1ec7u b\u1ecb l\u1ed7i, l\u00fd do kh\u00f4ng h\u1ee3p l\u1ec7 \u0111\u1ec3 d\u1ec5 d\u00e0ng ch\u1ec9nh s\u1eeda v\u00e0 nh\u1eadp l\u1ea1i ch\u00ednh x\u00e1c h\u01a1n.<\/p>\n<\/div><\/div>\n<\/div>\n
<\/span><\/p>\n
Nh\u1eadp kh\u1ea9u t\u1ed3n kho \u0111\u1ea7u k\u1ef3<\/strong><\/h4>\n
<\/div>
\n
\u0110\u1ec3 nh\u1eadp t\u1ed3n kho h\u00e0ng lo\u1ea1t m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, anh\/ch\u1ecb ch\u1ecdn ch\u1ee9c n\u0103ng\u00a0Nh\u1eadp t\u1eeb excel,\u00a0<\/strong>sau \u0111\u00f3 th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n
$\"\"$ <\/p>\n
B\u01b0\u1edbc 1:<\/u>\u00a0Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/strong><\/h5>\n
1. Anh\/ch\u1ecb ch\u1ecdn file nh\u1eadp kh\u1ea9u t\u1eeb c\u00e1c file d\u1eef li\u1ec7u s\u1eb5n c\u00f3 tr\u00ean m\u00e1y t\u00ednh ho\u1eb7c c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu v\u1ec1 \u0111\u1ec3 nh\u1eadp theo file d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u.<\/p>\n
2. Ch\u1ecdn sheet c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp v\u00e0 l\u1ef1a ch\u1ecdn d\u00f2ng b\u1eaft \u0111\u1ea7u l\u1ea5y d\u1eef li\u1ec7u.<\/p>\n
3. Ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u: Th\u00eam m\u1edbi d\u1eef li\u1ec7u ch\u01b0a c\u00f3, kh\u00f4ng c\u1eadp nh\u1eadt d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed3n t\u1ea1i.<\/p>\n
4. Sau khi \u0111\u00e3 ho\u00e0n t\u1ea5t l\u1ef1a ch\u1ecdn, anh\/ch\u1ecb nh\u1ea5n Ti\u1ebfp t\u1ee5c<\/strong>\u00a0\u0111\u1ec3 chuy\u1ec3n sang b\u01b0\u1edbc 2.<\/p>\n
B\u01b0\u1edbc 2:<\/u><\/strong>\u00a0Gh\u00e9p d\u1eef li\u1ec7u<\/strong>:<\/h5>\n
Anh\/ch\u1ecb th\u1ef1c hi\u1ec7n gh\u00e9p c\u00e1c c\u1ed9t trong t\u1ec7p ngu\u1ed3n t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u1ed9t d\u1eef li\u1ec7u tr\u00ean ph\u1ea7n m\u1ec1m:<\/p>\n
1. Tr\u01b0\u1eddng h\u1ee3p l\u1ea5y t\u1eeb file m\u1eabu th\u00ec ch\u01b0\u01a1ng tr\u00ecnh 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<\/p>\n
2. Tr\u01b0\u1eddng h\u1ee3p l\u00e0 file do ng\u01b0\u1eddi d\u00f9ng t\u1ef1 t\u1ea1o kh\u00f4ng theo m\u1eabu ch\u01b0\u01a1ng tr\u00ecnh th\u00ec ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n gh\u00e9p c\u1ed9t th\u1ee7 c\u00f4ng.<\/p>\n
L\u01b0u \u00fd<\/strong>:<\/em><\/p>\n
\n
T\u1ea1i d\u00f2ng\u00a0c\u00f3 t\u00edch ch\u1ecdn<\/strong>\u00a0\u201cB\u1eaft bu\u1ed9c gh\u00e9p c\u1ed9t v\u00e0 nh\u1eadp th\u00f4ng tin\u201d\u00a0<\/strong>\u00a0th\u00ec ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i \u0111\u1ea3m b\u1ea3o c\u1ed9t tr\u00ean t\u1ec7p excel t\u01b0\u01a1ng \u1ee9ng c\u00f3 nh\u1eadp \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin li\u00ean quan.<\/em><\/li>\n
N\u1ebfu\u00a0kh\u00f4ng t\u00edch ch\u1ecdn<\/strong>\u00a0\u201cB\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 ng\u1ea7m \u0111\u1ecbnh ho\u1eb7c \u0111\u1ec3 tr\u1ed1ng theo y\u00eau c\u1ea7u c\u1ee7a t\u1eebng tr\u01b0\u1eddng d\u1eef li\u1ec7u theo t\u1eebng danh m\u1ee5c, ch\u1ee9ng t\u1eeb.<\/em><\/li>\n<\/ul>\n
B\u01b0\u1edbc 3:<\/u><\/strong>\u00a0Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong><\/h5>\n
1. Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd ki\u1ec3m tra to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t v\u1edbi d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh v\u00e0 hi\u1ec3n th\u1ecb s\u1ed1 l\u01b0\u1ee3ng b\u1ea3n ghi h\u1ee3p l\u1ec7\/l\u1ed7i, Khi \u0111\u00f3 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn:<\/p>\n
\n
Nh\u1ea5n\u00a0Th\u1ef1c hi\u1ec7n<\/strong>: ch\u01b0\u01a1ng tr\u00ecnh 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 c\u00e1c m\u00e3 c\u00f3 t\u00ecnh tr\u1ea1ng h\u1ee3p l\u1ec7.<\/li>\n
Ki\u1ec3m tra th\u00f4ng tin chi ti\u1ebft l\u1ed7i tr\u00ean giao di\u1ec7n ho\u1eb7c t\u1ea3i file k\u1ebft qu\u1ea3 \u0111\u1ec3 ki\u1ec3m tra l\u1ea1i. Sau \u0111\u00f3 NSD c\u00f3 th\u1ec3 quay l\u1ea1i b\u01b0\u1edbc 1 \u0111\u1ec3 c\u1eadp nh\u1eadt l\u1ea1i file nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n
2. Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u00e1c m\u00e3 \u0111\u00e3 nh\u1eadp th\u00e0nh c\u00f4ng ho\u1eb7c kh\u00f4ng th\u00e0nh c\u00f4ng d\u1ef1a theo k\u1ebft qu\u1ea3 ki\u1ec3m tra<\/p>\n
3. Nh\u1ea5n \u0110\u00f3ng\u00a0<\/strong>ho\u1eb7c nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u\u00a0X<\/strong> \u0111\u1ec3 ho\u00e0n th\u00e0nh nh\u1eadp kh\u1ea9u t\u1ed3n \u0111\u1ea7u k\u1ef3.<\/p>\n
$\"\"$ <\/p>\n<\/div><\/div>\n<\/div>\n
<\/span><\/p>\n
Nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb<\/strong><\/h4>\n
<\/div>
\n
1. \u0110\u1ec3 nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb h\u00e0ng lo\u1ea1t m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, anh\/ch\u1ecb ch\u1ecdn ch\u1ee9c n\u0103ng Nh\u1eadp t\u1eeb excel <\/strong>t\u1ea1i danh s\u00e1ch ch\u1ee9ng t\u1eeb c\u1ea7n nh\u1eadp kh\u1ea9u.<\/p>\n
$\"\"$ <\/p>\n
2. Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd hi\u1ec3n th\u1ecb giao di\u1ec7n:<\/p>\n
$\"\"$ <\/p>\n
3. Anh\/ch\u1ecb th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n
B\u01b0\u1edbc 1:<\/u>\u00a0Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/strong><\/h5>\n
1. Anh\/ch\u1ecb ch\u1ecdn file nh\u1eadp kh\u1ea9u t\u1eeb c\u00e1c file d\u1eef li\u1ec7u s\u1eb5n c\u00f3 tr\u00ean m\u00e1y t\u00ednh ho\u1eb7c c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu v\u1ec1 \u0111\u1ec3 nh\u1eadp theo file d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u.<\/p>\n
2. Ch\u1ecdn sheet c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp v\u00e0 l\u1ef1a ch\u1ecdn d\u00f2ng b\u1eaft \u0111\u1ea7u l\u1ea5y d\u1eef li\u1ec7u.<\/p>\n
3. Ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u: Th\u00eam m\u1edbi d\u1eef li\u1ec7u ch\u01b0a c\u00f3, kh\u00f4ng c\u1eadp nh\u1eadt d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed3n t\u1ea1i.<\/p>\n
4. Sau khi \u0111\u00e3 ho\u00e0n t\u1ea5t l\u1ef1a ch\u1ecdn, anh\/ch\u1ecb nh\u1ea5n Ti\u1ebfp t\u1ee5c<\/strong>\u00a0\u0111\u1ec3 chuy\u1ec3n sang b\u01b0\u1edbc 2.<\/p>\n
$\"\"$ <\/p>\n
B\u01b0\u1edbc 2:<\/u><\/strong>\u00a0Gh\u00e9p d\u1eef li\u1ec7u<\/strong><\/h5>\n
Anh\/ch\u1ecb th\u1ef1c hi\u1ec7n gh\u00e9p c\u00e1c c\u1ed9t trong t\u1ec7p ngu\u1ed3n t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u1ed9t d\u1eef li\u1ec7u tr\u00ean ph\u1ea7n m\u1ec1m:<\/p>\n
1. Tr\u01b0\u1eddng h\u1ee3p l\u1ea5y t\u1eeb file m\u1eabu th\u00ec ch\u01b0\u01a1ng tr\u00ecnh 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<\/p>\n
2. Tr\u01b0\u1eddng h\u1ee3p l\u00e0 file do ng\u01b0\u1eddi d\u00f9ng t\u1ef1 t\u1ea1o kh\u00f4ng theo m\u1eabu ch\u01b0\u01a1ng tr\u00ecnh th\u00ec ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n gh\u00e9p c\u1ed9t th\u1ee7 c\u00f4ng.<\/p>\n
$\"\"$ <\/p>\n
L\u01b0u \u00fd<\/strong>:<\/em><\/p>\n
\n
T\u1ea1i d\u00f2ng\u00a0c\u00f3 t\u00edch ch\u1ecdn<\/strong>\u00a0\u201cB\u1eaft bu\u1ed9c gh\u00e9p c\u1ed9t v\u00e0 nh\u1eadp th\u00f4ng tin\u201d\u00a0<\/strong>\u00a0th\u00ec ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i \u0111\u1ea3m b\u1ea3o c\u1ed9t tr\u00ean t\u1ec7p excel t\u01b0\u01a1ng \u1ee9ng c\u00f3 nh\u1eadp \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin li\u00ean quan.<\/em><\/li>\n
N\u1ebfu\u00a0kh\u00f4ng t\u00edch ch\u1ecdn<\/strong>\u00a0\u201cB\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 ng\u1ea7m \u0111\u1ecbnh ho\u1eb7c \u0111\u1ec3 tr\u1ed1ng theo y\u00eau c\u1ea7u c\u1ee7a t\u1eebng tr\u01b0\u1eddng d\u1eef li\u1ec7u theo t\u1eebng danh m\u1ee5c, ch\u1ee9ng t\u1eeb.<\/em><\/li>\n<\/ul>\n
B\u01b0\u1edbc 3:<\/u><\/strong>\u00a0Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong><\/h5>\n
1. Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd ki\u1ec3m tra to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t v\u1edbi d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh v\u00e0 hi\u1ec3n th\u1ecb s\u1ed1 l\u01b0\u1ee3ng b\u1ea3n ghi h\u1ee3p l\u1ec7\/l\u1ed7i, Khi \u0111\u00f3 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn:<\/p>\n
\n
Nh\u1ea5n\u00a0Th\u1ef1c hi\u1ec7n<\/strong>: ch\u01b0\u01a1ng tr\u00ecnh 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 c\u00e1c m\u00e3 c\u00f3 t\u00ecnh tr\u1ea1ng h\u1ee3p l\u1ec7.<\/li>\n
Ki\u1ec3m tra th\u00f4ng tin chi ti\u1ebft l\u1ed7i tr\u00ean giao di\u1ec7n ho\u1eb7c t\u1ea3i file k\u1ebft qu\u1ea3 \u0111\u1ec3 ki\u1ec3m tra l\u1ea1i. Sau \u0111\u00f3 NSD c\u00f3 th\u1ec3 quay l\u1ea1i b\u01b0\u1edbc 1 \u0111\u1ec3 c\u1eadp nh\u1eadt l\u1ea1i file nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n
2. Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u00e1c m\u00e3 \u0111\u00e3 nh\u1eadp th\u00e0nh c\u00f4ng ho\u1eb7c kh\u00f4ng th\u00e0nh c\u00f4ng d\u1ef1a theo k\u1ebft qu\u1ea3 ki\u1ec3m tra<\/p>\n
3. Nh\u1ea5n \u0110\u00f3ng\u00a0<\/strong>ho\u1eb7c nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u\u00a0X<\/strong> \u0111\u1ec3 ho\u00e0n th\u00e0nh nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb<\/p>\n
$\"\"$ <\/p>\n<\/div><\/div>\n
<\/div><\/span><\/span><\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
1. T\u1ed5ng quan Ch\u01b0\u01a1ng tr\u00ecnh cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng nh\u1eadp nhanh d\u1eef li\u1ec7u t\u1eeb t\u1ec7p Excel v\u00e0o ph\u1ea7n m\u1ec1m. 2. H\u01b0\u1edbng d\u1eabn chi ti\u1ebft <\/p>\n","protected":false},"author":115,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[257],"ht-kb-tag":[],"class_list":["post-19301","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-thiet-lap-cac-tien-ich"],"_links":{"self":[{"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/ht-kb\/19301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/comments?post=19301"}],"version-history":[{"count":3,"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/ht-kb\/19301\/revisions"}],"predecessor-version":[{"id":20433,"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/ht-kb\/19301\/revisions\/20433"}],"wp:attachment":[{"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/media?parent=19301"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/ht-kb-category?post=19301"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/ht-kb-tag?post=19301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}