Simpliguides

Simpliguides › Productivity

How to edit a password-protected Word, Excel or PowerPoint file in Google Drive

Google Drive can open a Word, Excel or PowerPoint file that has a password on it and let you edit it in Docs, Sheets or Slides, with no download and no Microsoft Office needed. The catch is that choosing Edit removes the password from the file permanently, so this guide covers that choice as well as the steps. It works with .docx, .xlsx and .pptx files only β€” the older .doc, .xls and .ppt formats open in a viewer and can't be edited this way. Desktop browser.

What you'll need: A Google Account (a personal Gmail account works). A desktop or laptop browser. The file's password β€” Drive asks for it before it does anything, and there is no way round that.

1

Get the file into Google Drive

Go to drive.google.com and sign in. If the file is already there, or someone has shared it with you, find it in My Drive or Shared with me. If it's on your computer, drag it from a Finder or File Explorer window onto the Drive page and wait for the upload to finish.

2

Open the file

Double-click the file. Drive recognises that it's password-protected and, instead of showing the contents, asks you for the password.

3

Type the password

Enter the password that was set in Word, Excel or PowerPoint. It is case-sensitive, so check Caps Lock if Drive rejects it.

4

Choose Edit

Drive offers two ways to open the file: Preview and Edit. Click Edit.

Edit removes the password from the file, and it doesn't come back. Drive strips the protection so the file can be edited and shared like any other Drive file. From now on, anyone with access to the file in Drive opens it without a password. If you only want to read the file, or you must keep it protected, choose Preview instead β€” see Variations below.
5

Make your changes

The file opens in Google Docs, Sheets or Slides, depending on its type, with the file's extension shown next to its name at the top of the page. It stays a Microsoft Office file β€” Drive doesn't convert it to a Google Doc. Edit it as you would any other document. Changes save automatically to the file in Drive.

6

Download a copy (optional)

If someone needs the edited file back as an attachment, click File › Download and pick the Office format. The downloaded copy has no password on it either.

Variations

You only want to read the file and keep its password

At step 4, click Preview. The file opens read-only, the password stays on it, and Drive asks for the password again the next time you or anyone else opens it. Nothing about the file changes.

Put a password back on the file afterwards

Drive has no option to add a password to an Office file. To protect it again, download it (step 6), open it in Word, Excel or PowerPoint on your computer, set a password there, then upload the new copy to Drive. The copy that Drive stripped the password from is still in Drive until you delete it, so remove it if the content is sensitive.

The file is an older .doc, .xls or .ppt

Drive doesn't offer Edit for the older binary Office formats, whether or not they have a password. Open the file in Word, Excel or PowerPoint, save it in the modern format (.docx, .xlsx or .pptx), then upload that version and start again from step 2.

Troubleshooting

Drive only offers Preview, not Edit

Check the file's extension first β€” if it ends in .doc, .xls or .ppt, see the variation above. If it is a modern file, the usual cause is that someone shared it with you as Viewer or Commenter. Drive can't strip the password from a file you aren't allowed to change, so ask the owner to give you Editor access, or make your own copy by downloading it and uploading it to your own Drive.

Drive says the password is wrong, but it isn't

Office passwords are case-sensitive and can include spaces, so retype it rather than pasting from a note that might have picked up a trailing space. If the file came from someone else, confirm with them that the password was set to open the file. Word and Excel can also set a separate password that only restricts editing, and that's a different thing.

Someone else opened the file without being asked for a password

That's expected once anyone has chosen Edit. The password was removed from the file at that point, for everyone, not only for the person who entered it. If the file needs to stay protected, follow the variation above to put a password back on a fresh copy, and review who the file is shared with in Drive.

Advertisement

Need a calculator rather than a guide? Try Simplicalcs β†’