{"id":5284,"date":"2018-06-28T16:21:48","date_gmt":"2018-06-28T09:21:48","guid":{"rendered":"http:\/\/gcloudvn.wam.vn\/cac-meo-khi-nhap-du-lieu-vao-google-sheets\/"},"modified":"2023-09-26T11:29:16","modified_gmt":"2023-09-26T04:29:16","slug":"cac-meo-khi-nhap-du-lieu-vao-google-sheets","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/cac-meo-khi-nhap-du-lieu-vao-google-sheets\/","title":{"rendered":"Tips for importing data into Google Sheets"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Google Sheets is a great application for working with Spreadsheets, a simple interface aimed at enhancing teamwork experience and productivity, completely built on Google&#039;s Cloud platform. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Google Sheets provides advanced functions to maximize the quality of work, while also providing a series of small but extremely handy features for users, features aimed at saving time. with data. This article will help you discover those rarely used but very useful features for your data entry.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 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\/cac-meo-khi-nhap-du-lieu-vao-google-sheets\/#Xoa_gia_tri_voi_ham_Trim_va_Clean\" >Remove values with Trim and Clean . functions<\/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\/cac-meo-khi-nhap-du-lieu-vao-google-sheets\/#Bao_ve_du_lieu_trong_o\" >Protect data in cells<\/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\/cac-meo-khi-nhap-du-lieu-vao-google-sheets\/#Xac_thuc_du_lieu_nhap_vao_cac_o\" >Validate data entered in cells<\/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\/cac-meo-khi-nhap-du-lieu-vao-google-sheets\/#Viet_hoa_ky_tu_dau_moi_o\" >Capitalize the first letter of each cell<\/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\/cac-meo-khi-nhap-du-lieu-vao-google-sheets\/#Chia_du_lieu_thanh_tung_phan_rieng_biet\" >Split data into separate pieces<\/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\/cac-meo-khi-nhap-du-lieu-vao-google-sheets\/#Do_thi_hoa_du_lieu_bang_Sparkline\" >Graphing data with Sparkline<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Xoa_gia_tri_voi_ham_Trim_va_Clean\"><\/span><b>Remove values with Trim and Clean . functions<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li><span style=\"font-weight: 400;\">CLEAN function: Very useful when users need to delete characters <\/span><a href=\"https:\/\/www.juniper.net\/documentation\/en_US\/idp5.1\/topics\/reference\/general\/intrusion-detection-prevention-custom-attack-object-extended-ascii.html\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">non-printable<\/span><\/a><span style=\"font-weight: 400;\"> exist in the cells. When using the CLEAN function, the returned results will no longer contain ASCII characters, but see details at <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/3267340?hl=en\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">CLEAN <\/span><\/a><\/li>\n<li><span style=\"font-weight: 400;\">TRIM function: When it is necessary to remove the space characters (space) appearing at the beginning or end of each cell, TRIM will be the function to support that. See details at <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/3094140?hl=en\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">TRIM.<\/span><\/a><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16314 aligncenter\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Xoa-gia-tri-voi-ham-Trim-va-Clean.jpg\" alt=\"Remove values with Trim and Clean . functions\" width=\"600\" height=\"327\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Xoa-gia-tri-voi-ham-Trim-va-Clean.jpg 600w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Xoa-gia-tri-voi-ham-Trim-va-Clean-18x10.jpg 18w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Bao_ve_du_lieu_trong_o\"><\/span><b>Protect data in cells<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">In some cases, when you share data with others with Edit permission, but do not want the data you entered in the sheet or even in the cell to be changed, then <\/span><b>Protect sheet<\/b><span style=\"font-weight: 400;\"> will be the function to look for. Use Protect sheet at <\/span><b>Tool \u2192 Protect sheet.\u00a0<\/b>You can refer to the section<b>\u00a0<\/b><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/huong-dan-han-che-quyen-truy-cap-trong-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Instructions for restricting access in Google Sheets.<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16316 aligncenter\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Bao-ve-du-lieu-trong-o.jpg\" alt=\"Protect data in cells\" width=\"600\" height=\"398\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Bao-ve-du-lieu-trong-o.jpg 600w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Bao-ve-du-lieu-trong-o-391x260.jpg 391w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Bao-ve-du-lieu-trong-o-18x12.jpg 18w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Xac_thuc_du_lieu_nhap_vao_cac_o\"><\/span><b>Validate data entered in cells<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sometimes users need to specify the data type to enter in the correct cell according to the specified requirements, the function at <strong>Data (<\/strong><\/span><b>Data) \u2192 Data validation (Validation data) <\/b><span style=\"font-weight: 400;\">will allow it. Google Sheets supports a wide variety of validated input data types.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">The user can create a numeric authentication, or define the data to be entered. If entered incorrectly, Google Sheets will notify and ask to re-enter.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16317 aligncenter\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Xac-thuc-du-lieu-nhap-vao-cac-o.jpg\" alt=\"Validate data entered in cells\" width=\"600\" height=\"359\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Xac-thuc-du-lieu-nhap-vao-cac-o.jpg 600w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Xac-thuc-du-lieu-nhap-vao-cac-o-18x12.jpg 18w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Viet_hoa_ky_tu_dau_moi_o\"><\/span><b>Capitalize the first letter of each cell<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sometimes the user needs the data of the cells to be capitalized the same at the first letter, the function <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/3094133?hl=en\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">PROPER <\/span><\/a><span style=\"font-weight: 400;\">provided by Google Sheets to do just that.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16311 aligncenter\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Viet-hoa-ky-tu-dau-moi-o.jpg\" alt=\"Capitalize the first letter of each cell\" width=\"600\" height=\"314\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Viet-hoa-ky-tu-dau-moi-o.jpg 600w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Viet-hoa-ky-tu-dau-moi-o-18x9.jpg 18w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">And for when you need to return to lowercase the first-line data of cells, you can use the function <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/3094083\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">LOWER.<\/span><\/a><\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><strong><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cach-viet-hoa-chu-cai-dau-trong-google-sheets\/\">Detailed instructions on how to capitalize the first letter in Google Sheets<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Chia_du_lieu_thanh_tung_phan_rieng_biet\"><\/span><b>Split data into separate pieces<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Have you ever needed to split data from a string of characters with spaces in a cell into multiple separate cells?<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Data \u2192 Split text to columns<\/b><span style=\"font-weight: 400;\"> is the problem-solving function that Google provides.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16318 aligncenter\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Chia-du-lieu-thanh-tung-phan-rieng-biet.jpg\" alt=\"Split data into separate pieces\" width=\"600\" height=\"493\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Chia-du-lieu-thanh-tung-phan-rieng-biet.jpg 600w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Chia-du-lieu-thanh-tung-phan-rieng-biet-15x12.jpg 15w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Do_thi_hoa_du_lieu_bang_Sparkline\"><\/span><b>Graphing data with Sparkline<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">If you have a large amount of monthly profit data for your company that needs to be analyzed to determine growth or decline milestones, then the function <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/3093289?hl=en\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Sparkline <\/span><\/a><span style=\"font-weight: 400;\">is what Google brings to you Google Sheets.<\/span><\/p>\n<p style=\"text-align: right;\"><strong><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16319\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Do-thi-hoa-du-lieu-bang-Sparkline.jpg\" alt=\"Graphing data with Sparkline\" width=\"600\" height=\"187\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Do-thi-hoa-du-lieu-bang-Sparkline.jpg 600w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2018\/06\/Do-thi-hoa-du-lieu-bang-Sparkline-18x6.jpg 18w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: right;\"><strong>Update: <a href=\"https:\/\/gcloudvn.com\/en\/\">Gimasys<\/a><\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Google Sheets is a great application for working with Spreadsheets, a simple interface aimed at enhancing the experience and productivity of teamwork, completely built on the Cloud platform\u2026<\/p>","protected":false},"author":1,"featured_media":5285,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[134,1],"tags":[],"class_list":["post-5284","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-workspace","category-kienthuc","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/5284","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=5284"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/5284\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/5285"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=5284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=5284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=5284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}