how to convert lotus 123 files to excel 2003 /2010

Posted on 2011-04-28
Last Modified: 2012-05-11
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.

Question by:miamiLAW
    LVL 31

    Accepted Solution

    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
    LVL 17

    Expert Comment

    From memory Excel can open the files directly
    LVL 46

    Expert Comment

    by:Sjef Bosman
    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

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
    This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now