Export specific data from Microsoft word form to excel spreadsheet

Tyson Peters 0 Reputation points

Hello I have made a WHS compliance check list form in Microsoft word. I write the name of the staff member at the top of the form with the date then a bunch of tick boxes to ensure they are compliant. I save-as each document under the staff members name in a folder. I just want to copy the name of the staff member the assessment and date it was completed into an excel spreadsheet to keep a record that I captured everyone for the year. Is it possible to automate this or do I have to do it manually one form at a time?

A family of Microsoft word processing software products for creating web, email, and print documents.
497 questions
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,075 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Charles Kenyon 2,251 Reputation points

    Here are two links to get you started:

    0 comments No comments