Tag

Google Drive Archives - Page 4 of 5 - Google Drive & Docs In 30 Minutes

How to permanently delete a file in Google Drive or Docs

By Blog

How to permanently delete a file or folder in Google Docs, Google Sheets, Google Slides, or Google Drive, using the new Google Drive interface released in 2015. While most people think that clicking the trash can icon for a selected file or folder in Google Drive will remove it for good, that’s not the case — it still exists in a sort of holding pen. The following two-minute video explains how to permanently delete a file or folder in Google Drive:

For more tips and tricks on how to get the most out of Google Drive, check out Google Drive & Docs In 30 Minutes, 2nd Edition.

How to restore a deleted file in the new Google Drive

By Blog

Learn how to restore a deleted file or folder, using the new Google Drive interface released in 2015. Because Google Drive doesn’t delete selected files or folders when you “remove” them using the trash can icon in the Google Drive toolbar, you can restore them. This means that old project folder or a Google docs file you mistakenly trashed can be recovered as long as you haven’t emptied the trash. The video below explains how it works:

This video is less than 2 minutes long. For more tips and tricks on how to get the most out of Google Drive, check out Google Drive & Docs In 30 Minutes, 2nd edition.

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.

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:

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.

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:

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

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

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.

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.