how do i convert works to excel files,

Discussion in 'Microsoft Excel New Users' started by Guest, Dec 16, 2004.

  1. Guest

    Guest Guest

     
    Guest, Dec 16, 2004
    #1
    1. Advertisements

  2. Guest

    Frank Kabel Guest

    Hi
    a repost from Ken Wright to convert MS Works files:
    -----

    Generally you would normally open the file in WORKS and then save it
    down as a file that Excel can read. .xlr is a native Excel format,
    or .txt, .csv, dbaseIV are all formats it can read. You can also find
    a converter here if you don't have WORKS.

    http://www.rl-software.com/indexjs.htm?/converter/wkscnvxls_e.htm

    Text from the website above:-

    Microsoft does not provide an import Excel filter for Works-WKS files
    later than version 2. (for Works-WPD and Word they do). There is no
    standard way to convert a lot of Works-WKS files into the Excel format.
    You need to save each file out
    of Works manually into XLS which is a pain in the neck.
    Here comes our MS Works spreadsheets to Excel Converter. It does not
    need a Works Installation and you
    can use the batch converting wizard (see right side).
    a.. Completely integrated into Excel 97/2000/XP, no external program
    b.. Imports MS Works Spreadsheet (*.WKS) 3.x ,4.x, 200xfiles
    c.. Convenient, selfextracting and selfinstalling setup procedure
    d.. Can be removed completely with standard deinstall procedure
    e.. Works with Windows 9x, ME, NT 4, 2000, XP
    f.. Our RL-File-Conversion-Wizard is part of the package
    g.. Converts cell alignments, font styles, etc.
    h.. Excel helper macros to make migration easier
    i.. No need for a Works installation
    j.. Free Updates: Our registered customers can download the latest
    version from our download area at any time

    Two articles from Microsoft that deal with Works and the files it can
    open/save as.

    Works: Sharing Works Files with Other Programs
    http://support.microsoft.com/default.aspx?scid=KB;en-ca;271080


    Works: Limitations of Sharing Files with Excel
    http://support.microsoft.com/default.aspx?scid=KB;en-ca;269273



    --
    Regards
    Frank Kabel
    Frankfurt, Germany
    "fgiord" <> schrieb im Newsbeitrag
    news:...
    >
     
    Frank Kabel, Dec 16, 2004
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    Thanks,
    I purchased a new computer and dumped all my files into it now the new one
    doesn't have works so now I can't even open Works Word proccessor and the
    Works database files!

    "fgiord" wrote:

    >
     
    Guest, Dec 16, 2004
    #3
  4. Guest

    Frank Kabel Guest

    Hi
    then either find a friend who still has Works installed (and let him convert
    your files) or go for one of the commercial converters

    --
    Regards
    Frank Kabel
    Frankfurt, Germany

    fgiord wrote:
    > Thanks,
    > I purchased a new computer and dumped all my files into it now the
    > new one doesn't have works so now I can't even open Works Word
    > proccessor and the Works database files!
    >
    > "fgiord" wrote:
     
    Frank Kabel, Dec 16, 2004
    #4
  5. Guest

    Guest Guest

    Thanks Frank,

    I guess I'll hook up the old computer and (start convert'n)

    "Frank Kabel" wrote:

    > Hi
    > then either find a friend who still has Works installed (and let him convert
    > your files) or go for one of the commercial converters
    >
    > --
    > Regards
    > Frank Kabel
    > Frankfurt, Germany
    >
    > fgiord wrote:
    > > Thanks,
    > > I purchased a new computer and dumped all my files into it now the
    > > new one doesn't have works so now I can't even open Works Word
    > > proccessor and the Works database files!
    > >
    > > "fgiord" wrote:

    >
    >
    >
     
    Guest, Dec 16, 2004
    #5
  6. Guest

    LeAnne Guest

    Frank Kabel wrote:

    > Hi
    > then either find a friend who still has Works installed (and let him convert
    > your files) or go for one of the commercial converters
    >

    PMFJI -

    Is that the poster's only option? I am able to open existing Works
    spreadsheet files from XL(97 or 03)...select File > Open and then hit
    the dropdown list for "Files of Type;" file formats with the extension
    ..wks are listed. Likewise, Word appears to be able to open word
    processing files of filetype .wps.

    hth,

    LeAnne
     
    LeAnne, Dec 22, 2004
    #6
  7. Guest

    LeAnne Guest

    LeAnne, Dec 22, 2004
    #7
  8. Guest

    Nick Hodge Guest

    LeAnne

    For some reason known only to MS, they abandoned the converter for *.wks
    (also used by Lotus as an extension) after V2 of Works, so any version after
    that has to be saved as such in Works... seems mad to me too!

    --
    HTH
    Nick Hodge
    Microsoft MVP - Excel
    Southampton, England
    HIS


    "LeAnne" <> wrote in message
    news:%...
    > Frank Kabel wrote:
    >
    >> Hi
    >> then either find a friend who still has Works installed (and let him
    >> convert your files) or go for one of the commercial converters
    >>

    > PMFJI -
    >
    > Is that the poster's only option? I am able to open existing Works
    > spreadsheet files from XL(97 or 03)...select File > Open and then hit the
    > dropdown list for "Files of Type;" file formats with the extension .wks
    > are listed. Likewise, Word appears to be able to open word processing
    > files of filetype .wps.
    >
    > hth,
    >
    > LeAnne
     
    Nick Hodge, Dec 22, 2004
    #8
  9. Guest

    Frank Kabel Guest

    Hi
    at least my Excel would open only VERY old Works 2.0 files but not the newer
    versions

    --
    Regards
    Frank Kabel
    Frankfurt, Germany

    LeAnne wrote:
    > Frank Kabel wrote:
    >
    >> Hi
    >> then either find a friend who still has Works installed (and let him
    >> convert your files) or go for one of the commercial converters
    >>

    > PMFJI -
    >
    > Is that the poster's only option? I am able to open existing Works
    > spreadsheet files from XL(97 or 03)...select File > Open and then hit
    > the dropdown list for "Files of Type;" file formats with the extension
    > .wks are listed. Likewise, Word appears to be able to open word
    > processing files of filetype .wps.
    >
    > hth,
    >
    > LeAnne
     
    Frank Kabel, Dec 22, 2004
    #9
  10. Guest

    LeAnne Guest

    Nick Hodge wrote:

    > LeAnne
    >
    > For some reason known only to MS, they abandoned the converter for *.wks
    > (also used by Lotus as an extension) after V2 of Works, so any version after
    > that has to be saved as such in Works... seems mad to me too!
    >


    Hi Nick,

    <sarcasm> Good ol' M$...</sarcasm>

    Seriously, according to the KB article posted above:

    "Microsoft Excel can open and view a Works Spreadsheet document in its
    native (.xlr) format. A Works Spreadsheet document can be viewed with
    any program that can open or view a Microsoft Excel worksheet.
    Additionally, Spreadsheet can also open Backup files (.bks) and Text
    files (.txt)."

    L.
     
    LeAnne, Dec 22, 2004
    #10
  11. Guest

    Nick Hodge Guest

    Mmmmmmm

    If anyone has a file, send it and I'll try, but I will be staggered as to
    why they suddenly included it again. It hasn't worked since XL97 or 2000,
    can't remember now.

    --
    HTH
    Nick Hodge
    Microsoft MVP - Excel
    Southampton, England
    HIS


    "LeAnne" <> wrote in message
    news:...
    > Nick Hodge wrote:
    >
    >> LeAnne
    >>
    >> For some reason known only to MS, they abandoned the converter for *.wks
    >> (also used by Lotus as an extension) after V2 of Works, so any version
    >> after that has to be saved as such in Works... seems mad to me too!
    >>

    >
    > Hi Nick,
    >
    > <sarcasm> Good ol' M$...</sarcasm>
    >
    > Seriously, according to the KB article posted above:
    >
    > "Microsoft Excel can open and view a Works Spreadsheet document in its
    > native (.xlr) format. A Works Spreadsheet document can be viewed with any
    > program that can open or view a Microsoft Excel worksheet. Additionally,
    > Spreadsheet can also open Backup files (.bks) and Text files (.txt)."
    >
    > L.
     
    Nick Hodge, Dec 22, 2004
    #11
  12. Guest

    Frank Kabel Guest

    [...]
    > <sarcasm> Good ol' M$...</sarcasm>
    >
    > Seriously, according to the KB article posted above:
    >
    > "Microsoft Excel can open and view a Works Spreadsheet document in its
    > native (.xlr) format. A Works Spreadsheet document can be viewed with
    > any program that can open or view a Microsoft Excel worksheet.
    > Additionally, Spreadsheet can also open Backup files (.bks) and Text
    > files (.txt)."


    Hi LeAnne
    but this is probably not the default format to save a Works file. If the
    user has the option to create such file in Works he could create a *.xls
    file anyway :)

    Frank
     
    Frank Kabel, Dec 22, 2004
    #12
  13. Guest

    LeAnne Guest

    Frank Kabel wrote:
    >
    >
    > Hi LeAnne
    > but this is probably not the default format to save a Works file.


    Hmm. Okay, if it isn't .wks, and it isn't .xl*, what is the default file
    format for a Works spreadsheet these days?

    LeAnne
     
    LeAnne, Dec 22, 2004
    #13
  14. In newer versions of Works (6.0, or later), it looks like .xlr is the
    default format.

    http://support.microsoft.com/?kbid=271074

    LeAnne wrote:
    > Frank Kabel wrote:
    >
    >>
    >>
    >> Hi LeAnne
    >> but this is probably not the default format to save a Works file.

    >
    >
    > Hmm. Okay, if it isn't .wks, and it isn't .xl*, what is the default file
    > format for a Works spreadsheet these days?
    >
    > LeAnne



    --
    Debra Dalgleish
     
    Debra Dalgleish, Dec 22, 2004
    #14
  15. Guest

    LeAnne Guest

    Debra Dalgleish wrote:

    > In newer versions of Works (6.0, or later), it looks like .xlr is the
    > default format.
    >
    > http://support.microsoft.com/?kbid=271074
    >


    Debra to the rescue! Girl power! Woohoo!

    Thanks,

    LeAnne
     
    LeAnne, Dec 22, 2004
    #15
  16. Guest

    Spence Guest

    All...you can also simply download Open Office and use it. I've had very
    good luck with old Lotus files and I'm running OS X.



    "Frank Kabel" wrote:

    > Hi
    > at least my Excel would open only VERY old Works 2.0 files but not the newer
    > versions
    >
    > --
    > Regards
    > Frank Kabel
    > Frankfurt, Germany
    >
    > LeAnne wrote:
    > > Frank Kabel wrote:
    > >
    > >> Hi
    > >> then either find a friend who still has Works installed (and let him
    > >> convert your files) or go for one of the commercial converters
    > >>

    > > PMFJI -
    > >
    > > Is that the poster's only option? I am able to open existing Works
    > > spreadsheet files from XL(97 or 03)...select File > Open and then hit
    > > the dropdown list for "Files of Type;" file formats with the extension
    > > .wks are listed. Likewise, Word appears to be able to open word
    > > processing files of filetype .wps.
    > >
    > > hth,
    > >
    > > LeAnne

    >
    >
    >
     
    Spence, Aug 27, 2008
    #16
  17. Guest

    Gord Dibben Guest

    Spence

    You replied to 3 1/2 year old post but thanks for the info.


    Gord Dibben MS Excel MVP

    On Wed, 27 Aug 2008 08:55:01 -0700, Spence
    <> wrote:

    >All...you can also simply download Open Office and use it. I've had very
    >good luck with old Lotus files and I'm running OS X.
    >
    >
    >
    >"Frank Kabel" wrote:
    >
    >> Hi
    >> at least my Excel would open only VERY old Works 2.0 files but not the newer
    >> versions
    >>
    >> --
    >> Regards
    >> Frank Kabel
    >> Frankfurt, Germany
    >>
    >> LeAnne wrote:
    >> > Frank Kabel wrote:
    >> >
    >> >> Hi
    >> >> then either find a friend who still has Works installed (and let him
    >> >> convert your files) or go for one of the commercial converters
    >> >>
    >> > PMFJI -
    >> >
    >> > Is that the poster's only option? I am able to open existing Works
    >> > spreadsheet files from XL(97 or 03)...select File > Open and then hit
    >> > the dropdown list for "Files of Type;" file formats with the extension
    >> > .wks are listed. Likewise, Word appears to be able to open word
    >> > processing files of filetype .wps.
    >> >
    >> > hth,
    >> >
    >> > LeAnne

    >>
    >>
    >>
     
    Gord Dibben, Aug 27, 2008
    #17
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. homefry

    Transferring Works files into Excel XP

    homefry, Apr 18, 2004, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    320
    Bernard Liengme
    Apr 18, 2004
  2. Guest

    How do I convert a Works file to an Excel file

    Guest, Sep 27, 2004, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    489
    Ken Wright
    Sep 27, 2004
  3. Guest

    Convert Works 6.0 data base to Excel?

    Guest, Jan 8, 2005, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    451
    Ken Wright
    Jan 8, 2005
  4. Guest

    how do I convert Works DB files to Word

    Guest, Jan 19, 2005, in forum: Microsoft Excel New Users
    Replies:
    5
    Views:
    420
    Gordon
    Jan 19, 2005
  5. Guest

    Opening MS Works files in Excel

    Guest, Feb 22, 2005, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    15,672
    Ken Wright
    Feb 22, 2005
  6. Guest

    Can I convert my Quatro Pro files to MS Excel files?

    Guest, Jan 17, 2006, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    412
    Guest
    May 11, 2006
  7. SeeAll

    ATTN: Works wdb files to Excel 2003 converter query

    SeeAll, Jul 9, 2006, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    310
    Nick Hodge
    Jul 9, 2006
  8. B. Atkins

    converting works data files to excel with original formats

    B. Atkins, Nov 28, 2009, in forum: Microsoft Excel New Users
    Replies:
    0
    Views:
    423
    B. Atkins
    Nov 28, 2009
Loading...