{"id":6678,"date":"2020-11-16T16:19:20","date_gmt":"2020-11-16T09:19:20","guid":{"rendered":"http:\/\/gcloudvn.wam.vn\/su-dung-smart-fill-trong-google-sheets-de-giup-tu-dong-nhap-du-lieu\/"},"modified":"2023-04-13T09:31:42","modified_gmt":"2023-04-13T02:31:42","slug":"su-dung-smart-fill-trong-google-sheets-de-giup-tu-dong-nhap-du-lieu","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/su-dung-smart-fill-trong-google-sheets-de-giup-tu-dong-nhap-du-lieu\/","title":{"rendered":"Use Smart Fill for Google Sheets to automatically import data"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/su-dung-smart-fill-trong-google-sheets-de-giup-tu-dong-nhap-du-lieu\/#Google_Sheets_co_gi_thay_doi\" >Google Sheets c\u00f3 g\u00ec thay \u0111\u1ed5i\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/su-dung-smart-fill-trong-google-sheets-de-giup-tu-dong-nhap-du-lieu\/#Tac_dong_den_ai\" >Who is affected?\u00a0\u00a0\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/su-dung-smart-fill-trong-google-sheets-de-giup-tu-dong-nhap-du-lieu\/#Co_gi_quan_trong\" >What&#039;s important?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/su-dung-smart-fill-trong-google-sheets-de-giup-tu-dong-nhap-du-lieu\/#Thong_tin_them\" >Additional details<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/su-dung-smart-fill-trong-google-sheets-de-giup-tu-dong-nhap-du-lieu\/#Hay_bat_dau_voi_Smart_Fill_Google_Sheets\" >H\u00e3y b\u1eaft \u0111\u1ea7u v\u1edbi Smart Fill Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/su-dung-smart-fill-trong-google-sheets-de-giup-tu-dong-nhap-du-lieu\/#Thoi_gian_trien_khai\" >Rollout pace<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/su-dung-smart-fill-trong-google-sheets-de-giup-tu-dong-nhap-du-lieu\/#Tinh_kha_dung\" >Availability<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Google_Sheets_co_gi_thay_doi\"><\/span><b>Google Sheets c\u00f3 g\u00ec thay \u0111\u1ed5i\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">Google is launching Smart Fill for Google Sheets, which detects and learns patterns between columns to intelligently auto-complete data entries.<\/p>\n<p style=\"text-align: justify;\">For example, if you have a \u201cFull Name\u201d column, you might want to separate it into a column with \u201cFirst Name\u201d and a column with \u201cLast Name\u201d. When you start typing names in a column, Sheets automatically searches for patterns. If Sheets detects a pattern, Sheets creates the corresponding formula and then autofills the rest of the columns for you.<\/p>\n<p style=\"text-align: justify;\">Tr\u01b0\u1edbc \u0111\u00e2y, Google \u0111\u00e3 th\u00f4ng b\u00e1o r\u1eb1ng Smart Fill for Sheets s\u1ebd s\u1edbm ra m\u1eaft. Xem th\u00eam chi ti\u1ebft b\u00ean d\u01b0\u1edbi.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-17766 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2020\/11\/smartfill-in-sheets.gif\" alt=\"S\u1eed d\u1ee5ng Smart Fill cho Google Sheets \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng nh\u1eadp d\u1eef li\u1ec7u 1\" width=\"639\" height=\"408\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tac_dong_den_ai\"><\/span><b>Who is affected?<\/b><b>\u00a0\u00a0\u00a0 <\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">End users<\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Co_gi_quan_trong\"><\/span><b>What&#039;s important?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">Google hy v\u1ecdng r\u1eb1ng Smart Fill s\u1ebd gi\u00fap b\u1ea1n chu\u1ea9n b\u1ecb v\u00e0 s\u1eed d\u1ee5ng d\u1eef li\u1ec7u trong Sheets d\u1ec5 d\u00e0ng h\u01a1n. T\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch Smart Compose trong Gmail gi\u00fap b\u1ea1n vi\u1ebft nhanh h\u01a1n v\u1edbi \u00edt l\u1ed7i h\u01a1n, Smart Fill gi\u00fap nh\u1eadp d\u1eef li\u1ec7u nhanh h\u01a1n v\u00e0 \u00edt b\u1ecb l\u1ed7i h\u01a1n.<\/p>\n<p style=\"text-align: justify;\">G\u1ea7n \u0111\u00e2y, Google c\u0169ng \u0111\u00e3 ra m\u1eaft t\u00ednh n\u0103ng Sheets Smart Cleanup, s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 th\u00f4ng minh t\u01b0\u01a1ng t\u1ef1 \u0111\u1ec3 gi\u00fap chu\u1ea9n b\u1ecb v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u trong Sheets. B\u1eb1ng c\u00e1ch b\u1ed5 sung c\u00e1c t\u00ednh n\u0103ng m\u1edbi, th\u00f4ng minh \u0111\u1ec3 gi\u00fap t\u1ef1 \u0111\u1ed9ng h\u00f3a vi\u1ec7c chu\u1ea9n b\u1ecb v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, Google hy v\u1ecdng s\u1ebd trao quy\u1ec1n cho t\u1ea5t c\u1ea3 ng\u01b0\u1eddi d\u00f9ng khai th\u00e1c s\u1ee9c m\u1ea1nh c\u1ee7a d\u1eef li\u1ec7u v\u00e0 nhanh ch\u00f3ng \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean d\u1eef li\u1ec7u.<\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Thong_tin_them\"><\/span><b>Additional details<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">Ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng d\u1eef li\u1ec7u trong m\u1ed9t trang t\u00ednh, Smart Fill c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng d\u1eef li\u1ec7u t\u1eeb Google\u2019s Knowledge Graph c\u1ee7a Google. V\u00ed d\u1ee5: n\u00f3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng d\u1eef li\u1ec7u c\u00f4ng khai \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n v\u00e0o danh s\u00e1ch c\u00e1c qu\u1ed1c gia n\u01a1i c\u00f3 c\u00e1c th\u00e0nh ph\u1ed1 \u0111\u01b0\u1ee3c \u0111\u1ecbnh v\u1ecb.<\/p>\n<p style=\"text-align: justify;\">\u0110\u1ed1i v\u1edbi kh\u00e1ch h\u00e0ng Enterprise Plus, h\u1ecd c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng th\u00f4ng tin t\u1eeb Danh b\u1ea1 nh\u00e2n s\u1ef1 c\u1ee7a c\u00f4ng ty \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng ho\u00e0n th\u00e0nh d\u1eef li\u1ec7u. V\u00ed d\u1ee5: n\u00f3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng d\u1eef li\u1ec7u organization-only \u0111\u1ec3 \u0111i\u1ec1n \u0111\u1ecba ch\u1ec9 email cho nh\u00e2n vi\u00ean c\u1ee7a c\u00f4ng ty.<\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Hay_bat_dau_voi_Smart_Fill_Google_Sheets\"><\/span><b>H\u00e3y b\u1eaft \u0111\u1ea7u v\u1edbi Smart Fill Google Sheets<br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li>\u0110\u1ed1i v\u1edbi Qu\u1ea3n tr\u1ecb vi\u00ean: Smart Fill s\u1ebd \u0111\u01b0\u1ee3c B\u1eacT theo m\u1eb7c \u0111\u1ecbnh cho ng\u01b0\u1eddi d\u00f9ng. Kh\u00f4ng c\u00f3 quy\u1ec1n ki\u1ec3m so\u00e1t c\u1ee7a qu\u1ea3n tr\u1ecb vi\u00ean cho t\u00ednh n\u0103ng n\u00e0y. Truy c\u1eadp Help Center \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch qu\u1ea3n l\u00fd th\u00f4ng tin trong danh b\u1ea1 c\u1ee7a c\u00f4ng ty b\u1ea1n.<\/li>\n<li>\u0110\u1ed1i v\u1edbi Ng\u01b0\u1eddi d\u00f9ng cu\u1ed1i: T\u00ednh n\u0103ng n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c B\u1eacT theo m\u1eb7c \u0111\u1ecbnh. H\u00e3y truy c\u1eadp Help Center \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng Smart Fill ho\u1eb7c t\u1eaft t\u00ednh n\u0103ng n\u00e0y cho t\u00e0i kho\u1ea3n c\u1ee7a b\u1ea1n.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Thoi_gian_trien_khai\"><\/span><b>Rollout pace<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li>Ph\u00e1t h\u00e0nh nhanh: Ph\u00e1t h\u00e0nh m\u1edf r\u1ed9ng (c\u00f3 th\u1ec3 l\u00e2u h\u01a1n 15 ng\u00e0y \u0111\u1ec3 t\u00ednh n\u0103ng xu\u1ea5t hi\u1ec7n) b\u1eaft \u0111\u1ea7u t\u1eeb ng\u00e0y 15 th\u00e1ng 10 n\u0103m 2020<\/li>\n<li>Ph\u00e1t h\u00e0nh theo l\u1ecbch tr\u00ecnh: Ph\u00e1t h\u00e0nh m\u1edf r\u1ed9ng (c\u00f3 th\u1ec3 l\u00e2u h\u01a1n 15 ng\u00e0y \u0111\u1ec3 t\u00ednh n\u0103ng xu\u1ea5t hi\u1ec7n) b\u1eaft \u0111\u1ea7u t\u1eeb ng\u00e0y 5 th\u00e1ng 11 n\u0103m 2020<\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tinh_kha_dung\"><\/span><b>Availability<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li>Smartfill kh\u1ea3 d\u1ee5ng cho c\u00e1c kh\u00e1ch h\u00e0ng Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus; <a href=\"https:\/\/gcloudvn.com\/en\/google-workspace-for-education\/\">Google Workspace For Education<\/a>, Enterprise for Education v\u00e0 t\u1ed5 ch\u1ee9c phi l\u1ee3i nhu\u1eadn v\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u00f3 T\u00e0i kho\u1ea3n Google c\u00e1 nh\u00e2n<\/li>\n<li>T\u00edch h\u1ee3p Smartfill v\u1edbi danh b\u1ea1 ch\u1ec9 kh\u1ea3 d\u1ee5ng cho kh\u00e1ch h\u00e0ng Enterprise Plus.<\/li>\n<\/ul>\n<p style=\"text-align: right;\"><strong>Source: <a href=\"https:\/\/gcloudvn.com\/en\/\">Gimasys<\/a><\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Google is launching Smart Fill for Google Sheets, which detects and learns patterns between columns to intelligently auto-complete data entries.<br \/>\nFor example, if you have a \u201cFull Name\u201d column, you might want to separate it into a column with \u201cFirst Name\u201d and a column with \u201cLast Name\u201d. When you start typing names in a column, Sheets automatically searches for patterns. If Sheets detects a pattern, Sheets creates the corresponding formula and then autofills the rest of the columns for you.<\/p>","protected":false},"author":1,"featured_media":6679,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-6678","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/6678","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=6678"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/6678\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/6679"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=6678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=6678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=6678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}