Wir helfen Unternehmen in der Schweiz
seit 17 Jahren bei der Softwareauswahl

Über Google Sheets

Entwickelt zum Erstellen, Ändern und Freigeben von Tabellen in Echtzeit. Vorgefertigte Vorlagen, Chats und Kommentare stehen zur Verfügung.

Erfahre mehr über Google Sheets

Vorteile:

Even greater is that since a sheet file can be uploaded in Google Cloud, then sharing the file and having the file available for all tech supports across the university.

Nachteile:

I hate that there is no customer support really when you are having an issue and you have to go to the forums.

Bewertungen zu Google Sheets

Durchschnittliche Bewertung

Benutzerfreundlichkeit
4.6
Kundenservice
4.4
Funktionen
4.4
Preis-Leistungs-Verhältnis
4.8

Weiterempfehlungsquote

9.1/10

Google Sheets hat eine Gesamtbewertung von 4.7 von 5 Sternen basierend auf 13’079 Nutzerbewertungen auf Capterra.

Haben Sie Google Sheets bereits verwendet?

Teile deine Erfahrungen mit anderen Softwarekäufern.

Nutzerbewertungen filtern (13’079)

Laura
Laura
Owner
Verifizierter Nutzer auf LinkedIn
E-Learning, 2–10 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

I've used Google Sheets for long distance grant proposal development.

5.0 vor 2 Jahren
Untertitel auf Deutsch sind im Videoplayer verfügbar
Laura
Marketing Manager in Spanien
Marketing & Werbung, Selbstständig
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Ich bin zufrieden

4.0 letztes Jahr

Kommentare: Top Produkt! Top Preis-Leistung!

Vorteile:

Dafür, dass Google Sheets kostenlos ist, ist es wirklich top! Alle Funktionen sind vorhanden und die Anwendung ist einfach

Nachteile:

Manche Funktionen erscheinen mir etwas weniger intuitiv als bei Excel, aber das stört mich nicht besonders.

Kevin
Finanzberater in Deutschland
Finanzdienstleistungen, Selbstständig
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Für jeden sinnvoll!

5.0 vor 3 Monaten

Vorteile:

Sehr umfangreich und trotzdem bildet es alles ab, was ich für das führen von Statistiken oder zur Pflege von Leads benötige.

Nachteile:

Gerade die Formeln können am Anfang für Verwirrung sorgen. Ich brauche immer etwas Zeit um wieder rein zu kommen.

Tanishq
Tanishq
Content Writer and Digital Marketing Executive in Indien
Verifizierter Nutzer auf LinkedIn
Verbraucherdienste, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Take your reporting to the next level with Google Sheets

5.0 vor 5 Jahren

Kommentare: User friendly with good and exciting features supporting the requirements of today's day and age.

Vorteile:

1. Simple and easy to understand with all the necessary tools available right in front of the eyes. 2. Uploading and downloading feature with multiple file format support. 3. Version and editing history with option to suggest edits. 4. Highly controllable in terms of sharing with email notifications.

Nachteile:

I did not find any cons of this product.

Mike
Global SEO Lead in USA
Finanzdienstleistungen, 201–500 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Shareability and control makes Sheets stand apart from others

5.0 letzten Monat Neu

Kommentare: Whether my files are for an organization or for personal life, the shareability and control over access is the greatest feature Sheets has. I even have my parents using it! and it's free so it's a no-brainer to use for everything. Most of the foundational elements of a spreadsheet are there but being able to work in collaboration with others is such a game-changer from the old Excel days. I know it's simple but the value is immense.

Vorteile:

I love how shareable the files are. The control it provides over accessibility such as edit and read access, for your org colleagues, or per individual - is excellent. and don't forget about the file versions in case you need to go back to an earlier version.

Nachteile:

It's different from Excel and that has taken some time to get used to. I often find myself hopping over to Google to find a certain formula or to figure out how to find a certain feature - though I did recently find out that many of the same hot keys work on Sheets as they do with Excel.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Bau, Selbstständig
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung
Quelle: GetApp

Forgets Basic Formatting Features

3.0 vor 2 Jahren

Kommentare: It's nice to have data access everywhere. It's not nice to have to constantly reformat data whose format should never change. As you can see, the Cons outweigh the Pros for my use.

Vorteile:

Ease of use-Feature clone of MS Excel. Being familiar with Excel makes it easy to use.Accessibility-Anywhere you have a computer and internet access you can access program & data.

Nachteile:

It doesn't remember basic settings. I decided to setup a checkbook register so I could update it online. Sheets is sporadic in remembering format settings such as :1. Date column format (99/99/99)2. Money column format ($9999.99)3. Money column format (debits bold, red)4. Money column format (credits bold, green)5. Doesn't remember last location. A checkbook register gets lots of entries! I have to Hide hundreds of rows, then Unhide them all if I want to look for one entry from last month, then Hide them all again for daily data entry. This makes it unwieldy for data manipulation..I never know what it's going to remember and what it's going to forget. In Excel I set and forget; Excel remembers formats ALL THE TIME. Sheets does not.

Ninos
Ninos
Creative Director in Australien
Verifizierter Nutzer auf LinkedIn
Marketing & Werbung, 2–10 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

I Quit Excel!

5.0 vor 3 Monaten

Kommentare: Very pleased with Google Sheets, we use it daily , we integrate it in many business operations its part of the ecosystem.
Great software, free and lightweight.
Ticks all the boxes.
the new updates with some AI integration are cool too!

Vorteile:

we've used Excel for years, it being the industry standard somehow, we found Google Sheets way better. Lightweight No setup required FREE! Easy collaboration - you just need a Google account. Third party apps and Google App Scripts, to further create custom functions. It's portable and available on cloud. one more thing, the UI is clean, you do not get lost and the function names make sense.. try that with Excel! good luck!

Nachteile:

Only thing i could think of from past experience, wish we could Lock or Disable "editors" from downloading or exporting the sheet.

Robert
Fleet Admin in UK
Software für die Automobilindustrie, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Google Sheets

5.0 letzten Monat Neu

Kommentare: Overall, for me, Google Sheets seems to be the best choice for a sheet app. It works great for my needs and integrates nice with Google Workspace.

Vorteile:

The most I liked is that is an web based app, is safely stored in Google Drive and is accessible from any device. It works very fast even with large amounts of data and is not limited by the PC performance like Excel. Another great feature in my opinion is the sharing and collaborating within the sheet with ease. When sharing I have the option to give viewer or editor permission so I can allow just specific people to add data.

Nachteile:

After switching from Excel, I found out that not all formulas are the same.

Susan
Digital Marketer in USA
Marketing & Werbung, Selbstständig
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Highly recommend!

5.0 letzten Monat Neu

Kommentare: I use Google Sheets every day. It helps to keep me organized. I use it for my social media content calendar, to track expenses, I also use it for sales data.

Vorteile:

I LOVE using Google Sheets. It's such an easy way to set up databases and the ability to instantly share with other team members is crucial. I like that we can be in the document at the same time.

Nachteile:

There isn't anything that I've come across so far that I do not like about Google Sheets.

Avery
Coach, Retailer, Administrator in Australien
Sport, Selbstständig
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Coach's Life Saver

5.0 vor 2 Monaten

Kommentare: I use Sheets outside of my day job and the functionality is the same as Excel. I use it to track business finance, student details, Ah and exporting results from Google Forms is a very helpful function.

Vorteile:

It's easy to use and I can whip up the app on my mobile from anywhere to access my sheets. In my coaching role this is especially helpful.

Nachteile:

I haven't identified any cons in approx. five years of use.

BILVIKA
student in Indien
Bildungsmanagement, Selbstständig
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

A Powerful Tool for Collaboration and Data Management

4.0 letzten Monat Neu

Kommentare: My overall experience with Google Sheets has been positive. Its collaborative features and ease of access make it a preferred choice for many projects. While it has some limitations with larger datasets, the advantages outweigh the drawbacks, especially for team-oriented tasks.

Vorteile:

Google Sheets is highly accessible and allows for real-time collaboration, making it easy for teams to work together. The integration with other Google Workspace tools enhances productivity, and the ability to easily share and comment on documents is invaluable.

Nachteile:

Sometimes, Google Sheets can be slower with larger datasets, and the formula capabilities, while robust, can feel limited compared to desktop alternatives like Excel for complex data analysis.

Jamal
Personal Trainer in UK
Gesundheit, Wellness & Fitness, Selbstständig
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

My experience using google sheets

5.0 vor 3 Wochen Neu

Kommentare: My overall experience using this app was pleasurable and straightforward allowing me to produce programmes in a legible format

Vorteile:

Its compatibility with serving its purpose

Nachteile:

The function commands that would pop up when typing full stops eg

Ashley
Coordinator in USA
Non-Profit-Organisation Management, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Great budgeting tool!

5.0 vor 2 Monaten Neu

Vorteile:

Sheets is very user friendly. Even if you don't have any experience with spreadsheets it takes a minimal amount of time to learn. You can invite others to collaborate and that makes budgeting for my non profit very simple.

Nachteile:

Nothing. it's very smooth to use for many purposes

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Vorstandsbüro, Selbstständig
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Who doesn't love a good Spreadsheet?

5.0 vor 5 Jahren

Vorteile:

Where do you go when you need access to quality tools at no cost? You go to Google, of course! I am a Project Manager and planner who works virtually with a team that is spread across the USA, so being able to work together on one Sheet at the same time (and clearly see the revisions) is precisely what I needed. Spreadsheets are my life! I get excited about inserting formulas, collaborating on projects and sharing spreadsheets and data in real-time. Google Sheets has improved the ability to comment and chat on a Sheet directly from a free Google account. It is simple to use but can also be made as complex as any other spreadsheet creator that I know of. I keep learning more each day!

Nachteile:

If you're an experienced user with Excel, you might find yourself frustrated by some of the features that are not yet available in this free software; however, they are working diligently to roll out new improvements and updates regularly. You probably won't be waiting for long.

Jen
Jen
Freelance Editor and Writer in USA
Schreiben & Editieren, Selbstständig
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Necessary for the Writing Business

5.0 vor 5 Jahren

Kommentare: I was hesitant to switch to sheets since I was a long-term Excel user. However, a friend convinced me to make the switch so that I could help her with planning some social media posts for her business. Once I got started, I found that I liked how intuitive everything felt. I decided to use Sheets instead of Excel for plotting my novels after getting some experience with it. I find that it is quicker for me to chart everything I want to write. Also, it is easy to share my documents with other users, which is essential for me and my alpha reader. I will absolutely keep using Google Sheets and highly recommend making the switch if you're struggling with Excel.

Vorteile:

Google Sheets is easy to use - even easier than Microsoft Excel. In fact, it is the better option since the documents you create can easily be shared and edited by others. As a writer, I like creating plot outlines in Sheets. It makes the plotting process that much more coherent for me. And having it auto-save is fantastic.

Nachteile:

The only thing I noticed with Sheets is that it can sometimes be a bit slow to load. But, once it it is loaded, Sheets scrolls fluidly.

Chris
Owner in Kanada
Musik, 2–10 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Very Useful and Practical Spreadsheet Program

5.0 vor 5 Jahren

Kommentare: Overall, I use Sheets daily. It integrates flawlessly with other Google services as well as IFTTT and 3rd party workflow utilities. Google Assistant can update your spreadsheets by voice and the functionality is perfect for all of my needs. I require no other spreadsheets and I still find new functionality I wasn't aware of as I go.

Vorteile:

Google Sheets is a cloud based browser interface software. You don't actually have to install an application in order to use it. although, unless you're on a PC or Mac you'll want to anyway just for the ease of use of the app interface. Because of the cloud base all of your documents are accessible on any device that you can sign in on with your Google account. To use the software it stores your data in a free Google drive or if you choose a paid Google One storage service. The biggest point here is that if you choose not to have the massive storage you still get plenty of free space to hold as many of your free spreadsheets as you can imagine. So you can utilize these services for no cost and have all of the base functionality that any regular business or person would require. Combine the service delivery model with the the functionality of Sheets and you've got a winning formula to tackle most if not all of your needs. You can utilize formulas, traditional row column handling, paste in graphics or use charts etc. All in all, it has every major function available that the average user could need/want.

Nachteile:

The interface getting into Sheets can seem a bit clunky at times. Unless you're used to cloud based services you may find yourself frustrated desperately seeking the same button. It auto saves and you need to therefore be able to interface with the cloud to access your spreadsheet or think ahead and use the 'make available offline' option. The interface is a little different if you're coming from a Microsoft world so there will be a bit of a change you'll go through adapting.

Awit
Registrar in USA
Bildungsmanagement, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Real Time Updates with Google Sheets!

5.0 vor 4 Jahren

Kommentare: Overall Google Sheets solves the problem of sending excel files back and forth from staff members. By sharing the Google Sheet with applicable staff, we are able to see real time information and we aren't left guessing which is the most "current data".

Vorteile:

Google sheets has always been useful to our organization. However since the pandemic hit, we've relied even more on google sheets for up to date information between staff! When we transitioned from working in the office to working from home and not many workers had access to VPN, google sheets was an easy way for us to share data in real time! Though we use other similar software, google sheets serves a different purpose for us. It is simple, direct, and we can see the changes being made real time and even add comments in the cells for us to check in with each other. Even if we do return to the office, we will still continue to use google sheets.

Nachteile:

Integration using this software was easy and we have not had any major issues as we know what Google Sheets is capable of doing.

Guido
Guido
Digital Media Manager in Italien
Verifizierter Nutzer auf LinkedIn
Marketing & Werbung, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

A lot of features, ease of use and a great support community

4.0 vor 4 Jahren

Kommentare: Google Sheets is definitely the best solution I've met so far for managing a large number of spreadsheets. Based on the cloud, sharing the files is as simple as clicking a button. All necessary features are present and perfectly working. Documents are organized in your Google Drive, so they can be arranged in folders and can be browsed or searched very easily.

Vorteile:

The software has all the features you could think of, it's fully compatible with Microsoft Excel and documents can be shared very easily with different access policies. And if you need a template or a particular solution to a specific problem, you can count on thousands of users who post tips, templates, suggestions and the support offered by Google.

Nachteile:

Formatting cells is not always intuitive (especially for dates and times), and when you import data from other systems it may take a while to fix numbers and other fields (importing data into Excel or Apple Numbers is a little easier, with a formatting options menu presented right after the import). The user interface is not really appealing from a graphical point of view: it may be improved.

julio
President in USA
Marketing & Werbung, 2–10 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Why would you use something else?

4.0 vor 4 Jahren

Kommentare: Solid easy to use, easy to deploy. I had been using Excel for what I needed it to do for years, and it was simple switching over to sheets.

Vorteile:

I like how integrates with other apps I use both inside and out of the Google environment. For what I need it for it does everything that Excel does and you always have it because it is in the cloud.

Nachteile:

You need connectivity to access your files and you need to have a Google gmail account. Which 98% of the time is not an issue.

Eddie
CEO in USA
E-Learning, 2–10 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Most convenient and universal spreadsheet platform, great product evolution

5.0 vor 3 Jahren

Kommentare: All prior advantages other spreadsheet programs had like more robust formulas and being able to edit locally have now been incorporated into Google Sheets as well so Google Sheets is the leader. The collaboration among Google Sheets is the easiest of all platform since everyone already has Google accounts and the links are easily sharable where everyone can edit the document at the same time.

Vorteile:

Real-time collaboration with any number of peers, built-in chat, easy access from other Google Workspace products as a new feature.

Nachteile:

Very few issues, Google Sheets can be accessed locally now as well even without internet. All prior issues with complexity of formulas have been solved now as well, Google Sheets is great.

Danika
Supervisor Of Services in Kanada
Bürgerliche & soziale Einrichtungen, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

I will be recommending Google Sheets to everyone!

5.0 letztes Jahr

Kommentare: I utilize Google Sheets more then I do any other app on my work computer.

Vorteile:

My favourite thing about Google Sheets is how similar the actions are compared to Excel, the fact that it is a free software, and that it is editable by multiple people since it is a document on the internet.

Nachteile:

What I least like about Google Sheets is that when I attempt to share something with another email, I have to give permission for them to view it after I send the document.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 2–10 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Better than Excel

5.0 vor 12 Monaten

Kommentare: I love Google Sheets. I've had an incredible experience with Google Sheets. It's super convenient and user-friendly.

Vorteile:

I absolutey love Google Sheets. I'm a very experienced and long-time user of Excel and have always loved it. However, after using Google Sheets - I'm a big fan. I was surprised - I figured it would be more limited than Excel, but it has all the functionality of Excel. Imports/exports into or from Excel are easy and convert easily with little to no complications. My favorite thing about Google Sheets is that it has AI integrated and can recommend formulas based on your activity. That function alone has saved me hours of work. It's very easy and user-friendly. It has a modern look and feel. I prefer the Google Sheets interface to Excel. Functions and formulas operate the same. I also love that multiple users can utilize the sheet in real-time. It also has an edit/version history of who did what and when, which is very convenient. You can also control permissions and restrict access. You can also have Google Sheets integrated into your apps and software. Honestly, I only use Google Sheets now.

Nachteile:

I don't have any cons for Google Sheets. The only annoying thing is it can have network issues but it's very rare and you can download the sheet and work offline.

Heather
Owner Operator Coach in USA
Gesundheit, Wellness & Fitness, 2–10 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Love Google Sheets paired with Google Drive

5.0 vor 6 Jahren

Kommentare: This allows me to increase productivity for the business. I can work from anywhere I have a spare moment. Updating spreadsheets on the go. If I can’t make it to the gym, I can update a workout in the spread sheet on my phone which my partner can immediately access at the gym from the iPad and display on monitor for athletes arriving thanks to sheets paired with google drive. We are a small operation and any additional cost, however small, is a big deal. Even if I had the resources, I can not see paying for Excel when Sheets meet and exceed my expectations! Again learning curve is small and intuitively obvious especially if you are a user of Excel

Vorteile:

Google sheets is free, easy to use and with google drive I can use it across all my tech phone, computer and iPad! It is similar enough to Microsoft Excel that the learning curve is small. One of the best things is how easy it is to use paired with Google Drive. I can up date sheets on my phone, computer or iPad and the change is universal. If I am at the doc office with time to spare. I can write a program on my phone. Then go to gym and access it on my computer to display on big screen or make modifications via my iPad or computer. I can update a sheet and allow my partner to see changes and he can make adjustments to the sheet if necessary. I am an athletic performance coach and personal trainer. I use it write my workouts, keep up with athletes assessments and measurements. Use formulas to calculate stats, BMR, calories, etc. it has become a crucial part of how I run my personal business.

Nachteile:

There are a few nuances that are not intuitively obvious compared to using Excel. I had trouble freezing 2 columns etc the way I would in excel. The minor inconveniences are small compared to the great savings and the flow between google software products that make this software a tool that I would not want to give up!

Katrina
Katrina
Event Specialist in USA
Verifizierter Nutzer auf LinkedIn
Konsumgüter, Selbstständig
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Just like Excel but better!

5.0 vor 6 Jahren

Kommentare: Google Sheets have helped me out when Microsoft Excel let me down. I had a school account for MS Suites. On one of my assignments, all of my data was lost when my tablet died. After that I found Google sheets ony Chrome book, it worked with or without the internet. I syned all the time after every edit. It works great with my invoices and school assignments. I can insert charts, format cells, find and replace data, save to my SD card or my device, attach to emails and edit Excel files to save on my device. This software I'd very useful.

Vorteile:

I like ease of using this software. I am a mystery shopper and most of my assignments require lists that use this format. On any assignment, I may have around 2000 grocery items to locate and update. I find it easy to select cells to enter their UPC codes , ounces, or general data, multiplying or adding formulas are easy. I am thankful I recently had a computer programs refresher course last semester that taught how to edit spreadsheets. You can also sync your progress so you won't lose progress. This is a BIG plus to me! You don't know how many times I was using Microsoft Excel and my tablet died and my information was lost because it didn't sync! I had to return to the location and start back over and write the prices down during and after the tablet died again. Google sheets sync without me having to save anything. It even allows me to work offline, which is fantastic. Every edit/change is automatically updated and saved. I don't have to be connected to the internet and it still sync my sheets. I love Google sheets. I also use it for receipts and inventory for my online Clothing Boutique "Beauty Dior Divas". The color formats are great, I like the choice of change. I used sheets to analyze and graph my sales monthly. I help my mom with her business, I set up here monthly sales and chart her losses and gains to compare to the same month but previous year. I love the ease of sharing your sheets by email. My scheduler can edit the forms, if necessary.

Nachteile:

None, I have no problems with Google sheets.

Shayne
Shayne
Director of Sales in Indien
Verifizierter Nutzer auf LinkedIn
Internet, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

An amazing Cloud Based spreadsheet

5.0 vor 6 Jahren

Kommentare: I use Google Sheets for various business functions including inventory management, budgetary analysis and various other processes. I may not be able to do as much of the 'heavy lifting' as other spreadsheets out there, but it certainly gets the job done. The best part is, it's free!

Vorteile:

1) Accessibility: You can access Google Sheets from any device at any time and continue working on a spreadsheet. This is because Google Sheets is cloud-based and your changes are saved in real-time. 2) Adaptability: If you've used MS Excel in the past, then using Google Sheets will be a piece of cake for you. 3) Document Sharing: Google Sheets makes it possible for you to share your spreadsheet with other people so that they can review your document in real-time. 4) Sharing Security Options: Not only is the spreadsheet sharing option an amazing feature, it also allows you to apply certain restrictions to the people you share your document with. For example, you may want someone to help you compose the document. You can give that person editing rights, as opposed to the 'view only' option where he can only view your spreadsheet without editing it.

Nachteile:

1) Internet Connectivity: Since Google Sheets is cloud-based, you're going to have to stay connected to the internet. Although you have the 'edit offline' option, you're going to have to be connected to an internet connection in case you've shared your work with someone and they are referring to it on a regular basis. 2) Confusion: There could be a lot of confusion when two people are working on the spreadsheet at the same time. However, if you're careful enough, then Google Sheets highlights the cell that each user is currently editing with different colours.

Mike
Product Manager - Consultant in Kanada
Sport, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Solid Collaborative Spreadsheet Tool with the Essential Features

5.0 vor 5 Jahren

Kommentare: Google sheets is an excellent collaborative spreadsheet tool that allows multiple users to work on the same spreadsheet concurrently without worrying about merging files later. Google sheets can be shared with specific people within your organization or the entire organization, and even people outside of your organization with this product. Colleagues can also request to spreadsheets to receive approved access, giving secure but not excessive security. Our company has had great success by building spreadsheets internally and then sharing the finished sheet with a client. We have also had success working on sheets collaboratively with a client in the past. The “see history” feature allows you to go back in time to see who changed what and revert to a previous copy should major mistakes be made. The product provides powerful formulas as well as a scripting language that can be leveraged. There is also conditional formatting. We use this to track numerical values, as well as check lists when doing client implementations, shared directly with clients. Google sheets is an excellent online tool that makes sense to use if you are already using Google products. It can be used to track progress on projects, initiatives and even client implementations successfully. It is a very light weight tool that does not take a lot effort to get set up and start working on right away.

Vorteile:

The formulas that Sheets provide have good documentation within the product, and there’s also documentation online to help understand the syntax and how to use each formula. For those who are used to excel you will need to get familiar with some of the changes, but there significant overlap. Powerful formulas such as Vlookup are also available which is nice if you are used to MS Excel. For those who have used VBA in Excel, you will have to relearn the scripting language that Google sheets provides. The scripting language is functional and fun to use however it is more like JavaScript then VBA. You will need to have prior development experience in order to leverage the scripting functionality, similar to how VBA works with Excel. For those in your company who are not excel power users, then they should see very little difference between Ms Excel and Google Sheets, and should be able to easily complete the job that they have to do within Google sheets. The sharing and collaboration features are good and what you would except from a tool used internally and with clients.

Nachteile:

The scripting language provided is useful however I have found VBA to be far more useful at this time. Certain features such as conditional formatting and other features from Microsoft Excel are either harder to use or not available in the Google Sheets right now which ultimately makes MS Excel my preferred choice if I’m doing “power user” work. Google sheets is likely to continue to improve and bridge the gap between itself and Excel, I still however would prefer to use Excel over Google sheets if no collaboration is required on a document. The user community is not as large as Excel’s, making it harder to get help online for certain issues.