{"id":43203,"date":"2023-07-10T21:55:23","date_gmt":"2023-07-10T19:55:23","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=43203"},"modified":"2026-10-08T00:35:44","modified_gmt":"2026-10-07T22:35:44","slug":"comment-fusionner-des-feuilles-de-calcul-google","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/how-to-solve-with-sheetgo\/how-to-merge-google-sheets\/","title":{"rendered":"Comment fusionner des feuilles de calcul Google"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_row _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>If you want to level up your data management game, look no further than <a href=\"https:\/\/www.google.com\/sheets\/about\/\" target=\"_blank\" rel=\"noopener\">Google Sheets<\/a>. It&#8217;s a very powerful, flexible, and affordable tool that can help you store, manage and analyze data. As a result, it has become a very popular spreadsheet application that is very helpful and easy to use. Businesses of all sizes and industries are using Google Sheets to manage their data.<\/p>\n<p>Although it&#8217;s relatively easy to manipulate data in Google Sheets, this powerful tool does come with some limitations. For instance, merging data from multiple files can be quite tricky in Google Sheets.<\/p>\n<p>However, you don&#8217;t have to worry. We&#8217;ll show you how you can merge Google Sheets easily and effortlessly. In this article, you will find a step-by-step guide on how to merge Google Sheets manually and automatically.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Why merge Google Sheets?<\/h2>\n<p>If you deal with multiple spreadsheets on a regular basis, chances are that you have already tried to consolidate data from different sheets into a single spreadsheet. By merging Google Sheets, you can bring together data from different sources, consolidate it into a single spreadsheet and create comprehensive reports.\u00a0<\/p>\n<p>When you merge data from multiple spreadsheets, you can:<\/p>\n<ul>\n<li>Consolidate data from multiple departments, locations, branches, projects or employees.<\/li>\n<li>Get a summary of data from multiple sources.<\/li>\n<li>Gain valuable insights from a more comprehensive analysis.<\/li>\n<li>Identify trends and patterns.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to merge Google Sheets manually<\/h2>\n<p>You can merge Google Sheets manually if you simply copy and paste data from the source files into a spreadsheet. All you need to do is copy the range of data you want to transfer and paste it into the destination file. You can keep copying data from as many sources as you want and pasting it into a master spreadsheet.<\/p>\n<p>Although it&#8217;s a simple and easy way to consolidate data from multiple sources, there are many drawbacks to this approach.<\/p>\n<ul>\n<li>Since it requires manually copying and pasting data, it can be a time-consuming process, especially when dealing with large datasets or frequent updates.<\/li>\n<li>Transferring data manually is prone to errors, which can lead to inaccuracies and inconsistencies.<\/li>\n<li>In order to keep your data always up-to-date, you would need to repeat the process whenever you add, remove or edit data.<\/li>\n<li>It&#8217;s not scalable. The more data you add, the more difficult it is to keep up with all the changes.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to merge Google Sheets with formulas<\/h2>\n<p>If you want to use a formula to merge data from multiple spreadsheets, you can use IMPORTRANGE, which is a built-in function in Google Sheets that allows you to transfer data between worksheets. Some of the advantages of using IMPORTRANGE include:<\/p>\n<ul>\n<li>Unlike copy-pasting, IMPORTRANGE enables you to transfer data automatically by using a formula. This makes the process of pulling data from a spreadsheet and transferring to another sheet easier and faster.<\/li>\n<li>Whenever you update the source spreadsheet, IMPORTRANGE automatically updates the destination file. This will keep your spreadsheet always up-to-date.<\/li>\n<li>Since it&#8217;s a built-in function in Google Sheets, you don&#8217;t need to download any software or add-on. You&#8217;ll be able to consolidate data in Google Sheets simply by using a formula.<\/li>\n<\/ul>\n<p>However, it&#8217;s important to keep in mind that IMPORTRANGE does come with some limitations.<\/p>\n<ul>\n<li>If you&#8217;re dealing with a significant amount of data and multiple complex formulas, the use of IMPORTRANGE can sometimes result in slow performance. You might need to wait for a long time until your spreadsheets are up-to-date.<\/li>\n<li>When you import data from multiple sources, you might get lost and lose track of all the multiple connections between your files.<\/li>\n<li>You may get some different errors when using the formula: formula parse errors, &#8220;spreadsheet cannot be found&#8221;, &#8220;cannot find range or sheet&#8221;, etc.<\/li>\n<li>When you transfer data from a sheet, you\u2019ll need to grant permission to access that sheet. Whoever has access to the destination file will also be able to access data from the source file. Thus, you won&#8217;t be able to protect your data or keep it private.<\/li>\n<\/ul>\n<p>If you want to learn how to use IMPORTRANGE in Google Sheets, <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/importrange\/\">check out this article<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to merge Google Sheets automatically<\/h2>\n<p>If you want to merge Google Sheets automatically, there&#8217;s a better way. With Sheetgo, you can create automated workflows to consolidate data effortlessly.<\/p>\n<ul>\n<li>Say goodbye to complex formulas: You don&#8217;t need to write any complex formulas to import data from multiple sheets. You will be able to import data with just a few clicks.<\/li>\n<li>Keep your formatting intact: Sheetgo can preserve formatting when importing data, so you don\u2019t have to waste time fixing it afterwards.<\/li>\n<li>Data privacy: You don\u2019t have to share the data from the source file. Sheetgo keeps the data from the source spreadsheet private, ensuring that only authorized users can access it.<\/li>\n<li>Less prone to errors: When you use the IMPORTRANGE formula, you can get a lot of errors. With Sheetgo, you can transfer data with a few clicks, reducing the chances of errors.<\/li>\n<\/ul>\n<p>Here&#8217;s how you can merge Google Sheets with Sheetgo.<\/p>\n<p>In this example, I&#8217;ll merge data from three gradebooks into a single file.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/07\/how-to-merge-google-sheets_1.png&#8221; title_text=&#8221;how to merge google sheets_1&#8243; _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Step 1: Sign up for Sheetgo<\/h3>\n<p>First, click the button below to sign up for Sheetgo and create your account.<\/p>\n<p>[\/et_pb_text][et_pb_code admin_label=&#8221;Sheetgo banner to web app&#8221; _builder_version=&#8221;4.22.2&#8243; background_color=&#8221;#f6f8f9&#8243; custom_padding=&#8221;12px||12px||true|false&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; border_width_all=&#8221;1px&#8221; border_color_all=&#8221;#f6f8f9&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<div style=\"display: flex; justify-content: space-around; align-items: center; flex-wrap: wrap;\"><!-- [et_pb_line_break_holder] --><\/p>\n<div style=\"margin: 0 10px 0 10px;\"><!-- [et_pb_line_break_holder] --><img decoding=\"async\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/08\/banner-logo-light.svg\" style=\"margin-top: 0px !important; margin-bottom: 0px !important; width: 100px; height: 100px;\"\/><!-- [et_pb_line_break_holder] --><\/div>\n<p><!-- [et_pb_line_break_holder] --><\/p>\n<div style=\"max-width: 40%; margin: 0 10px 0 10px;\" class=\"sheetgo-post-no-shadow-img\">\n<h4>Sheetgo Automations<\/h4>\n<p><!-- [et_pb_line_break_holder] --><\/div>\n<p><!-- [et_pb_line_break_holder] --><\/p>\n<div><!-- [et_pb_line_break_holder] --><\/p>\n<div class=\"md2-contained-button\" style=\"margin: 10px\"><!-- [et_pb_line_break_holder] --><a href=\"https:\/\/automations.sheetgo.com\/login\" target=\"_blank\" rel=\"noopener noreferrer\">Start free trial<\/a><!-- [et_pb_line_break_holder] --><\/div>\n<p><!-- [et_pb_line_break_holder] --><\/div>\n<p><!-- [et_pb_line_break_holder] --><\/div>\n<p><!-- [et_pb_line_break_holder] -->[\/et_pb_code][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Then, click <b>Create connection<\/b> to start building your workflow.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/07\/how-to-merge-google-sheets_2.png&#8221; title_text=&#8221;how to merge google sheets_2&#8243; _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Step 2: Select your data source<\/h3>\n<p>Now select your source. Since I want to merge data from multiple sources, I&#8217;ll choose <b>Multiple files<\/b>. You can also select <b>Files in a folder<\/b> if I want to merge data from all spreadsheets in a folder.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/07\/how-to-merge-google-sheets_3.png&#8221; title_text=&#8221;how to merge google sheets_3&#8243; _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Then click <b>Select file<\/b> to choose your source spreadsheets.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/07\/how-to-merge-google-sheets_4.png&#8221; title_text=&#8221;how to merge google sheets_4&#8243; _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Here I&#8217;ll select all my source files.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/07\/how-to-merge-google-sheets_5.png&#8221; title_text=&#8221;how to merge google sheets_5&#8243; _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>I&#8217;ll enable the <b>Transfer formatting<\/b> feature in order to preserve number formatting in the master spreadsheet.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/07\/how-to-merge-google-sheets_6.png&#8221; title_text=&#8221;how to merge google sheets_6&#8243; _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Step 3: Select a data processor<\/h3>\n<p>Now I can select a data processor. You can choose to filter or merge data. Here I&#8217;ll select <b>Merge<\/b>.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/07\/how-to-merge-google-sheets_7.png&#8221; title_text=&#8221;how to merge google sheets_7&#8243; _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Now you can select which row you want to use as a header. The default option is the first row.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/07\/how-to-merge-google-sheets_8.png&#8221; title_text=&#8221;how to merge google sheets_8&#8243; _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Step 4: Select your data destination<\/h3>\n<p>Now it&#8217;s time to select a destination. I&#8217;ll select Google Sheets.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/07\/how-to-merge-google-sheets_9.png&#8221; title_text=&#8221;how to merge google sheets_9&#8243; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; alt=&#8221;how to merge google sheets 9&#8243; sticky_enabled=&#8221;0&#8243;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Then I&#8217;ll choose the destination file. You can either let Sheetgo create a new file or use an existing spreadsheet. I&#8217;ll let Sheetgo create a new file. I&#8217;ll name it <b>Gradebook<\/b>.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/07\/how-to-merge-google-sheets_10.png&#8221; title_text=&#8221;how to merge google sheets_10&#8243; _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Choose a name for the tab. I&#8217;ll name it <b>Grades<\/b>.<\/p>\n<p>Click <b>Finish and save<\/b> to create the workflow.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Step 5: Automate the workflow<\/h3>\n<p>If you want to update the files manually, click <b>Run<\/b>.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/07\/how-to-merge-google-sheets_11.png&#8221; title_text=&#8221;how to merge google sheets_11&#8243; _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>In order to schedule automatic transfers, click <b>Automate<\/b>. Now you can schedule your workflow to run automatically. Select how often you want to update your workflow and click <b>Save<\/b>.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/07\/how-to-merge-google-sheets_12.png&#8221; title_text=&#8221;how to merge google sheets_12&#8243; _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>There you have it! Your workflow is up and running.<\/p>\n<p>You have merged data from multiple Google Sheets into a spreadsheet.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Automate data management with Sheetgo<\/h2>\n<p>Sheetgo is your go-to tool to transfer data between spreadsheets. With Sheetgo, you can not only merge multiple Google Sheets, but you can also transfer, filter and split data with just a few clicks.\u00a0<\/p>\n<p>If you want to split data from a spreadsheet into multiple files, check out this article on <a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/how-to-split-google-sheet-into-multiple-sheets\">how to split Google Sheet into multiple sheets<\/a>.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you want to level up your data management game, look no further than Google Sheets. It&#8217;s a very powerful, flexible, and affordable tool that can help you store, manage and analyze data. As a result, it has become a very popular spreadsheet application that is very helpful and easy to use. Businesses of all [&hellip;]<\/p>\n","protected":false},"author":42,"featured_media":42182,"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":[33],"tags":[],"class_list":["post-43203","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-solve-with-sheetgo"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/43203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/42"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=43203"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/43203\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/42182"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=43203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=43203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=43203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}