Adobe 22002484 User Guide - Page 206

Manage form data files, Import form data, Merge exported data files to a spreadsheet

Page 206 highlights

USING ACROBAT 9 STANDARD 201 Forms Manage form data files You can move the answers on a PDF form to and from other file formats that preserve all the data in much less space than a full PDF. Import form data In some workflow scenarios, individuals submit filled-in forms as data-only files rather than as complete PDF files. These files are not PDFs, but use another file format, such as FDF or XML. You can view the data submitted by an individual recipient in the context of the PDF by opening the original file and importing the information in the data file. 1 In Acrobat, open the PDF form into which you want to import data. 2 Choose Forms > Clear Form. Note: When you import data from another file into a PDF form, the imported data replaces any information that appeared previously in the individual form fields. However, if the imported data file contains one or more blank form fields, importing will not clear the original data. 3 Choose Forms > Manage Form Data > Import Data. 4 In the Select File Containing Form Data dialog box, select a format in File Of Type corresponding to the data file you want to import. Then locate and select that file, and click Select. Note: Some formats are available only for specific types of PDF forms, depending on the application used to create the form, such as Acrobat or Designer ES. Data you import from a text file (.txt) must be formatted in tab-delimited rows that form columns. Export form data You can save the information in a completed PDF form as a data file in another file format. Later, you can reuse the data to fill in the form again or another form with the same fields and field names. 1 In Acrobat, open the completed form file. 2 Choose Forms > Manage Form Data > Export Data. 3 In the Export Form Data As dialog box, select the format in which you want to save the form data (FDF, XFDF, XML, or TXT). Then select a location and filename, and click Save. Note: Some file formats are available only for specific types of PDF forms, depending on how the form was created. Merge exported data files to a spreadsheet If you want to compile data from forms that are not already in a data set, use the following process. 1 Choose Forms > Manage Form Data > Merge Data Files Into Spreadsheet. 2 In the Export Data From Multiple Forms dialog box, click Add Files. 3 In the Select file Containing Form Data dialog box, select a file format option in File Of Type option (Acrobat Form Data Files or All Files). Then locate the form files that you want to merge into the spreadsheet, select them, and click Select. 4 Repeat the previous step to add form data files that are in other locations, as needed. 5 Click Export. Then select a folder and filename for the spreadsheet, and click Save. 6 In the Export Progress dialog box, click either View File Now to open the spreadsheet file or Close Dialog to return to Acrobat. Last updated 9/30/2011

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280
  • 281
  • 282
  • 283
  • 284
  • 285
  • 286
  • 287
  • 288
  • 289
  • 290
  • 291
  • 292
  • 293
  • 294
  • 295
  • 296
  • 297
  • 298
  • 299
  • 300
  • 301
  • 302
  • 303
  • 304
  • 305
  • 306
  • 307
  • 308
  • 309
  • 310
  • 311
  • 312
  • 313
  • 314
  • 315
  • 316
  • 317
  • 318
  • 319
  • 320
  • 321
  • 322
  • 323
  • 324
  • 325
  • 326
  • 327
  • 328
  • 329
  • 330
  • 331
  • 332
  • 333
  • 334
  • 335
  • 336
  • 337
  • 338
  • 339
  • 340
  • 341
  • 342
  • 343
  • 344
  • 345
  • 346
  • 347
  • 348
  • 349
  • 350
  • 351
  • 352
  • 353
  • 354
  • 355
  • 356
  • 357
  • 358
  • 359
  • 360
  • 361
  • 362
  • 363
  • 364
  • 365
  • 366
  • 367
  • 368
  • 369
  • 370
  • 371
  • 372
  • 373
  • 374
  • 375
  • 376
  • 377
  • 378
  • 379
  • 380

201
USING ACROBAT 9 STANDARD
Forms
Last updated
9
/30/2011
Manage form data files
You can move the answers on a PDF form to and from other file formats that preserve all the data in much less space
than a full PDF.
Import form data
In some workflow scenarios, individuals submit filled-in forms as data-only files rather than as complete PDF files.
These files are not PDFs, but use another file format, such as FDF or XML. You can view the data submitted by an
individual recipient in the context of the PDF by opening the original file and importing the information in the data
file.
1
In Acrobat, open the PDF form into which you want to import data.
2
Choose Forms > Clear Form.
Note:
When you import data from another file into a PDF form, the imported data replaces any information that
appeared previously in the individual form fields. However, if the imported data file contains one or more blank form
fields, importing will not clear the original data.
3
Choose Forms > Manage Form Data > Import Data.
4
In the Select File Containing Form Data dialog box, select a format in File Of Type corresponding to the data file
you want to import. Then locate and select that file, and click Select.
Note:
Some formats are available only for specific types of PDF forms, depending on the application used to create the
form, such as Acrobat or Designer ES. Data you import from a text file (.txt) must be formatted in tab-delimited rows
that form columns.
Export form data
You can save the information in a completed PDF form as a data file in another file format. Later, you can reuse the
data to fill in the form again or another form with the same fields and field names.
1
In Acrobat, open the completed form file.
2
Choose Forms > Manage Form Data > Export Data.
3
In the Export Form Data As dialog box, select the format in which you want to save the form data (FDF, XFDF,
XML, or TXT). Then select a location and filename, and click Save.
Note:
Some file formats are available only for specific types of PDF forms, depending on how the form was created.
Merge exported data files to a spreadsheet
If you want to compile data from forms that are not already in a data set, use the following process.
1
Choose Forms > Manage Form Data > Merge Data Files Into Spreadsheet.
2
In the Export Data From Multiple Forms dialog box, click Add Files.
3
In the Select file Containing Form Data dialog box, select a file format option in File Of Type option (Acrobat Form
Data Files or All Files). Then locate the form files that you want to merge into the spreadsheet, select them, and click
Select.
4
Repeat the previous step to add form data files that are in other locations, as needed.
5
Click Export. Then select a folder and filename for the spreadsheet, and click Save.
6
In the Export Progress dialog box, click either View File Now to open the spreadsheet file or Close Dialog to return
to Acrobat.