{"id":260379,"date":"2026-04-21T19:44:42","date_gmt":"2026-04-21T17:44:42","guid":{"rendered":"https:\/\/www.sheetgo.com\/?page_id=260379"},"modified":"2026-05-18T21:34:50","modified_gmt":"2026-05-18T19:34:50","slug":"mesclar","status":"publish","type":"page","link":"https:\/\/www.sheetgo.com\/pt\/tools\/merge\/","title":{"rendered":"Mesclar M\u00faltiplos Arquivos CSV ou Excel"},"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>Merge Multiple CSV or Excel Files Into One<\/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>Stack rows from many files into a single sheet \u2014 including multi-row headers<\/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>Combine two or more CSV, Excel, or Google Sheets files by stacking their rows into one master file. Supports multi-row headers (useful when your spreadsheets have two or three header rows). Runs in your browser \u2014 no upload, 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;\">Select multiple files<\/div>\n<div style=\"font-size:15px;color:#434F55;line-height:1.5;\">Upload several files, or pick Sheets from Google Drive, BigQuery queries, or REST API endpoints.<\/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;\">Set the header row count<\/div>\n<div style=\"font-size:15px;color:#434F55;line-height:1.5;\">Tell the tool whether your files have one, two, or three header rows so they&#8217;re preserved correctly.<\/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;\">Download one merged file<\/div>\n<div style=\"font-size:15px;color:#434F55;line-height:1.5;\">A single consolidated file with all rows, headers intact.<\/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\/merge\/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;\">Consolidating the same set of reports every week? Sheetgo can watch a Google Drive folder and automatically merge any new files into your master sheet \u2014 scheduled, hands-off, repeatable.<\/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 merging spreadsheet files<\/h3>\n<p>Get the answers to your questions about combining spreadsheets[\/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 handle files with multi-row headers?&#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. Tell the tool whether your header spans one, two, or more rows and it will preserve that structure when stacking data below.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;Do the files need matching columns?&#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>Ideally yes \u2014 matching column headers makes the merge clean. The tool flags mismatches and lets you decide how to handle them.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;How many files can I merge?&#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>Any practical number. Memory is the only real limit in your browser.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;Can I merge data from BigQuery or APIs?&#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. Combine results from BigQuery queries, REST API endpoints, and files \u2014 all stacked into one master sheet.<\/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>Merge Multiple CSV or Excel Files Into OneStack rows from many files into a single sheet \u2014 including multi-row headersCombine two or more CSV, Excel, or Google Sheets files by stacking their rows into one master file. Supports multi-row headers (useful when your spreadsheets have two or three header rows). Runs in your browser \u2014 [&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-260379","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/260379","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/page"}],"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=260379"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/260379\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/260374"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=260379"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/difl_page_category?post=260379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}