Issue: Not able to open Microsoft Excel on G-Suite (Google Spreadsheet)
Open Excel File in from Google Drive
If your Excel XLS is already in Google Drive, it is easy to convert it to Google Sheets.
First, right-click on the file in Google Drive.
Next, choose Open with and then choose Google Sheets.
Your spreadsheet will now be converted to Google Sheets.
Convert Excel To Google Sheets
You can upload an Excel file and convert it to Google Sheets when you upload it.
To do that, go to the Google Sheets Home.
Then hit the Open file picker icon in the top-right corner.
Next, hit the Upload tab and drag your XLS file into the Upload section or hit Select a file from your computer and choose the Excel file you want to upload.
Your file will then be uploaded and converted to Google Sheets.
What You Can And Can Not Convert
Here is what Google Sheets will convert:
Spreadsheets: .xls (if newer than Microsoft® Office 95), .xlsx, .xlsm, .xlt, .xltx, .xltm .ods, .csv, .tsv, .txt, .tab
Here are the features that are not supported:
- Password protected files
- Macros (you can implement your macro in Apps Script)
- Embedded charts in Word and PowerPoint files
- Linked spreadsheets in Excel files
Excel files containing Macros will need to be manually re-created in Google Sheets
Gary's stance on the matter is as follows: "We can't unfortunately provide support for franchisee created sheets with macros. They'll need to take the time to convert to sheets themselves but in the meantime excel can still be accessed via RDS, so they can continue to use it. If these are documents that the brand created (or centrally created) and now the franchisee uses, we'll need to help the originating department convert them" - Gary Black.