{"id":25250,"date":"2026-05-15T08:32:37","date_gmt":"2026-05-15T01:32:37","guid":{"rendered":"https:\/\/gcloudvn.com\/?p=25250"},"modified":"2026-05-15T08:32:37","modified_gmt":"2026-05-15T01:32:37","slug":"paste-and-convert-unformatted-text-into-google-sheets-tables-with-gemini","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/paste-and-convert-unformatted-text-into-google-sheets-tables-with-gemini\/","title":{"rendered":"Paste and convert unformatted text into Google Sheets tables with Gemini"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">We're excited to introduce a new AI-powered feature in Google Sheets that allows you to transform unstructured text into organized tables.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Manually formatting and organizing unformatted data in spreadsheets can be a tedious, time-consuming task. Now, when you paste content like bulleted lists, freeform text, or JSON we surface a \u201cConvert to table\u201d button which leverages Gemini to turn your pasted content into a table with just a single click. This helps to streamline data entry so you can move to analysis faster.<\/span><\/p>\n<p><a href=\"https:\/\/gcloudvn.com\/en\/students-can-now-create-personal-class-notebooks-with-notebooklm-in-google-classroom\/attachment\/paste-and-convert-unformatted-text-into-google-sheets-tables-with-gemini-6727\/\" rel=\"attachment wp-att-25216\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25216\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2026\/05\/Paste-and-convert-unformatted-text-into-Google-Sheets-tables-with-Gemini-6727.gif\" alt=\"\" width=\"2000\" height=\"1248\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2026\/05\/Paste-and-convert-unformatted-text-into-Google-Sheets-tables-with-Gemini-6727.gif 2000w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2026\/05\/Paste-and-convert-unformatted-text-into-Google-Sheets-tables-with-Gemini-6727-768x479.gif 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2026\/05\/Paste-and-convert-unformatted-text-into-Google-Sheets-tables-with-Gemini-6727-1536x958.gif 1536w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2026\/05\/Paste-and-convert-unformatted-text-into-Google-Sheets-tables-with-Gemini-6727-18x12.gif 18w\" sizes=\"auto, (max-width: 2000px) 100vw, 2000px\" \/><\/a><\/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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/paste-and-convert-unformatted-text-into-google-sheets-tables-with-gemini\/#Bat_dau\" >Getting started<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/paste-and-convert-unformatted-text-into-google-sheets-tables-with-gemini\/#Thoi_gian_trien_khai\" >Rollout pace<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/paste-and-convert-unformatted-text-into-google-sheets-tables-with-gemini\/#Tinh_kha_dung\" >Availability<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Bat_dau\"><\/span><b>Getting started<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Admins: This feature is an additional entry point to existing AI table generation functionality. This feature will be hidden if the Smart features for Google Workspace setting is disabled.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">End users: You must have Workspace smart features enabled to use this feature.<\/span><span style=\"font-weight: 400;\">\u00a0This feature will be ON by default for eligible users. To use it, simply paste text into a Sheet; if the content is suitable, a \"Convert to Table\" prompt will appear. Visit the Help Center to learn more about collaborating with Gemini in Google Sheets.<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Thoi_gian_trien_khai\"><\/span><b>Rollout pace<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on April 22, 2026<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on May 6, 2026<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_kha_dung\"><\/span><b>Availability<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Business: Business Standard and Plus<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Enterprise: Enterprise Standard and Plus<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Education: Google AI Pro for Education<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Consumer: Google AI Pro and Ultra<\/span><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Google r\u1ea5t vui m\u1eebng gi\u1edbi thi\u1ec7u t\u00ednh n\u0103ng m\u1edbi \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 b\u1edfi tr\u00ed tu\u1ec7 nh\u00e2n t\u1ea1o (AI) trong Google Sheets, cho ph\u00e9p b\u1ea1n chuy\u1ec3n \u0111\u1ed5i v\u0103n b\u1ea3n kh\u00f4ng c\u1ea5u tr\u00fac th\u00e0nh b\u1ea3ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp g\u1ecdn g\u00e0ng. Vi\u1ec7c \u0111\u1ecbnh&hellip;<\/p>","protected":false},"author":2,"featured_media":25215,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1,134],"tags":[],"class_list":["post-25250","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","category-google-workspace","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/25250","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=25250"}],"version-history":[{"count":2,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/25250\/revisions"}],"predecessor-version":[{"id":25252,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/25250\/revisions\/25252"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/25215"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=25250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=25250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=25250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}