Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-14-2016, 02:13 PM
Labyrinth Labyrinth is offline Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Windows 10 Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Office 2013
Novice
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet
 
Join Date: Jul 2016
Posts: 5
Labyrinth is on a distinguished road
Cool Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet


How can I export specific data fields from a job application form created in MS Word to a MS Excel spreadsheet please this will save me weeks as I am currently manually transferring all the data from hundreds of files

Last edited by Charles Kenyon; 07-15-2016 at 08:30 AM. Reason: Mark as solved
Reply With Quote
  #2  
Old 07-14-2016, 07:25 PM
DougMVP DougMVP is offline Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Windows 7 32bit Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Office 2010 32bit
Advanced Beginner
 
Join Date: Nov 2013
Posts: 50
DougMVP will become famous soon enough
Default

See the following pages of Greg Maxey's website

http://gregmaxey.com/word_tip_pages/...rom_forms.html

http://gregmaxey.com/word_tip_pages/...ment_file.html

http://gregmaxey.com/word_tip_pages/...form_data.html
Reply With Quote
  #3  
Old 07-16-2016, 03:38 PM
Labyrinth Labyrinth is offline Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Windows 10 Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Office 2013
Novice
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet
 
Join Date: Jul 2016
Posts: 5
Labyrinth is on a distinguished road
Default

Thankyou I will see if the links help a quick question does the original word document have to be built in a special way or can data be extracted from any word document using the methods shown above
Reply With Quote
  #4  
Old 07-16-2016, 04:11 PM
DougMVP DougMVP is offline Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Windows 7 32bit Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Office 2010 32bit
Advanced Beginner
 
Join Date: Nov 2013
Posts: 50
DougMVP will become famous soon enough
Default

I assume that as you mentioned that you wanted to "export specific data fields from a job application form" that the documents are in a format that allows the data that is to be exported to be identified. Exactly what do you mean by "data fields"? Are they one of the various types of controls that can be added to a Word document?
Reply With Quote
  #5  
Old 07-17-2016, 02:15 PM
Labyrinth Labyrinth is offline Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Windows 10 Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Office 2013
Novice
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet
 
Join Date: Jul 2016
Posts: 5
Labyrinth is on a distinguished road
Default

The job application has been created using a simple word document with no drop downs or any identifiers for each section that needs completing example the applicants name is just first name with a box and surname with a box. Can I transform this document to capture these fields into an Excel spreadsheet or will I need to recreate the job application form using gvthe techniques highlighted in your first response
Reply With Quote
  #6  
Old 07-17-2016, 03:15 PM
DougMVP DougMVP is offline Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Windows 7 32bit Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Office 2010 32bit
Advanced Beginner
 
Join Date: Nov 2013
Posts: 50
DougMVP will become famous soon enough
Default

Can you send me one of the documents so that I can see exactly from what it is that you want to extract the data. You should also let me know what data it is that is to be extracted. Send it to dkr[atsymbol]mvps[dot]org
Reply With Quote
  #7  
Old 07-17-2016, 09:03 PM
Labyrinth Labyrinth is offline Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Windows 10 Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Office 2013
Novice
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet
 
Join Date: Jul 2016
Posts: 5
Labyrinth is on a distinguished road
Default

I will send it to you later today thankyou for your continued support on this matter
Reply With Quote
  #8  
Old 07-19-2016, 01:35 PM
Labyrinth Labyrinth is offline Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Windows 10 Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Office 2013
Novice
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet
 
Join Date: Jul 2016
Posts: 5
Labyrinth is on a distinguished road
Default Blank Template

I have sent across the document might be a large file as there are coloured logos on it
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting quiz scores from powerpoint to excel spreadsheet/word rjagile PowerPoint 1 02-08-2016 02:26 PM
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet word 2013 to excel 2013 Word4Dick Word 3 07-01-2015 09:57 PM
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Problem with Excel Template Population from Access (Very Specific Setup) *Office 2013 used* wingzero Excel 1 08-27-2014 06:12 AM
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Importing/Exporting data using Excel and some specific rules stagg201 Excel 1 03-27-2014 08:58 PM
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Macro: Exporting Data to a LEGIBLE Excel Spreadsheet jeffcoleky Word VBA 6 05-08-2012 08:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft