creating spreadsheet to fill pdf form

%3CLINGO-SUB%20id%3D%22lingo-sub-2703421%22%20slang%3D%22en-US%22%3Ecreating%20spreadsheet%20to%20fill%20pdf%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2703421%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20fillable%20.pdf%20form%20that%20is%20not%20user%20friendly.%20If%20you%20make%20a%20mistake%20on%20a%20line%20you%20cannot%20move%20the%20info%20down%20and%20insert%20a%20line%20of%20course.%20I%20would%20like%20to%20create%20a%20spreadsheet%20with%20the%20appropriate%20layout%26nbsp%3B%20so%20that%20I%20could%20insert%20the%20form%20into%20my%20printer%20and%20Excel%20would%20print%20the%20info%20in%20the%20appropriate%20blocks.%20How%20would%20I%20do%20this%20%3F%20Attached%20is%20the%20.pdf%20form.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2703421%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2704819%22%20slang%3D%22en-US%22%3ERe%3A%20creating%20spreadsheet%20to%20fill%20pdf%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2704819%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1142521%22%20target%3D%22_blank%22%3E%40learaviator%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20important%20is%20it%20that%20that%20actual%20form%20exactly%20as%20it%20is%20be%20used%3F%20Would%20it%20be%20acceptable%20to%20use%20an%20Excel%20replica%20(with%20maybe%20some%20of%20the%20vertical%20lines%20at%20the%20top%20not%20aligned%20as%20they%20are%2C%20but%20with%20all%20the%20same%20information%20appearing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20ask%20because%20you're%20going%20to%20encounter%20problems%20trying%20to%20align%20the%20physical%20form%20with%20an%20Excel%20workbook%20in%20a%20printer.%20It'll%20work%20sometimes%2C%20but%20wouldn't%20take%20much%20to%20be%20out%20of%20alignment....%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20the%20organization%20(the%20FAA%3F)%20is%20still%20distributing%20a%20printed%20form%20strikes%20me%20as%20anachronistic%20to%20begin%20with.%20Maybe%20you'd%20be%20hailed%20as%20a%20hero%20if%20you%20suggested%20a%20change.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%2C%20if%20I%20were%20in%20your%20place%2C%20I'd%20be%20looking%20to%20change%20the%20process%20of%20filling%20in%20the%20form...either%20creating%20an%20Excel%20workbook%20template%20that%20met%20the%20same%20requirements%20for%20thoroughness%20and%20clarity%20OR%20a%20Word%20document--which%20might%20be%20even%20better%2C%20since%20Word%20is%20made%20to%20process%20words%20and%20that%20looks%20to%20be%20more%20the%20content%20that%20is%20expected.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a fillable .pdf form that is not user friendly. If you make a mistake on a line you cannot move the info down and insert a line of course. I would like to create a spreadsheet with the appropriate layout  so that I could insert the form into my printer and Excel would print the info in the appropriate blocks. How would I do this ? Attached is the .pdf form.  

4 Replies

@learaviator 

 

How important is it that that actual form exactly as it is be used? Would it be acceptable to use an Excel replica (with maybe some of the vertical lines at the top not aligned as they are, but with all the same information appearing.

 

I ask because you're going to encounter problems trying to align the physical form with an Excel workbook in a printer. It'll work sometimes, but wouldn't take much to be out of alignment.... 

 

That the organization (the FAA?) is still distributing a printed form strikes me as anachronistic to begin with. Maybe you'd be hailed as a hero if you suggested a change.

 

Anyway, if I were in your place, I'd be looking to change the process of filling in the form...either creating an Excel workbook template that met the same requirements for thoroughness and clarity OR a Word document--which might be even better, since Word is made to process words and that looks to be more the content that is expected.

@mathetes 

It might not be that critical to use the exact form. The form is available in a fillable .pdf but for example,  if you fill out lines 1-15 and then need to enter a line between say 10 and 11, you cannot add a line, you have to cut and paste each block of each line down one row. I can convert it to the .pdf to Excel and fill it out, but the form ends up being noticeably smaller. Might not be important, we will see. Thanks for your reply!

As I suggested, though, I think Word would actually be preferable anyway. The tables in Word are far more flexible...and cells can contain more text than Excel allows. And it is easy to add a line (row) to a table in Word.
Thank you for your suggestion, I will work on this tonight!!