[Aggregation of PDFs into Excel Pt. 1] How to create a form for generating PDFs with MS Word
These days, it is very convenient to use services such as Google Forms or Microsoft Forms to collect data such as surveys. Creating a form is convenient, but collecting and counting forms is more efficient than anything else.
However, there are times when you need to use individual form files for your own reasons, and the best way to do this is to use Adobe Acrobat Pro.
※ "[Adobe Acrobat] Creating a PDF score sheet form that automatically sums total points", 2020. 8. 12., http://cantips.com/3266
※ "[Adobe Acrobat Pro] Collect distributed PDF form files and organize them in Excel", 2020. 8. 14., http://cantips.com/3267
However, since Acrobat is not a free program, it has a disadvantage that it is not easy to use for general purpose. So, let's check how to create and distribute forms in commonly used MS Word or HWP, collect them back into PDF files, and then aggregate them in Excel.
First, let's learn how to create a form with MS Word.
Although it is a general method of creating a form in Word, it is premised on converting it to a PDF file and becoming a good form for use in Excel.
Additionally, it explains how to use formulas within tables and how to restrict editing of documents.
It also introduces how to write a macro (record a macro) for updating a field and how to input a field (macrobutton) for executing a macro.
Users who receive the document created in Word can enter the content and then convert it to PDF and reply. If you just reply in the original form, there is no problem even if the receiving end converts it to PDF.
This video also explains how to link one collected PDF file to Excel. This method is useful when you want to manage and analyze data in a form that automatically updates the contents by linking with Excel when PDF files with the same name and composition are collected regularly or irregularly.
How to combine multiple PDF files and aggregate them all into one Excel worksheet is covered in another video.
Note that PDF files created with Acrobat's form filling function cannot be aggregated with Excel's data management function.