Import Lotus .123 files into Excel?

  stlucia2 17 Jun 11
Locked

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 17 Jun 11

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

  wiz-king 18 Jun 11

You could use OpenOffice.

  stlucia2 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.

Advertisement

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

Should I upgrade to Windows 10? 8 reasons why you should upgrade to Windows 10... and 2 why you…

We are being sold the ability to spend money we don't have. And we love it

Encore creates eerie effects for Spielberg's new TV show The Whispers

How to set up Apple Music & make sure you don't get charged: Get Apple Music for free

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message