Combine responses only after field names, export values, missing answers and file formats preserve the same meaning across every returned form
Use a collection-purpose–consent–source-form-version–response-file–field-name–visible-label–field-type–export-value–format–encoding–missing-value–duplicate–sample-check–merge–access-control–release chain. Treat every column header as a claim about what the original respondent was asked and what their stored answer means.
Why this English matters now
Reading Acrobat’s exported form data and field names before combining responses is practical English for students, schools and document teams searching how to export PDF form data, merge Acrobat forms into a spreadsheet or understand FDF, XFDF, XML, TXT and CSV files.
Adobe’s current guidance says a completed form can export data as FDF, XFDF, XML or TXT, while a response-file workflow can export selected entries to CSV or XML. Adobe also documents merging exported form data files into a spreadsheet and warns that importing data can replace existing information in individual fields, although blank imported fields do not clear existing information.
A successful export is not automatically a trustworthy dataset. Strong reviewers preserve original returns, map internal field names to visible questions and export values, define missing-data rules, check versions and duplicates, minimise personal data, validate a small sample and combine only into an auditable copy whose row and column meanings are explicit.
Checked against the linked first-party sources on 30 October 2026. Interfaces, managed-device rules and school procedures can change, so reopen the current source before a live assessment, disclosure or account decision.
The practical reading method
Use a collection-purpose–consent–source-form-version–response-file–field-name–visible-label–field-type–export-value–format–encoding–missing-value–duplicate–sample-check–merge–access-control–release chain. Treat every column header as a claim about what the original respondent was asked and what their stored answer means.
- Adobe says completed PDF form data can be exported to FDF, XFDF, XML or TXT, depending on form type.
- Adobe says response-file data can be exported to spreadsheet or XML formats and documents CSV or XML choices.
- Adobe documents merging exported form data files into a spreadsheet.
- Adobe says importing form data replaces existing information in fields, while blank imported fields do not clear existing information.
Official factual floor
- Adobe Acrobat: Collect and manage PDF form data
- Adobe Acrobat: PDF form field properties
- MOE English Language Syllabus 2020
- IMDA Digital Skills for Life
- Adobe lists FDF, XFDF, XML and TXT for exporting data from a completed form, with availability depending on the form type.
- Adobe documents exporting response-file entries to CSV or XML and merging exported form data files into a spreadsheet.
- Adobe says imported data replaces existing information in fields, but blank fields in the imported data do not clear existing information.
Did You Know?
The question a person sees and the field name stored in exported data can be different. A clear label such as Preferred contact time may arrive under a legacy internal name, so combining files by headers alone can merge unlike questions.
Full chapter index
- 1. Define purpose, authority and minimum data
- 2. Preserve returned forms and response files
- 3. Record the source form version
- 4. Choose the export format deliberately
- 5. Map field names to visible labels
- 6. Read field types and option export values
- 7. Define blanks and missing answers
- 8. Protect dates, identifiers and leading zeros
- 9. Detect duplicates and repeated submissions
- 10. Compare a sample with original forms
- 11. Merge into an auditable spreadsheet
- 12. Secure the combined dataset
- 13. Verify the exact dataset and release
The mechanism
Originals provide the audit trail for later corrections.
Adobe says response-file data can be exported to spreadsheet or XML formats and documents CSV or XML choices. In this chapter, the decisive phrase is preserve returned forms and response files. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Only the merged spreadsheet is kept, so an ambiguous code cannot be checked.
An exported data file represents stored form-field values in a chosen format. It does not prove labels match field names, all returns use the same form version, blanks mean no response, export values are human-readable, dates and identifiers retained their types, respondents are unique or collection and reuse are authorised.
- 1. store originals securely
- 2. make a read-only inventory
- 3. record filenames and hashes where appropriate
- 4. work on a controlled copy
Preserve original returned forms and response files; confirm collection purpose, authority and retention; record source form versions; export a small sample; map each field name, visible label, type and export value; inspect encoding, dates, leading zeros, checkboxes, radio groups, blanks and duplicates; compare sample rows with original forms; merge into a controlled spreadsheet; calculate row counts and exceptions; restrict access; save, close, reopen and verify the exact dataset shared for review. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record collection owner, purpose, source form ID and version, response files, export date, format and encoding, field-name map, labels, field types, option export values, missing-data codes, duplicate rule, sample comparisons, row counts, exceptions, access controls, retention plan, reviewer and final dataset identity.
Transfer: Provenance language supports accountability. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Field names and meanings can change between revisions.
Adobe documents merging exported form data files into a spreadsheet. In this chapter, the decisive phrase is record the source form version. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Responses from old and new forms are merged because their column headers happen to match.
An exported data file represents stored form-field values in a chosen format. It does not prove labels match field names, all returns use the same form version, blanks mean no response, export values are human-readable, dates and identifiers retained their types, respondents are unique or collection and reuse are authorised.
- 1. record form version
- 2. compare visible questions
- 3. compare field names
- 4. separate incompatible returns
Preserve original returned forms and response files; confirm collection purpose, authority and retention; record source form versions; export a small sample; map each field name, visible label, type and export value; inspect encoding, dates, leading zeros, checkboxes, radio groups, blanks and duplicates; compare sample rows with original forms; merge into a controlled spreadsheet; calculate row counts and exceptions; restrict access; save, close, reopen and verify the exact dataset shared for review. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record collection owner, purpose, source form ID and version, response files, export date, format and encoding, field-name map, labels, field types, option export values, missing-data codes, duplicate rule, sample comparisons, row counts, exceptions, access controls, retention plan, reviewer and final dataset identity.
Transfer: Version language supports comparability. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
FDF, XFDF, XML, TXT, CSV and a spreadsheet serve different workflows.
Adobe says importing form data replaces existing information in fields, while blank imported fields do not clear existing information. In this chapter, the decisive phrase is choose the export format deliberately. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: CSV is chosen without checking commas, encoding, dates or leading zeros.
An exported data file represents stored form-field values in a chosen format. It does not prove labels match field names, all returns use the same form version, blanks mean no response, export values are human-readable, dates and identifiers retained their types, respondents are unique or collection and reuse are authorised.
- 1. name the receiving tool
- 2. choose a documented format
- 3. export a small sample
- 4. record delimiter and encoding
Preserve original returned forms and response files; confirm collection purpose, authority and retention; record source form versions; export a small sample; map each field name, visible label, type and export value; inspect encoding, dates, leading zeros, checkboxes, radio groups, blanks and duplicates; compare sample rows with original forms; merge into a controlled spreadsheet; calculate row counts and exceptions; restrict access; save, close, reopen and verify the exact dataset shared for review. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record collection owner, purpose, source form ID and version, response files, export date, format and encoding, field-name map, labels, field types, option export values, missing-data codes, duplicate rule, sample comparisons, row counts, exceptions, access controls, retention plan, reviewer and final dataset identity.
Transfer: Format language supports interoperability. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Internal names can outlive the wording shown to respondents.
Adobe says completed PDF form data can be exported to FDF, XFDF, XML or TXT, depending on form type. In this chapter, the decisive phrase is map field names to visible labels. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: email_2 is assumed to mean guardian email although the revised form uses it for student email.
An exported data file represents stored form-field values in a chosen format. It does not prove labels match field names, all returns use the same form version, blanks mean no response, export values are human-readable, dates and identifiers retained their types, respondents are unique or collection and reuse are authorised.
- 1. open the source form
- 2. list field names
- 3. copy visible labels
- 4. record question purpose
Preserve original returned forms and response files; confirm collection purpose, authority and retention; record source form versions; export a small sample; map each field name, visible label, type and export value; inspect encoding, dates, leading zeros, checkboxes, radio groups, blanks and duplicates; compare sample rows with original forms; merge into a controlled spreadsheet; calculate row counts and exceptions; restrict access; save, close, reopen and verify the exact dataset shared for review. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record collection owner, purpose, source form ID and version, response files, export date, format and encoding, field-name map, labels, field types, option export values, missing-data codes, duplicate rule, sample comparisons, row counts, exceptions, access controls, retention plan, reviewer and final dataset identity.
Transfer: Mapping language supports accurate columns. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Checkboxes, radio buttons, lists and text fields store different kinds of values.
Adobe says response-file data can be exported to spreadsheet or XML formats and documents CSV or XML choices. In this chapter, the decisive phrase is read field types and option export values. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: On is treated as a literal written answer rather than a checkbox export value.
An exported data file represents stored form-field values in a chosen format. It does not prove labels match field names, all returns use the same form version, blanks mean no response, export values are human-readable, dates and identifiers retained their types, respondents are unique or collection and reuse are authorised.
- 1. record field type
- 2. list option values
- 3. distinguish selected from unselected
- 4. translate codes only with a documented map
Preserve original returned forms and response files; confirm collection purpose, authority and retention; record source form versions; export a small sample; map each field name, visible label, type and export value; inspect encoding, dates, leading zeros, checkboxes, radio groups, blanks and duplicates; compare sample rows with original forms; merge into a controlled spreadsheet; calculate row counts and exceptions; restrict access; save, close, reopen and verify the exact dataset shared for review. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record collection owner, purpose, source form ID and version, response files, export date, format and encoding, field-name map, labels, field types, option export values, missing-data codes, duplicate rule, sample comparisons, row counts, exceptions, access controls, retention plan, reviewer and final dataset identity.
Transfer: Type language supports interpretation. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
An empty cell can mean unanswered, unavailable, not applicable or export failure.
Adobe documents merging exported form data files into a spreadsheet. In this chapter, the decisive phrase is define blanks and missing answers. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: All blanks are converted to No.
An exported data file represents stored form-field values in a chosen format. It does not prove labels match field names, all returns use the same form version, blanks mean no response, export values are human-readable, dates and identifiers retained their types, respondents are unique or collection and reuse are authorised.
- 1. define missing categories
- 2. preserve source emptiness
- 3. check conditional questions
- 4. document any recoding
Preserve original returned forms and response files; confirm collection purpose, authority and retention; record source form versions; export a small sample; map each field name, visible label, type and export value; inspect encoding, dates, leading zeros, checkboxes, radio groups, blanks and duplicates; compare sample rows with original forms; merge into a controlled spreadsheet; calculate row counts and exceptions; restrict access; save, close, reopen and verify the exact dataset shared for review. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record collection owner, purpose, source form ID and version, response files, export date, format and encoding, field-name map, labels, field types, option export values, missing-data codes, duplicate rule, sample comparisons, row counts, exceptions, access controls, retention plan, reviewer and final dataset identity.
Transfer: Missing-data language supports fair analysis. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Spreadsheet software may reinterpret text during import.
Adobe says importing form data replaces existing information in fields, while blank imported fields do not clear existing information. In this chapter, the decisive phrase is protect dates, identifiers and leading zeros. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A student code beginning with zero becomes a shorter number.
An exported data file represents stored form-field values in a chosen format. It does not prove labels match field names, all returns use the same form version, blanks mean no response, export values are human-readable, dates and identifiers retained their types, respondents are unique or collection and reuse are authorised.
- 1. declare column types
- 2. test representative values
- 3. compare raw export
- 4. avoid automatic date assumptions
Preserve original returned forms and response files; confirm collection purpose, authority and retention; record source form versions; export a small sample; map each field name, visible label, type and export value; inspect encoding, dates, leading zeros, checkboxes, radio groups, blanks and duplicates; compare sample rows with original forms; merge into a controlled spreadsheet; calculate row counts and exceptions; restrict access; save, close, reopen and verify the exact dataset shared for review. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record collection owner, purpose, source form ID and version, response files, export date, format and encoding, field-name map, labels, field types, option export values, missing-data codes, duplicate rule, sample comparisons, row counts, exceptions, access controls, retention plan, reviewer and final dataset identity.
Transfer: Data-type language supports accuracy. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Several files can represent the same person, a correction or a legitimate repeated event.
Adobe says completed PDF form data can be exported to FDF, XFDF, XML or TXT, depending on form type. In this chapter, the decisive phrase is detect duplicates and repeated submissions. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A second submission is deleted solely because the name matches.
An exported data file represents stored form-field values in a chosen format. It does not prove labels match field names, all returns use the same form version, blanks mean no response, export values are human-readable, dates and identifiers retained their types, respondents are unique or collection and reuse are authorised.
- 1. define a duplicate key
- 2. consider timestamps
- 3. preserve correction history
- 4. flag rather than guess
Preserve original returned forms and response files; confirm collection purpose, authority and retention; record source form versions; export a small sample; map each field name, visible label, type and export value; inspect encoding, dates, leading zeros, checkboxes, radio groups, blanks and duplicates; compare sample rows with original forms; merge into a controlled spreadsheet; calculate row counts and exceptions; restrict access; save, close, reopen and verify the exact dataset shared for review. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record collection owner, purpose, source form ID and version, response files, export date, format and encoding, field-name map, labels, field types, option export values, missing-data codes, duplicate rule, sample comparisons, row counts, exceptions, access controls, retention plan, reviewer and final dataset identity.
Transfer: Identity language supports careful review. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Row-level checking reveals mapping and import mistakes before full combination.
Adobe says response-file data can be exported to spreadsheet or XML formats and documents CSV or XML choices. In this chapter, the decisive phrase is compare a sample with original forms. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Thousands of responses are merged before one radio-button code is interpreted.
An exported data file represents stored form-field values in a chosen format. It does not prove labels match field names, all returns use the same form version, blanks mean no response, export values are human-readable, dates and identifiers retained their types, respondents are unique or collection and reuse are authorised.
- 1. sample simple and edge cases
- 2. compare every selected field
- 3. include blanks and non-ASCII text
- 4. record discrepancies
Preserve original returned forms and response files; confirm collection purpose, authority and retention; record source form versions; export a small sample; map each field name, visible label, type and export value; inspect encoding, dates, leading zeros, checkboxes, radio groups, blanks and duplicates; compare sample rows with original forms; merge into a controlled spreadsheet; calculate row counts and exceptions; restrict access; save, close, reopen and verify the exact dataset shared for review. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record collection owner, purpose, source form ID and version, response files, export date, format and encoding, field-name map, labels, field types, option export values, missing-data codes, duplicate rule, sample comparisons, row counts, exceptions, access controls, retention plan, reviewer and final dataset identity.
Transfer: Sampling language supports quality assurance. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Adobe provides a merge workflow, but the output still needs controlled structure.
Adobe documents merging exported form data files into a spreadsheet. In this chapter, the decisive phrase is merge into an auditable spreadsheet. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Files from different form versions are added without a source column.
An exported data file represents stored form-field values in a chosen format. It does not prove labels match field names, all returns use the same form version, blanks mean no response, export values are human-readable, dates and identifiers retained their types, respondents are unique or collection and reuse are authorised.
- 1. add source and version columns
- 2. preserve raw headers
- 3. record row counts
- 4. keep transformation steps
Preserve original returned forms and response files; confirm collection purpose, authority and retention; record source form versions; export a small sample; map each field name, visible label, type and export value; inspect encoding, dates, leading zeros, checkboxes, radio groups, blanks and duplicates; compare sample rows with original forms; merge into a controlled spreadsheet; calculate row counts and exceptions; restrict access; save, close, reopen and verify the exact dataset shared for review. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record collection owner, purpose, source form ID and version, response files, export date, format and encoding, field-name map, labels, field types, option export values, missing-data codes, duplicate rule, sample comparisons, row counts, exceptions, access controls, retention plan, reviewer and final dataset identity.
Transfer: Audit language supports reproducibility. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Combination increases the amount and sensitivity of information in one place.
Adobe says importing form data replaces existing information in fields, while blank imported fields do not clear existing information. In this chapter, the decisive phrase is secure the combined dataset. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A response spreadsheet is emailed widely because the individual PDFs were already shared.
An exported data file represents stored form-field values in a chosen format. It does not prove labels match field names, all returns use the same form version, blanks mean no response, export values are human-readable, dates and identifiers retained their types, respondents are unique or collection and reuse are authorised.
- 1. restrict access
- 2. encrypt or use approved storage
- 3. remove unnecessary fields
- 4. record sharing and deletion
Preserve original returned forms and response files; confirm collection purpose, authority and retention; record source form versions; export a small sample; map each field name, visible label, type and export value; inspect encoding, dates, leading zeros, checkboxes, radio groups, blanks and duplicates; compare sample rows with original forms; merge into a controlled spreadsheet; calculate row counts and exceptions; restrict access; save, close, reopen and verify the exact dataset shared for review. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record collection owner, purpose, source form ID and version, response files, export date, format and encoding, field-name map, labels, field types, option export values, missing-data codes, duplicate rule, sample comparisons, row counts, exceptions, access controls, retention plan, reviewer and final dataset identity.
Transfer: Privacy language supports trust. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Raw export, cleaned table, analysis copy and shared file are different artefacts.
Adobe says completed PDF form data can be exported to FDF, XFDF, XML or TXT, depending on form type. In this chapter, the decisive phrase is verify the exact dataset and release. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: The checked sample is correct but an earlier merge is sent to the team.
An exported data file represents stored form-field values in a chosen format. It does not prove labels match field names, all returns use the same form version, blanks mean no response, export values are human-readable, dates and identifiers retained their types, respondents are unique or collection and reuse are authorised.
- 1. save close and reopen
- 2. recheck headers and row counts
- 3. open the actual shared file
- 4. retain a versioned audit record
Preserve original returned forms and response files; confirm collection purpose, authority and retention; record source form versions; export a small sample; map each field name, visible label, type and export value; inspect encoding, dates, leading zeros, checkboxes, radio groups, blanks and duplicates; compare sample rows with original forms; merge into a controlled spreadsheet; calculate row counts and exceptions; restrict access; save, close, reopen and verify the exact dataset shared for review. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record collection owner, purpose, source form ID and version, response files, export date, format and encoding, field-name map, labels, field types, option export values, missing-data codes, duplicate rule, sample comparisons, row counts, exceptions, access controls, retention plan, reviewer and final dataset identity.
Transfer: Release verification supports education and careers. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
Four useful discoveries
Define purpose, authority and minimum data
Form export turns individual answers into a reusable dataset and increases responsibility.
Boundary: This guide does not determine legal authority or consent.
Preserve returned forms and response files
Originals provide the audit trail for later corrections.
Boundary: Preservation must follow retention and privacy rules.
Record the source form version
Field names and meanings can change between revisions.
Boundary: A version number helps only when revision history is reliable.
Choose the export format deliberately
FDF, XFDF, XML, TXT, CSV and a spreadsheet serve different workflows.
Boundary: Availability depends on the PDF form type and workflow.
Practice with realistic decisions
Map field names to visible labels
email_2 is assumed to mean guardian email although the revised form uses it for student email.
- open the source form
- list field names
- copy visible labels
- record question purpose
Read field types and option export values
On is treated as a literal written answer rather than a checkbox export value.
- record field type
- list option values
- distinguish selected from unselected
- translate codes only with a documented map
Define blanks and missing answers
All blanks are converted to No.
- define missing categories
- preserve source emptiness
- check conditional questions
- document any recoding
Advice for students, families and educators
For students
- Use fictional forms when learning export and merge workflows.
- Map field names and option values before calculating anything.
For families
- Ask why each personal field is needed and who can access the combined file.
- Do not send real identifiers through practice datasets.
For educators
- Provide a synthetic dataset with legacy field names, blanks and leading zeros.
- Assess provenance, mapping, privacy and sample verification alongside the final table.
Frequently asked questions
What formats can a completed form export?
Adobe lists FDF, XFDF, XML and TXT, with availability depending on form type.
What can a response file export?
Adobe documents spreadsheet or XML workflows, including CSV or XML choices.
Can Acrobat merge form data into a spreadsheet?
Adobe documents that workflow.
Are field names the same as visible labels?
Not necessarily.
What does a blank mean?
It must be defined from the form logic and source evidence.
Can importing data overwrite fields?
Adobe says it replaces existing field information, with a stated exception for blank imported fields.
Why preserve originals?
To verify ambiguous values and corrections.
Does a successful merge prove consent or quality?
No.
What should I verify?
Purpose, versions, fields, values, formats, missing data, duplicates, samples, access and exact file.
Why English?
Because label, field name, export value, blank, duplicate, import and merge describe different data meanings.
Useful next reading
- Acrobat form-field tooltips — align the accessible field description with the data map
- Acrobat Submit Form action — verify how completed forms travel before export
- Why English Matters in Singapore — connect precise data language to school and work
Closing thought
A reliable response table begins before the spreadsheet opens. Preserve the originals, map the fields to the questions people actually saw, test the difficult values and combine only when every column can be explained without guesswork.