{"id":810,"date":"2020-08-31T10:33:55","date_gmt":"2020-08-31T03:33:55","guid":{"rendered":"http:\/\/helpbhxh.misa.vn\/?post_type=ht_kb&#038;p=810"},"modified":"2026-04-28T10:43:06","modified_gmt":"2026-04-28T03:43:06","slug":"them-moi-lao-dong-vao-don-vi-bang-cach-nhap-khau-tu-excel","status":"publish","type":"ht_kb","link":"\/amis-bhxh\/kb\/them-moi-lao-dong-vao-don-vi-bang-cach-nhap-khau-tu-excel\/","title":{"rendered":"Th\u00eam ng\u01b0\u1eddi lao \u0111\u1ed9ng v\u00e0o \u0111\u01a1n v\u1ecb b\u1eb1ng c\u00e1ch nh\u1eadp kh\u1ea9u t\u1eeb file Excel"},"content":{"rendered":"\r\n<h3><span style=\"font-size: 14pt;\"><strong>I. T\u1ed5ng quan<\/strong><\/span><\/h3>\r\n<p>B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn \u0111\u01a1n v\u1ecb nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u lao \u0111\u1ed9ng l\u00ean ph\u1ea7n m\u1ec1m theo m\u1eabu file excel c\u00f3 s\u1eb5n.<\/p>\r\n<h3><span style=\"font-size: 14pt;\"><strong>II. H\u01b0\u1edbng d\u1eabn th\u1ef1c hi\u1ec7n<br \/><\/strong><\/span><\/h3>\r\n\r\n\r\n\r\n\r\n\r\n<p>T\u1ea1i ph\u00e2n h\u1ec7 <strong>Qu\u1ea3n l\u00fd lao \u0111\u1ed9ng<\/strong>, nh\u1ea5n v\u00e0o d\u1ea5u m\u0169i t\u00ean b\u00ean c\u1ea1nh m\u1ee5c <strong>Th\u00eam m\u1edbi lao \u0111\u1ed9ng &gt; Nh\u1eadp kh\u1ea9u t\u1eeb Excel<\/strong><\/p>\r\n\r\n\r\n\r\n\r\n\r\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-22953\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/15.png\" alt=\"\" width=\"1352\" height=\"545\" \/><\/p>\r\n<h4><span style=\"font-size: 12pt;\"><strong>1. Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/strong><\/span><\/h4>\r\n\r\n\r\n\r\n\r\n\r\n<p><strong>B\u01b0\u1edbc 1:<\/strong> T\u1ea3i file m\u1eabu sau \u0111\u00f3 c\u1eadp nh\u1eadt th\u00f4ng tin ng\u01b0\u1eddi lao \u0111\u1ed9ng v\u00e0o file m\u1eabu.<\/p>\r\n\r\n\r\n\r\n<p><strong><span style=\"color: #ff0000;\">L\u01b0u \u00fd:\u00a0 <\/span><\/strong><\/p>\r\n<ul>\r\n<li><span style=\"color: #ff0000;\">C\u1ea7n nh\u1eadp ch\u00ednh x\u00e1c th\u00f4ng tin theo c\u00e1c tr\u01b0\u1eddng trong m\u1eabu th\u00ec m\u1edbi c\u00f3 th\u1ec3 nh\u1eadp kh\u1ea9u l\u00ean ph\u1ea7n m\u1ec1m.<\/span><\/li>\r\n<li><span style=\"color: #ff0000;\">Tr\u01b0\u1eddng h\u1ee3p d\u1eef li\u1ec7u trong file Excel t\u1ea3i l\u00ean c\u00f3 CMTND\/CCCD\/H\u1ed9 chi\u1ebfu tr\u00f9ng v\u1edbi danh s\u00e1ch lao \u0111\u1ed9ng ch\u01b0\u01a1ng tr\u00ecnh \u0111\u00e3 c\u00f3 tr\u01b0\u1edbc \u0111\u00f3:<\/span><\/li>\r\n<\/ul>\r\n<p><span style=\"color: #ff0000;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0&#8211; Nh\u1ea5n <strong>C\u1eadp nh\u1eadt m\u1edbi<\/strong> n\u1ebfu mu\u1ed1n c\u1eadp nh\u1eadt d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p.<\/span><\/p>\r\n<p><span style=\"color: #ff0000;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0&#8211; Nh\u1ea5n <strong>B\u1ecf qua<\/strong> n\u1ebfu kh\u00f4ng mu\u1ed1n c\u1eadp nh\u1eadt d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p.<\/span>\r\n\r\n<\/p>\r\n<p>\r\n\r\n<\/p>\r\n<p><a href=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/2022-02-17_10-17-12.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-15935\" style=\"border-width: 1px; border-style: groove;\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/2022-02-17_10-17-12.png\" alt=\"\" width=\"1200\" height=\"687\" \/><\/a><\/p>\r\n\r\n\r\n\r\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1eadp kh\u1ea9u l\u00ean ph\u1ea7n m\u1ec1m b\u1eb1ng c\u00e1ch k\u00e9o file d\u1eef li\u1ec7u v\u00e0o kho\u1ea3ng tr\u1ed1ng \u0111\u01b0\u1ee3c khoanh \u0111\u1ecf.<\/p>\r\n<p><a href=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/2022-02-17_10-17-12-1.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-15936\" style=\"border-width: 1px; border-style: groove;\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/2022-02-17_10-17-12-1.png\" alt=\"\" width=\"1200\" height=\"687\" \/><\/a><\/p>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<p>B\u01b0\u1edbc 3: Nh\u1ea5n <strong>Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 chuy\u1ec3n b\u01b0\u1edbc th\u1ef1c hi\u1ec7n.<\/p>\r\n\r\n\r\n\r\n\r\n\r\n<h4><span style=\"font-size: 12pt;\"><strong>2. Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong><\/span><\/h4>\r\n\r\n\r\n\r\n<p>H\u1ec7 th\u1ed1ng c\u1eadp nh\u1eadt danh s\u00e1ch ng\u01b0\u1eddi lao \u0111\u1ed9ng v\u1eeba \u0111\u01b0\u1ee3c t\u1ea3i l\u00ean th\u00e0nh c\u00f4ng.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"620\" class=\"wp-image-815\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/5-7.png\" alt=\"\" srcset=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/5-7.png 1024w, \/amis-bhxh\/wp-content\/uploads\/2020\/08\/5-7-300x182.png 300w, \/amis-bhxh\/wp-content\/uploads\/2020\/08\/5-7-768x465.png 768w, \/amis-bhxh\/wp-content\/uploads\/2020\/08\/5-7-50x30.png 50w, \/amis-bhxh\/wp-content\/uploads\/2020\/08\/5-7-60x36.png 60w, \/amis-bhxh\/wp-content\/uploads\/2020\/08\/5-7-100x61.png 100w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Danh s\u00e1ch ng\u01b0\u1eddi lao \u0111\u1ed9ng \u0111\u01b0\u1ee3c chia theo nh\u00f3m d\u1eef li\u1ec7u. Nh\u1ea5n v\u00e0o t\u1eebng nh\u00f3m \u0111\u1ec3 xem chi ti\u1ebft<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"100\" class=\"wp-image-816\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/6-4-1024x100.png\" alt=\"\" srcset=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/6-4-1024x100.png 1024w, \/amis-bhxh\/wp-content\/uploads\/2020\/08\/6-4-300x29.png 300w, \/amis-bhxh\/wp-content\/uploads\/2020\/08\/6-4-768x75.png 768w, \/amis-bhxh\/wp-content\/uploads\/2020\/08\/6-4-50x5.png 50w, \/amis-bhxh\/wp-content\/uploads\/2020\/08\/6-4-60x6.png 60w, \/amis-bhxh\/wp-content\/uploads\/2020\/08\/6-4-100x10.png 100w, \/amis-bhxh\/wp-content\/uploads\/2020\/08\/6-4.png 1063w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li><strong>T\u1ed5ng d\u00f2ng d\u1eef li\u1ec7u<\/strong>: T\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng d\u1eef li\u1ec7u bao g\u1ed3m: d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p t\u1ea1i excel, d\u1eef li\u1ec7u \u0111\u00e3 c\u00f3, d\u1eef li\u1ec7u sai.<\/li>\r\n<li><strong>D\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p t\u1ea1i excel<\/strong>: Bao g\u1ed3m c\u00e1c d\u00f2ng d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p s\u1ed1 CMTND\/CCCD\/H\u1ed9 chi\u1ebfu trong file b\u1ea3n excel \u0111ang \u0111\u01b0\u1ee3c t\u1ea3i l\u00ean v\u00e0 s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o ch\u01b0\u01a1ng tr\u00ecnh. Khi c\u00f3 tr\u01b0\u1eddng h\u1ee3p tr\u00f9ng n\u00e0y, ch\u1ec9 c\u00f3 d\u00f2ng d\u1eef li\u1ec7u cu\u1ed1i c\u00f9ng trong b\u1ea3n excel c\u1ee7a anh\/ch\u1ecb \u0111\u01b0\u1ee3c nh\u1eadp kh\u1ea9u v\u00e0o ch\u01b0\u01a1ng tr\u00ecnh.<\/li>\r\n<li><strong>D\u1eef li\u1ec7u \u0111\u00e3 c\u00f3<\/strong>: Bao g\u1ed3m c\u00e1c d\u00f2ng d\u1eef li\u1ec7u t\u1ea1i b\u1ea3n excel c\u00f3 CMTND\/CCCD\/H\u1ed9 chi\u1ebfu tr\u00f9ng v\u1edbi danh s\u00e1ch lao \u0111\u1ed9ng ch\u01b0\u01a1ng tr\u00ecnh \u0111ang c\u00f3. Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd th\u1ef1c hi\u1ec7n &#8220;B\u1ecf qua&#8221; ho\u1eb7c &#8221; C\u1eadp nh\u1eadt m\u1edbi&#8221; d\u00f2ng d\u1eef li\u1ec7u theo l\u1ef1a ch\u1ecdn c\u1ee7a anh\/ch\u1ecb tr\u01b0\u1edbc \u0111\u00f3.<\/li>\r\n<li><strong>D\u1eef li\u1ec7u sai<\/strong>: Bao g\u1ed3m c\u00e1c d\u00f2ng d\u1eef li\u1ec7u c\u00f3 th\u00f4ng tin sai \u0111\u1ecbnh d\u1ea1ng ho\u1eb7c th\u00f4ng tin kh\u00f4ng n\u1eb1m trong danh s\u00e1ch \u0111\u00e3 c\u00f3 c\u1ee7a ch\u01b0\u01a1ng tr\u00ecnh. C\u00e1c d\u00f2ng d\u1eef li\u1ec7u n\u00e0y s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o ch\u01b0\u01a1ng tr\u00ecnh.<\/li>\r\n<li><strong>T\u1ea3i v\u1ec1 file b\u00e1o l\u1ed7i<\/strong>: Khi file t\u1ea3i l\u00ean ch\u1ee9a c\u00e1c d\u1eef li\u1ec7u sai, anh\/ch\u1ecb th\u1ef1c hi\u1ec7n t\u1ea3i file b\u00e1o l\u1ed7i v\u1ec1 \u0111\u1ec3 ki\u1ec3m tra v\u00e0 ch\u1ec9nh s\u1eeda l\u1ea1i.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n\r\n\r\n<p>=&gt; Sau khi \u0111\u00e3 ki\u1ec3m tra c\u00e1c nh\u00f3m d\u1eef li\u1ec7u, nh\u1ea5n <strong>Nh\u1eadp kh\u1ea9u<\/strong>\u00a0\u0111\u1ec3 th\u00eam c\u00e1c lao \u0111\u1ed9ng v\u00e0o danh s\u00e1ch ng\u01b0\u1eddi lao \u0111\u1ed9ng c\u1ee7a \u0111\u01a1n v\u1ecb.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"289\" height=\"60\" class=\"wp-image-817\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/5-8.png\" alt=\"\" srcset=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/5-8.png 289w, \/amis-bhxh\/wp-content\/uploads\/2020\/08\/5-8-50x10.png 50w, \/amis-bhxh\/wp-content\/uploads\/2020\/08\/5-8-60x12.png 60w, \/amis-bhxh\/wp-content\/uploads\/2020\/08\/5-8-100x21.png 100w\" sizes=\"(max-width: 289px) 100vw, 289px\" \/><\/figure>\r\n","protected":false},"excerpt":{"rendered":"<p>I. T\u1ed5ng quan B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn \u0111\u01a1n v\u1ecb nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u lao \u0111\u1ed9ng l\u00ean ph\u1ea7n m\u1ec1m theo m\u1eabu file excel c\u00f3 s\u1eb5n. II. H\u01b0\u1edbng d\u1eabn th\u1ef1c hi\u1ec7n T\u1ea1i ph\u00e2n h\u1ec7 Qu\u1ea3n l\u00fd lao \u0111\u1ed9ng, nh\u1ea5n v\u00e0o d\u1ea5u m\u0169i t\u00ean b\u00ean c\u1ea1nh m\u1ee5c Th\u00eam m\u1edbi lao \u0111\u1ed9ng &gt; Nh\u1eadp&#8230;<\/p>\n","protected":false},"author":2,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[],"ht-kb-tag":[],"class_list":["post-810","ht_kb","type-ht_kb","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb\/810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/amis-bhxh\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/comments?post=810"}],"version-history":[{"count":5,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb\/810\/revisions"}],"predecessor-version":[{"id":24651,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb\/810\/revisions\/24651"}],"wp:attachment":[{"href":"\/amis-bhxh\/wp-json\/wp\/v2\/media?parent=810"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb-category?post=810"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb-tag?post=810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}