#1
|
|||
|
|||
Any tips on how to migrate 4mb and larger files from Lotus123 to Excel?
My Dad is trying to move from Lotus123 to Excel. We have successfully converted some of his Lotus files to Excel using free online converters that are available, but we're having trouble finding any that can handle his biggest files.... one is 4mb and another is 7mb. He cannot get into Lotus anymore to break the files into smaller pieces.
Any tips on how to migrate 4mb+ files from Lotus123 to Excel? |
#2
|
|||
|
|||
Step 1
Locate the Lotus .123 file that you wish to open. If it has a “.123” appendage, you need to rename it to have a “.wk4” appendage. This will allow Excel to read the file. Step 2 Right click the Lotus 123 (.wk4) file. Select “Open with…” and select Microsoft Excel. Excel will open the file with all associated information and formatting. If you wish to convert to a native Excel file, merely save it, making sure to select the Excel format. |
#3
|
|||
|
|||
Hi Logit,
Thank you for the reply. When I open the file in the manner you suggest, Excel gives the message "This file is not in a recognizable format." It then kicks me into the Text Import Wizard, where I can specify delimiters. This allows me to open the file but what is displayed is not anything meaningful.... just stuff like this: пяяЂяяАяяя#Т‹PeяяяяпяяЂяяАяяя#Т Thanks, Burt |
#4
|
|||
|
|||
Can you post one of the Lotus files here ? I'd like to see what I can do with it.
You are running Excel 2016 and I'm using 2007. I'm curious if my version still has something in it to convert the file. |
#5
|
|||
|
|||
.
Sent you a private message. |
#6
|
|||
|
|||
I emailed you the files. Thanks a lot for your help!
|
#7
|
|||
|
|||
.
Also ... have you looked at this download ? Lotus to Microsoft Mass Conversion download | SourceForge.net Sourceforge.net has been around for ages and is a reputable download site. I've used it a lot ... so I would trust the download after checking it with an anti-virus to be certain. |
#8
|
|||
|
|||
No, I have not tried that one. I have only tried online converters. That is a great suggestion!
|
#9
|
|||
|
|||
.
Well ... my version won't touch it either. Sorry. |
#10
|
|||
|
|||
Well, I appreciate you trying!
I will give Sourceforge Mass Conversion a shot. Thanks for your help! |
Tags |
excel 2016, file conversion, lotus123 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting Lotus 123.wk4 files to Excel files | Joven | Excel | 1 | 03-25-2018 01:07 AM |
If not VISIO then migrate to PPT or WORD? | Niall O | Visio | 4 | 02-23-2017 03:30 AM |
250 Excel Tips link | cannetom | Excel | 2 | 01-18-2016 09:25 AM |
Need to migrate our Macro from one document to another | Niclasfa | Word VBA | 5 | 12-01-2015 10:13 PM |
Opening Word /Excel reinstalls files, loses recent files | adj1 | Office | 3 | 05-10-2013 12:27 AM |