Mass-Fill PDF Form Files Using Spreadsheets (Excel/Calc/GDocs) w/ Open Source Software (BulkPDF)

Auto-Fill PDF: Quite easy to fill PDFs with one spreadsheet. It's a real blessing in a world that can't handle spreadsheets.
LibreOffice Calc & Writer are avaialble for free (they are open source) without the requirement for admin rights (they are portable) from www.libreoffice.org/download/...
BulkPDF (also open source and portable) is available from github.com/Tadelsucht/BulkPDF... (get the ZIP for the portable version)
Subscribe to brand new hacks & showcases: bit.ly/OSBsub

Пікірлер: 44

  • @andreilogin4681
    @andreilogin4681 Жыл бұрын

    Thank you so much for the tutorial. I previously tried getting into VBA on excel but it was a very big pain for a small project. This solution just saved me from tens of hours of work and it worked flawlessly. Hats of to you sir and to the developer of BulkPDF.

  • @AdultLearningCenterMKE
    @AdultLearningCenterMKE Жыл бұрын

    Excellent tutorial!!! This got me exactly what I needed, and will save me HOURS of work for YEARS to come - thank you so much!!!

  • @mauriciotagliaferro3867
    @mauriciotagliaferro38674 жыл бұрын

    You helped me solve a problem that I had for a long time about how to fill PDF forms in bulk, THANKS!!

  • @shinepdf2713

    @shinepdf2713

    4 жыл бұрын

    Hello I have developed Speed PDF application in vb net, which will fill all excel user information into PDF form. You can also extract PDF form field information into excel sheet. kzread.info/dash/bejne/gYl_s7F6e5Ooe5M.html

  • @AnallelyMartinez-xb7do
    @AnallelyMartinez-xb7do3 жыл бұрын

    Most helpful video ever. Thank you!!

  • @saoirseor1
    @saoirseor13 жыл бұрын

    Great video Thank You! One problem...I am using check boxes in the pdf. With 'Yes' in excel. But when I complete the merge I get X in the checkbox field instead of Tick. It's a medical pdf so X would be too confusing. Can you advise?

  • @zuhaibzia1813
    @zuhaibzia1813 Жыл бұрын

    excellent tutorial. my work has become very fast now.

  • @power-reconcile
    @power-reconcile Жыл бұрын

    Awesome tutorial!

  • @Welinkup
    @Welinkup2 жыл бұрын

    What about for uploaded images? Like file attachements like Id cards?

  • @andreschoonbee4054
    @andreschoonbee40542 жыл бұрын

    Great Video Thanks. I tried it but the populated PDF's don't display the data but only when I click on the field can I see the data. I also cannot print the PDF with data. Any solution for this problem?

  • @oliverpintor6946
    @oliverpintor69462 жыл бұрын

    Hello. Is there a way to auto-run the bulkpdf for every new entry in the excel. Let’s say I will link my excel thru google drive and infor will be entered via google forms. And once new data will be entered, it will just create a new PDF for the new data and not for the entire sheet. I hope you can help me with this. Thank you!

  • @user-yz4xt7rj3r
    @user-yz4xt7rj3r Жыл бұрын

    This is awesome! Quick question tho, is it possible to use a REVU/BLUEBEAM form to fill out? I created text boxs similar but it seems they are not reading...

  • @massimoguillory3822
    @massimoguillory38223 жыл бұрын

    Check box won't work for me, i tried yes/no numbers letters. Nothing

  • @jorbedo
    @jorbedo6 ай бұрын

    Can I combine all forms in 1 single document? All the field names will be the same or they are different per row? Thanks a lot!

  • @bojanvu
    @bojanvu4 ай бұрын

    I need an assistance. Could you give me advice how to solve a problem with printing from access query on such custom made form?

  • @netpostv1459
    @netpostv14594 жыл бұрын

    Awesome stuff

  • @jansemora2588
    @jansemora25882 жыл бұрын

    Hi guys, I have tried this awesome thing and I have a problem. In Czech language there is a lot of letter such as Ř, Ž,.. If I open that PDF file, I cant see thise letters. Only if I click on that box, they appear. Can you help me fix that please? It would save me a tons of time. Also sorry for my english,.. Thanks!

  • @COOKINGBIRD
    @COOKINGBIRD Жыл бұрын

    How we can remove the water mark ""BulkPDF BUSINSS DEMO"FROM THE GENERATED PDF

  • @AfkarzemerTech
    @AfkarzemerTech Жыл бұрын

    Can i use these same with Google excel online

  • @sabrinaramos-cotto6326
    @sabrinaramos-cotto6326 Жыл бұрын

    THANK YOU SO MUCH!!!!

  • @enpdizajnproduction3790
    @enpdizajnproduction37904 жыл бұрын

    Hello, how are you? It great video and help me really. But I how one question, need some help if it not a problem? Thank you

  • @vinuthnayak4377
    @vinuthnayak43773 ай бұрын

    I have created .pdf file and tested it but my bad luck libeoffice call is no more portable (No Portable Version (MultilingualStandard) is currently available No Portable Version (MultilingualAll) is currently available)

  • @atiqnurrahman3007
    @atiqnurrahman30072 жыл бұрын

    You are reallllllllllllllly Greatttttttttttt Thanks

  • @RashidAli-hq1yx
    @RashidAli-hq1yx Жыл бұрын

    error during the opening of spreadsheet in BulkPDF application

  • @bobblack2643
    @bobblack26433 жыл бұрын

    Great video... I have a question I am getting an error while creating PDF files with this it appears it will not overwrite same named versions of files. System.Exception: Could not find a part of the path 'C:\Users\Bob\Desktop\test\Auntie Ann's\Gatlinburg.pdf'. at BulkPDF.PDF.SaveFilledPDF(String filePath, Boolean finalize) at BulkPDF.PDFFiller.CreateFiles(PDF pdf, Boolean finalize, IDataSource dataSource, Dictionary`2 pdfFields, String outputDir, DelGetFilename GetFilename, DelSetPercent setPercent, DelIsAborted isAborted) at BulkPDF.MainForm.backGroundWorker_DoWork(Object sender, DoWorkEventArgs e)

  • @bulkpdf5761

    @bulkpdf5761

    2 жыл бұрын

    The apostrophe in the file path could be the problem 🤷‍♀️

  • @alexxaray7618
    @alexxaray7618 Жыл бұрын

    Holy moly you are a beast

  • @massimoguillory3822
    @massimoguillory38223 жыл бұрын

    Radio buttons are driving me crazy. Can anyone help please.

  • @hebe1483
    @hebe14834 жыл бұрын

    Great Jooooooob. Congratulations the version for pc works great but the portable no. Please you can check it. When I unzip the system throw error. In my job does not let install no one software therefore its important the version portable

  • @ivan291194
    @ivan291194 Жыл бұрын

    some text fields in the pdf file dont get recognized by the pdf bulk app. someone know why?

  • @lg7705

    @lg7705

    Жыл бұрын

    could be that the fields are labeled correctly. Go to field options.

  • @jakubg6985
    @jakubg69853 жыл бұрын

    Any simlar software for MacOS?

  • @bulkpdf5761

    @bulkpdf5761

    2 жыл бұрын

    You could use BulkPDF in Parallel Desktop or VirtualBox.

  • @NinjMMA
    @NinjMMA Жыл бұрын

    Is there a web based version ?

  • @peace.n.blessings5579
    @peace.n.blessings55793 жыл бұрын

    Thanks

  • @massimoguillory3822
    @massimoguillory38223 жыл бұрын

    Bulkpdf won't autofill check boxes. I tried numbers letters 1/2. Ot won't autofill them. Any suggestions?

  • @agustinallerena8892

    @agustinallerena8892

    3 жыл бұрын

    Hi Massimo , I'm having the same issue. Did you find any solution? I've tried Yes/No, X/0 and lots of numbers and it wont fill them.

  • @daft1138

    @daft1138

    3 жыл бұрын

    Yes, try 1, 2... i used pdf pro to look the properties of the document and see what coding styles were used into creating the document. (Massimo)

  • @justinf9109
    @justinf91096 ай бұрын

    On/Off worked to put x's in my pdf boxes

  • @alexfriant3235
    @alexfriant3235 Жыл бұрын

    This is fantastic software and a wonderful tutorial.

  • @nickhorrific
    @nickhorrific Жыл бұрын

    I love you

  • @jameslabs1
    @jameslabs13 жыл бұрын

    good info that was clear and quick. Very fixable, very unprofessional audio in between each edit. Please fix the high-hum it runes all your effort. We're past 2015 half-assed quality. Thanks otherwise