• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Can this be done?

New Here ,
Aug 15, 2017 Aug 15, 2017

Copy link to clipboard

Copied

Okay I will apologize before hand because this might be a little long and maybe a bit confusing.

I am a school registrar.  Enrolling and withdrawing students are a daily task for me. Each student has different needs based on their academic history and 90% of the time it is not a simple as gather documents and enter the student into the computer.

Currently everything I do is hand written and time consuming. I end up hand writing the same info 10 time for 1 student. That isnt bad but when i have 100 kids to do this for its tiresome and time consuming. What I would like to is

type the needed data about a student into an excel spreed sheet that is then imported into a multi-page pdf document that will match these fields and fill in the blanks for me so I can click print and be ready to head to the fax, rather than writing it in by hand, or typing it in multiple times  and all the other places it has to be written and logged.

I already have the forms mostly in word a few in excel all of which I could turn into PDF's with very little trouble. The excel spreed sheet could then act as my log and the other documents needed would be auto filled based on one row of data from excel. Taking 10 mins rather than 30, this would also help on what has and has not been done for each student as I could pick and choose which pages i need to print based on the students needs.

Any help would be appreciated, I have acrobat Pro, Office, Onedrive and a ton of applications I just want the most simple way to make this work. Thank you in advance.

TOPICS
General troubleshooting

Views

272

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Aug 16, 2017 Aug 16, 2017

This is easily done in Acrobat. You just need to use the right tools and formatting. Here's how you do it:

Add your form fields to the PDF file. Where you want the same value to appear in multiple places just give the fields the same name and they will automatically have the same value.

The Excel file needs to have two (or more) rows of data, with the field names (named EXACTLY like they appear in the PDF) in the first row and the values in the second. Now save the file as a tab-delimited text fil

...

Votes

Translate

Translate
Community Expert ,
Aug 16, 2017 Aug 16, 2017

Copy link to clipboard

Copied

LATEST

This is easily done in Acrobat. You just need to use the right tools and formatting. Here's how you do it:

Add your form fields to the PDF file. Where you want the same value to appear in multiple places just give the fields the same name and they will automatically have the same value.

The Excel file needs to have two (or more) rows of data, with the field names (named EXACTLY like they appear in the PDF) in the first row and the values in the second. Now save the file as a tab-delimited text file and close it.

Then you open your PDF in Acrobat and select Tools - Forms - More Form Options - Import Data. Select the file you created from Excel, and if you have more than two rows select which one to import, and you're done!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines