How To Use Google Sheets Instead Of Excel

This will export a version of the file that is ready to be edited within microsoft.

How to use google sheets instead of excel. They were sending an excel with periods and xls instead of xls. In google sheets click file then click import. Here s what you do. So now that you are ready to use spreadsheets in your classroom here are 6 reasons why you should use google sheets instead of excel. On june 6 2006 google released a spreadsheets product as a limited test to a small number of users.

When you should use google sheets 1. Moving from excel to google sheets even if you use excel exclusively someone may need to open a spreadsheet in google sheets. All cofc students already have google accounts so it s very easy to share a spreadsheet with them or for them to share with one another. You can set your google drive to automatically convert subsequent uploads of excel files to google sheet format. You can convert xlsx csv and a few other file types.

Click settings from the options that show up. You can rename your sheet in the top left corner. You want to share and collaborate. I think it s fair to say that shared workbooks in microsoft excel are in short terrible. The google sheet editing window this is what your blank google sheet will look like.

While in google drive right click on the file you want to be reverted. Google enables you to use many of its other programs within sheets. You can set this up as follows. By using formulas like googletranslate or googlefinance you can take advantage of the numerous other free products that google offers without even having to leave the spreadsheet. Once the excel file uploads sheets automatically converts and opens it ready for you to start to edit share and collaborate.

Getting started with google sheets is user friendly and pretty intuitive. This will save you a lot of time if you need to often use excel files in google sheets. That limited test stuck around and google sheets is now widely used as a sub feature of google docs the product resembles a simple version of microsoft excel with some web enabled features such as easy collaboration. Should you have the need you can easily revert the newly converted google sheet back into xls file format. Click on the gear icon on the top right.