Three levels of access control when sharing (view, comment, and edit).

It’s possible to lock individual workbooks with a password.

Easy sharing.įree to use on a personal Google account. New versions of (offline) files must be shared manually.įiles are updated in real-time, meaning everyone sees the latest version. The desktop version requires you to hit “save”.Ĭhanges are automatically saved to the cloud. Intuitive collaboration functions (including chat) make it easy to work together in real-time. xlsb formats saved in OneDrive or Sharepoint. An easy way to do this is using Sheetgo’s add-on for Excel and Google Sheets.Īllows for large datasets (up to 17 million cells).Ĭo-authoring is available in .xlsx. As a result, many people will need a way to convert Excel to Google Sheets, and vice versa. This means that it’s now common for companies to use both spreadsheet formats. On top of that, you can see what’s happening with your data in real-time.īoth tools have their pros and cons. You access Google Sheets via your web browser, so you don’t need to install any software - all you need is an internet connection.Īlthough it’s a bit more basic than Excel, Google Sheets is free and it offers small businesses a great alternative to purchasing a Microsoft Office license.Īnyone can access Google Sheets files via their browser, multiple users can work in the same sheet simultaneously and changes are saved automatically. Because it’s cloud-based, Google Sheets and the other Google Workspace apps (formerly known as G Suite) are simple to use, accessible from anywhere, and great for collaboration.

With hundreds of advanced functions, Excel is still the tool of choice for many businesses, but Google Sheets is a good alternative. When it comes to flexibility and accessibility, nothing beats a spreadsheet for data management and analysis. According to Microsoft, an estimated 1 in 5 adults on the planet use Excel and there’s no sign of that changing any time soon. Indeed for many people, the name Excel is synonymous with the word spreadsheet. Microsoft Excel has been the world’s leading business application for more than 3 decades.

Open google drive file in excel