Visualize your data with charts in Google Sites

Ever since we launched the chart editor in Google spreadsheets, many of you have asked us to integrate charts into Google Sites as well. Today we are making this possible. Now you can display charts in your Sites by going to Insert Menu and choosing Charts in edit mode.Once you select a spreadsheet, the editor picks existing charts from the spreadsheet to embed into a Site.You can also create a chart by specifying the sheet and range and customize...

Read More

Trying on the new Dynamic Views from Blogger

As you may have noticed, the Docs blog looks a lot different today. That’s because we—along with a few other Google blogs—are trying out a new set of Blogger templates called Dynamic Views.Launched today, Dynamic Views is a unique browsing experience that makes it easier and faster for readers to explore blogs in interactive ways. We’re using the Classic view, but you can also preview this blog in any of the other six new views by using the view selection bar at the top left of the screen.We’re eager to hear what you think about the new Dynamic...

Read More

This week in Docs: Import/export and paste special improvements

Yesterday, we announced the vertical merge feature in Google spreadsheets, and today we’re happy to share two new features that we hope will make analyzing data a little more efficient. More import and export support in Google spreadsheetsNow you can convert most pivot tables between Microsoft Excel files and Google spreadsheets for powerful data analysis in whatever file format you prefer. Additionally, filters that help you better visualize and...

Read More

Merge cells vertically in Google spreadsheets

There are many times when you want to format your spreadsheets in a certain way to make your data easier to read and understand. Starting today, we’ve extended the merge functionality to let you create vertical merges across several rows of data.In the spirit of the NFL season, let’s say you want to host a football tournament for your friends. To make it easier for them to cast their votes on the winning team, you organize the NFL teams by conference...

Read More

+1 button in Google Sites

We have been thrilled with the response to the launch of the +1 button on websites all across the web, but we also heard that you’d like a simple way to add the +1 button to your own Google Sites. Adding the +1 button to your site will allow your visitors to recommend it to their friends and contacts, which helps more people discover it via their personalized search results. Starting today, you can add the +1 button to any individual page by choosing...

Read More

Improved Accessibility in Google Docs and Sites

Today we announced some of the updates we’ve released recently to make Google’s applications more accessible to the blind community. For Google Docs and Sites, we’re pleased to announce new keyboard shortcuts and better screen reader support for our blind users.Screen reader support in Google Docs and SitesTo help blind users read, edit and navigate content, Google Docs (including documents list, documents and spreadsheets) and Sites now support two screen readers: JAWS and ChromeVox. Here are a few examples of how screen readers work in Google...

Read More

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 documentsFirst, 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...

Read More

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

Read More

What Happened Wednesday

Not our best week. On Wednesday we had an outage that lasted one hour and meant that document lists, documents, drawings and Apps Scripts were inaccessible for the majority of our users. We use Google Docs ourselves every day, so we feel your pain and are very sorry.So what happened? The outage was caused by a change designed to improve real time collaboration within the document list. Unfortunately this change exposed a memory management bug which was only evident under heavy usage.Every time a Google Doc is modified, a machine looks up the servers...

Read More

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

Read More