Copy link to clipboard
Copied
Hi everyone
Would like to ask for some help
I have created a form in Adobe DC and wanted to export the form field data to a txt file.
I am able to export but once I open the txt file in notepad it is blank.
I have tried this a few times and continue to get blank txt files.
I was able to export to excel and in rtf format successfully but I do not need the form field titles I just need the data so I can do txt to columns.
Can anyone help and share some thoughts on resolving this
thank you in advance.
Martin
Copy link to clipboard
Copied
How did you export the data?
Copy link to clipboard
Copied
Hi
I used the export feature on DC
Screenshots below
the end result is a blank txt file picture below
I was hoping export to txt would work and I could then import to excel and do text to columns but not understanding why this is not working - any thoughts would be appreciated
Copy link to clipboard
Copied
This will export the PDF document, not the form data. Use the export under prepare form.
Copy link to clipboard
Copied
I know if you export as XML format but save it as a .XLS file; and it should import into Excel. I don't think there is a built-in easy way to export just the field values without the field names without using custom scripting, libraries or applications.
For a custom JavaScript solution; it's possible to loop thru each field, get the value and generate a string. But, i don't know if it's possible to save this text string to your desktop. A Visual Studio .net solution would be to use FDFToolkit.net, iTextSharp or other libraries retrieve the values. The .NET solution would allow you to fully control and customize the output.
Copy link to clipboard
Copied
thanks for the replies
so if I understand this correctly a user that does not have ADOBE DC will not be able to export the form data into excel?
Martin
Copy link to clipboard
Copied
Why do you assume this?
Copy link to clipboard
Copied
hi all was able to figure this out with some tinkering..it turns out there is an export as spreadsheet function but you have to search for it in the toolbar and it will give you the csv file
Find more inspiration, events, and resources on the new Adobe Community
Explore Now