Our favorite Docs things - 2010 Year in Review

We’ve been keeping busy this year with over 85 new enhancements to Google Docs and Google Sites, making it possible for you to work, communicate and collaborate entirely in the cloud. We wanted to take a moment to share a few of the most exciting enhancements from 2010 that are making it easier for you to go “100% web.”

In addition to some of the most requested favorite features like mobile editing, OCR, advanced sorting rules and a more consistent look, here are more of our team’s favorite things from this last year:

• A new Google Docs built from the ground up for real-time collaboration
• The new Google drawings editor for making flowcharts, diagrams and more
• Upload and store your files in the cloud and stop worrying about losing files
• Simplified sharing with new features like “Private”
• New charts editor and chart types because pictures are worth 1000 words
• New revision history UI in documents and spreadsheets make it easier to see what has changed
• Horizontal navigation in Sites gives you more options when building your sites
• More fonts in documents provide you with more ways to express yourself
• Formula highlighting in spreadsheets makes it easier to understand your formulas
• Google Docs demo makes it easier for anyone to try Google Docs

We look forward to bringing you more improvements next year. Let us know what is at the top of your Google Docs and Sites wish list in the comments.

On behalf of the entire the Google Docs and Google Sites teams, happy holidays! We’ll see you in the New Year!

Posted by: Jonathan Rochelle, Director, Product Management

Demo Slam! Epic Docs Animation

If you’re reading this post, you’ve probably seen your fair share of Google Docs videos featured on this blog. Well, we have one more to show you this year, created entirely with Google Docs, demonstrating the power of nothing but the web -- and it just might be our favorite yet.

Google introduced Demo Slam in October 2010 as a way to turn traditionally boring tech demonstrations into out-of-this-world displays of technology. A couple of weeks ago, three animators worked together for three days in three different cities to create a Google Docs demo slam using Google presentations and drawings. Take a look:



If you like what you see, vote for “Epic Docs Animation.” Let the Slam begin!

Posted by: Tu Uthaisri, Google Creative Lab

This week in Docs: Revision history in spreadsheets

Today we’re excited to announce that the new revision history view we added to documents is now available in spreadsheets. At a glance, you can now see all of the changes that collaborators have made cell-by-cell. Each collaborator is represented by a different color so it is easy to understand who made what changes.



Changes made by collaborators are grouped into batches. To expand these batches, select “Show more detailed revisions.”

Let us know what you think in the comments.

Posted by: Niklaus Haldimann, Senior Software Engineer

Tips & Tricks: Building Organizational Charts in Google drawings

With the new addition of connectors in Google drawings, it’s easier than ever to build anything from a family tree to a flowchart in just a few minutes.

In honor of the holidays, we thought we’d create a bracket-style showdown between our favorite types of pie.

Select Shape from the Insert menu, and you’ll see a variety of bubbles, arrows, and symbols to choose from. I used the rounded rectangle shape for this example, but you can select the shape that’s best for your flowchart.


From there, you can double-click on individual bubbles to enter text.


When you select and drag a particular object, the snap to guides will help you line it up with other objects.


Hold Shift and click to select multiple objects at once. This allows you to move these objects around as a group.



Next, use our newly launched connector tool to attach lines to your shapes. Even if you move or rotate your shapes, they’ll stay connected.


In just a few steps, you’ll have created an organizational chart that you can share, download, or embed into another Google doc. Try it out for yourself.


Want to know what else you can do in Google drawings? Check out our template gallery for more inspiration.

Posted by: Teresa Wu, Consumer Operations Associate

How to share a big file (and 50 other things you might want to teach your parents)

Recently my dad, Eugene, asked me to help him backup all his pictures and files to avoid potentially losing important memories. The conversation that followed was interesting as I attempted to explain how great cloud storage was, but suffice it to say that my dad wasn’t convinced that sharing large files online was really that easy or seamless using just his Google account.

I’m sure my dad isn’t the only one nervous about losing important documents. To help our parents better understand technology, a handful of us at Google decided to create a website-- TeachParentsTech.org. The idea is to have a place where “kids” can send basic how-to videos to their moms, dads, uncles-- whomever. Here’s a video I made that walks through how to backup and share a large file:



To see more videos or to send someone a tech support care package of your own, visit TeachParentsTech.org.

Posted by: Yan Tseytlin, Technical Specialist

Tips & Tricks: More options for mobile editing on the the iPad

A couple weeks ago, we made is possible to edit your documents on many popular mobile phones and on the iPad.

The new mobile editor is fast and lightweight, but sometimes you want to make more style edits like changing a font, or center aligning a paragraph. If you’re on an iPad, you can do that by visiting the Desktop version of the document editor.

If you want to insert formulas in a Google spreadsheet from your iPad, you can use the same trick. Just click Go to spreadsheet view at the top of the mobile view to try out the full version of Google spreadsheets. You can now insert formulas in from the editable formula bar.

Of course, mobile and even tablet browsers are still not as powerful as their desktop counterparts, which is why we recently launched the mobile-optimized version of the Google documents editor for the iPad.

But we figured for one-off times when you need to make an advanced change, that Desktop link might be just what you’re looking for.

Posted by: Peter Solderitsch, Software Engineer

Your feedback makes a difference: Product Ideas

Many of you have visited our Product Ideas page to let us know what features you’d like to see in Google Docs or what you think we’re missing. Your participation was astounding: we received over 165,000 votes on over 5,000 ideas from thousands of people around the world over the course of a year. Here are just a few of the things we launched in the last year that accomplish many of the things you’ve been asking for:

• Real-time collaboration. While we’ve had real-time collaboration in spreadsheets since 2006, we enhanced our collaboration in documents in April 2010 to be truly real-time. Now you can follow along character-by-character with your friends, family and colleagues.
• Google Docs on mobile devices. You can now view and edit on your Google Docs on the go.
• Convert more file types to Google Docs format. You can convert a variety of file types - from .doc to .txt to .pdf - to Google Docs format and vice versa.
• Optical Character Recognition (OCR). This new feature interprets scanned files and PDF files and converts them to Google documents format.
• A stand-alone drawings editor. You requested a mind mapping tool, and we delivered Google drawings. And to make your mind maps and drawings even better, we just added connectors.
• Chat in documents, presentations and spreadsheets. Now you can ask fellow collaborators a question right in the document.
• A more consistent look for all Google Docs editors. Documents, presentations and spreadsheets used to have different interfaces and varying menus.
• Advanced sorting rules and in-cell drop down lists. These two features in Google spreadsheets now make your spreadsheet editing and organization more streamlined.

We’re starting a new process with the Product Ideas page to make sure we keep it fresh and avoid favoring older posts. We’ve temporarily closed the page to new posts to gather a comprehensive look at your ideas thus far and to restructure our Product Ideas sessions.

In order to get the most precise feedback possible, the new Product Ideas sessions will be targeted at a specific feature, product or idea. These sessions will happen every three months or so for a few weeks at a time. As we receive new ideas on the Product Ideas page, we’ll keep working hard to implement the top requests and ideas that are posted. We’ll let you all know when the ideas page is open and post ongoing updates here on the blog and in the help forum.

Posted by: Julia Harter, Consumer Operations Associate

Import WMF files into Google drawings

Yesterday we added a new import type for Google drawings: Windows Metafile (WMF) . It’s an image format that’s designed to be scalable. Unlike other image formats (PNG, JPEG, etc.) WMF files use vectors to represent pictures so that no matter how much you stretch an image, it will never look pixelated.

To import a WMF file to Google drawings, start with a WMF file you own on your computer like this one:


Go to the upload page in Google Docs, and select the image that you’ll be uploading. Make sure to check the box to automatically convert files to the corresponding Google Docs formats.

When you click on the uploaded file, it will open in Google drawings. From there it’s easy to view the image, or to edit it yourself. Here’s what that same bag looks like with a green interior:

We hope this feature makes it a little easier to take your drawings and move them to the cloud.

Posted by: Chris Nokleberg, Software Engineer

Staying connected in Google drawings

Ever since we launched the Google drawings, the most requested feature has been shape connectors. Well today, they’re here.

From now on, when you add a new line in a Google drawing, you can connect that line directly to a shape (old lines will need to be replaced with new lines). Think of connectors as the glue that keeps your drawings together: no matter how much you move around or rotate your shapes, the lines attached to them will stretch so that the shapes stay connected.

To use a connector, start drawing a line and move your cursor near an existing shape. You’ll see small red dots, showing you the points on the shape that you can connect to. Release your mouse when you’re hovering over a point, to connect the line to that point.

Connectors are especially helpful for complex drawings with lots of shapes and lines.

We’re hoping connectors will make drawing online just a little bit easier. Let us know what you think in the comments.

Posted by: Chris Nokleberg, Software Engineer

New this week in Docs: Connectors, hidden controls, and more upload options

From connectors in drawings to hidden controls, we have a lot of updates to share this week:

Connectors in drawings
Since we launched Google drawings in April, the most requested feature has been line connectors. Starting today, all new lines can connect to shapes making it easier to create flowcharts and complex diagrams.

Insert images directly from Picasa
If you’ve got images stored in your Picasa web albums, the image dialog will let you insert those images directly into documents and drawings.



Hidden controls
A couple weeks ago, we introduced compact controls to the document editor. This week we’re bringing compact controls to the drawing editor as well. We also added a new feature to both documents and drawings: hidden controls. Choosing View -> Hide controls will hide the title bar, menu bar, and toolbar. Once you’ve hidden the controls, you can always press Esc to make them appear again.

WMF upload
We now support uploading WMF (Windows Metafile) files and converting them into Google drawings.

Stay tuned for in-depth posts throughout the rest of the week.

Posted by: Jeffrey Harris, Product Manager

Update on Google Docs offline and the new Chrome Web Store

The Chrome Web Store was announced at the Chrome event in San Francisco today, giving Chrome users an easy way to discover a broad range of amazing web apps. You can install our Google Docs web app by clicking Install on our store landing page. This will add a handy shortcut to your favorite web productivity app.

In addition, at the event today, we were excited to demonstrate a feature that we expect to deliver early in 2011 -- the return of offline support for Google Docs. For those who used offline, we are bringing back the much improved feature by taking advantage of advancements in modern browser technology like HTML5.

Together, the web app plus the upcoming offline feature will make it even easier to access your docs everywhere you are.

Posted by: Jonathan Rochelle, Group Product Manager

Tips and Tricks: Images in cells

As we mentioned a couple of weeks ago, you can now insert images into a cell. With the image() formula you can link to a publicly accessible image and control how it will look with optional parameters. This is useful for bringing a visual element to your spreadsheets for things such as a product catalog listing.

For example the formula
=image("http://www.google.com/intl/en_ALL/images/srpr/logo1w.png", 1) will scale the image down in the current cell. With other parameters you can choose from a variety of sizing options including size to fit, stretch, original size, and even specify a custom size.

Try them all out using this template and let us know what you think in the comments.

Posted by: Li-Wei Lee, Senior Software Engineer

Improving team collaboration and productivity with Google Sites

If you’re interested in learning more about Google Sites, this cross post from the Google Enterprise Blog might interest you.

Effective collaboration has become a key driver to improve team productivity. Project teams, often located across disparate locations and time zones, produce and distribute content in different formats and platforms. Teams need to consolidate relevant information in one place that’s easy to navigate and retrieve. Contributors and reviewers have specific needs to manage the creative process, maintain the project plan and keep all stakeholders informed.

With Google Sites, you can easily manage projects and create, share, find, and publish content across your organization. Easy to use features such as site and page templates and embedded documents make it easy for any user to create useful sites. Google Sites can be used for company intranets, portals, team project and more. Furthermore, the Google Sites API gives third-party developers a way to access, integrate with, and extend the platform. The To-Do gadget is an example of extending a Google Site with a tool that can enable teams to track and manage tasks.

Join Scott Johnston, Group Product Manager of Google Sites, and me for a live webinar on Tuesday, December 7th to learn more about improving collaboration and team productivity. I’ll start with an overview of Google Sites and highlight features that can help teams be more productive. We will be featuring a live demo.

Register to attend the live webinar on 12/7 @ 10am PST / 1pm EST / 6 pm GMT.

We hope to see you there.

Posted by Lisa Ding, Google Sites Team

New this week in Docs: Drag and drop upload and compact controls

We just launched a pair of features that can save you time and give you more room to work: drag and drop upload and compact controls.

Drag and drop upload
A few weeks ago, we made it easier to add images to your documents using drag and drop. Today we’re extending that functionality to the file upload page, making it even easier to move your files into the cloud. Now if you’re using Chrome, Safari, or Firefox, you’ll be able to quickly drag files into the drop area and shoot them up to the cloud.

Compact controls
The document editor borrowed a feature from spreadsheets to save screen space. You can now hide the title bar above the editor by choosing View -> Compact controls or pressing Ctrl Shift F (Cmd Shift F on Macs).

Let us know what you think in the comments.

Posted by: Mike Procopio, Software Engineer

A bridge to the cloud: Google Cloud Connect for Microsoft Office now available to early testers

Cross posted on the Google Enterprise Blog

Tens of millions of people have moved to Google Docs because it’s 100% web: it provides real-time collaboration in the browser, with no software to install, manage or upgrade. Of course, we know that many more of you still use Microsoft Office, because until recently, there weren’t many tools to help you collaborate and share with others. Now there’s more choice.

To help smooth the transition from Office to the cloud, my teammates and I founded a company called DocVerse, which was acquired by Google earlier this year. Over the last 9 months, we’ve been hard at work moving the DocVerse product to Google’s infrastructure. We’ve also renamed it Google Cloud Connect for Microsoft Office. Today, we’re pleased to take the next step towards a public launch and make it available to early testers.

For those of you who have not made the full move to Google Docs and are still using Microsoft Office, Google has something great to offer. With Cloud Connect, people can continue to use the familiar Office interface, while reaping many of the benefits of web-based collaboration that Google Docs users already enjoy.

Users of Office 2003, 2007 and 2010 can sync their Office documents to the Google cloud, without ever leaving Office. Once synced, documents are backed-up, given a unique URL, and can be accessed from anywhere (including mobile devices) at any time through Google Docs. And because the files are stored in the cloud, people always have access to the current version.

Once in the Google cloud, documents can be easily shared and even simultaneously edited by multiple people, from right within Office. A full revision history is kept as the files are edited, and users can revert to earlier versions in one click. These are all features that Google Docs users already enjoy today, and now we’re bringing them to Microsoft Office.

All you need is a Google account, and you’re ready to go. That’s it!

If you’re a Google Apps for Business customer interested in joining our preview program, please sign up here. If you’re not, don’t worry- at launch, Google Cloud Connect will be available free to everyone, including consumers.

Posted by Shan Sinha, Group Product Manager

Update: Thank you for your interest! Due to the extraordinary demand from thousands of businesses in just the last few hours, we are no longer accepting volunteers for our early testing program. Please fill out this form if you would like to be notified when Google Cloud Connect becomes available.

Many of you have also asked about availability for Macs. Unfortunately due to the lack of support for open APIs on Microsoft Office for Mac, we are unable to make Google Cloud Connect available on Macs at this time. We look forward to when that time comes so we can provide this feature to our Mac customers as well.

Tips & Tricks: Creating new Google Docs from your mobile

Yesterday, we announced mobile editing on Google Docs, which we've now rolled out to all English-language users.

One of the new features that launched is creating new documents and spreadsheets on your phone. This is particularly useful to jot down quick notes on the run, whether it’s capturing that game-changing idea for your company while at the gym, or typing out your grocery list on the train ride home.

Head to docs.google.com from your mobile and tap the create new icon at the top of your mobile Docs List. From here, you can name the spreadsheet or document and get started editing immediately:

For now, we support certain mobile devices, though we're working hard to accommodate other platforms as well.

Creating a new doc is just one of several new features available on your mobile device, and we'd love to know how you're using your Docs on the go -- be sure to let us know in the comments.

Posted by: Bob Rose, Senior Software Engineer

Editing your Google Docs on the go

Cross posted on the Official Google Blog, Google Enterprise Blog and the Google Mobile Blog

With Google Docs, we’re always trying to make you more productive—and part of that means making it possible for you to get things done from anywhere, at anytime. That’s why we’re excited that the new documents editor now supports editing on your mobile browser. We’re rolling this out over the next few days.

That means that...

• You can work on that important memo...while on the bus or train to work.
• If you’re behind on a group proposal, but really want to make it to the ball game tonight, your whole team can work on it from the bleacher seats.
• You can take minute-by-minute notes at a concert so you’ll always remember the setlist. And your friends can jealously follow in real-time at home.
• ...and the list goes on!

Take a look at this video to see mobile editing in action:



It’s easy to get started: visit docs.google.com in a browser on a supported device, and select the document you want to edit. Then, when you’re viewing it, press the Edit button to switch to the mobile editor.

In the next few days, we’re rolling this out to English-language users around the world on Android with Froyo (version 2.2) and on iOS devices (version 3.0+) including the iPad. We’ll be adding support for other languages soon. And as before, we also support editing of spreadsheets from your mobile device’s browser.

We hope you enjoy editing your documents on the go—especially when you’re at the game with a hot dog in your other hand.

Posted by: Andrew Grieve, Software Engineer

Faster typing, fewer mistakes

With Google Docs we try to make writing a document as easy and as fast as possible. Yesterday, we added two new auto-correction features to speed up your document writing.

LaTeX shortcuts in equations
Until now, the only way to enter an equation in documents was to create the equation from the Insert menu, and then use the equation toolbar to choose your symbols.

The toolbar makes it easy to discover which types of equations are possible.

Today we’re making it a little easier for users to quickly type equations using LaTeX equation shortcuts. For anyone who heard of LaTeX before, it’s a document markup language that’s often used by academics to quickly type out complex formulas. In Google Docs, when you’re inside an equation you can type '\sqrt' followed by a space or a parenthesis to automatically convert the text into a square root sign √. Other examples of useful shortcuts are '\frac' for a fraction and shorthands like '\epsilon' for Greek symbols.

If you want to quickly enter a superscript or a subscript while inside an equation, you can do that with '^' and '_'respectively. Here’s a full list of the automatic equation shortcuts supported in Google Docs.

Text replacements
We also added the ability to substitute text automatically. For example, you can type '(c)' followed by a space to have it automatically converted into a copyright sign ©, or '2/3' and a space to have it automatically converted into the fraction symbol: ⅔.

This feature is especially useful if there are spelling mistakes that you notice yourself making over and over again. You can right click on a misspelled word, go down to the AutoCorrect option, and choose a way of automatically fixing this spelling mistake in the future.

If you don’t want text replacements, you can disable them from the Tools > Preferences dialog. From that dialog, you’ll also be able to manage your text replacements by adding and removing items from the list.

Finally, if a document ever makes an auto-correction that you don’t want, you can press Ctrl Z (Cmd Z on a Mac) to undo it.

We hope that these new features will help make you a speedier writer in Google Docs.

Posted by: Evgeniy Stepanov, Software Engineer

New this week in Docs: auto-corrections, LaTeX in equations and images in cells

If you’re looking for more ways to speed up your typing or have been craving images in your spreadsheets, we have something for you this week. Auto-corrections and LaTeX shortcuts to equations speed up typing and reduce editing while images to cells make it easy to add color to your spreadsheets. These features are rolling out over the next couple of days.

We’ll be blogging about each feature in detail, but in the meantime here’s the quick digest version:

Auto-corrections
We’ve added a feature to substitute text automatically. For example, you can type '(c)' followed by a space to have it automatically converted into a copyright sign ©. You can also create your own custom auto-corrects.

LaTex in equations
If you’re familiar with LaTex, you’ll enjoy the many LaTeX shortcuts we added to the equation editor. For example, while editing an equation you can type '\frac' followed by a space and it will automatically be converted into an equation fraction.

Add images to cells
You can now add images to individual spreadsheet cells and choose from a variety of sizing options including size to fit, stretch, original size, and custom.

We’ve also got another feature ready to go for tomorrow so stay tuned.

Posted by: Lindsay Hall, Software Engineering Intern

Tips & Tricks: Moving my files to the cloud

About a year ago, I started scanning and uploading all the important papers floating around my house into Google Docs. It seemed like an obvious solution to three things that drove me crazy:

• Clutter (I believe papers not only accumulate but secretly multiply)
• Access (I always need that bill/file that is at home and not at the office with me)
• Sharing (It’s a common occurrence that I need someone else to also look at that file, and that person is hardly ever with me at the office either.)

Scanning and uploading ended up being only half the battle. My house was cleaner, but my organizing and sharing work-flow was far from perfect. So, I developed a system in Google Docs to keep organized. Here are some tips & tricks that you may find useful:

Folders and sub-folders
What: With the Create New button in the upper left, you can create folders to organize your content. Click on your newly created folder on the left hand side of your document list. While you’re there, you can click Create New again to make a sub-folder within the first folder.
Tip: To minimize how many folders I see on the left hand side, I create general folder titles like Bills and Photos. I then use sub-folders for clearer classification like Electricity and Cell Phone under my ‘Bills’ folder. When I’m uploading a scanned document I’m able select the appropriate sub-folder right away.

Shared folders
What: Once you’ve created a folder, you can keep it for yourself, or share it with anyone. Right click on a folder, select Share, and choose the sharing option that best fits your need.
Tip: My husband and I compiled all of our immigration paperwork into one folder. Recently my brother took the plunge and also had to work his way through this process. By sharing my folder with him, it made it easier for him to see what was needed and simplified the process a bit (at least that’s what he told me...).

Managing document versions
What: Click on any file and select ‘Add or manage versions’ in order to upload and group different versions of the same document together.
Tip: While this is an ideal tool for a designer that wants to keep iterations of the same graphic in one place, I found my own everyday use for this feature. I keep track of items where the most recent has more importance than past ones. For example, I scan my taxes, and upload the oldest ones first so the newest one is visible, but I have the option to download past copies.

Exporting your files
What: Someone you know doesn’t live in the cloud? Gasp! No worries, I can easily export all the files in a folder. Just right-click the folder, choose Export, and click the Download button.
Tip: Taking this action will save a .zip file to my computer’s hard drive that I can then email to anyone who’s not as tech-savvy (though, I might have to unzip the file for them too!).

If you’re in the mood to give your filing cabinet the boot, chime in here with your own tips for moving your files to the cloud.

Posted by: Rebecca Steelman, Consumer Operations

Tips & Tricks: Our favorite shade of beige, the ruler

Recently, we launched a rebuilt document editor from the ground up. Just like some colors stand out more than others, there are some features in the new editor that are particularly shiny. While features like real-time collaboration, more fonts, and an advanced revision history tool are like neon green, crimson red, and ultramarine, the ruler tends to be viewed more like a beige.

But the ruler, like beige, can certainly have its charms. You can use the ruler to position your text anywhere on the page. And that makes it a powerful tool.

There are a number of blue shapes on the ruler -- these affect the positioning of each paragraph, and are either indents or tab stops.


All paragraphs have three indents: the first line indent,the left indent, and the right indent.

Dragging the first line indent adjusts the left padding of the first line of a paragraph, while the left indent adjusts all subsequent lines of a paragraph. If you drag the left indent along the ruler, the first line indent will follow it. The right indent adjusts how far a paragraph extends toward the right side of the page.

Tab stops

Sometimes you need to control the display of your text with more granularity than what you can accomplish with just indents. That’s where tab stops come in handy.


With tab stops, you can align text relative to a specific spot on the ruler. So that means that a left tab stop will left align text to a position on the ruler, a right tab stop will right align text to a spot on the ruler, while a center tab stop will center-align the text.

To move between tab stops, you can press the tab key, and subsequent text will align with the tab stop. You can add multiple tab stops by clicking on a spot on the ruler and selecting the appropriate tab stop.

You can move the position of a tab stop by dragging it around the ruler. And to remove a tab stop, simply drag it off the ruler.

Margins

Tab stops and indents are great for adjusting individual paragraphs, but sometimes you want to change alignment for an entire document. For that, you can use margins.

You can adjust the left and right margins by dragging the gray space on either side of the ruler.

You can also adjust the left and right margins, as well as the top and bottom margins of your document from File -> Page setup.

Once you get going, like with beige, it’s a bit surprising all of the things you can do with the trusty ruler.

Posted by: Luiz Pereira, Software Engineer

Google Docs on Twitter

Want to stay up-to-date on all the latest Google Docs news, tips and tricks? Follow us on Twitter http://twitter.com/googledocs

Writing a campaign speech with Google Docs

A few months ago, my colleague Julia and I were at a technology conference for educators. Teachers were very enthusiastic when we demonstrated working together on documents at the same time and were really excited about how they could use it in their classrooms. What surprised us though, was how many of our favorite features - like working together at the same time - were brand new to them.

We knew we wanted to share that same excitement with even more people. Inspired by the Search Stories videos, we set off to tell a story using Google Docs. The result is this video:



We hope you enjoy seeing some of the cool features Google Docs offers in action. And if you think your friends would like it, show it to them too!

Posted by: Bryan Carroll, Consumer Operations Strategist, Google Docs

Join the Docs Community on YouTube

Two years ago, we created the Google Docs Community on YouTube as a space to feature user-created videos about Google Docs. Today, we’re reviving the channel with new life and new videos from the community and the Google Docs team.

You’ll find videos ranging from helpful tutorials to creative testimonials in easy to browse playlists. On the channel, you can view Google Docs success stories:



And learn how to use features in Google Docs and Sites, ranging from basic editing to features used by our most advanced users:



You’ll even be able to check out new Google Docs and Sites features:



Check out the channel to connect with the Docs community and the Google Docs team, and learn tips and tricks. If you want to hear more, just click the subscribe button on the channel, and if you’d like to submit a video to share with the world, simply fill out this form.

Posted by: Julia Harter, Consumer Operations

Recapping the Google Sites webinar

Guest post: Stephen Hind (commonly known as Steegle) has been a Top Contributor in the Google Sites help forum since its launch in January 2009. Top Contributors are Google-recognized participants of our help forums who exemplify excellent product knowledge, are consistently kind and respectful to others, and are helpful in the forum. He’s an avid user of Google Sites both professionally and personally, and creates and manages Google Sites for other businesses. His website (www.steegle.com) contains many FAQs and how-tos for Google Sites and receives 30,000 visits per month.

I began using Google Sites when it was first released for Google Apps in February 2008. When I created my first site, I saw that Google Sites offered the features I wanted on any site: a navigation gadget; a breadcrumb trail; a hierarchical structure; a simple editor; and a configurable look and feel. Since then, I’ve been offering support to other users because I enjoy helping others get the most out of their sites.

At the beginning of September, Google invited me to present a webinar as part of the Get British Business Online campaign (gbbo.co.uk) to demonstrate how to get more out of Google Sites. The webinar was offered three times that day maximize how many people could watch. During the webinar I presented on these topics:

• how to create and edit pages
• revert to previous versions of pages
• add a logo
• change and customise themes
• change site width
• edit sidebar and horizontal navigation
• add images directly and from Picasa Web Albums
• add gadgets for maps, contact us forms and videos.

After the presentation I held a Q&A session. Two questions surfaced in every session: “Why does my site not appear in Google Search?” and “How can I see how many people have visited my site?” I answered these by explaining how to register a Google Site with Google Webmaster Tools and demonstrating how to add Google Analytics to the site. It was great to offer these simple tips to help attendees guarantee the success of their own sites.

It was a wonderful opportunity to show others how Google Sites provides an easy and quick way to create informative and reliable websites. The feedback I received, and continue to get, gives me great encouragement to continue to help the Google Sites community, and I look forward to future opportunities to increase Google Sites usage.

Posted by: Stephen Hind, Google Sites Power User

New in Google Docs and Google Sites

Two big advantages of building web applications are frequent feature releases and easier cross-product sharing. Today we have a little of both for you. This week, we are adding version history to uploaded files in the documents list as well as drop downs in horizontal navigation and a new sharing experience to Google Sites.

Version history
Earlier this year, we added the ability to “Upload any file” to Google Docs so that you upload, store, and share any file up to 1 GB in size. Now you can upload new versions of the same file to your document list. Previously, each time you updated a file, you would have to upload the new version as a new file with a new URL, re-share it, and put in the correct folders again.

When you select the “Add or manage versions” option on any file, you can upload new versions of a file, download previous versions, and delete older versions.

Drop down menu in horizontal navs
Sometimes, you want to group information using drop downs and now you can by going More actions > Manage site > Site layout.

New sharing experience
Back in June, we made sharing easier in Google Docs. Today, we extended this simplified sharing experience to Google Sites, unifying the sharing experience across Google Docs and Google Sites. As with Google Docs, Google Sites now be set to one of three visibility options: private, anyone with the link, or public on the web.

The new visibility option is always available at a glance at the top of each site.

With this update, the new “Anyone with the link” setting makes your site available to anyone that knows the unique URL, but blocks search engines from indexing the site. And for those times that someone sends you a link to a site but you don’t have access, you can now request access to that site from the access denied page.

As always, we’d love your feedback and if you have any questions, please check out our document list and Google Sites help pages.

Posted by: Mike Procopio, Software Engineer

Guest post: Writing a book using Google Docs

Guest post: November is National Writing Month and to celebrate, we’ve invited Dr. Steven Daviss to talk about how he used Google Docs to write a book with two colleagues. Dr. Daviss is currently the Chairman of Psychiatry at Baltimore Washington Medical Center in Maryland and has been increasingly leveraging his clinical and administrative experience towards a career merging health care policy, informatics, and health care reform.


Two other psychiatrists (Anne Hanson and Dinah Miller) and I have been writing a popular blog (Shrink Rap) about the practice of psychiatry since 2006. A year later, we started a podcast (My Three Shrinks) that has received great reviews in iTunes. Late in 2007, we decided to take some of those posts and weave them together to write a book.

We started out using a desktop word processor to write the book, each chapter being a separate document. We learned about the limitations of making edits and sending out each of our revisions to the other two: we very quickly had multiple out-of-sync versions and the whole thing was a mess. This is from one of Dinah’s emails back then: “With 3 people doing this, I need to be able to keep track of what everyone wants to write. As I revise it, I'll change the file to reflect the date, but remember that if you and steve are sending me changes and edits simultaneously, I may not see them or it may get very confusing. Your color is red.”

After several weeks of this, we were all seeing red, which was causing a lot of unnecessary tension.

I had used Google Docs collaboratively before to write a couple articles and a few grant proposals, but wasn’t sure if we could successfully use it to write an entire 250-plus page book. But I knew it had to be better than what we were doing.

Once we switched to Google Docs, writing the book together became a much more fluid process because we were able to focus on the writing and not on the complications of getting the technology to keep up with us. We imported the first couple chapters and proceeded from there, making each chapter a separate document shared by the three of us and (eventually) our editor. We could write our own chapters privately until they were ready to show our co-authors, then sharing was as simple as clicking a couple buttons. Whenever we changed our minds about what to take out, we were able to restore sections from previously saved versions. We didn’t have to think about which version of word processing software someone was using, or if the documents would lose formatting between Mac and Windows. And, I could see when my co-authors were also working on the book, so I knew when to call and talk about the project.

Eighteen months after getting the book contract, we had a completed manuscript ready for copy editing.

Google Docs also helped to save our relationship. Initially, despite being good friends, the three of us had many conflicts about the technology and about the way we wanted to write (e.g., grammar, tense, tone, characters). When we were using emailed versions of documents, our arguments increased. After switching to Google Docs, we went back to our usual level of bickering ;-).

The book is being typeset now by Johns Hopkins University Press and will be out in May of 2011. And we have Google Docs to thank.

Posted by: Steve Daviss MD

Using new visualizations to tell your story

Spreadsheet data can tell compelling stories when placed into charts and other visualizations. Today we’re excited to announce a new editor for charts, redesigned from the ground up as well as a set of new chart types. Check out our video to see these charts in action:

New and improved chart types

We’ve added annotated time-lines, organizational charts, gauges, our popular motion chart (which makes it easy to visualize data changing over time) and more to our chart types.


We’ve also given our existing charts a more professional look and feel with with a refreshed color palette, improved layout and new customization options.


New charts editor
With these new chart types, we’ve also added a new charts editor that suggests recommended charts, matches your data labels and headers, auto selects colors, has a full size preview pane and more. The editor is designed to help you create the chart you need in just a few clicks.

The Start tab has basic options, including up to four recommended charts based on the data you selected. For example, if you have a charts with the following five columns: date, number, text, number, text, the first recommended chart will be an annotated timeline.



The “Charts” tab includes the full gallery of new and redesigned charts, and the “Customize” tab includes all of the advanced customization options.


Improved publishing
It’s easy to show charts you’ve created in spreadsheets with the world. Publish your interactive chart on any webpage and it will update as you change the data in your spreadsheet. Click the play button below:


Give the new charts editor a try at goo.gl/newcharts, learn more from our help articles and let us know what you think on the forums.

Posted by: Hillel Maoz, Software Engineer

Google Apps Script support in Google Sites

Google Apps Scripts can save time by sending emails, scheduling calendar events and more with one click.

We just announced on the Google Enterprise Blog that you can now create, edit, and launch Google Apps Scripts from any Google Site. For example, you can create a site to browse and sign up for training sessions. On a training site, you could have a “Register Now” button on each classes page that would automatically add users to the class roster, add the class to their Google Calendar, and email them to confirm enrollment.

To learn more about how to automate tasks in Google Sites using Google Apps Scripts, check out our post on the Google Enterprise Blog.

Posted by: Laurent Tu, Google Apps Software Engineer

Drag and drop images in documents

When writing a document, it often helps to augment text with images and diagrams. Google documents already has three ways to add images: you can choose them from your hard-drive, add them by URL, and you can find them using Google Image Search.

But sometimes the exact image you need is on your desktop and you just want to add it to your document quickly. Starting today, you can drag images from your desktop directly into your documents.

For now, you can use image drag and drop with the latest versions of Google Chrome, Firefox, and Safari. We’ll enable it on other browsers as soon as they support the feature.

Posted by: Philipp Weis, Software Engineering Intern