Automate Job application word doc to Excel (with data validation)

[dylansmith]

how difficult is it to achieve and how reliable will the method be?

Most importantly, I'd also like to know how to validate data for various fields within Word (e.g. date of birth cannot be >70 years old, salary <$20,000, each employment period cannot overlap with one another for different roles), and then populate these fields in Excel for further analysis next time.

In addition (but off-topic), It will also be a bonus if there's a more secure method of storing sensitive information other than Google forms, especially for job applications (without resorting to enterprise-level solutions).

I look forward to hearing from you soon. Thanks!

[macropod]

Originally Posted by dylansmith

how difficult is it to achieve and how reliable will the method be?

How long is a piece of string? Are you trying to push that string end-wise uphill?

Really, you've told us nothing much that can be used for this. Getting the data out of Word depends on how well structured those documents are. Analysing the data in Excel requires that you set up the appropriate filters and that you've collected the relevant data in a way it is amenable to such analysis. Furthermore, Excel may not be the best tool; Access might be better suited.