Can I import a Lotus 1-2-3 spreadsheet into Excel and save all fo.

B

Benemills

I would like to import a 1-2-3 spreadsheet that contains many formulas. It
would be really great if the formulas were understood by Excel and preserved
during the import. Is this possible?
 
J

Jack Schitt

I think it depends on your versions.
I use Excel XP (2002) and when I file/Open, I get a choice of file types,
including an option to select
"Lotus 1-2-3 (*.wk?)"
file type.
I think Lotus superseded that with *.123 file types (and for all I know they
may have moved on from that ... it has been a while).

Lotus also has an option to save a file as .xls or .xlw file type, but again
depending on your version of lotus it may be referring to a primitive
version of Excel.

Whichever method, don't expect complete compatibility if the workbook is at
all complicated, and forget about Macro translation.

There are 3rd party utilities that do a better job of translation, I believe
(no experience of them). Again I would recommend careful checking of the
result.
 
F

Frank Kabel

Hi
if you want to import *'123 files Excel has no converter for this:
1. Either save in Lotus as Excel format
2. You may try www.dataviz.com The claim to offer a product which could
convert these files (never tested it myself)
 
J

Jim Rech

The claim to offer a product which could convert these files (never tested
Hey Frank-

After saying this same thing myself for years I bought it just to find out.
It does indeed convert .123 files,
 
F

Frank Kabel

Hi Jim
thanks for this update :))
always good to know it really works (never has usage for *.123
conversions)
 
Top