MrExcel Publishing
Your One Stop for Excel Tips & Solutions

convert 1-2-3 files


Posted by Mike W. on October 25, 2001 4:19 PM

Hi:
I have 100's of Lotus 1-2-3 files that I'd like to convert to excel so I can use excel exclusively. Instead of manually opening each 1-2-3 file and saving it in excel format, can you suggest an easier method? The MS Support page has a suggested macro but it looks a little cumbersome. Any ideas?

Many thanks.


Posted by Don C on October 26, 2001 5:10 AM

www.dataviz.com
has software for converting files from one type to another. Conversions Plus (PC) or MacLink Plus (Mac) allow batch conversions; just drop a bunch of 123 files on the progam, set the options to convert to Excel and in few minutes your files are all converted. Bingo, you now have Excel files. List price is about $70; haven't checked street prices. With hundreds of files, it is probably worth the bucks.

Posted by mseyf on October 26, 2001 11:06 AM

if you're using Office 2000 you can try:

http://www.microsoft.com/office/ork/2000/appndx/95t3_5.htm

if you're using Office 97, there should be a utility on the installation disk (Fileconv.xla), or it may already be in Tools>Add-ins.