{"id":5052,"date":"2021-01-05T17:02:00","date_gmt":"2021-01-05T16:02:00","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=5052"},"modified":"2025-12-17T19:54:28","modified_gmt":"2025-12-17T18:54:28","slug":"convert-excel-to-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/how-to-solve-with-sheetgo\/convert-excel-to-google-sheets\/","title":{"rendered":"Comment convertir automatiquement Excel en Google Sheets"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ custom_padding=”54px|5px|3px|0px|false|false” da_disable_devices=”off|off|off” 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”][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.3″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Microsoft Excel has been the world’s leading business application for more than 3 decades. Indeed, “Excel” and “spreadsheet” are often used as synonyms. With hundreds of advanced functions, Excel is still the tool of choice for many businesses, but Google Sheets is a good alternative.<\/p>\n

Because it’s cloud-based, Google Sheets and the other Google Workspace<\/a> apps (formerly known as G Suite) are simple to use, accessible from anywhere, and great for collaboration. You access Google Sheets via your web browser, so you don’t need to install any software\u00a0\u2014 all you need is an internet connection.<\/p>\n

Both tools have their pros and cons. This means that it’s now common for companies to use both spreadsheet formats. As a result, many people will need a way to convert Excel to Google Sheets<\/strong>, and vice versa.<\/p>\n

You can use Sheetgo to connect Excel to Google Sheets<\/a><\/a>.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.27.3″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Migrating from Excel to Google Sheets or working with both?<\/h2>\n

It might seem like your team is permanently migrating to Google Workspace, but keeps receiving data or reports in Excel files.<\/p>\n

Some companies restrict employees to Excel and insist that staff only share files as attachments.<\/p>\n

At other times, it comes down to personal preference: analysts sometimes prefer to use Excel for heavy data processing before transferring that information to Google Sheets for collaboration and reporting.<\/p>\n

Sometimes, Google Sheets can be used as an input source for other software, such as Google Data Studio<\/a>.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”excel-vs-google-sheets” _builder_version=”4.27.3″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Which is better? Excel vs Google Sheets<\/h2>\n

There’s no easy answer here, as it depends on your needs and what you’re used to!<\/p>\n

In general, Excel is a more powerful option for heavy users processing large amounts of data. But when it comes to online collaboration and ease of use, Google Sheets leads the way. Check out our full side-by-side comparison of Excel and Google Sheets<\/a>.<\/p>\n

Here’s a quick\u00a0summary of how the two programs compare:<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

Excel<\/h4>\n<\/td>\n

\n

Google Sheets<\/h4>\n<\/td>\n<\/tr>\n

Allows for large datasets (up to 17 million cells).<\/td>\nFile size limited to 5 million cells.<\/td>\n<\/tr>\n
Co-authoring is available in\u00a0.xlsx, .xlsm, or .xlsb formats saved in OneDrive or Sharepoint.<\/td>\nIntuitive collaboration functions (including chat) make it easy to work together in real-time.<\/td>\n<\/tr>\n
The desktop version requires you to hit “save”.<\/td>\nChanges are automatically saved to the cloud.<\/td>\n<\/tr>\n
New versions of (offline) files must be shared manually.<\/td>\nFiles are updated in real-time, meaning everyone sees the latest version. Easy sharing.<\/td>\n<\/tr>\n
Requires a Microsoft Office license.<\/td>\nFree to use on a personal Google account.<\/td>\n<\/tr>\n
It’s possible to lock individual workbooks with a password.<\/td>\nThree levels of access control when sharing (view, comment, and edit).<\/td>\n<\/tr>\n
Powerful for statistical analysis and visualization.<\/td>\nInternet latency can cause slow file processing.<\/td>\n<\/tr>\n
Advanced functions make it popular with analysts doing heavy number crunching.<\/td>\nSimpler and user-friendly for spreadsheet beginners.<\/td>\n<\/tr>\n
Can be used offline or online.<\/td>\nOnline only. Files are accessible from any device, anywhere, at any time.\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.27.3″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Supported file types for converting Excel to Google Sheets<\/span><\/h2>\n

Before you get started with converting your Excel files to Google Sheets, it’s important to know which file types are supported.<\/span><\/p>\n

The good news is that Google Sheets can convert a variety of file formats created by Excel, including .xls, .xlsx, .xlsm, .xlt, .xltx, and .xltm. So, if you’ve been using an older version of Excel or if you have macros in your files, don’t worry \u2013 Google Sheets has got you covered.<\/span><\/p>\n

Additionally, Google Sheets can also convert other file types such as .csv and .tsv, which are commonly used for data exchange between different systems. So, if you have data in a different format that you need to work on in Google Sheets, you can easily convert it.<\/span><\/p>\n

It’s important to keep in mind that some of the advanced features in your Excel files may not be supported when you convert them to Google Sheets.\u00a0<\/span><\/p>\n

[\/et_pb_text][et_pb_video src=”https:\/\/www.youtube.com\/watch?v=k6DBnWjqZEs” _builder_version=”4.24.1″ _module_preset=”default” custom_margin=”15px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_video][et_pb_text module_id=”upload-excel-to-google-sheets-manually” _builder_version=”4.27.3″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to transfer Excel to Google Sheets<\/h2>\n

There are two ways to do this.<\/p>\n

The first method is OK if you want to convert Excel to Google Sheets<\/strong> on a one-off, ad-hoc basis.<\/p>\n

The second option is to use Sheetgo to automatically sync Excel to Sheets<\/strong> regularly. This approach can only be followed during Sheetgo’s free trial period or by purchasing any paid plan.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.27.3″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

1. Upload manually<\/h3>\n
    \n
  1. Upload the Excel file to your Google Drive.<\/span><\/li>\n
  2. Double-click on the file and it will open.<\/li>\n
  3. At the top of the screen, click File<\/strong> >\u00a0Save as Google Sheets.<\/strong><\/li>\n<\/ol>\n

    This will convert the file. The new Google Sheets version of the file is now saved in your Drive, alongside the original Excel workbook.<\/p>\n

    [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/01\/excel-google-sheets-source-data-select-tab-\u2013-1.png” alt=”convert-excel-to-google-sheets-save-as-sheets” title_text=”excel-google-sheets-source-data-select-tab \u2013 1″ _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

    You can also manually import data from Excel into a Google Sheets file from inside the spreadsheet.<\/p>\n

      \n
    1. Open a Google Sheets file.<\/li>\n
    2. Go to File<\/strong> > Import<\/strong>.<\/li>\n
    3. Choose your Excel file and click Select<\/strong>.<\/li>\n
    4. Choose from the options: Create new spreadsheet<\/strong>, Insert new sheet(s)<\/strong>, or Replace spreadsheet<\/strong>.<\/li>\n
    5. Click Import data<\/strong>.<\/li>\n<\/ol>\n

      [\/et_pb_text][et_pb_text module_id=”problems-converting-excel-to-google-sheets” _builder_version=”4.27.3″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

      Problems converting Excel to Sheets<\/h3>\n

      The manual upload or import method is straightforward but you might run into a couple of issues.<\/p>\n

      Firstly, Google Sheets may notify you that some Excel features are not compatible.<\/p>\n

      Here’s the type of message you might see:<\/p>\n

      [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/01\/excel-google-sheets-error-message.png” alt=”convert-excel-google-sheets-error-message” title_text=”excel-google-sheets-error-message” _builder_version=”4.16″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

      There are other potential drawbacks to this approach too.<\/p>\n