Find facts and do research inside Google Documents

Today we’re introducing the research pane—a new feature that brings the web’s wealth of information to you as you’re writing documents.

The research pane taps into Google Search directly from Google documents, so whether you want to add a cool destination to your itinerary for an upcoming trip to India or you're looking for the perfect presidential quote for a political science paper, you don’t even have to open a new tab.

You can access the research pane from the Tools menu by right clicking on a selected word that you want to learn more about, or by pressing Ctrl+Alt+R on Windows or Cmd+Alt+R on Mac. From the research pane, you can search for whatever info you need to help you write your document. With just a couple clicks you can look up maps, quotes, images, and much more.

If you find something you like, you can add it by clicking the insert button or, for images, by dragging them directly into your document. If appropriate we’ll automatically add a footnote citation so there’s a record of where you found the info.

Hopefully bringing knowledge from the web to Google documents will make your writing process just a little bit more efficient.

Posted by Sarveshwar Duddu, Software Engineer

Introducing Google Drive... yes, really

(Cross posted from the Official Google Blog)

Just like the Loch Ness Monster, you may have heard the rumors about Google Drive. It turns out, one of the two actually does exist. Today, we’re introducing Google Drive—a place where you can create, share, collaborate, and keep all of your stuff. Whether you’re working with a friend on a joint research project, planning a wedding with your fiancé or tracking a budget with roommates, you can do it in Drive. You can upload and access all of your files, including videos, photos, Google Docs, PDFs and beyond.

With Google Drive, you can:

• Create and collaborate. Google Docs is built right into Google Drive, so you can work with others in real time on documents, spreadsheets and presentations. Once you choose to share content with others, you can add and reply to comments on anything (PDF, image, video file, etc.) and receive notifications when other people comment on shared items.
• Store everything safely and access it anywhere (especially while on the go). All your stuff is just... there. You can access your stuff from anywhere—on the web, in your home, at the office, while running errands and from all of your devices. You can install Drive on your Mac or PC and can download the Drive app to your Android phone or tablet. We’re also working hard on a Drive app for your iOS devices. And regardless of platform, blind users can access Drive with a screen reader.
• Search everything. Search by keyword and filter by file type, owner and more. Drive can even recognize text in scanned documents using Optical Character Recognition (OCR) technology. Let’s say you upload a scanned image of an old newspaper clipping. You can search for a word from the text of the actual article. We also use image recognition so that if you drag and drop photos from your Grand Canyon trip into Drive, you can later search for [grand canyon] and photos of its gorges should pop up. This technology is still in its early stages, and we expect it to get better over time.

You can get started with 5GB of storage for free—that’s enough to store the high-res photos of your trip to the Mt. Everest, scanned copies of your grandparents’ love letters or a career’s worth of business proposals, and still have space for the novel you’re working on. You can choose to upgrade to 25GB for $2.49/month, 100GB for $4.99/month or even 1TB for $49.99/month. When you upgrade to a paid account, your Gmail account storage will also expand to 25GB. Drive is built to work seamlessly with your overall Google experience. You can attach photos from Drive to posts in Google+, and soon you’ll be able to attach stuff from Drive directly to emails in Gmail. Drive is also an open platform, so we’re working with many third-party developers so you can do things like send faxes, edit videos and create website mockups directly from Drive. To install these apps, visit the Chrome Web Store—and look out for even more useful apps in the future. This is just the beginning for Google Drive; there’s a lot more to come. Get started with Drive today at drive.google.com/start—and keep looking for Nessie... Posted by Sundar Pichai, SVP, Chrome & Apps

March in Review: Improved charting, expanded language support, and Apps Script updates

Another month and another batch of improvements to Google Docs. We recently debuted a new spell checker that gets smarter and grows with the web, and we’ve also turned on a few features that let you do more with Docs.

New charting options 
We’ve added a bunch of new ways to make richer charts in Google spreadsheets. You can now control the opacity of an area chart, set fonts to be bold or italic, and label sections of your charts along the axis.

These new features bring the number of charting improvements up to 30 since the beginning of the year, which is about 1 new feature every 3 days. Some of our favorite charts updates include annotations, error bars, a second Y axis, donut charts, and loads of formatting options.

OCR and spreadsheets support more languages
With Google Docs, you can upload PDFs and images of scanned text and have them automatically converted into Google documents using our Optical Character Recognition (OCR) technology. Starting this week, this is available in four new languages: Hebrew, Hindi, Chinese Traditional, and Cherokee.

Language support got better in Google spreadsheets too. For Hebrew and Arabic speakers, sheets and cells now offer right-to-left support.

More ways to use Google Apps Script 
Google Apps Script is a way for developers to customize Google Docs and other Google products. Over the past month, we’ve made some changes which developers may find helpful, including:

• Support for adding your own HTML to your script’s dialogues and pages. Let’s say you wrote a script that prompts collaborators to play a game when they open a certain spreadsheet. It’s now possible to include more sophisticated HTML, like a table in the dialog that you built. 

• The option to programmatically set sheet protection in Apps Script. If you’re a teacher, you could add a script that automatically looked at all your spreadsheets and made sure that you’re the only one allowed to edit any sheet named “Grades”. 
• A redesign to the Apps Script menus. Sometimes when you’re starting a new project you’ll want to use scripts that you’ve already created. The menu changes make it easier for you to reuse scripts that you’ve already built and to share your scripts with other people . 

Posted by Michael Schidlowsky, Software Engineer

January in Review: Styles, Sparklines, Google+ sharing, and more

One of the best things about working on web apps like Google Docs is that it gives us the flexibility to frequently bring you new features and improvements. Starting this month, we’re going to make some small changes to how we communicate what’s been happening in the world of Docs. Instead of writing blog posts for each and every minor update, we're going to try bundling them together monthly to give you a detailed overview of our favorite features and a short list of other notable changes to make sure you don't miss out on anything new.

On that note, we’ve got a bunch of new features that launched today, as well as some great things that improved over the month of January.

Customizable styles in documents
Giving your document consistent and beautiful formatting should be easy. Before today, if you wanted to update all the Subtitles in your document to look a particular way, you had to change each of them one at a time. That’s too many steps. Now you can restyle all your regular paragraphs, headings, or titles with just a couple clicks. For example, if you want to update all the Subtitles in your document to be a particular size, set one Subtitle to that size, select it, right click and choose Update Subtitle to match selection. This will change all the Subtitles already in your document and automatically update the style for any new Subtitles you create. Plus, with the new Options menu in the styles dropdown, you can set the current document’s styles as the default for new documents or you can load your default styles into the current document.

Sparklines in spreadsheets and more charting options
In Google spreadsheets, we’ve added more charting options and support for sparklines to make it easier to communicate data. The new options give you a bunch of tools to create more sophisticated charts including different Y-axes on either side of the chart, formatting options for the axis and title text, and all sorts of other customization for how your lines, bars, or pies are displayed. We’ve also added sparklines, which let you display line or bar charts inside of cells and are handy for presenting and comparing data in a simple, bite-sized way. In the example below, we’ve used sparklines to plot currency exchange rates over a 30-day period.

Sharing forms on Google+ 
Sharing the forms you create in Google Docs with the right people shouldn’t be a hassle. Today we added a Google+ share to the form editor so that you can share your forms directly with your circles with just a couple clicks.

And there’s more… 
On top of today’s new features, here are some changes from January that you may have missed:

• Adding images to your docs from a high quality stock photo gallery. Simply go to Insert > Image, select Stock photos, and then search for the images that you want.

• A more streamlined format for document discussion notifications that batches multiple discussions into a single email.
• Quickly opening and selecting items from specific menus with keyboard accelerators. For example, when using Google Chrome, Ctrl+Option+E on a Mac and Alt+E on Windows or Linux will open the Edit menu.
• Copying and pasting via the context (right click) menu in documents when you have the Chrome App installed.
• Easily adding Google drawings or Google Groups discussions to a Google Site from the Insert menu.

• Progress bars while uploading files to Google Sites.
• Searching for text inside of PDFs in your documents list using Optical Character Recognition. 

If you’d like to learn more about what we’ve been up to in January, I’ll be doing a Hangout On Air later this week this to talk about these changes and listen to your feedback. Stop by our Community Manager Teresa’s Google+ page on Thursday, February 9 at 12 p.m. EST to tune in.

Posted by: Jeff Harris, Product Manager

Google Docs and Sites 2011: A Year in Review

This year, we introduced over 100 new features to Google Docs to make creating, sharing, and collaborating in the cloud an even better experience.

In addition to the features you asked for the most, like page numbers and vertical merge, here are our team’s favorite improvements of 2011:

• A new version of Google presentations with character-by-character collaboration - plus new transitions, animations, and themes 
• Comments in Google documents, followed by improvements including collapsible discussions, better email notifications, and a more detailed discussion pane
• A Google Docs Android app available in 48 languages for searching, viewing, and sharing Google Docs on the go in 48 languages
• Comment-only access in documents that allows others to view and comment on your doc without editing
• Offline viewing for your documents and spreadsheets
• Pivot tables in spreadsheets to process and summarize large data sets in seconds 
• Pagination in documents that provide visual page breaks on the screen 
• New printing options such as one-click CloudPrint from your mobile device 
• Page-level permissions in Google Sites for better control over who can view and edit your pages
• Improved accessibility including new screen reader support and shortcuts that makes Google Docs more accessible and navigable for blind users
• A new look across Google Docs and Sites for a more consistent web experience

Our team also loved hearing from you throughout the year: We had you ask us anything in a Reddit AMA, met our Docs and Sites Top Contributors, and held our first Docs Office Hours Google+ Hangout. Our interactions with you were constant reminders of why we build these products.

Let us know in the comments what your favorite features of 2011 were -- and what you’re wishing for in the new year. Thanks for following along -- we look forward to bringing you more in 2012.

Happy holidays from the Google Docs team!

Posted by: Jonathan Rochelle, Product Management Director

Try Google presentations. No login required.

We recently launched a new version of Google presentations with many new features to help you create beautiful presentations together. We’ve added the new editor to our Docs demos to make it easier to test drive your presentation building skills.

Check out the new animations and transitions, get artsy with drawings, and show off your masterpiece to a friend or colleague. You can share the link in the demo with others and work on the same presentation together. No login required. No Google account needed. Just go to docs.google.com/demo to take it for a spin.

The new Google presentations continues to gradually roll out to all users. You can try it in the demo and if you like it, you can enable it in your Docs settings.

Posted by: Sarah Cooper, User Experience Designer

Faces of Docs: Vance Vagell, User Interface Software Engineer

One of my favorite things about being the community manager on the Google Docs team is working alongside people with a myriad of backgrounds, interests, and talents. From learning of one of teammate’s pro cricket player past or another’s literary aspirations, I’m constantly discovering new things about the people I spend my workdays with. I thought you might enjoy reading about them, too--which is why we’re taking a cue from our friends at Gmail to bring you “Faces of Docs,” a series that will spotlight the people that make up our team.

Photo by: Antonella Pavese

Name:
Vance Vagell

What do you do on the Docs team and how long have you been at Google?
I lead a team of user experience (UX) prototypers. We build realistic-looking prototypes of new Google Docs features, so that our researchers can try them out with people. This lets us improve them before our engineers build the real thing. I’ve been here two years, but things move so quickly it may as well be 10.

What’s your typical day like?
I hop on the subway, read a few chapters of whatever sci-fi novel I’m working through (currently “Olympos” by Dan Simmons), and get to the office in about an hour.

Grab a coffee, then try to tackle my email inbox. Afterwards, I’m usually doing one of three things: building a prototype, preparing for a study, or running brainstorm and design sessions. My mind is usually at least one year in the future, although sometimes people force me to think about near-term problems.

What do you like most about what you do?
Watching someone enjoy a feature I’ve helped revise a few times—once we’ve finally gotten it right. I like being an advocate for what’s truly useful, and what people need. On the other hand, occasionally I get to work on bigger changes that help push technology in new directions, and that’s a blast too.

What’s the most challenging part of your role?
There are so many teams that want to see their ideas prototyped, that sometimes I have to put a few on the backburner. That said, we always prioritize, and then squeeze in a few “blue sky” projects so we keep moving forward and never get stuck in the status quo. We call a project “blue sky” when it’s unrealistic by today’s standards, but could be a great direction tomorrow.

What did you do before joining Google?
I’ve always worked in NYC—love the east coast (as I alienate myself from my west coast colleagues with this post). Started out as an indie game developer, then worked in voice technology for a few years. I was delighted to discover a posting for “User Interface Software Engineer” at Google NYC, and haven’t looked back since. I focus more on UX than engineering these days, but there’s an important intersection between the two that I represent.

What are the three Docs features you wouldn’t be able to live without?
Can I list ones that haven’t launched yet? Probably not. Okay, in that case: @-mentions in document comments that shoot off emails to people, Google Forms to quickly gather feedback, and real-time editing to bang out ideas as a group. These are all critical to my daily work.

What do you do when you’re not working on Docs?
Far too much computer gaming. Some of my favorites: Everquest (original and EQ2), Planetside, Eve Online, and City of Heroes.

Also love to go bird-watching. My favorite spot is Central Park. People are often surprised that you can spot over 20 bird species in a single afternoon there with a pair of binoculars. Did you know there’s a family of red-tailed hawks in the park that has reared several seasons of chicks now? Google “Pale Male”. On one outing, one of those hawks dove not more than a foot above my head to pick up a mouse beneath a tree across from me. Promptly carried it to a nearby branch and … dined. Very cool experience.

What kind of desk flair do you have?
Souvenirs from aquariums and zoos I’ve visited, and a photobooth print out of me and my partner at one of the Google NYC holiday parties. At last year’s, they had caricature artists, but I’m not ready to share that particular image of me yet. :)

What’s your pet peeve?
Apathy. Be passionate about something, and don’t be afraid to stand up for it.

What do you do in your downtime?
Between projects I like to catch up on UX blogs and papers. Some of my favorites are UX Matters, Jakob Nielsen’s Alertbox, and Don Norman’s essays.

What would your last meal be?
Definitely my partner Ray’s vegetable curry, it’s sublime, and you can’t beat home-cooked!

Posted by: Teresa Wu, Community Manager

A fresh start for Google presentations

A year and a half ago, we released completely new document, spreadsheet and drawing editors. Google Docs has been picking up speed ever since with more than 60 new features and millions of new users. Today we’re rounding out the suite by previewing a new version of presentations with faster collaboration and more features.


A collaborative approach
Presentations are made to be shared—whether it’s presenting your thesis to your professors or inspiring colleagues at a conference. And the best presentations are made together, collaborating with others to build a compelling story that captivates your audience. Creating presentations together is easy because you can:

• See exactly what others are working on with colorful presence markers
• Edit with your team members simultaneously from different locations
• Use revision history to see who made changes or to revert to earlier versions
• Say hello, start a conversation or share new ideas using built-in chat

More than 50 new features
In the new presentations, we’ve added many of your most requested features, including:

• Transitions to move between slides with simple fades or spicier 3D effects
• Animations to add emphasis or to make your slides more playful
• New themes to create beautiful presentations with distinct visual styles
• Drawings to build new designs, layouts, and flowcharts within a presentation
• Rich tables with merged cells and more options for adding style to your data

What’s next
We’re gradually rolling out the new presentations. To get an early start, click on the gear icon in your document list, and select Document settings. Then, from the editing tab, check the box to “Create new presentations using the latest version of the presentation editor.” Learn more about getting started with the new presentation editor over at our Help Center.

Many of the new features were built using technologies that are only available in modern browsers. If you’re using an older browser you’ll be able to view, but not edit, the new presentations.

With today’s launch, the Google Docs suite is now built on a single, solid foundation. Now that the groundwork is in place, you can expect more useful and collaborative features, delivered faster than ever before.

Posted by: Steven Saviano, Software Engineer

Experience the new look of Docs and Sites

Starting today, we’re rolling out the new design for Google Docs and Sites to everyone.

We began rolling out these improvements in early August with the documents list and have since upgraded our entire collaboration suite. You may have noticed that our new look matches other recent Google visual updates, which aim to bring a consistent, improved experience across our products.

Your content is what’s important, and we aim to highlight it with this new design. You’ll see clean menus and toolbars, prominent action buttons, and colorful presence that pops when you’re editing with others.


To people who opted-in to try the new look — thank you. Based on your feedback, here are some of the improvements we made:

• We made it clearer that your document is always saved, by showing “Saving...” right after you make a change and then “All changes saved” once it’s fully saved.


• We added an icon to the Share button so you can tell if your document is shared at a glance.


• If you’re looking for options that were previously under the Share button (e.g. “Email as attachment...”), you can now find these in the File menu.


• By default, the documents list automatically fits a comfortable number of documents on your screen (large desktop monitors show more, smaller laptop screens show fewer). We also added density options to give you more control:

If you’re not quite ready for the new look, choose Help > Use the classic look (or in the gear menu, for some products). We’ll support the classic look for at least a few more weeks, but encourage you to use the new look, get settled in, and send us any feedback you have.

We hope you enjoy this refreshed experience.

Posted by: Vance Vagell, User Interface Software Engineer

This week in Docs: Format painter, Google Fusion Tables, and drag & drop images

This week in Docs, we’re introducing three new tools that put the fun in functional.

Format painter in Google documents

First, we’ve added a format painter to help you copy formatting within Google documents. The new format painter allows you to copy the style of your text, including font, size, color and other formatting options and apply it somewhere else in your document. To use the format painter, select the text for the formatting you want to copy, press the paintbrush button in your toolbar, and then select the text where you want to apply that formatting.

If you double-click on the format painter icon, you’ll enter a mode that lets you select multiple sections of text so you can apply the same formatting to each section.

You can also use keyboard shortcuts for format painting. To copy the style of your selected text, press Ctrl+Option+C for Mac or Ctrl+Alt+C for Windows. To apply any copied styles to whatever text you have selected, press Ctrl+Option+V for Mac or Ctrl+Alt+V for Windows.

Google Fusion Tables in documents list

With this week’s update, we’re also integrating Google Fusion Tables into your documents list. Google Fusion Tables is a data management web application that makes it easy to gather, visualize and collaborate on data online. Now you’ll be able to store and share your Fusion Tables with the rest of the files in your documents list.

Recently, people have used Google Fusion Tables to:

• Visualize evacuation zones for New York City during Hurricane Irene
  
• Host data sets made public by the State of California
  
• Gather data from local flu shot clinics for Google Flu Vaccine Finder
  
• Map shelters and road status during the tsunami crisis in Japan

Go to Create new > Table from your documents list menu to get started visualizing or sharing tables of data in .csv, .xls or .kml files.

We're working on making Google Fusion Tables available to Google Apps customers and will let you know as soon as they are. Take a tour to learn more about Google Fusion Tables.

Drag & drop images in Google drawings

We also made it easier to add images from your desktop to Google drawings. If you’re using the latest version of Chrome, Safari, or Firefox, you can now drag an image from your desktop and drop it directly in the drawing canvas.


Give these tools a try and let us know what you think in the comments.

Posted by: Micah Lemonick, Software Engineer

Updated 9/13 to add shortcuts for Windows

Comment-only access in Google documents

In the past several months, we’ve added new discussion and commenting features to improve collaboration in Google documents. As an engineer, I often create docs with design concepts and send them to my team to review and provide feedback, and we use the commenting features to facilitate these discussions. Sometimes, I want to let team members view and make comments without allowing them to directly edit my document.

Over the next several days, we're releasing a new sharing option so that you can let people view and add comments to your documents without giving them edit access. To give comment-only access to your document, click on the Share button. From there, add in the contact you’d like to share your document with, and select Can comment.


You can also choose to give comment-only access to anyone with the link or anyone on the web by changing the sharing settings within the document. To do this, click Change in the sharing settings window and change visibility options to Public on the web or Anyone with the link, then change the access options to Can comment.

Similarly, if you’re using a Google Apps account, click Change in the sharing settings and select either “People at [your domain] who have the link can access” or “People at [your domain] can find and access.” Then change access option to Can comment.


Users that have comment-only access can view your document and add comments throughout -- without being able to change the content of the document directly.

We hope this latest feature in discussions helps you get the feedback you need while providing you with more control over the content in your docs. So comment away and tell us what you think -- below or in the forum.

Posted by: Sarah Wu, Software Engineer

Tips & Tricks: Using the new Subtotal function in Google spreadsheets

This week, we added the Subtotal function to our list of functions in Google spreadsheets. One of the benefits of the Subtotal function is that it works well with AutoFilters by only using unfiltered data when performing calculations (other functions such as Sum include filtered data calculations). Subtotal also lets you change what function you’re performing on those values very quickly, by selecting an item from a drop-down list. See our help article for details.

This versatile function is often used by accountants, finance professionals, and business consultants. It can also be extremely convenient for any user -- let’s show you why.



Say that you’re helping to plan your family’s annual Labor Day beach weekend. You want to decide how many hot dogs and veggie dogs to buy. To figure this out, you create a Google spreadsheet that includes all your family members, their meat preferences, and the number of hot dogs everyone ate at the past several family gatherings:

To quickly count how many veggie dogs you need to buy based off the number of veggie dogs eaten last month, add a filter to the columns , sort to “Yes” only in Column C, and type in this Subtotal function underneath the table:

=SUBTOTAL(109, F2:F14)



Cells F2 through F14 show the number of hot dogs each family member ate last month. “109” is the code that references the Sum function (“9” would also work). Typing in a regular Sum function in this case (=SUM(F2:F14)) would have added all dogs, veggie or not, whereas Subtotal ignores hodogs which have been filtered.

Another neat feature of the Subtotal function is that the function code (such as “109” above) can easily be changed to refer to different operations like Average, Minimum, and Maximum. As a result, Subtotal can be used to condense a number of calculations into a small space.



Let’s say you want to see not only the total number of hot dogs eaten each summer month, but also the average number eaten. Rather than creating two different functions (Sum and Average) for each month, you can use Subtotal.

• In an open cell -- let’s use B15 -- you would create a drop-down list with the codes for the Sum and Average function (109 and 101 respectively).
• And under the column for each month, you would write a Subtotal function, but reference cell B15 instead of typing in a code.

For June, therefore, your function would read: =SUBTOTAL(B15, D2:D14)



Every time you change which code appears in cell B15 through the drop-down, the values under each month will change, showing either the total or the average number of hot dogs eaten by your family with just one click.





We hope the Subtotal function makes your data analysis a lot easier -- and maybe even more fun.



Posted by: Lai Kwan Wong, Software Engineer

Access Google Docs with FedEx Office Print Online

With Google Docs, you have instant access to your files anytime -- whether you’re at the office on your desktop, on the go with your mobile phone, or at home on your laptop.



When you need to print your documents from anywhere, FedEx Office® is now making it even easier with a Google Docs feature. With FedEx Office Print Online, you can upload and access your Google Docs directly from their site, choose what file types to print and customize your printing options. Once you’ve completed your order, you can choose to pick up the prints at a local FedEx Office retail location or have them delivered right to your door.



So whether you’re creating brochures for your business or a mid-term project to share with classmates, the power of the web helps you access your files from anywhere and even get them into your hands, literally.



Posted by: Teresa Wu, Community Manager

This week in Docs: Page numbers in documents and one click to Google Cloud Print

This week in Docs, we’re announcing page numbers and page count in documents, plus one click to Google Cloud Print -- a couple features that we hope will save you time and energy.



Page numbers and page count in documents

Today we’re making it possible to add page numbers and page count to your documents. You can use the Insert > Page number option to add page numbers to the header or footer of your documents.





We’ve also added the option to insert page count, which displays the total number of pages in your document. You can combine the page number and the page count to create more advanced headers and footers. For example, to create the “Page 3 of 15” header below, take the following steps:

1. Go to Insert > Header.
2. Click the right align icon in the toolbar to move the cursor to the upper right corner.
3. Type the word “Page”.
4. Go to Insert > Page number > Top of page to add page numbers to the headers of your document.
5. Type the word “of”.
6. Go to Insert > Page count to add the total number of pages to the headers of your document.

Print with Google Cloud Print in just one click

Earlier this year, we announced Google Cloud Print for mobile documents. Google Cloud Print is a service in Beta that allows printing from any app on any device, OS or browser without the need to install any software.



We’re making it easier to print on the go directly from your mobile documents list in Google Docs. Simply select a document from the documents list and click on Actions > Print from the bottom toolbar. Currently, you can use Cloud Print in Google documents and spreadsheets.





To get started, you’ll need to connect your printer to Google Cloud Print. To learn more, check out the new site.



We hope you’ll take advantage of these latest features. Stay tuned for the next This Week in Docs.



Posted by: Chris Graves, Software Engineer Intern

The Google Docs app for Android now with Web Clipboard and in 46 languages

In April, we introduced the Google Docs app for Android, which allows you to access and create new docs on the go, directly from an app on your Android phone. Since then, we’ve continued to work on ways to improve your mobile experience, and I’m excited to share a couple of new updates that we hope will do just that.



Starting today, you can easily take pictures with your Android phone and insert them into a Google document, using the new Web Clipboard feature. Here’s how:



1. From the Docs widget on your phone, tap the camera icon.





2. Snap a photo then select Send to Web Clipboard and press OK.





3. Open any Google document from your computer. Click the Web Clipboard icon and select the item to paste into your doc.





A couple of other new features for the Android app include improved open and send options. You can open your documents with any compatible viewer application or send a doc as an attachment through email or another app on your phone.



Last but certainly not least, we’re making the Docs app available in 45 additional languages so more users around the world can access, share and edit on the go. Here’s an example of what the app looks like in German:





You can grab the app from Android Market and learn more by visiting the help center. As always, let us know what you think in the comments or on the forum.



Posted by: Tobias Thierer, Software Engineer

How I use Google Docs as a student

Shep McAllister is a rising senior at Trinity University in San Antonio, TX, and editor of the popular student blog HackCollege. For the past several years, he has done his college coursework exclusively on Google Docs, and today he shares his five favorite uses for the platform in the classroom.



When I started out at Trinity University, I didn’t know much about Google Docs and relied heavily on desktop word processors. As I became increasingly frustrated with these programs crashing mid-sentence, I thought I’d give Google Docs a try. But what started as an experiment to test Google Docs for group projects and class notes quickly became a permanent solution for all of my schoolwork, and I haven’t looked back once. Here are a few of my favorite uses of Google Docs in college:



1. Work together on group projects

Before I started using Google Docs, group projects were a nightmare. A co-authored paper would fragment into a dozen different documents. Group presentations became last minute scrambles to get combine slides. Any information sharing about our project took place in splintered email threads. With Google Docs, my class groups are able work together on the same presentation or paper simultaneously while sharing links and ideas in a separate doc. The discussions feature released earlier this year made collaboration even simpler.



2. Take notes collaboratively

My classmates and I always get together near exam time to combine our notes and share ideas, so why not do it in real time? I work with friends to take in-class notes on a single Google doc, allowing everyone to come away with a more thorough set of notes than they could have written individually. I discuss this concept in more detail on my blog, HackCollege.



3. Convert PDFs and handouts to searchable text with Optical Character Recognition (OCR)

As a student, I get a lot of assigned reading as PDF files. Unfortunately, most of them are low-quality scans from the library, which makes it hard to search through them for keywords or make annotations. With Google Docs’ OCR capabilities, I’m able to upload a low-quality PDF and receive an editable text document in return. This also works well for any important handouts professors give out in class -- I just scan the handout and upload to Google Docs, keeping all of my class material in one place.



4. Save major assignments in the cloud

Writing important papers in Google Docs allows me to access my assignments and papers from any computer, anywhere. I can’t count the number of times I’ve been stuck in the library without my laptop, or only have my smartphone handy. With Google Docs, it doesn’t matter, because all of my assignments are stored in the cloud, meaning I don’t have to be tethered to my laptop to get work done. This saved my sanity (and GPA) during finals last semester, when my computer crashed and was out of commission for over a week. Luckily, there was no need to panic, because I knew my final papers and study guides were tucked safely in the Google Docs cloud, instead of my dying hard drive.



5. Collect information from a group with forms

Before I started using Google Docs, organizing my classmates for a group dinner or campus event was a nightmare. Now, I use Google Docs to create web forms to send to my friends and classmates. My friends have gotten involved too, using it for keeping track of club participation, voting on housing for their fraternity’s beach weekend, and even conducting surveys for major research projects.



Posted by: Shep McAllister, HackCollege.com Blogger & Trinity University Student

Better control in Google Sites with page-level permissions

Today we’re introducing page-level permissions, a new feature that will allow you to control who can view and edit your Google Site on a page by page basis.



Using page-level permissions, you can make some pages private for certain users while keeping other pages public for everyone to see. For instance, let’s say you have a Google Site that you’ve shared with your team and your manager. You can allow your team to see one set of pages, let your manager edit another set of pages, and keep yet another set of pages private for only you.



Only site owners have the ability to enable this feature, which is turned off by default for new and existing sites. To turn on page-level permissions, go to More Actions > Sharing and Permissions.





From there, click Enable page-level permissions. Then, in the dialog box, click Turn on page-level permissions.





Once page-level permissions is enabled, you’ll have three options to choose from:

• allow a page to inherit all of your site-level permissions
• elect to include future site-level changes to a page
• prevent a page from inheriting any future changes made at the site-level

Using page-level permissions should give you greater control over who can edit and access your Google site. To learn more about setting page-level permissions, take a look at our getting started guide. Let us know what you think in our support forums.



Posted by: Eric Zhang, Software Engineer

Making Google spreadsheet functions easier to discover and use

From the simple SUM function to GoogleLookup, Google spreadsheets continues to add features that help you power through data. But sometimes it can be a challenge to find the one you need to use or figure out the right way to use it. We’ve made the following improvements to help you quickly discover and understand all of the powerful functions that Google spreadsheets has to offer.



Help snippets directly in spreadsheets

You shouldn’t have to interrupt your work to figure out how to build a particular formula, which is why we’re bringing help documentation directly into Google spreadsheets.



As soon as you start typing a formula into a cell, you’ll notice an auto-suggest box with the name and syntax of the function you might be looking for. Mouse over any of the suggested functions, and you’ll see a description that explains the function, its syntax, and how it’s used. You’ll also see links to related content and a link to the complete list of functions.





Auto-suggest displays syntax and help documentation for all 300+ available functions and even recognizes nested functions, making it easier to build complex formulas.



Revamped help documentation in the Google Docs Help Center

We’ve also completely rebuilt our help documentation for Google spreadsheet functions with invaluable input from some of our most active forum users such as ahab, yogia1, Ted J, A.P.L, MarinusP, and other forum Top Contributors. Here’s a look at what’s new:

• A completely new table for browsing help documentation for all 300+ Google spreadsheets functions. This table is easy to browse, sort or search. To view the table, you can visit the Google Docs Help Center, click the complete list of functions link in the auto-suggest help snippets, or select Help > Function list in any Google spreadsheet.
• Help documentation for nearly 60 new functions and formulas.
• More detailed help documentation, including better instructions for some of our most sophisticated and complex functions.

All of these improvements are now in English, and will be available in additional languages in the coming weeks. So take advantage of these new resources at your fingertips and you’ll be a Google spreadsheets ninja in no time.



Posted by: Michael Schidlowsky, Software Engineer

Give your templates a refresh in the new document editor

We continue to add new features like pagination and discussions to the new document editor, and we want to make sure you always have access to all of the latest functionality -- whether you’re creating a new doc from scratch or using a template from the gallery. As part of this effort, we’re removing Google Docs templates created in the old document editor from the Google Docs template gallery.

Starting on September 30th, old style templates will remain accessible to their owners and to anyone who the template has been shared with, but they will no longer be visible in the public gallery. This will only apply to the public Google Docs template gallery; templates created in Google Apps domains will not be affected by this change.

You can ensure your templates remain in the gallery by converting them to the new document editor. Just follow these simple steps:

1. Open the document from your documents list
2. Click the Preview link at the top of the document to see what it looks like in the new editor
3. From inside the preview window, click the Update this document link

When old style templates are removed from the gallery on September 30th, the template owners will still be able to restore the templates to the gallery by upgrading them to the new editor.

By making this change, we hope to bring the best possible experience to more documents.

Posted by: Jeff Harris, Product Manager

Try out a new look and keyboard shortcuts for your documents list

As part of our effort to provide an improved and consistent web experience across Google products, we’d like to invite you to try out a new look for the documents list that's rolling out to users over the next few days. If it's available to you, you'll be able to preview the new look by clicking on Try the new look under the gear icon in the upper right. You’ll be able to return to the classic look using the same menu.

Classic look

New look

While using the new interface, you may want to see more of the items in your documents list on the screen at one time. To do this, click on the gear icon in the upper right and go to Documents settings. Under Row height, you’ll be able to select the option to use a denser view.

As part of this new look, we’ve also added keyboard shortcuts to help you easily navigate your documents list without a mouse. For example, when selecting a document, use the ⇓ (down arrow) to move down the list and the ⇑(up arrow) to move back up. Once you find the item you're looking for, type a to open the Actions menu. Then, use the ⇑ and ⇓ arrow keys to navigate the Actions menu, and hit to select an action.

The Create new shortcuts are also convenient for creating new docs while you’re working. Simply hit Shift + T to create a new text document, Shift + S to create a spreadsheet, or Shift + C to create a new collection.

Can't remember all those shortcuts? Just remember the question mark. Type ? when you’re not in the search bar, and a window will appear showing all available shortcuts.


These shortcuts will only be available if you’re using the new interface. Keep an eye out for more changes to the new interface as it evolves, and make sure to tell us what you think about the new design in this brief feedback form so we can continue to improve your experience.

Posted by: Ted Chen, Software Engineer