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
thenoo

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
Irene

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
thenoo

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
Golden
Microsoft MVP

Windows 7 Ult. 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
Irene

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
thenoo

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





Similar help and support threads
Thread Forum
IE11 form data question
Hi all. New install of W7 Ult, and fully updated. I use webmail for my Comcast email, and also my personal website email (different address, obviously) With auto complete on, I open IE11 to my Comcast email, and enter my email address & pwrd. Both are remembered. I then open the link to my...
Browsers & Mail
Converting Dynamic drive to Basic drive without data loss.
I recently installed an SSD in my system, as I was clearing off my secondary disk I messed something up on it. My secondary drive is a 1tb WD Black that had 3 partitions. It had the 100mb System Reserved, a 75gb partition that contained my Windows 7 install and all necessary drivers, and the...
Hardware & Devices
Excel Guru Needed - Help with order form that will update an inventory
Hi, I was hoping someone could help me with creating an order form in excel that would then update the inventory (the main reason for this is to update the inventory rather than actually store any data). e.g. Order for Black Collar with the name jamie - when clicking on proceed it would...
Microsoft Office
Need to swap some data in Excel
Hi, I need to rearrange some data that are mistyped in an Excel sheet. Imagine two columns and many rows. There are some data that need to swap their places so it gets under the appropriate column. The data in this sheet are quite huge and I am thinking of a method like when clicking on those...
Microsoft Office
Converting a dynamic disk to basic without data loss
Hello All, Would really appreciate some help. I have a 500GB dynamic hard drive which had a Windows 7 install on it. I wanted to reinstall Windows, so from within Windows setup I formatted the system and Windows partition, leaving a partition containing documents and pictures (i was unable to...
General Discussion
Getting data from excel to firefox??
So... i have an excel doc with about 300 records all in a cell each, i want to get them all in to a specific field on a website in their own tab in firefox. any one know if this can be done? Thanks. D
General Discussion

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 13:15.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App