how to convert lotus 123 files to excel 2003 /2010

i have an administrator who uses lotus 123 for his speadsheets. will excel 2003 and/or 2010 convert them easily or is there a special way of doing so.

Who is Participating?
Rob HensonFinance AnalystCommented:
In a previous job we moved from Lotus to Excel and all files had to be converted. We had a routine available that would open all lotus files (with wk4 extension) and resave as an xls. This was back at the turn of the century so it was Lotus 97 and Excel 97. Some users had Lotus 123 which saved as a 123 extension so had to open and resave as a wk4 but later versions of excel have probably got round this. I believe the conversion wizard was a download from MS Website.

We came across a number of issues, to name a few:

Graphs didn't convert properly
Lotus Macros {Statements} didn't convert, they ended up as text on a sheet with no functionality.
Some functions weren't compatible eg @CELLPOINTER didn't convert to =CELL

The wizard gave a list of errors for each file it processed.

Hopefully the newer versions of Excel have overcome some issues but there may also be new ones with newer versions of Lotus.

Rob H
SteveIT ManagerCommented:
From memory Excel can open the files directly
Sjef BosmanGroupware ConsultantCommented:
AFAIK Excel2003+ lost that ability, you can no longer import 123 files. Even OpenOffice has no converter for it.

Get an older Excel version somewhere, and use that to convert files.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.