Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Converting Publisher to Excel... is it possible?


(!)

BlessedCash2008's Avatar
BlessedCash2008 BlessedCash2008 is offline
Junior Member with 1 posts.
THREAD STARTER
 
Join Date: Jan 2010
04-Jan-2010, 12:32 PM #1
Question Converting Publisher to Excel... is it possible?
My boss just asked me to convert a publisher 2003 file to an excel 2003 so it can be used in another store location. Is that posible and how?
HELP!
The Villan's Avatar
Member with 2,222 posts.
 
Join Date: Feb 2006
Location: Lincolnshire UK
04-Jan-2010, 03:46 PM #2
LOL
I might be wrong and would love to be proven wrong, but your boss is in cuckoo land.

You can convert it to a word document, but the results may not be too great.

You would use the File Save As.. and change the file type to a Word.doc.

Depending on what the documenet is will determine how well it gets converted.

maybe if you could upload an example we could have a go at converting it.

You could of course select the data in the publisher document and copy and then go to an excel workshet and Paste the data.

Each part of the publisher document will be pasted as an object, but it will look like what you have in Publisher.

Maybe thats all your boss wants. Doesn't make sense to me but you never know, you might win some brownie points.

Good luck
DaveA's Avatar
Computer Specs
Trusted Advisor with 10,992 posts.
 
Join Date: Nov 1999
Location: Renton, Washington
Experience: Advanced
04-Jan-2010, 04:50 PM #3
I am with "The Villan", what is in this Publisher file that could be used in a Excel spreadsheet?
jimr381's Avatar
Computer Specs
Member with 4,175 posts.
 
Join Date: Jul 2007
Location: Vienna, VA
Experience: Computer Illiterate
05-Jan-2010, 11:58 AM #4
A table can be copied and pasted into an Excel spreadsheet but there is not export option to save it as an Excel spreadsheet. What exactly is in the file and are you trying to edit it later on?
letchworth's Avatar
letchworth letchworth is offline
Member with 860 posts.
 
Join Date: Jul 2005
Location: New York State
Experience: eager to learn more
06-Jan-2010, 12:15 PM #5
Quote:
Originally Posted by BlessedCash2008 View Post
My boss just asked me to convert a publisher 2003 file to an excel 2003 so it can be used in another store location. Is that posible and how?
HELP!
You don't give many details-- so it is hard to imagine a use for such a file.

Converting the Publisher file to an image and then installing it in a single cell is quite easy-- Just group all the objects on the page you wish to move to Excel- (look up "group objects" in the help file if that is not a familiar process for you). Then open Excel and point to the cell you wish to hold your new image. Then click on Edit> Paste SPECIAL> and bitmap. Your Publisher image is now on your page and can be moved as needed by dragging.

HOWEVER, realize that this is now an IMAGE-- no longer text and cannot be edited in Excel (however, if you keep the Publisher file it can be edited there and moved over again).

The Villan's copy & paste solution creates a new version of the file (much better IMO than my solution-- but will take much longer, and if all you wish is a copy of the image- quick and easy-- this will do it for you).

Perhaps given the details of what you are doing (dummy mock-up approximating the actual document) we could be more specific.
Good luck
letchworth
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
07-Jan-2010, 08:26 AM #6
All I can imagine is that you have a table that is in Publisher and you want it in Excel. If that is the case, if you want it to function in Excel, you must cut and paste.
One possibility - but one I have never tried, and you would want to make certain that you are not dealing with confidential data - is this service, Zamzar. Using this firm, you could convert the publisher file to a text document and open that with Excel, or convert it to an HTML file and open that with Excel.
It appears that you will get an ad on the converted file (or a lot of pop-up ads or something) unless you pay a fee, but the Pro version is only $16/mo, there are no ads, you can delete your files (rather than waiting for them to do it as they wish) and the conversion is guaranteed in 4 days. (Actually, they claim to be able to convert Publisher files to any of the following formats: doc, html, odt, pcx, pdf, png, ps, rtf, txt.)
But I have no connection with this company and have never used this service. Still, if your publisher file is big and you are not worried about confidentiality, this might work.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 2 (0 members and 2 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑