Comment fusionner plusieurs fichiers Excel en un seul

How many different Excel files do you open on a single day? Do you need to merge Excel files and combine data from multiple spreadsheets?  If you’re an analyst or administrator who collects information from across the company, chances are you spend a fair amount of time gathering and combining data from multiple files.

Excel has powerful data storage and management capabilities. One workbook alone can hold millions of cells and hundreds of sheets, limited only by your computer’s memory. And if you upload your Excel files to OneDrive, you can use Excel for the web’s fonction de co-auteur to share files and collaborate with colleagues.

But when you want to combine multiple Excel sheets ou merge multiple files into one, there is no simple inbuilt solution.

If you’re preparing a report, it’s time-consuming to search for the right information and compile a new spreadsheet manually. You might have to ask colleagues to send you their latest file versions before copy-pasting data from multiple sheets.

Not only is that tedious, but it’s also easy to make mistakes. And by the time you’ve finished, the data might already be out of date.

Instead of combining Excel sheets manually, you can create connections between your spreadsheets. This allows you to merge multiple files into one automatically. The connections will pull data from several sheets into a central master sheet. Once you’ve set up the system, you can generate new reports on demand.

A simple way to combine Excel files

By connecting your Excel files, you can sync data between them. This means that when you combine multiple sheets into one, changes in each individual file will be updated in the central file automatically.

An automated file merging system has many advantages. It enables you to:

• Combine multiple Excel sheets into one workbook
• Save time — no more copy-pasting
• Collect information from colleagues automatically
• Merge data from different sheets in Excel
• Share data without sharing the same spreadsheet
• Get accurate data that’s always up-to-date
• Pull data directly into reports
• Feed dashboards with data from multiple Excel files
• Dedicate one file to one task
• Avoid large, heavy spreadsheets
• Ensure better traceability and data governance

Why use Sheetgo to merge multiple Excel files into one

Sheetgo simplifies the merging process by automatically sending and combining data from multiple sources into a single file. Some of the benefits of using Sheetgo include:

• You don’t have to copy and paste data from one spreadsheet to another
• You don’t need to write complex VBA macros
• You can update the destination file by scheduling automatic updates

All you need to do is create a simple and easy-to-use automated workflow. After creating a workflow with just a few clicks, Sheetgo will do all the heavy lifting for you.

Comment fusionner plusieurs fichiers Excel en un seul

Sheetgo is a no-code tool that enables you to push and pull data between worksheets in different spreadsheets automatically.

Here I’ll show you how to consolidate three sheets (in three separate Excel files) into one central spreadsheet for analysis.

Changes to the data in the source sheets will be synced to the central spreadsheet each time there’s an update.

Étape 1 : Installer Sheetgo

Click on the blue button below to install Sheetgo and start connecting.

Sheetgo allows you to connect Excel files stored on any of the main cloud storage platforms, so you’ll see that you have the option to log in with your Microsoft, Google, or Dropbox account.

Inside Sheetgo click +Créer un flux de travail et ensuite Connecter to start combining your spreadsheets.

En haut de l'écran, donnez votre Flux de travail sans titre un nom afin de pouvoir l'identifier ultérieurement.

In this example, I’ll call my workflow Merge Excel Files.

Step 2: Select the Excel files you want to merge

Dans Sheetgo, cliquez sur Nouveau flux de travail to get started. Give your Flux de travail sans titre un nom en haut de l'écran. Ici, je l'appellerai Merge Excel files. 

Then, click on Créer une connexion pour commencer à construire votre système de conversion de Google Sheets vers Excel.

• Sous Sélectionner la source, cliquer sur Fichier(s) de feuilles.

• Sous Source, cliquer sur Sélectionner un fichier.
• Cliquez sur +Sélectionner le(s) fichier(s) to find the first Excel file in your cloud storage.

If you’re working with the desktop version of Excel, it’s easy to sync your local files to OneDrive or another cloud storage platform. Just follow the steps provided here:

When you’ve selected the first file you want to merge, it appears inside Sheetgo. 

Sous Onglet Fichier, make sure you select the correct onglet source. This is the specific tab (worksheet) that contains the data you want to merge.

Cliquez maintenant sur +Ajouter un autre fichier source to select the next file you want to merge.

Select the file and the same tab.

As you can see below, I am consolidating data from three separate Business units.

Check your source tabs are the same

To consolidate data from multiple Excel sheets into one, the source tab must have the même nom in every file.

Each tab should also have the same column structure and layout so that Sheetgo can combine the data correctly.

Data traceability

When you consolidate multiple sheets into one, you may want to be able to see which source file the data originated from. To do this, enable the Identifier les données setting.

• Sous Advanced settings, enable Identify data.
• Now choose your selected identifier.

Sheetgo will create an additional column in the destination spreadsheet identifying which file the data was imported from.

Here I’ll select Nom du fichier source as the identifier.

Repeat the above steps until you’ve added all the Excel files you want to merge.

When they are all visible on the Sheetgo screen, click the blue Prochaine étape bouton.

Étape 3 : Sélection d'un responsable du traitement des données

Vous pouvez maintenant sélectionner un responsable du traitement des données. 

Sélectionner Filtrer si vous souhaitez transférer des données filtrées de Google Sheets vers Excel.

Sélectionner Fusionner if you want to combine data from multiple Excel sheets.

Dans ce cas, sélectionnez Fusionner. Select which row you want to use as a header.

Cliquez ensuite sur Prochaine étape.

Étape 4 : Choisissez votre fichier de destination

Now it’s time to select which Excel file you want the data to be consolidated, or merged, into. 

Since I want to send the data to an Excel file, select Fichier(s) de feuilles.

Sous Send data, sélectionner Fichier Excel.

Les destination file is the spreadsheet where your source data will be consolidated.

Note that when Sheetgo transfers your data from sheet to sheet, your source file(s) remain unchanged.

You have the option to send the data to an existing file or a new file. In both cases, Sheetgo will create a new tab in the destination file, containing the consolidated data.

Merge into an existing file

1. Sélectionner Excel as the file type. 
2. Sélectionner Dossier existant > +Select file.
3. Choose a file from any of your cloud storage solutions.
4. Optional: under Onglet Nouveau fichier give the new tab a name of your choice.

Merge into a new file

If you use this option, Sheetgo will create a new file for you automatically.

1. Sélectionner Excel as the file type.
2. Sélectionner Nouveau dossier.
3. By default, the file will be saved to your main cloud storage folder. Click Changer le dossier de destination to select another cloud storage platform or a specific folder.
4. Give the file a name in the Nom du fichier boîte.
5. Optional: give the new tab a name in the Tab Name boîte. 

Here, I want Sheetgo to create a new Excel file for me, saved in Google Drive.

I’ll name the new file Business units and the tab Merged data.

Cliquez sur Terminer et sauvegarder et Sheetgo créera la connexion.

Cliquez sur Flux de travail to see how your Excel files are connected.

As you can see, data from my three source files are now flowing into my central file Business units.

A partir de la Flux de travail ou Dossiers menu, double-click on a file to open it.

Here I’ll take a look at my new destination file: Business units.

As you can see, Sheetgo has consolidated the data from my source files into a new tab in the destination sheet.

In Column D, Sheetgo has added a Column (called Source) indicating which file the data originated from.

Step 5: Update the connections

Now that your files are connected with Sheetgo, you can update the workflow any time.

• Open Sheetgo and select the workflow from the list on the left.
• Cliquez sur Exécuter dans la barre de menu.

This will refresh all the connections, updating the destination sheet with the latest data from your source sheets.

Étape 6 : Automatiser le flux de travail

Your Excel file merging workflow is now up and running.

To save time and ensure you’ve always got the latest data, you can automate the entire system.

• Cliquez sur Automatiser on the Sheetgo menu bar inside your workflow
• Choose how frequently you want updates: from once an hour, to once a month.
• Select which time of day, or day(s) of the week you want it to be updated.

Want to combine a large number of Excel sheets?

Sheetgo enables you to combine data from an unlimited amount of source files into one. Instead of selecting each file manually, you can save time and automate another stage of your work by consolidating from a folder.

To combine data from multiple Excel files in a folder,

• Open Sheetgo and create a new workflow > Connect.
• Sous Source data, sélectionner An entire folder.

As before, each source file must have the same column format and source tab.

Whenever you add a new file to the folder, it will be automatically included in the Consolider connection with the next update.

Automatically merge Excel files

That’s how to combine and consolidate data from multiple Excel workbooks into a single file for automated reporting and analysis.

Looking for a way to transfer specific data from a worksheet? Learn how to filter Excel from one workbook to the other automatiquement.