Import Lotus .123 files into Excel?

  stlucia2 21:27 PM 17 Jun 11

I'm considering switching from Lotus 1-2-3 to MS Excel for my spreadsheets. According to the MS blurb, it can handle Lotus spreadsheets, but the 30-day trial version I've downloaded doesn't seem to be able to.

The drop-down list of file types in Excel lists several other types, but not Lotus 1-2-3. When I select "All files" and try to open a .123 file with MS Excel 2010, it reports "The file is not in a recognisable format". I currently don't have Lotus 1-2-3 on my PC, so can't use it to export the files in MS Excel format. Is there any other simple way of getting them from .123 into Excel, please?

Or is the trial version of Excel less capable than the paid-for version?

  bremner 22:11 PM 17 Jun 11

If you can save the Lotus file as a csv this can then be imported into Excel

  wiz-king 00:51 AM 18 Jun 11

You could use OpenOffice.

  stlucia2 07:54 AM 18 Jun 11

bremner, I can't save the Lotus files because I no longer have Lotus on my PC.

wiz-king, OpenOffice has done the job. I've lost formatting, but the numbers and formulae seem okay. Thanks.


This thread is now locked and can not be replied to.

Sony Vaio Z Canvas release date, price and specs: Another Surface Pro rival but for the US

1995-2015: How technology has changed the world in 20 years

Adobe unveils Sketch-rival Project Comet for UX design

How to fix iOS 9 problem iPhone stuck screen, unresponsive, no swipe, frozen, can't turn off