G
Guest
How do you import Lotus 123 files into Excel?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
If you have Lotus try saving the file in Lotus as Excel file. If you don't,
you'll need a commercial converter, such as the one available at
:www.dataviz.com.
tj
you'll need a commercial converter, such as the one available at
:www.dataviz.com.
tj
B
Bill Sharpe
In Excel 2003, use File | Open and scroll down to Lotus 1-2-3 files in
the Files of Type drop down box.
Don't know about previous versions.
Now if Excel would recognize some of the newer versions of Quattro Pro
files to open that easily....
Bill
How do you import Lotus 123 files into Excel?
the Files of Type drop down box.
Don't know about previous versions.
Now if Excel would recognize some of the newer versions of Quattro Pro
files to open that easily....
Bill
How do you import Lotus 123 files into Excel?
L
Lady Layla
Excel 2003 lists .123 as types of files it will open for Lotus? No longer just
WK1 or WK4 types?
: In Excel 2003, use File | Open and scroll down to Lotus 1-2-3 files in
: the Files of Type drop down box.
: Don't know about previous versions.
:
: Now if Excel would recognize some of the newer versions of Quattro Pro
: files to open that easily....
:
: Bill
:
: : How do you import Lotus 123 files into Excel?
:
:
WK1 or WK4 types?
: In Excel 2003, use File | Open and scroll down to Lotus 1-2-3 files in
: the Files of Type drop down box.
: Don't know about previous versions.
:
: Now if Excel would recognize some of the newer versions of Quattro Pro
: files to open that easily....
:
: Bill
:
: : How do you import Lotus 123 files into Excel?
:
:
J
Jim Rech
Excel 2003 lists .123 as types of files it will open for Lotus?
No. No change from previous versions.
--
Jim Rech
Excel MVP
| Excel 2003 lists .123 as types of files it will open for Lotus? No
longer just
| WK1 or WK4 types?
|
|
| | : In Excel 2003, use File | Open and scroll down to Lotus 1-2-3 files in
| : the Files of Type drop down box.
| : Don't know about previous versions.
| :
| : Now if Excel would recognize some of the newer versions of Quattro Pro
| : files to open that easily....
| :
| : Bill
| :
| : | : How do you import Lotus 123 files into Excel?
| :
| :
|
|
No. No change from previous versions.
--
Jim Rech
Excel MVP
| Excel 2003 lists .123 as types of files it will open for Lotus? No
longer just
| WK1 or WK4 types?
|
|
| | : In Excel 2003, use File | Open and scroll down to Lotus 1-2-3 files in
| : the Files of Type drop down box.
| : Don't know about previous versions.
| :
| : Now if Excel would recognize some of the newer versions of Quattro Pro
| : files to open that easily....
| :
| : Bill
| :
| : | : How do you import Lotus 123 files into Excel?
| :
| :
|
|
L
Lady Layla
Thanks
Didnt think there was a change, but wanted to make sure before noting that the
advice Bill gave was incorrect
: >>Excel 2003 lists .123 as types of files it will open for Lotus?
:
: No. No change from previous versions.
:
: --
: Jim Rech
: Excel MVP
: : | Excel 2003 lists .123 as types of files it will open for Lotus? No
: longer just
: | WK1 or WK4 types?
: |
: |
: | : | : In Excel 2003, use File | Open and scroll down to Lotus 1-2-3 files in
: | : the Files of Type drop down box.
: | : Don't know about previous versions.
: | :
: | : Now if Excel would recognize some of the newer versions of Quattro Pro
: | : files to open that easily....
: | :
: | : Bill
: | :
: | : : | : How do you import Lotus 123 files into Excel?
: | :
: | :
: |
: |
:
:
Didnt think there was a change, but wanted to make sure before noting that the
advice Bill gave was incorrect
: >>Excel 2003 lists .123 as types of files it will open for Lotus?
:
: No. No change from previous versions.
:
: --
: Jim Rech
: Excel MVP
: : | Excel 2003 lists .123 as types of files it will open for Lotus? No
: longer just
: | WK1 or WK4 types?
: |
: |
: | : | : In Excel 2003, use File | Open and scroll down to Lotus 1-2-3 files in
: | : the Files of Type drop down box.
: | : Don't know about previous versions.
: | :
: | : Now if Excel would recognize some of the newer versions of Quattro Pro
: | : files to open that easily....
: | :
: | : Bill
: | :
: | : : | : How do you import Lotus 123 files into Excel?
: | :
: | :
: |
: |
:
:
B
Bill Sharpe
The open dialog box in Excel 2003 has an option to open Lotus
1-2-3(*.wk?) files in the Files of Type drop-down box. I opened a .WK1
file and got options to save the file as .WK1, .WK3 or .WKS.
Bill
Excel 2003 lists .123 as types of files it will open for Lotus? No
longer just
WK1 or WK4 types?
: In Excel 2003, use File | Open and scroll down to Lotus 1-2-3 files in
: the Files of Type drop down box.
: Don't know about previous versions.
:
: Now if Excel would recognize some of the newer versions of Quattro Pro
: files to open that easily....
:
: Bill
:
: : How do you import Lotus 123 files into Excel?
:
:
1-2-3(*.wk?) files in the Files of Type drop-down box. I opened a .WK1
file and got options to save the file as .WK1, .WK3 or .WKS.
Bill
Excel 2003 lists .123 as types of files it will open for Lotus? No
longer just
WK1 or WK4 types?
: In Excel 2003, use File | Open and scroll down to Lotus 1-2-3 files in
: the Files of Type drop down box.
: Don't know about previous versions.
:
: Now if Excel would recognize some of the newer versions of Quattro Pro
: files to open that easily....
:
: Bill
:
: : How do you import Lotus 123 files into Excel?
:
:
B
Bill Sharpe
Not incorrect. I never said the file extension was .123. Jim did. I said
"Lotus 1-2-3 files."
Thanks
Didnt think there was a change, but wanted to make sure before noting
that the
advice Bill gave was incorrect
: >>Excel 2003 lists .123 as types of files it will open for Lotus?
:
: No. No change from previous versions.
:
: --
: Jim Rech
: Excel MVP
: : | Excel 2003 lists .123 as types of files it will open for Lotus? No
: longer just
: | WK1 or WK4 types?
: |
: |
: | : | : In Excel 2003, use File | Open and scroll down to Lotus 1-2-3
files in
: | : the Files of Type drop down box.
: | : Don't know about previous versions.
: | :
: | : Now if Excel would recognize some of the newer versions of Quattro
Pro
: | : files to open that easily....
: | :
: | : Bill
: | :
: | : : | : How do you import Lotus 123 files into Excel?
: | :
: | :
: |
: |
:
:
"Lotus 1-2-3 files."
Thanks
Didnt think there was a change, but wanted to make sure before noting
that the
advice Bill gave was incorrect
: >>Excel 2003 lists .123 as types of files it will open for Lotus?
:
: No. No change from previous versions.
:
: --
: Jim Rech
: Excel MVP
: : | Excel 2003 lists .123 as types of files it will open for Lotus? No
: longer just
: | WK1 or WK4 types?
: |
: |
: | : | : In Excel 2003, use File | Open and scroll down to Lotus 1-2-3
files in
: | : the Files of Type drop down box.
: | : Don't know about previous versions.
: | :
: | : Now if Excel would recognize some of the newer versions of Quattro
Pro
: | : files to open that easily....
: | :
: | : Bill
: | :
: | : : | : How do you import Lotus 123 files into Excel?
: | :
: | :
: |
: |
:
:
L
Lady Layla
Correct but it will not open or save as a .123 which is the latest version Lotus
uses. -- I believe the ext changed in 97 or so to the .123
: The open dialog box in Excel 2003 has an option to open Lotus
: 1-2-3(*.wk?) files in the Files of Type drop-down box. I opened a .WK1
: file and got options to save the file as .WK1, .WK3 or .WKS.
:
: Bill
:
: : Excel 2003 lists .123 as types of files it will open for Lotus? No
: longer just
: WK1 or WK4 types?
:
:
: : : In Excel 2003, use File | Open and scroll down to Lotus 1-2-3 files in
: : the Files of Type drop down box.
: : Don't know about previous versions.
: :
: : Now if Excel would recognize some of the newer versions of Quattro Pro
: : files to open that easily....
: :
: : Bill
: :
: : : : How do you import Lotus 123 files into Excel?
: :
: :
:
:
:
uses. -- I believe the ext changed in 97 or so to the .123
: The open dialog box in Excel 2003 has an option to open Lotus
: 1-2-3(*.wk?) files in the Files of Type drop-down box. I opened a .WK1
: file and got options to save the file as .WK1, .WK3 or .WKS.
:
: Bill
:
: : Excel 2003 lists .123 as types of files it will open for Lotus? No
: longer just
: WK1 or WK4 types?
:
:
: : : In Excel 2003, use File | Open and scroll down to Lotus 1-2-3 files in
: : the Files of Type drop down box.
: : Don't know about previous versions.
: :
: : Now if Excel would recognize some of the newer versions of Quattro Pro
: : files to open that easily....
: :
: : Bill
: :
: : : : How do you import Lotus 123 files into Excel?
: :
: :
:
:
:
B
Bill Sharpe
I haven't used Lotus 1-2-3 since WK3 days, so appreciate the
information. Excel has done even less to keep track of Quattro Pro
files. As far as I can tell Excel only supports Quattro Pro DOS format,
which goes back to the 1980's. Quattro Pro, however, does support saving
spreadsheets with a .123 extension, although the program warns that
Quattro features may be lost when doing a save.
Bill
Correct but it will not open or save as a .123 which is the latest
version Lotus
uses. -- I believe the ext changed in 97 or so to the .123
: The open dialog box in Excel 2003 has an option to open Lotus
: 1-2-3(*.wk?) files in the Files of Type drop-down box. I opened a .WK1
: file and got options to save the file as .WK1, .WK3 or .WKS.
:
: Bill
:
: : Excel 2003 lists .123 as types of files it will open for Lotus? No
: longer just
: WK1 or WK4 types?
:
:
: : : In Excel 2003, use File | Open and scroll down to Lotus 1-2-3 files
in
: : the Files of Type drop down box.
: : Don't know about previous versions.
: :
: : Now if Excel would recognize some of the newer versions of Quattro
Pro
: : files to open that easily....
: :
: : Bill
: :
: : : : How do you import Lotus 123 files into Excel?
: :
: :
:
:
:
information. Excel has done even less to keep track of Quattro Pro
files. As far as I can tell Excel only supports Quattro Pro DOS format,
which goes back to the 1980's. Quattro Pro, however, does support saving
spreadsheets with a .123 extension, although the program warns that
Quattro features may be lost when doing a save.
Bill
Correct but it will not open or save as a .123 which is the latest
version Lotus
uses. -- I believe the ext changed in 97 or so to the .123
: The open dialog box in Excel 2003 has an option to open Lotus
: 1-2-3(*.wk?) files in the Files of Type drop-down box. I opened a .WK1
: file and got options to save the file as .WK1, .WK3 or .WKS.
:
: Bill
:
: : Excel 2003 lists .123 as types of files it will open for Lotus? No
: longer just
: WK1 or WK4 types?
:
:
: : : In Excel 2003, use File | Open and scroll down to Lotus 1-2-3 files
in
: : the Files of Type drop down box.
: : Don't know about previous versions.
: :
: : Now if Excel would recognize some of the newer versions of Quattro
Pro
: : files to open that easily....
: :
: : Bill
: :
: : : : How do you import Lotus 123 files into Excel?
: :
: :
:
:
:
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.