[et_pb_section fb_built=”1″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]You can manually make a table in Google Sheets or use Gemini, Google\u2019s AI. But how does it work?[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
You can make a table in Google Sheets in 5 ways:<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
The first way to make a table in Google Sheets is to enter data into cells manually.<\/p>\n
For example, I created a table to store attendee data from an online event.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_1.webp” title_text=”make-a-table-in-google-sheets_1″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″ border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d6e5f5″ background_color=”#f3f7fc” custom_padding=”20px|20px|20px|20px|true|true” custom_margin=”||40px||false|false”]Did you know?<\/b> This method is helpful if you want to start with a blank table structure.<\/p>\n 1. Click Insert > Tables<\/strong> at the top menu bar.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_2.webp” title_text=”make-a-table-in-google-sheets_2″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]2. A side panel will open on the right. Click \u201cInsert\u201d next to the table you want to create, whether it\u2019s an event, a project, or a content tracker.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_3.webp” title_text=”make-a-table-in-google-sheets_3″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n On May 14, 2024, Google announced<\/a> a new way to make a table in Google Sheets. Here is how it works:<\/p>\n 1. Manually enter your data in\u00a0 Google Sheets[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_4.webp” title_text=”make-a-table-in-google-sheets_4″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]2. Select your table and click Format > Convert to Table[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_5.webp” title_text=”make-a-table-in-google-sheets_5″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]And there you go! You just created a new table in Google Sheets.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_6.webp” title_text=”make-a-table-in-google-sheets_6″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n This method is also impressive because it allows you to format columns quickly.<\/p>\n 3. Click the arrow next to a header element and choose Edit column type > Dropdown<\/strong>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_7.webp” title_text=”make-a-table-in-google-sheets_7″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]4. A panel will open on the right. Choose your own colors and click Done.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_8.webp” title_text=”make-a-table-in-google-sheets_8″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n The fourth way to create a table in Google Sheets is to use Gemini, Google\u2019s AI.<\/p>\n 1. Select the cell where you want the table to start from and click the Gemini icon in the top-right corner of your Google Sheets. Then, write your prompt in the bottom-right corner and press \u201cEnter\u201d on your keyboard.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_9.webp” title_text=”make-a-table-in-google-sheets_9″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]2. Gemini will create a new table. If satisfied, click \u201cInsert\u201d or the \u201carrow\u201d icon.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_10.webp” title_text=”make-a-table-in-google-sheets_10″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]What if you aren\u2019t satisfied? You can give more instructions to Gemini. However, Gemini can sometimes tell you it cannot edit the Sheets content.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_11.webp” title_text=”make-a-table-in-google-sheets_11″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n However, you can still click the \u201cRetry\u201d icon to ask Gemini to try again.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_12.webp” title_text=”make-a-table-in-google-sheets_12″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n The fifth way to make a table in Google Sheets is in Gemini.<\/p>\n 1. Start a new chat in Gemini.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_13.webp” title_text=”make-a-table-in-google-sheets_13″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]2. Enter your prompt and click \u201cEnter\u201d on your keyboard or click the submit arrow.<\/p>\n Here is the prompt I used:<\/p>\n \u201cCreate a sales inventory table for a shop that sells electronics. The table should have 15 rows and the following columns: Item ID, Product Name, Category, Stock Quantity, Unit Price, Total Value\u201d<\/i><\/p><\/blockquote>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_14.webp” title_text=”make-a-table-in-google-sheets_14″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]3. Gemini will follow your instructions and create a table.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_15.webp” title_text=”make-a-table-in-google-sheets_15″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]4. Scroll down to the bottom of the table and click Export to Sheets > Open Sheets.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_16.webp” title_text=”make-a-table-in-google-sheets_16″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]You will now see your table in Google Sheets.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_17.webp” title_text=”make-a-table-in-google-sheets_17″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]5. Follow \u201cMethod 3\u201d in this article to convert your table.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_18.webp” title_text=”make-a-table-in-google-sheets_18″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n Google Sheets provides various advanced table formatting options to create professional-looking tables, such as:<\/p>\n Conditional formatting changes the appearance of cells (like background color, text color, or font style<\/a>) depending on the data they contain or their relationship to other data. For example, you can use conditional formatting to highlight duplicates in Google Sheets<\/a>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_19.webp” title_text=”make-a-table-in-google-sheets_19″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]For more information, check out our guide on conditional formatting<\/a>.<\/p>\n Alternating colors are excellent for large tables with many rows or columns. They help you easily follow the data across the table.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_20.webp” title_text=”make-a-table-in-google-sheets_20″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]For step-by-step instructions, check out our tutorial on how to create alternated colors in Google Sheets<\/a>.<\/p>\n In Google Sheets, a filter allows you to isolate relevant information without altering the original dataset. It can also temporarily hide rows that don’t meet specific criteria.<\/p>\n For example, here is my table before applying any filters: [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_21.webp” title_text=”make-a-table-in-google-sheets_21″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]Now, I want to see the Stock Quantity in descending order, from the highest number to the lowest.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/make-a-table-in-google-sheets_22.webp” title_text=”make-a-table-in-google-sheets_22″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n For more information, check out our complete guide on Google Sheets filters<\/a>.<\/p>\n There are also\u00a0 more ways to format your tables in Google Sheets, like:<\/p>\n And there you have it! This guide showed you five ways to create tables in Google Sheets. You can create and design the table manually or use AI (Gemini) to do it faster.<\/p>\n You can also check out the following guides to make better Google Sheets tables.<\/span><\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" You can manually make a table in Google Sheets or use Gemini, Google\u2019s AI. But how does it work?How to make a table in Google Sheets? You can make a table in Google Sheets in 5 ways: Enter data manually Insert a table Enter data and convert to table Create a table with Gemini (AI) […]<\/p>\n","protected":false},"author":2,"featured_media":44470,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-50587","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/50587","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=50587"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/50587\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/44470"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=50587"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=50587"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=50587"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nYou can save daily hours by automating Google Sheets workflows and eliminating manual data entry. For example, you can sign up for Sheetgo<\/a> to create forms to collect data from users and automatically populate your Google Sheets file.[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\nMethod 2: Insert a table<\/h3>\n
Method 3: Enter data and convert to table<\/h3>\n
Method 4: Create a table with Gemini directly in Google Sheets<\/h3>\n
Method 5: Create a Google Sheets table directly in Gemini<\/h3>\n
Table advanced formatting options<\/h2>\n
1. Conditional formatting<\/h3>\n
2. Alternating colors<\/h3>\n
3. Filters<\/h3>\n
\n
You can create a table in Google Sheets<\/h2>\n
\n