Google Sheets

Google Sheets

door Google

Wat is Google Sheets?

Ontworpen om spreadsheets in realtime te creëren, te wijzigen en te delen. Vooraf ontworpen sjablonen, chatten en opmerkingen zijn beschikbaar.

Google Sheets - Details

Google

http://www.google.com

Google Sheets - Prijsoverzicht

Google Sheets heeft een gratis versie en biedt een gratis proefperiode. Hieronder vindt u extra prijsinformatie voor Google Sheets.

Gratis versie

Ja

Gratis proef

Ja

Implementatie

Geïnstalleerd - Mac

Cloud, SaaS, Web

Geïnstalleerd - Windows

Mobiel - iOS native

Mobiel - Android native

Training

Live online

Documentatie

Ondersteuning

Online

Functies van Google Sheets

Spreadsheet software
Analyse
Audittrail
Grafieken maken
Rekenmachines
Samenwerking tussen meerdere gebruikers
Sjablonen

Reviews van Google Sheets

5 van 9.868 reviews worden weergegeven

In totaal
4.7/5
Gebruiksgemak
4.6/5
Klantenservice
4.4/5
Functies
4.4/5
Waar voor je geld
4.8/5
Aaron L.
Teacher
Schoolleiding, 1.001-5.000 werknemers
Heeft de software gebruikt voor: 2+ jaar
  • Totaalscore
    5/5
  • Gebruiksgemak
    5/5
  • Functies en functionaliteit
    5/5
  • Klantenondersteuning
    5/5
  • Waar voor je geld
    5/5
  • Waarschijnlijkheid van aanbeveling
    10/10
  • Bron van de reviewer 
  • Beoordeeld op 24-10-2019

"Google Sheets: A User Friendly Experience"

Opmerkingen: Google Sheets has allowed me to be more efficient with my grading. As a classroom teacher, grading can take up a lot of time and become overwhelming. Google Sheets has solved this problem for me and allowed me to create a system that is tailored made to meet my exact needs. Our budgeting has also improved significantly. In the past, everything was kept track on paper with lots of missed items and deadlines. With using Google Sheets and the "shared" option, we no longer have these problems.

Pluspunten: Google Sheets is very user friendly. I use it for a couple of activities in my classroom. My first main use is using it as a grade book. I have created different tabs for each subject area. I then went through and set up each section with each assignment that I wanted to track the data on. I used the conditional formatting feature so that everything is automatically color coded as it is entered. This allows me to instantly see which students are falling behind and which assignments are missing. I like this better than other online gradebook options, because I have complete control over everything that is set up and entered. This did take significant time to set up, but the great thing about it is that I can now copy over the same Google Sheet each year and reuse it. This has ended up saving me lots of time as I prepare progress reports and report cards as well. The other main way that I use Google Sheets is as a budgeting tool. I help organize the budget for my grade level team. We have each section of our budget prepared on a different tab. We set up columns to keep track of the expenses ahead of us and ones that have already been processed. Perhaps the best feature is that we have this as a "shared" sheet. So everyone on the team has access to the sheet and can edit it. This helps to create a level of transparency and tracking which has been very helpful for our team.

Minpunten: Overall, there is very little about Google Sheets that is not useful. Like similar products, there is a small learning curve depending on your experience with the product. However, any problem that I have had, I have simply searched for a YouTube video on the issue and I have easily found guidance to fix it.

  • Bron van de reviewer 
  • Beoordeeld op 24-10-2019
Mike C.
Product Manager - Consultant
Sport, 13-50 werknemers
Heeft de software gebruikt voor: 2+ jaar
  • Totaalscore
    5/5
  • Gebruiksgemak
    4/5
  • Functies en functionaliteit
    3/5
  • Klantenondersteuning
    5/5
  • Waar voor je geld
    5/5
  • Waarschijnlijkheid van aanbeveling
    10/10
  • Bron van de reviewer 
  • Beoordeeld op 8-2-2020

"Solid Collaborative Spreadsheet Tool with the Essential Features"

Opmerkingen: 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.

Pluspunten: 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.

Minpunten: 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.

  • Bron van de reviewer 
  • Beoordeeld op 8-2-2020
Kassie C.
Customer Service Representative
Nieuwsbladen, 13-50 werknemers
Heeft de software gebruikt voor: 2+ jaar
  • Totaalscore
    5/5
  • Gebruiksgemak
    5/5
  • Functies en functionaliteit
    5/5
  • Klantenondersteuning
    Zonder beoordeling
  • Waar voor je geld
    Zonder beoordeling
  • Waarschijnlijkheid van aanbeveling
    10/10
  • Bron van de reviewer 
  • Beoordeeld op 3-1-2020

"Google Sheets for Business Use"

Opmerkingen: Google Sheets has been beneficial to our company's day-to-day tasks as well as weekly and monthly planning. With Google Sheets, we are able to communicate ad placement well in advance of when an ad is set to appear in our newspaper and it also allows our publisher to see which ads are running when so he knows where to place them within the paper each week. Google Sheets also allows us to communicate with managers and co-workers who may not be in the office on a regular basis, or even work remotely, as we are able to refer them to a specific document should there be any questions about our weekly productivity.

Pluspunten: I like the ease and simplicity of using Google Sheets. I quickly adapted to our company's use of Google Sheets when I began working at the company. We use Google Sheets to communicate ad placement in our nine weekly newspapers. We also use Google Sheets in various departments and I like that individuals in each department are able to view the spreadsheets and make changes if needed, and once they make changes, the rest of us can see those as well. I also like that Google Sheets is a free version of a program with spreadsheets and that more than one person can access a spreadsheet at a time instead of having to close the program/spreadsheet each time someone else needs to access that specific spreadsheet. The ability to be able to see what other individuals are adding to the spreadsheet while you also have the spreadsheet open is a game changer for a fast paced company like a newspaper.

Minpunten: The only issue I have with Google Sheets is that if one person has a cell selected in the program, you are not able to type anything in that cell while that person is also in that cell, i.e. typing in that cell. While this helps our company see who is using the program and accessing a specific spreadsheet at the same you are accessing it, it does cause for an issue when inputing data or text. I have found that if I wish to keep the spreadsheet open in my browser to be able to quickly go back to it when I need to, I make sure my cursor is not in a cell that someone else may need to access when they are in the spreadsheet as well.

  • Bron van de reviewer 
  • Beoordeeld op 3-1-2020
Craig S.
Small Business Owner
Kleding en mode, 2-10 werknemers
Heeft de software gebruikt voor: 1+ jaar
  • Totaalscore
    3/5
  • Gebruiksgemak
    4/5
  • Functies en functionaliteit
    3/5
  • Klantenondersteuning
    2/5
  • Waar voor je geld
    3/5
  • Waarschijnlijkheid van aanbeveling
    7/10
  • Bron van de reviewer 
  • Beoordeeld op 29-3-2020

"Easy Tool for Analysis and Charts"

Opmerkingen: Using Google Sheets has helped me manage my list of new and existing product skus for marketing optimization and analysis purposes. I have been able to dig deeper into why certain marketing campaigns or tactics perform better than the others for specific products, categories or customers. So, I can spend more money on tactics which improve my product conversions and ROI while reducing my spend on those tactics which are driving lower conversions and profits. I have been able to optimize my paid media spend and sku list with lower investments in software. So, my business has become more profitable.

Pluspunten: I use Google Sheets tool to collect all item skus I sell on my e-commerce website. So, I can concatenate them as one single string and apply as a filter in Google Analytics product performance report. I then run the report in Google Analytics by applying segment of specific email or social campaign and export it in Google Sheets format to pull a visual trend on sales over time. This strategy helps me quickly analyze the impact of external campaigns so I can determine any new items sales and new customers. Additionally, I can easily share my analysis with my business partner, so he is also in the loop on our business ROI. I give him edit rights, so he can add his own comments or products data from the categories he is managing. We both love the fact that if our computers freeze or shut down for a reason, our data gets saved in cloud.

Minpunten: Google Sheets tool has limited charting or data visualization capabilities when compared to Microsoft Excel. For example: when I try to create a stacked column chart using Google Sheets, it doesn't look that professional or easy to read. The copy tab feature can also be improved. Currently, I can copy a specific tab from one sheet to the next but it includes additional text 'copy of' or something along with the original tab name. So, I have the delete that additional text every time I make a copy. Microsoft Excel doesn't include that additional text. Finally, converting an Excel file with multiple tabs into a Google Sheet is not that simple. It is not easy to convert a specific tab and the whole file has to be converted.

  • Bron van de reviewer 
  • Beoordeeld op 29-3-2020
James L.
VP
Informatietechnologie en -diensten, 13-50 werknemers
Heeft de software gebruikt voor: 2+ jaar
  • Totaalscore
    5/5
  • Gebruiksgemak
    5/5
  • Functies en functionaliteit
    5/5
  • Klantenondersteuning
    3/5
  • Waar voor je geld
    5/5
  • Waarschijnlijkheid van aanbeveling
    10/10
  • Bron van de reviewer 
  • Beoordeeld op 26-3-2020

"The perfect spreadsheet for 90% of everyone"

Opmerkingen: For one, we were able to eliminate 90% of our Office licenses since Word and Excel were the two most commonly needed. I use it for everything and since i also handle IT for the office I essentially dictated that Sheets is what is what we offer outside extraordinary circumstances. Always there, always works. It has really made things such as simple pricing reports, equipment tracking very simple. I have not used Excel for years.

Pluspunten: It works great in all those usual spreadsheet ways but the sharing and collaboration is really top notch and while it's a bit standard nowadays when it launched it was really revolutionary. No more emailing files back and forth or file shares with permission issues. While many of those problems can be solved with good IT practices Sheets made it out of the box easy. It really just works and it's fast to load as well.

Minpunten: Printing setup could be better, i know that's a compromise with the browser running the show, but it almost always takes some adjusting to get things to print out the way you want.

  • Bron van de reviewer 
  • Beoordeeld op 26-3-2020