Sep 28
Love2

How to convert .docx files to Google Docs

By Blog

If you are making the switch from Microsoft Office to Google Drive, you’ll eventually have to convert .docx files to Google Docs. Or, you may have a situation in which someone emails you a .docx attachment and you need to import it into Google Docs to edit it.

Fortunately, it’s not hard to do. The quick video at the bottom of this post shows how to import and edit a .doc or .docx file, or you can follow these instructions:

  1. In Google Drive’s main screen, click the red up arrow symbol next to the Create button. New button and select File upload.
  2. Choose the .doc/.docx file that you want to import. It will show up in your Google Drive list with a Word symbol next to it (a blue “W”).
  3. Open it by clicking the name of the file. It will be displayed in read-only mode, perhaps with altered formatting, owing to inconsistencies between Word and Docs. No editing is possible.
  4. To perform editing, choose File>Open With>Google Docs
  5. If you want to bring the document back into Word later, you can re-export the document as a .docx file (but not .doc).
  6. If the exported file is reopened in Word, the formatting you applied in Google Docs may look different.

A little additional explanation is needed for this last point. While Google Drive makes it very easy to import all kinds of MS Office files, compatibility may be limited. This is especially true of .doc or .docx files that were heavily formatted in Microsoft Word. If the formatting is not supported in Docs, it will be stripped out.

Here’s the video that shows how to convert .docx to Google Docs:

Jul 24
Love3

Microsoft Office vs Google Drive: An honest overview

By Blog

A reader recently emailed to ask me about Microsoft Office vs Google Drive. He noted that Microsoft has invested millions of dollars refining its Office Suite over many decades, and the suite has now evolved to Office 2013 and the subscription-based Office 365. He added that Microsoft Word, although not perfect, is full of extremely useful functionality. Moreover, Microsoft Office has Access (a pretty powerful database tool), for which Google doesn’t even offer a corresponding product.

Microsoft Office vs Google Drive honest reviewAs I read his email, I found myself nodding in agreement. Microsoft Office is a powerful suite. Although I have written an in-depth guide to Google Drive & Google Docs, I am by no means a Google zealot. The Drive suite competes poorly against its Microsoft counterparts in several key aspects. However, it also has some functionality that Office does not have. Here’s my response to the reader asking about Google Drive vs. Microsoft Office:

If Access is a must-have application in your business suite, I would say that you should stick with Office. Likewise, if you need advanced formatting options in Word and PowerPoint, Office beats the Google Drive suite, hands-down.

The formatting options in Drive are very basic, suitable for basic business letters, reports, and spreadsheets, but for professional looking business-grade documentation or presentations Office is superior. Tracking changes in Word is also superior to Google Docs’ rudimentary functionality.

As I explained in my guide, where Google Drive excels is in its collaboration features and online integration. The real-time collaboration and permissions are very powerful, and the ability to publish documents to the Web for external review or other purposes is unmatched. Google Sheets also has neat features that let you publish online forms to the Web to gather data (for instance, a simple survey or customer contact form) and the data is automatically flowed into a spreadsheet or emailed to the account owner. Sheets can also publish a spreadsheet to the Web so audiences can slice and dice the data or even add their own data (if permission is granted). I describe how to use all of these features in my guide.

In the end, I have to acknowledge that the Microsoft Office suite is a superior tool in many respects to Google Drive. However, the powerful online features of Google Drive, not to mention it’s browser-based functionality are attractive to millions of users across the globe. In addition, it’s possible to work with both suites (I use Office and Google Drive for my business) and there are many conversion tools in Drive, which make it possible to convert a PDF to Google Drive or Microsoft Word, or convert a Google Sheets spreadsheet to Microsoft Excel.

Finally, Google Drive offers a powerful reason for newbies to at least try it out: It’s free for the basic storage plan offered by Google. Microsoft is experimenting with low-cost or free programs with Office Online, but for the full-featured Office suite, you’ll have to pay.

Apr 24
Love2

How to publish a Microsoft Word doc on the Web using Google Drive

By Blog

Here’s the scenario: You have a Microsoft Word .doc or .docx file. It’s important, and you want other people to see it, but you don’t want to email it around. The following short video (less than 5 minutes long) will show you how to publish a Microsoft Word document on the Web, using the free online word processor that comes with Google Drive.

While this method of online publishing may not preserve fine-tuned Word formatting, fonts, or special graphic treatments in the original .doc or .docx file, it’s great for publishing rough drafts of reports, letters, homework assignments, or other documents that you want to share with a wider audience. Google Drive will generate a link that you can copy and paste into other documents or email programs. Drive also lets you publish the link directly to Facebook or Twitter, and for those people who know how to use HTML, it’s also possible to embed the video in a blog post or some other type of online publishing system.

If you want to have a reference for this and other Google Drive tips and tricks, check out my book, Google Drive & Docs In 30 Minutes. In addition, if you enjoy the video, please share it or like it:

Nov 21
Love1

How to find good fonts using Google Drive

By Blog

At some point in the course of your work or studies, or maybe even a project at home, you will need to find a good font. Maybe it’s a sans-serif font for a report, a cool font for a flyer, a typewriter font for a list, or a stylist font for a Web project. How can you find good fonts? Many people use Microsoft Word and scroll through the available fonts. But there’s a better tool: Google Drive. Not only are hundreds of fonts available, you can use the fonts right away in a document or a slideshow, and print or share the results as needed.

To access the fonts, log into Google Drive, which is Google’s free online office suite (instructions on how to register and get started with Google Drive can be found in my Google Drive guide). Once you are logged in to Google Drive, create a new document (or slidehsow). The Font drop-down menu only has about a dozen fonts that are displayed by default. However, if you select “More Fonts” at the bottom of the list, you’ll be brought to a huge list of additional fonts that you can add to your palette. Here’s what it looks like:

Google Drive fonts

I didn’t count them all, but there are hundreds in the list, with more being added every month. The fonts run the range from conservative serif fonts to playful fonts with names like “Swanky and Moo Moo” and “Architect’s Daughter”. There are cursive fonts, kid fonts, gothic fonts, and fonts based on foreign or custom letters.

Once you’ve selected the fonts that you want to have available to your work, click the OK button. You’ll be brought back to your document. Then, highlight the text that you want to apply the new font to, and click the Font drop-down menu. The fonts that you just selected will be available in the list for you to choose. Apply the appropriate font, and look at the results. If you like what you see, that’s great, but if you don’t, you can go back to select another font.

The document or slideshow can then be printed out, displayed or even shared online. Doing these steps is beyond the scope of this post, but I recommend checking out Google Drive & Docs In 30 Minutes if you want to learn more.

Oct 20
Love4

Google Drive shortcuts: A basic reference list

By Blog

Google Drive shortcuts: Why use them?

Google Drive shortcuts

Google Drive shortcuts use combinations of keys to issue commands or perform formatting.

Keyboard shortcuts let users issue commands and perform basic formatting. They can save a lot of time. Instead of moving the cursor with a mouse to select a menu item or toolbar icon, you simply hold down two or more specific keys at the same time.

Here is a basic reference list of Google Drive shortcuts. It applies to Google Drive as well as Google Docs, Sheets and Slides.

To get a printed list of Google shortcuts, check out our Google cheat sheets for Drive, Docs, and Sheets — each one costs less than US$5, is printed on high-quality card stock, hole-punched for easy storage, and contains shortcuts, examples, and annotated lists of features.

All of the listed shortcuts work in the Google Chrome browser. Some may not work in Internet Explorer or Firefox. Google recommends the Chrome browser for Google Drive and other Google applications.

Google Drive home screen shortcuts

The following keyboard shortcuts work on Windows and Mac desktops and laptops as well as Chromebooks.

c – Create new file

u – Upload new file

o – Open file

d – Information about file

j or down arrow – Advance to next file

k or up arrow – Go back to previous file

x – Select file

t – Open settings pane

n – Rename selected file

Keyboard shortcuts for Google Docs, Sheets and Slides

Some keyboard shortcuts are identical to those used in Microsoft Office and other programs. For instance, copying and pasting text is the same in Google Docs and Microsoft Word.

Here is a list of shortcuts for Google Docs, Sheets and Slides:

Windows

Control + / – Show all keyboard shortcuts

Control + ‘ – Go to next misspelling (Docs only)

Control + Shift + c – Word count (Docs only)

Control + o – Open file

Control + p – Print file

Control + f – Find text

Control + z – Undo

Control + y – Redo

Control + b – Bold text

Control + i – Italicize text

Control + u – Underline text

Control + a – Select all

Control + x – Cut selected text

Control + c – Copy selected text

Control + v – Paste

Control + k – Create link to Web address

Alt + Shift + f – Open file menu

Alt + Shift + e – Open edit menu

Alt + Shift + v – Open view menu

Alt + Shift + i – Open insert menu

Alt + Shift + t – Open tools menu

 

Mac

Command + / – Show all keyboard shortcuts

Command + ‘ – Go to next misspelling (Docs only)

Command + Shift + c – Word count (Docs only)

Command + o – Open file

Command + p – Print file

Command + f – Find text

Command + z – Undo

Command + y – Redo

Command + b – Bold text

Command + i – Italicize text

Command + u – Underline text

Command + a – Select all

Command + x – Cut selected text

Command + c – Copy selected text

Command + v – Paste

Command + k – Create link to Web address

Control + Option + f – Open file menu

Control + Option + e – Open edit menu

Control + Option + v – Open view menu

Control + Option + i – Open insert menu

Control + Option + t – Open tools menu

Each one of our Google Drive, Google Docs and Google Sheets cheat sheets contains lists of keyboard shortcuts.

Jun 07
Love7

How to convert a PDF to Word or Google Docs

By Blog, Video

If you write reports, publish research, help companies produce manuals or marketing material, or deal with legal documents, eventually you will want to learn how to convert a PDF to Word or Google Docs for editing or republishing. This post and video (updated in 2015) show you how to do it.

It’s a very common — and very frustrating — scenario. Adobe PDF documents are meant for publishing and displaying information according to fixed layouts. However, PDFs cannot be edited, except with special software.

What typically happens is people find they need to extract text from or convert a PDF to Microsoft Word’s .docx file format or Google Docs, so the text can be updated or edited. The hard, frustrating way to do this involves copying and pasting text from the PDF into Word or a text editor, and then dealing with lots of formatting problems — copying text from a PDF ignores column structures and tables, which leads to weird braks, and sometimes unneeded text is captured, including page numbers, headers and footers.

But there’s a workaround that involves Google Drive and the free online word processor included with Drive, called Google Docs. The steps include:

  • Uploading the PDF to Drive
  • Using Google Drive to convert the PDF to Google Docs
  • Editing the document in Docs, or re-exporting it to Microsoft Word as an editable .docx file.

The video below shows exactly what steps to take. Note that converting PDFs to .docx files is a two-step process, and you will need to delete the image files that are created during the conversion process (assuming you no longer want them, and just want the text).

In addition, the conversion process does not work with PDFs that are based on images. The underlying data in the PDF needs to be text, not an image that was created with a camera.

After watching, if you’re interested in learning more about creating, sharing, and collaborating on documents using Google Drive & Docs, check out my guide. It’s called Google Drive & Docs In 30 Minutes and is available for the Kindle, iPad, Nook, Android tablets, and as a PDF and paperback.

Without further ado, here’s the video. Please “like” or share it after you’re done:

Apr 22
Love1

Three easy ways to upload files to Google Drive

By Blog

This post describes how to upload files to Google Drive. A typical scenario is storage of non-Google formats (such as image files, PDFs, or Microsoft Word files) but in certain cases people may want to upload files to convert them to Google Drive formats such as Google Docs, Google Sheets, and Google Slides. There are three easy ways that people use to upload files to Drive:

  1. Go to drive.google.com, logon, and click the red upload button to find the file you want to add (see inset image, below).
  2. Drag the file into the Google Drive folder on your hard drive
  3. Save the file directly into the Google Drive folder on your hard drive, using whatever application that can create the file format in question (for example, Microsoft Word, PhotoShop, etc.)

Google Drive upload buttonOne thing to note about using the red upload button: For certain file formats, including Microsoft Word or Excel, Google Drive may automatically convert the file to the equivalent Google Drive format (Google Docs, Google Sheets, etc.). While Google Drive formats are useful for collaboration and other functions, some users do not want or need conversion. To turn off conversion, click the Settings icon in the upload window (see image below) and uncheck “Convert uploaded files”.

I’ve found dragging and dropping to be the easiest method of transferring large numbers of non-Google file formats to Google Drive. It’s very easy, as long as you have have the Google Drive application installed on your PC or Mac. Simply select a file, folder, or group of files and folders in My Computer (Windows) or Finder (Mac), and then drag them to your Google Drive folder.

As for saving files directly to Google Drive from whatever application you are using, you’ll need to have the Google Drive application installed on your PC or Mac. When saving the file for the first time (or using “Save As” or “Duplicate” functions), just be sure to select the Google Drive folder on your hard drive, instead of My Documents or other folders you use.

For more information on setting up Google Drive on your PC or Mac, read Chapter 7 of “Google Drive & Docs In 30 Minutes”. Conversion is discussed in Chapter 2 (Google Docs). Purchasing options are listed here.

Image: Changing the automatic conversion settings for Google Drive:

Google Drive automatic conversion

Apr 21
Love0

Storage of non-Google formats in Google Drive

By Blog

A reader of “Google Drive & Docs In 30 Minutes” wants to know more about storage of non-Google formats in Google Drive. This could include anything from images to PDFs to Microsoft Office documents. It’s possible to upload such documents to your Google Drive account and use it as an online drive that synchronizes to all PCs and devices that have the Google Drive application installed. However, there are a few issues that make Google Drive a bit different than Dropbox or other online storage services:

  1. There are no account limits on the size or amounts of documents saved in native formats (Docs, Sheets, Slides, etc.). In other words, you can save as many of these files as you like, as long as they were created using Google Drive.
  2. Non-Google Drive formats are limited to 5 gigabytes of free storage space per account. When you hit the limit, you have to buy more storage space, or start deleting files.
  3. Non-Google files that other people share with you will not be counted toward your Google Drive account total.
  4. When browsing the files in your Google Drive account, non-Google formats are clearly identified in both the online and offline version using icons (see image at the bottom of this page).
  5. Google Drive’s online interface has many advanced features that cannot be found in Dropbox or other services, such as automatic conversion of Microsoft Word, Excel, and other Office file formats.
  6. There are lots of synchronization options, such as being able to control which subfolders are synced with the master repository online.
  7. For cross-device syncing, I’ve found that the Google Drive application needs to be manually nudged in order to update. This is unlike Dropbox, which is completely automatic and requires no manual intervention to update.

I’ve extensively discussed conversion options between Microsoft Office and Google Drive in “Google Drive & Docs In 30 Minutes“, as well as in the free videos available here. However, in the coming days on this blog I will also cover:

  • Basics of uploading non-Google formats to Google Drive
  • Syncing and “nudging” the Google Drive application on PCs and Macs
  • Accessing previous versions of a non-Google file

Follow the links above to read about these specific issues.

Image: Non-Google formats are identified by different icons in a Google Drive folder. In this example, native formats have their own icons (.gdoc, .gsheet, .gslides), while a Microsoft Word doc and Adobe PDF file have their own icons.

Google Drive non-Google format

Apr 10
Love0

Google Sites: How to import Google Drive files

By Blog

A reader recently asked about Google Sites. Her question: How could she import Google Drive files into Google Sites? Like many Google Sites users, her organization uses Google Sites for an intranet, and she wanted to bring some documents stored on Google Drive into the site. Is it possible to import documents into Google Sites?

The short answer: While it is possible to do this with Google Drive documents, presentations, spreadsheets, and drawings, as well as YouTube videos, other types of files are not supported (more on that, further down the page).

Let’s see how to bring a Google Drive file into Sites. It’s easy. If you are in “edit” mode for a page, or create a new page, click the “Insert” tab, and you’ll see a bunch of options to select Documents, Presentations, Spreadsheets, Drawings, etc. Here are the import options:

Google Sites import Google Drive

The choices for Documents, Presentations, Spreadsheets, and Drawings correspond to the Google Drive files associated with the same account. You can then browse until you find the Google Drive file you want to insert, and select it. It will then be embedded into the page.

However, you cannot add non-Google Drive file formats, such as Microsoft Word documents or Excel spreadsheets that you are storing in Google Drive. They either won’t be visible, or you’ll get an error message that says “The URL is not supported”. In addition, the Google Drive files you import into Google Sites have to be associated with the same Google account.

Apr 04
Love0

How to edit charts in Google Drive

By Blog, Video

Google Drive allows you to create and edit charts using Sheets, the free online spreadsheet program that comes with the suite. In this 3-minute video, learn how to edit an existing spreadsheet chart. Basic and advanced editing functions are shown, including changing the title of the chart, adjusting colors and backgrounds, increasing font sizes, and changing chart styles.

Once edited, the charts can be exported as image files, and then re-used in presentations, reports, and online. Because Google Sheets is so easy to use, it’s possible to create and edit a snazzy-looking chart in no time.

This lesson comes from Google Drive & Docs In 30 Minutes, authored by Ian Lamont. To see more Google Drive videos, visit the official Google Drive & Docs In 30 Minutes website. Purchasing options are shown on this page.

To watch the video full screen, start the player and click the icon in the lower right hand corner.