Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Converting Data in tabular form to Excel s/s ?

21 Jun 2011   #1

Windows 7 Home Premium x64
 
 
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 System SpecsSystem Spec
.

21 Jun 2011   #2

Windows 7 Home Premium 64bit
 
 

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 System SpecsSystem Spec
21 Jun 2011   #3

Windows 7 Home Premium x64
 
 
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 System SpecsSystem Spec
.


21 Jun 2011   #4

Microsoft Community Contributor Award Recipient

Windows 7 Ult. x64 Windows 8.1 x64
 
 

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 System SpecsSystem Spec
22 Jun 2011   #5

Windows 7 Home Premium 64bit
 
 

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.
.
.
.
My System SpecsSystem Spec
22 Jun 2011   #6

Windows 7 Home Premium x64
 
 

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 System SpecsSystem Spec
Reply

 Converting Data in tabular form to Excel s/s ?




Thread Tools




Our Sites

Site Links

About Us

Find 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 10:49 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33