XML to PDF

BijanBorazjani

New Member
Joined
Oct 22, 2021
Messages
25
Office Version
  1. 365
Platform
  1. Windows
I am using JotForms for data collection of names addresses and a short response. I am able to export those responses to a CSV or XLSX. I need to be able to take the responses exported and import it to a Fillable PDF form that was created. I was thinking the only way to do this easily is using an XML import/Export. The main issue i am having is that the number of responses will vary depending on each event. I need a way to be able to populate the PDF continuously and create a new sheet until all entries are in the PDF. I have attached the PDF Form, the XML, and the XLSX Export from Jot Forms. Any help would be greatly appreciated.

General_Inquiry_Contact_Form2024-01-08_10_36_38.xlsx
ABCDEFGH
1First NameLast NameStreet AddressCityState / ProvincePostal / Zip CodeEmailCondolence Message
2TimSmith123 Sesame StreetNew York CityNY12345Tim.Smith@Gmail.comIm Sorry
3DougManning234 Ask BlvdBeverly HillsCA90210Amy@gmail.comHkajehjr
4Crisp EBacon456 Pickup LnLafayetteLA70518Amy@gmail.comWe're so sorry to hear about Crisp
5SeymourButts
6PhilMcCrevasphilcrev@gmail.comSo sorry from the McCrevas family
7BijanBorazjanibijan@gmail.comtest
8JohnSmithJames.Gunn@gmail.comTESTING !@#
9AmyBorazjaniAmy@gmail.comThis is so sad
10BijanBorazjanibijan@gmail.comTest 2
11textbox_sample0textbox_sample1john@example.comLorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean mollis ultricies interdum. Nullam pharetra vitae lectus eget volutpat. Integer in sodales ligula. Vestibulum pellentesque arcu in est aliquam rhoncus. Curabitur et dui quis arcu scelerisque congue. Pellentesque libero ligula, sagittis a tempus quis, finibus eget erat. Nunc sed tempor nunc. Mauris tempor odio id lorem commodo dapibus. Nulla viverra mi in magna imperdiet volutpat.
12BijanBorazjanibijan@gmail.comtest
13BijanBorazjanibijan@gmail.comSorry for your loss
Sheet1
 

Attachments

  • Screenshot 2024-01-08 124639.png
    Screenshot 2024-01-08 124639.png
    80.4 KB · Views: 10
  • Screenshot 2024-01-08 124736.png
    Screenshot 2024-01-08 124736.png
    87.7 KB · Views: 10
  • Screenshot 2024-01-08 124602.png
    Screenshot 2024-01-08 124602.png
    155.4 KB · Views: 10

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,223,883
Messages
6,175,167
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top