In another thread I have been helped to deciding to get a copy of Office 2007 Home Edition.
Now I have the problem of converting a number of quite complex Lotus 1-2-3 97 Workbooks (123) to Excel.
Naturally, I am reluctant to spend hours/days/weeks formating these onto Excel, and so I wonder how I would go about transferring them to there. I am sure that Excel will steadfastly refuse to recognise Lotus files, but Lotus can save in Excel 97-2000 Workbook(XLS) or Excel 5/95 Workbook (XLS) form so would that work as a file recognised by Office 2007?
Or, it occurs to me, would it be best to save in an Excel form, put these into 'Open Office' and from there into Excel.
I feel sure that others have had to face this before now, but it doesn't seem to be a well documented path.
As a general rule Lotus products will import those from a wide range of other software houses, and export to many 'foreign' formats. Microsoft products are often only compatible with their earlier versions of the same or similar in-house products.
You may find that there are minor formatting differences which appear depending on the intermediate file format chosen, so its worth checking each for accuracy where it's important to you or your application. As VoG implies, going through OpenOffice only complicates - and may impair - the transfer process.