Can I import information from a form in MS Word into Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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!
 
You must log in or register to reply here.

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can a word list be imported to an excel spreadsheet? 2
forms, data import excel, generate multiple pages 2
Convert Excel Form into Word Form 6
Moving form data from Word to an Excel Spreadsheet? 3
Word 2007 Import Excel spreadsheet from Workbook 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Export an imbeded Excel file from Word 3
Importing an Excel spreadsheet into Word 1

Back
Top