How To Convert Xlsm To Google Sheets

by

If you have a macro-enabled Excel file (.xlsm) and wish to convert it to Google Sheets, you’ve come to the right place. This blog post will guide you through the steps to successfully do so. But before we dive in, it’s important to note that Google Sheets doesn’t support Excel’s VBA (Visual Basic for Applications) macros. However, you can still upload and convert the files —just remember that the macros won’t work.

Uploading XLSM Files to Google Drive

The first step to converting an XLSM file to Google Sheets is uploading the file to Google Drive. Follow the steps below:

  1. Open your Google Drive account.
  2. Click the “+ New” button on the left-hand side.
  3. Choose “File upload”.
  4. Select the XLSM file from your computer and click “Open”.

The file will then be uploaded to your Google Drive account.

Opening XLSM Files in Google Sheets

Now that your XLSM file is uploaded to Google Drive, you can open it with Google Sheets. Here’s how:

  1. Find the XLSM file in your Google Drive.
  2. Right-click on the file.
  3. Select “Open with” and then “Google Sheets”.

Your XLSM file will now open in Google Sheets. However, remember that any embedded macros will not function.

Converting XLSM Files to Google Sheets Format

After opening the XLSM file in Google Sheets, you’ll likely want to save it as a native Google Sheets file. To do this, follow these steps:

  1. With the document open in Google Sheets, click “File” in the upper left corner.
  2. Select “Save as Google Sheets”.

Google Sheets will create a copy of your XLSM file and save it in the native Google Sheets format. This new file will be stored in the same location as the original file in your Google Drive.

In Conclusion

Converting an XLSM file to Google Sheets is straightforward and requires only a few steps. However, due to Google Sheet’s lack of support for Excel’s VBA macros, macros from the original Excel file will not work in Google Sheets. If you rely heavily on macros, you might want to consider sticking with Excel. But if you’re looking for an easy way to share and collaborate on your Excel files, converting them to Google Sheets is a great solution.