Unlocking Your Data

It is frustrating when you don’t have the right application to open a file with. When someone sends you a PowerPoint or Publisher file and you don’t own the program, you will find it difficult to open the file unless you know some of the small business technology tricks of the trade.

In this column, I’ll show you tried and true ways to get access to just about any document regardless of the software you have on hand.

Try the easy solution first

Before you get started searching around for a solution for opening a file that you don’t have the corresponding small business software application for, see if what you do have on hand will work. This is the “try like with like” solution – typically most word processors can read and display another word processor’s document format and spreadsheets can understand each other and so on.

So, when you’re stuck with a file for which you don’t have a matching application, try the corresponding application you do have.

Can’t see the file?

To get access to, say, a document created in a word processor you don’t own, start by opening your word processor and choose File > Open. Your program will probably filter the files you see in its open dialog so you see only its own files. Look for a button or option to choose to see other formats and select the one that matches the extension of the file you have.

For example, if you open Microsoft Word’s file list you’ll see that it can read Works, WordPerfect, Open Document and a range of other file types. Select your file type, select your file and click Open. Most programs work in a similar way to this.

Microsoft Word

Programs like Word can open documents created in a range of other word processing programs

New file formats

One time when you’ll encounter difficulty is when a program releases a new document format such as happened with Office 2007. For some time after Office 2007 launched no other program would open the new format files.

We’re now some years down the road so it is easier to open the new Office 2007/2010 formats (which include .docx, .xlsx and .pptx) in other applications.

Ask the sender

In many cases, when you receive an incompatible file you can ask the person who sent it to you to convert it to a format you can use.

For example, Office 2007 and 2010 applications can save files in a range of other formats. All the user needs do is to select File > Save As and select the older or a different format type from the dropdown list. While some of these formats may not retain all the formatting they will retain the important data, which may be all that you need. Other small business software will offer a similar Save As feature.

If you have an older version of Office, such as Office 2003, instead of asking the sender to fix the problem, you can fix it yourself. Visit this Microsoft download page and download the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats. This installs into Office 2000, XP and 2003 and allows you to open files created and saved in the more recent Office formats.

Microsoft viewers

For some of its small business software applications, Microsoft provides viewers that you can use even if you don’t own the relevant program. These allow you to view the contents of the file but you won’t be able to edit or save the file. There are viewers for Word documents, Excel spreadsheets, PowerPoint files and Access databases all available from this Microsoft software download page.

This all makes the Microsoft Publisher .pub format one of the most frustrating of all small business software technology because there is no viewer for Publisher files. Instead, you will need to try an online solution such as Zamzar (see below), or one of the free pdf converters to convert a Publisher file to a format that you can easily view – applications such as PDFOnline can do this.


The online conversion site Zamzar.com can convert to and from a range of different formats.

Why we love free web apps

If you still cannot open a file then the Web is the next place to turn to. On the web, you’ll find plenty of tools for converting documents from one format to the next. One of those that I like a lot is Zamzar. Zamzar can convert from and to a range of formats including docx, xlsx and it can read Microsoft Publisher’s pub files.

Must Read