Need to convert an Excel file to Google Sheets? Rest assured, the process is not very complicated and explains step by step how here. Follow the leader.
When a team is collaborating on a project, members may need to edit a spreadsheet simultaneously. Fortunately, there is an easy way to convert Excel files to Google Sheets to achieve this. You can also transfer Google Sheets to Excel if your datasets exceed five million cells.
Read: Microsoft revamps Excel by letting you add your own data types
Is Google Sheets the same as Excel?
No, Google Sheets and Excel (and by extension Numbers on iOS and macOS) are very similar spreadsheet programs, but they share some key differences, such as how files are shared with others and how many cells you can to display.
Is Google Sheets compatible with Excel?
Yes, Google Sheets is compatible with Excel. You can download a sheet as an Excel file or email a copy of a sheet as an Excel file, as we’ll see.
How to convert an Excel file to Google Sheets?
First, upload the Excel file to your Google Drive and double click on the file to open it.
- Go to https://drive.google.com/drive/my-drive.
- Click New at the top left. Select and import your .XLS file.
- You’ll notice that although Excel files and Sheets files both have a green icon in Drive, an easy way to tell them apart is that Excel is marked with an “X” and Sheets marked with more than one “T” shape. .
- At the top, click Open with Google Sheets. Then click on File > Save as Google Sheets.
- You’ll find the Excel file and the new copy of the Sheets file in your Drive. It may be a good idea to give them different names to avoid confusion.
How to Convert Google Sheets to Excel File Format
You can work on a spreadsheet in Sheets and then download it or email a copy as an Excel or PDF file.
- To download a copy of a Sheets file and read it in Excel, click File > To download and select the appropriate format, in this case Microsoft Excel (XLSX).
- Alternatively, to email a copy of the sheet as an Excel file, click File > E-mail > Email this file. From the attachment options drop-down menu, select Microsoft Excel.
All you have to do is enter the recipient’s email address, subject and message. You can also send yourself a copy via the checkbox at the top.