How To: Export data from dropdown list into Excel

Question

For some of my data, I was able to edit it in Excel by doing: Prepare a Form > ... > All javascripts and I got exactly what I wanted, put it in an .xml format, and opened it in excel. However, I have multiple dropdown fields that weren't brought over. Is there a way to get this data in the same .xml format? This is a very large file, in case that matters!

try67 · Answer

Be careful of using this function. If you corrupt the XML structure the form fields in the file can become unusable, and there's no easy way to fix it.

The direct answer is no, but there are ways around it. You can use a script to set the values of a drop-down field, and then edit that code in Excel (or some other editor).

Another option is to use a script to import/export the values directly from the drop-down to a text file, which you could then edit in Excel. The latter can be achieved using this (paid-for) tool I've developed:

https://www.try67.com/tool/acrobat-import-items-from-a-text-file-to-a-combo-box-or-list-field

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