Mass-Fill PDF Form Files Using Spreadsheets (Excel/Calc/GDocs) w/ Open Source Software (BulkPDF)
Vložit
- čas přidán 5. 08. 2024
- 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
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.
Excellent tutorial!!! This got me exactly what I needed, and will save me HOURS of work for YEARS to come - thank you so much!!!
Most helpful video ever. Thank you!!
You helped me solve a problem that I had for a long time about how to fill PDF forms in bulk, THANKS!!
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.
czcams.com/video/OUKQOAK0BK0/video.html
Awesome tutorial!
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?
Awesome stuff
excellent tutorial. my work has become very fast now.
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!
THANK YOU SO MUCH!!!!
What about for uploaded images? Like file attachements like Id cards?
Holy moly you are a beast
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?
You are reallllllllllllllly Greatttttttttttt
Thanks
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...
Check box won't work for me, i tried yes/no numbers letters. Nothing
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!
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!
Can i use these same with Google excel online
I need an assistance. Could you give me advice how to solve a problem with printing from access query on such custom made form?
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
Thanks
How we can remove the water mark ""BulkPDF BUSINSS DEMO"FROM THE GENERATED PDF
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)
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)
The apostrophe in the file path could be the problem 🤷♀️
Is there a web based version ?
error during the opening of spreadsheet in BulkPDF application
Any simlar software for MacOS?
You could use BulkPDF in Parallel Desktop or VirtualBox.
Radio buttons are driving me crazy. Can anyone help please.
I love you
some text fields in the pdf file dont get recognized by the pdf bulk app. someone know why?
could be that the fields are labeled correctly. Go to field options.
This is fantastic software and a wonderful tutorial.
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
Bulkpdf won't autofill check boxes. I tried numbers letters 1/2. Ot won't autofill them. Any suggestions?
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.
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)
On/Off worked to put x's in my pdf boxes
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