Reply
 
Thread Tools Display Modes
  #1   Report Post  
nanner130
 
Posts: n/a
Default Can I import information from a form in MS Word into Excel?

I created a form in MS Word. I need to gather the data after I receive the
forms, and I wondered if I could create a spreadsheet in Excel that could
automatically take the information and add it to the spreadsheet without me
having to retype everything.

Is this possible?
  #2   Report Post  
DavisSon
 
Posts: n/a
Default

Yes, though indirectly. Word will allow you to save forms as text/csv. Excel
can then open up the csv files.

Goto Tools/Options/Save/Save data only for forms/OK. Then goto File/Save
Copy As/"your file name". In the Save as type box, choose Plain Text. You
can then open this comma-delimited file up and convert it itno Excel (choose
comma as your delimiter). Hope it helps!

"nanner130" wrote:

I created a form in MS Word. I need to gather the data after I receive the
forms, and I wondered if I could create a spreadsheet in Excel that could
automatically take the information and add it to the spreadsheet without me
having to retype everything.

Is this possible?

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
is word perfect compatible with office word? Noreen Microsoft Word Help 1 May 11th 05 11:17 PM
Making Word do something that Wordperfect can do NarniaUK New Users 4 May 1st 05 10:44 PM
Locking Two Words Together to Make a Proper Compound Noun in Word WorkingWoman Microsoft Word Help 2 April 7th 05 02:33 PM
What is the difference between Word Perfect and Microsoft Word, a. Jan New Users 4 March 31st 05 09:41 PM
WordPerfect keyboard macro>Word equivalent? Anty New Users 2 March 13th 05 06:23 PM


All times are GMT +1. The time now is 02:40 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"