Google Sheets

Comentarios: Overall I am very happy with google sheets. It helps me collect and organise data, generate reports, charts etc. And collaborate with co-workers and very easily share my sheets with friends.

Puntos a favor: It is very user friendly and you can share with your co-workers. It has wonderful collaboration functionalities, that multiple co-workers can view or edit the same spread sheet at the same time. And you can see it at real time. It provides data analytics functions, that let you create pivot tables to generate reports, graphs, charts, etc. I can also build forms within the sheet and creating a little programming functions to automate some tasks. It can be attached within email very easily, very well integrated with gmail.

Contras: I have used Microsoft Excel for a very long time. Google sheets have some different shortcuts that makes me get confused sometimes. Also when you enter url links into the cell, and I always accidentally click on it and open a web page, but I only want to edit that field. When data set is too big, it gets extremely slow and sometimes it crashes itself and won't even open. It would be nice if the performance can be improved.

Comentarios: Google sheets has been easy to use and colleagues are able to integrate it easily into their workflow.

Puntos a favor: This software enables real time editing by multiple users. Users are able to edit Google sheets, with the same functionality as Excel, and other users view or also edit the sheet edits in real time. There is no more conflicting copies of documents or multiple documents with different edits. It is all in one place and one up to date file.

Contras: The use of this software requires an internet connection.

Comentarios: I honestly don't even use Microsoft Excel anymore, since it's a great value for the price of free and it does everything Excel does and you can coillaborate with others.

Puntos a favor: How robust it is for an online application and how good it can handle complex formulas and allow you to online-share and live work with coworkers when analyzing data. Also the options to export it as an .xls and mobile app offerings that can allow me to keep track of the ranges of application data I need to use. You can share the links with permissions and if you're in a group/organization you can also keep the files safe for coworkers. Exporting is great too for working with Excel and same with importing excel documents.

Contras: Sometimes the mobile offering can lack a bit. It's mostly based for basic data viewing and nothing too heavy and complex. Same with trying to open the link on an mobile phone. If there's a lot of tabs with data, it can be really laggy and take a while to load. Also sometimes importing stuff from Excel won't show appropiately because they are Microsoft propietary so keep in mind when importing excel spreadsheets.

Comentarios: It’s been great up to these access issues which are locking people out. Several searches for solutions have not been able to resolve this issue, including Google Sheet resources. It’s been very frustrating and worrisome due to the sensitive information managed in these files.

Puntos a favor: Great for working in teams and staying in sync

Contras: Recently, google cloud products such as sheets or docs have been locking our accounts out every few minutes (revoking access). Even to the file owners (who have max control).

Comentarios: I do most, if not all, of my record-keeping in Sheets. It's length can be continued on and on without bogging down your computer like a large Excel file would. And being able to access it from anywhere at any time is a major plus.

Puntos a favor: Sheets is almost as good as Excel, but with slightly fewer features. My favorite thing about it, though, is that it's free and automatically saves to the cloud, meaning it can be accessed by just logging into your account from anywhere with an internet connection. Also very useful is being able to share it with others and collaborate on documents simultaneously, which is great for team projects. It also has a mobile phone app which is convenient for quick, on-the-fly changes. That is mainly why I switched from Excel.

Contras: It does have slightly fewer features than Excel, but mostly ones I can live without. I'm sure there's a way to do macros in Sheets, but that requires plugins and the like and I'm not quite advanced enough to do that. I also wish there were optional in-app tutorials on things like how to write a specific formula or whatever.