Is it possible to export the data from fillable fields into indesign?

Question

Just the basics:I'm on a mac, running CCWe are circulating PDF forms where users have to input information. Instead of copying and pasting the data into indesign, we wanted to see if there was a way to export the inputted data directly into indesign? I've attempted to export the data into excel but we're running excel for mac 2011 and I'm wondering if there's a compatibility issue with the exports (constantly have to be repaired). I also find that when the files are repaired that the entire form is included. If I cannot do a direct export to indesign is there a way that I can export just the filled data to excel and create my own .csv to do a data merge in indesign?Thanks,Rich

Karl Heinz Kremer · Accepted Answer

It worked! Though one field didn't show up on my text document or import. I'm guessing that when I enter the fields in the quotes the upper/lower case text of the field names has to match? Otherwise Karl & Try67 you two are awesome! Thanks so much for the help!

Yes, JavaScript is case sensitive, so the name of a field needs to be used the same way it was defined in the form. If you have a field named "The field 1", you cannot access it via "The Field 1" - These two field names are different.

try67 · Answer

InDesign is not suited for data collection. It's a tool for doing layout and designing a file, not process data.

If you have the data in form fields in the PDF then you can export it to a plain-text file, which you can then open in Excel and process further.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded