"...to become the leader in providing faster, friendlier, and more affordable subscription-based computer support services."

Ask Dr.Tech solution database


How to convert a PDF file to Word, Excel or JPG format

Wednesday, 20 January 2010 21:35 by Jim

One common question I’ve run across a lot these days in the office is how to convert a PDF file to Microsoft Word format (doc), Excel format (xls), or JPG picture format. Usually, people want to know how to convert a file to PDF, but it’s also nice to be able to convert back the other way. Converting to Word is actually pretty simple and can be done directly using an online file conversion service called Zamzar. Going to Excel or JPG is a two step process, but nothing very difficult to follow.

Convert a PDF file to JPG

Go to ZamZar.com, browse for your file and choose PNG format for the format to conver to under Step 2. PNG is another newer picture format that is slowly replacing the JPG format. Most programs that can open JPG files can open PNG. Zamzar automatically converts each page in the PDF document into it’s own PNG picture file. Now you can simply open Microsoft Paint (yes, all you need it Paint!) and choose File – Save As from the menu and choose JPEG from the drop down list of formats.

 1_1_1_1_1.png

Convert your PDF to a Word document

Go to Zamzar.com and click the Browse button next to Step 1 and choose your file. By default, Step 2 will be set to DOC format, but you can choose to convert your PDF to other file types such as TXT, HMTL, RTF, etc. Type in your email address for Step 3 and click Convert.

 2_1_1_1_1_1.png

You should receive an email within a few minutes with a download link to your converted file. I have tried out this service on some pretty complex PDF documents with text in multiple columns, multiple images, etc and have been very impressed with it’s conversion accuracy.

Convert a PDF file to Excel format

We will again follow the steps above using Zamzar, but this time choose TXT as the format you want to convert to. Unfortunately, you can’t convert straight to Excel format, so we’ll have to go through the intermediary TXT format. Once you have downloaded the TXT file and saved it on your computer, open Microsoft Excel and go to File – Open and change the Files of Type combo box to All Files.

 3_1_1_1_1_1.png

Now you should see the converted text file in the list of files. Choose it and click Open. You’ll now be brought to the Text Import Wizard. You have to open the file in this manner because if you simply right-click and say Open With Excel, all of the text for each row will appear in the first column and not be separated.

For Step 1, choose Delimited from the two options listed.

 

4_1_1_1_1_1.png

Click Next and check off the Space checkbox as one of the delimiters. Each value should now be separated by a vertical line, indicating it’s going to be in a separate column.

 

5_1_1_1_1_1.png

Click Next and then click Finish. You can now save the file as an Excel file by going to File – Save As. There are a few drawbacks, however, as this conversion does not always work perfectly! For example, if the original Excel sheet had a column where there was text with spaces included, each word will be separated into it’s own column! Also, you won’t see any formulas or functions that may have been in the original Excel sheet, only the text.

Tags:   ,
Categories:   Third-party Software

Sign up now - $98.00 annual plan
Also available plans: 15 day money back guarantee
per-incident $37.00
month to month* $47.00
* Plans include unlimited number of support incidents

A “must-have” service


Using Ask Dr. Tech is like having your personal technician always at hand *
* for only 26 cents per day