{"id":260381,"date":"2026-04-21T19:44:50","date_gmt":"2026-04-21T17:44:50","guid":{"rendered":"https:\/\/www.sheetgo.com\/?page_id=260381"},"modified":"2026-05-18T21:34:52","modified_gmt":"2026-05-18T19:34:52","slug":"dividir","status":"publish","type":"page","link":"https:\/\/www.sheetgo.com\/es\/tools\/split\/","title":{"rendered":"Dividir una hoja de c\u00e1lculo por valor de columna"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_type=&#8221;circular&#8221; background_color_gradient_direction_radial=&#8221;top right&#8221; background_color_gradient_stops=&#8221;#d9e7ff 0%|#efedff 15%|#ffffff 30%|#ffffff 100%&#8221; custom_padding=&#8221;10px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;1_2,1_2&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;align-items: center;&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text module_class=&#8221;section-title&#8221; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; header_font=&#8221;|300|||||||&#8221; header_text_color=&#8221;#003999&#8243; header_font_size=&#8221;16px&#8221; header_2_font=&#8221;|300|||||||&#8221; header_2_text_color=&#8221;#003999&#8243; header_2_font_size=&#8221;16px&#8221; background_color=&#8221;#d9e7ff&#8221; custom_padding=&#8221;8px|10px|8px|10px|true|true&#8221; custom_css_main_element=&#8221;width: fit-content;&#8221; border_radii=&#8221;on|15px|15px|15px|15px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>Split CSV, Excel, or Google Sheets by Column Value<\/h1>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; header_2_font=&#8221;|800|||||||&#8221; header_2_font_size=&#8221;50px&#8221; header_2_line_height=&#8221;0.9em&#8221; header_3_font=&#8221;|800|||||||&#8221; header_3_font_size=&#8221;50px&#8221; header_3_line_height=&#8221;0.9em&#8221; header_2_font_size_tablet=&#8221;50px&#8221; header_2_font_size_phone=&#8221;38px&#8221; header_2_font_size_last_edited=&#8221;on|phone&#8221; header_2_line_height_tablet=&#8221;0.9em&#8221; header_2_line_height_phone=&#8221;0.8em&#8221; header_2_line_height_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h2>One file per group, or one tab per group \u2014 your choice<\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Break a single spreadsheet into multiple files (or tabs) based on a column&#8217;s unique values. Pick a column like &#8220;region&#8221; or &#8220;email&#8221;, and get one file per distinct value. CSV, Excel, Google Sheets, BigQuery, or REST API \u2014 free, in-browser, no signup.<\/p>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;#Tool&#8221; button_text=&#8221;Use the tool&#8221; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#FFFFFF&#8221; button_bg_color=&#8221;#2979FF&#8221; button_border_width=&#8221;0px&#8221; button_border_color=&#8221;#2979FF&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|600|||||||&#8221; button_icon=&#8221;&#xf063;||fa||900&#8243; button_on_hover=&#8221;off&#8221; custom_padding=&#8221;15px|35px|15px|20px|true|false&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_text_color__hover_enabled=&#8221;on|desktop&#8221; button_border_color__hover_enabled=&#8221;on|hover&#8221; button_border_color__hover=&#8221;#2666E2&#8243; button_text_color__hover=&#8221;#FFFFFF&#8221; button_bg_color__hover=&#8221;#2666E2&#8243; button_bg_enable_color__hover=&#8221;on&#8221;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h3 style=\"color:#003999;margin-bottom:16px;\">How it works<\/h3>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<div style=\"background:#ffffff;border:1px solid #deeaf7;border-radius:12px;padding:18px 22px;margin-bottom:14px;box-shadow:0 2px 10px rgba(0,57,153,0.04);\">\n<div style=\"color:#003999;font-weight:600;font-size:13px;letter-spacing:0.5px;text-transform:uppercase;margin-bottom:4px;\">Step 1<\/div>\n<div style=\"font-weight:600;font-size:17px;margin-bottom:6px;color:#1a1a1a;\">Connect your data<\/div>\n<div style=\"font-size:15px;color:#434F55;line-height:1.5;\">Upload CSV, Excel, or TSV, pick a Sheet from Google Drive, run a BigQuery query, or pull from a REST API.<\/div>\n<\/div>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<div style=\"background:#ffffff;border:1px solid #deeaf7;border-radius:12px;padding:18px 22px;margin-bottom:14px;box-shadow:0 2px 10px rgba(0,57,153,0.04);\">\n<div style=\"color:#003999;font-weight:600;font-size:13px;letter-spacing:0.5px;text-transform:uppercase;margin-bottom:4px;\">Step 2<\/div>\n<div style=\"font-weight:600;font-size:17px;margin-bottom:6px;color:#1a1a1a;\">Pick the split column<\/div>\n<div style=\"font-size:15px;color:#434F55;line-height:1.5;\">The column whose unique values define the split.<\/div>\n<\/div>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<div style=\"background:#ffffff;border:1px solid #deeaf7;border-radius:12px;padding:18px 22px;margin-bottom:14px;box-shadow:0 2px 10px rgba(0,57,153,0.04);\">\n<div style=\"color:#003999;font-weight:600;font-size:13px;letter-spacing:0.5px;text-transform:uppercase;margin-bottom:4px;\">Step 3<\/div>\n<div style=\"font-weight:600;font-size:17px;margin-bottom:6px;color:#1a1a1a;\">Choose output format<\/div>\n<div style=\"font-size:15px;color:#434F55;line-height:1.5;\">One file per value, or one tab per value inside a single Excel file.<\/div>\n<\/div>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;0px||0px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; width=&#8221;92%&#8221; max_width=&#8221;1280px&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_code module_id=&#8221;Tool&#8221; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; min_height=&#8221;400px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<div id=\"sheetgo-tool-embed\" style=\"width:100%;\"><\/div>\n<p><script>(function(){function getCookie(n){var m=document.cookie.match(new RegExp('(?:^|; )'+n.replace(\/[-.+*?^${}()|[]\\]\/g,'\\$&')+'=([^;]*)'));return m?decodeURIComponent(m[1]):null;}var lang=getCookie('trp_language')||'en';var i=document.createElement('iframe');i.src='https:\/\/www.sheetgo.com\/mini-apps\/split\/index.html?lang='+encodeURIComponent(lang);i.style.width='100%';i.style.height='900px';i.style.border='none';i.setAttribute('loading','lazy');i.setAttribute('title','Sheetgo mini-app');i.setAttribute('allow','clipboard-read; clipboard-write');document.getElementById('sheetgo-tool-embed').appendChild(i);})();<\/script>[\/et_pb_code][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_type=&#8221;circular&#8221; background_color_gradient_direction_radial=&#8221;bottom left&#8221; background_color_gradient_stops=&#8221;#d9e7ff 0%|#efedff 20%|#ffffff 40%|#ffffff 100%&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; text_orientation=&#8221;center&#8221; max_width=&#8221;780px&#8221; module_alignment=&#8221;center&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h3>Want to schedule this, not just run it once?<\/h3>\n<p style=\"font-size:18px;\">Splitting the same master report every week for different teams? Sheetgo can schedule this split, generate fresh per-team files automatically, and email them to each owner \u2014 no copy-paste.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/04\/google-workspace-add-on.svg&#8221; alt=&#8221;Get Sheetgo on Google Workspace Marketplace&#8221; title_text=&#8221;google-workspace-add-on&#8221; url=&#8221;https:\/\/workspace.google.com\/marketplace\/app\/sheetgo\/94172092257&#8243; url_new_window=&#8221;on&#8221; align=&#8221;center&#8221; admin_label=&#8221;B \/ CTA \/ SHEETS \/ CENTER&#8221; module_class=&#8221;add-n-button&#8221; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; min_height=&#8221;56px&#8221; height=&#8221;56px&#8221; global_module=&#8221;225051&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;50px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text module_class=&#8221;section-title&#8221; _builder_version=&#8221;4.27.5&#8243; _module_preset=&#8221;default&#8221; header_font=&#8221;|300|||||||&#8221; header_text_color=&#8221;#003999&#8243; header_font_size=&#8221;16px&#8221; header_2_font=&#8221;|300|||||||&#8221; header_2_text_color=&#8221;#003999&#8243; header_2_font_size=&#8221;16px&#8221; background_color=&#8221;#d9e7ff&#8221; custom_padding=&#8221;8px|10px|8px|10px|true|true&#8221; custom_css_main_element=&#8221;width: fit-content;&#8221; border_radii=&#8221;on|15px|15px|15px|15px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h2>Frequently Asked Question<\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h3>Dive deeper into splitting spreadsheets by value<\/h3>\n<p>Get the answers to your questions about splitting data by column[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.27.5&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.27.5&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][difl_faq enable_schema=&#8221;on&#8221; close_icon_color=&#8221;#82afff&#8221; close_icon_size=&#8221;28px&#8221; open_icon_color=&#8221;#82afff&#8221; faq_anime_duration=&#8221;200&#8243; faq_item_wrapper_bg_bgcolor=&#8221;#f3f7fc&#8221; que_text_margin=&#8221;10px|20px|10px|20px|true|true&#8221; ans_text_padding=&#8221;0px|20px|10px|20px|false|true&#8221; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; question_text_font=&#8221;|600|||||||&#8221; question_text_font_size=&#8221;19px&#8221; design_answer_text_font=&#8221;|300|||||||&#8221; design_answer_text_font_size=&#8221;16px&#8221; design_answer_text_line_height=&#8221;1.6em&#8221; border_radii_faq_item_wrapper_border=&#8221;on|12px|12px|12px|12px&#8221; border_color_all_faq_item_wrapper_border=&#8221;#deeaf7&#8243; global_colors_info=&#8221;{}&#8221; que_wrapper_bg_bgcolor__hover=&#8221;1px||||false|false&#8221; que_wrapper_bg_bgcolor__hover_enabled=&#8221;on|hover&#8221;][difl_faqitem question=&#8221;Can I split into one file per value, or one tab per value?&#8221; question_title_tag=&#8221;h3&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; design_answer_text_line_height=&#8221;1.4em&#8221; global_colors_info=&#8221;{}&#8221; que_wrapper_bg_bgcolor__hover=&#8221;1px||||false|false&#8221; que_wrapper_bg_bgcolor__hover_enabled=&#8221;on|hover&#8221;]<\/p>\n<p>Both. Choose file-per-value (e.g., 10 separate Excel files) or tab-per-value (one Excel file with 10 tabs).<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;What if a value appears in only one row?&#8221; question_title_tag=&#8221;h3&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; design_answer_text_line_height=&#8221;1.4em&#8221; global_colors_info=&#8221;{}&#8221; que_wrapper_bg_bgcolor__hover=&#8221;1px||||false|false&#8221; que_wrapper_bg_bgcolor__hover_enabled=&#8221;on|hover&#8221;]<\/p>\n<p>Each unique value produces its own subset, even if it contains just a single row.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;Does the header row get copied to each split?&#8221; question_title_tag=&#8221;h3&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; design_answer_text_line_height=&#8221;1.4em&#8221; global_colors_info=&#8221;{}&#8221; que_wrapper_bg_bgcolor__hover=&#8221;1px||||false|false&#8221; que_wrapper_bg_bgcolor__hover_enabled=&#8221;on|hover&#8221;]<\/p>\n<p>Yes. Every split file or tab gets its own copy of the header row.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;Can I split data from BigQuery or an API?&#8221; question_title_tag=&#8221;h3&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; design_answer_text_line_height=&#8221;1.4em&#8221; global_colors_info=&#8221;{}&#8221; que_wrapper_bg_bgcolor__hover=&#8221;1px||||false|false&#8221; que_wrapper_bg_bgcolor__hover_enabled=&#8221;on|hover&#8221;]<\/p>\n<p>Yes. Connect a BigQuery query or a REST API response and split the returned rows by any column.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;What else can I do with the Sheetgo add-on?&#8221; question_title_tag=&#8221;h3&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; design_answer_text_line_height=&#8221;1.4em&#8221; global_colors_info=&#8221;{}&#8221; que_wrapper_bg_bgcolor__hover=&#8221;1px||||false|false&#8221; que_wrapper_bg_bgcolor__hover_enabled=&#8221;on|hover&#8221;]<\/p>\n<p>Beyond scheduled automation, the Sheetgo add-on \u2014 powered by Sheetgo Workflows \u2014 can send personalized emails from spreadsheet rows, generate Google Docs or PDFs as mail-merge outputs, chain multiple processing steps into one flow (for example: filter &rarr; merge &rarr; dedupe &rarr; email), and orchestrate approvals across teams. Everything runs unattended once set up. One-click install from Google Workspace Marketplace.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;Which data sources can I connect to with Sheetgo?&#8221; question_title_tag=&#8221;h3&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; design_answer_text_line_height=&#8221;1.4em&#8221; global_colors_info=&#8221;{}&#8221; que_wrapper_bg_bgcolor__hover=&#8221;1px||||false|false&#8221; que_wrapper_bg_bgcolor__hover_enabled=&#8221;on|hover&#8221;]<\/p>\n<p>With the Sheetgo add-on, your automated flows can pull from Google Sheets, Excel, CSV files in Google Drive, BigQuery (with live SQL queries), and any REST API using Bearer Token, API Key, or Basic authentication. The output can land back in a spreadsheet, a generated Google Doc or PDF, an email, or any combination chained in a Workflow.<\/p>\n<p>[\/difl_faqitem][\/difl_faq][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.27.5&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/workflow_build-workflow.webp&#8221; alt=&#8221;FAQ image&#8221; title_text=&#8221;workflow_build-workflow&#8221; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Split CSV, Excel, or Google Sheets by Column ValueOne file per group, or one tab per group \u2014 your choiceBreak a single spreadsheet into multiple files (or tabs) based on a column&#8217;s unique values. Pick a column like &#8220;region&#8221; or &#8220;email&#8221;, and get one file per distinct value. CSV, Excel, Google Sheets, BigQuery, or REST [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":260374,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"difl_page_category":[],"class_list":["post-260381","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/260381","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=260381"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/260381\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/260374"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=260381"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/difl_page_category?post=260381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}