Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-31-2020, 05:17 PM
Burt Burt is offline Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Windows 10 Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Office 2016
Novice
Any tips on how to migrate 4mb and larger files from Lotus123 to Excel?
 
Join Date: Apr 2019
Posts: 24
Burt is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 07-31-2020, 07:32 PM
Logit Logit is offline Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Windows 10 Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

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.
Reply With Quote
  #3  
Old 07-31-2020, 07:57 PM
Burt Burt is offline Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Windows 10 Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Office 2016
Novice
Any tips on how to migrate 4mb and larger files from Lotus123 to Excel?
 
Join Date: Apr 2019
Posts: 24
Burt is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 07-31-2020, 08:02 PM
Logit Logit is offline Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Windows 10 Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

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.
Reply With Quote
  #5  
Old 07-31-2020, 08:10 PM
Logit Logit is offline Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Windows 10 Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.
Sent you a private message.
Reply With Quote
  #6  
Old 07-31-2020, 08:18 PM
Burt Burt is offline Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Windows 10 Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Office 2016
Novice
Any tips on how to migrate 4mb and larger files from Lotus123 to Excel?
 
Join Date: Apr 2019
Posts: 24
Burt is on a distinguished road
Default

I emailed you the files. Thanks a lot for your help!
Reply With Quote
  #7  
Old 07-31-2020, 08:18 PM
Logit Logit is offline Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Windows 10 Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.
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.
Reply With Quote
  #8  
Old 07-31-2020, 08:24 PM
Burt Burt is offline Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Windows 10 Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Office 2016
Novice
Any tips on how to migrate 4mb and larger files from Lotus123 to Excel?
 
Join Date: Apr 2019
Posts: 24
Burt is on a distinguished road
Default

No, I have not tried that one. I have only tried online converters. That is a great suggestion!
Reply With Quote
  #9  
Old 07-31-2020, 08:32 PM
Logit Logit is offline Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Windows 10 Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.
Well ... my version won't touch it either. Sorry.
Reply With Quote
  #10  
Old 07-31-2020, 08:46 PM
Burt Burt is offline Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Windows 10 Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Office 2016
Novice
Any tips on how to migrate 4mb and larger files from Lotus123 to Excel?
 
Join Date: Apr 2019
Posts: 24
Burt is on a distinguished road
Default

Well, I appreciate you trying!

I will give Sourceforge Mass Conversion a shot.

Thanks for your help!
Reply With Quote
Reply

Tags
excel 2016, file conversion, lotus123

Thread Tools
Display Modes


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
Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? 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
Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Need to migrate our Macro from one document to another Niclasfa Word VBA 5 12-01-2015 10:13 PM
Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? Opening Word /Excel reinstalls files, loses recent files adj1 Office 3 05-10-2013 12:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft