Converting Data in tabular form to Excel s/s ?


  1. Posts : 140
    Windows 7 Home Premium x64
       #1

    Converting Data in tabular form to Excel s/s ?


    I have received a list of data which is in the form of a table containing several columns. This list contains something in excess of 300 lines which I want to put into an Excel 2003 spreadsheet. Is there any way I can achieve this without the tedium of manual input of each line ?
      My Computer


  2. Posts : 3,009
    Windows 7 Home Premium 64bit
       #2

    The following guide does not actually say which Office version they are using. However, hopefully it might provide the necessary information:
    How to Convert a Microsoft Word Table Into an Excel Workbook | eHow.com

    Please post back with the results, or if you require any further help. :)
      My Computer


  3. Posts : 140
    Windows 7 Home Premium x64
    Thread Starter
       #3

    Converting Data into Word and/or Excel ?


    Thanks for that reply. I think I may not have been too clear with the description of my initial request in my last post. Your reply refers to data already contained in the form of an MS Word Table format. I should have explained that the data I wish to transfer is merely in an ordinary .txt file but is held in 3 vertical columns in this file but not in any formal MS FORMAT. Is there any way to get such data , say , initially into a Word Table form preparatory to then converting it into Excel ?
      My Computer


  4. Posts : 19,383
    Windows 10 Pro x64 ; Xubuntu x64
       #4

    Hi,

    Please post a screen capture of the layout of the data in TXT format, and I'll see if I can suggest anything.

    Regards,
    Golden
      My Computer


  5. Posts : 3,009
    Windows 7 Home Premium 64bit
       #5

    Perhaps this is nearer the mark:
    Convert text to a table or vice versa - Word - Office.com

    Edit: Also a short 'training course' to import text into Excel:
    Import data: Import text files into Excel 2003 - Training - Office.com

    Please let us know if any of it works for you, or if you need more help. :)
    .
    .
    .
    Last edited by Irene; 22 Jun 2011 at 01:30.
      My Computer


  6. Posts : 140
    Windows 7 Home Premium x64
    Thread Starter
       #6

    Thanks very much for the replies from IRENE and GOLDEN. I will study the suggestions given there before I reply to them particularly. There is one further difficulty I have with this planned process which I didn't fully explain before and that is that the data I have is in a printed file only , i.e. it is not yet in digital form. I requested the source of this data if they could present it to me in , say , a .pdf form or in an extract from a data base but they say that will not be possible due , I presume , to information protection concerns as it involves financial data. I presume , therefore , in this case the very first step would be to convert this data into digital form by , for instance , scanning it . Would you agree with this ?
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 01:45.
Find Us