• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4142
  • Last Modified:

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.

1 Solution
Rob HensonIT & Database AssistantCommented:
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.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now