Struggling with importing fillable .pdf data into Excel

[NeilTee44]

Hi everyone, not sure if this thread belongs here but couldn't find anywhere else.

Okay so I've been tasked with creating a .pdf file (a questionnaire) that people can fill out, and then this information will get collated together using Excel. The tools at my disposal are the newest versions of Adobe Acrobat Pro DC, Indesign DC and obviously Excel (365).

So far I can create the pdf okay, however when I import the data it only shows column 1 with the headings. Nothing ever shows up from the answers side. Things will show up in the second column if I use a table, however I'm not going to be using a table as nearly everything is radio buttons.

Does anyone have any idea why this is happening? Is there a setting I'm missing when creating the interactive objects in the pdf? I've tried naming them carefully and everything, putting them closer to eachother etc. None of the tutorials I've watched go into much detail on actually linking the interactive object (ie. grouping them or whatever), and apparently this is meant to happen automatically.

thanks to anyone who can provide any help on this at all
Neil

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Struggling with importing fillable .pdf data into Excel
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.