How to Change the Export Value of an Unchecked PDF Checkbox
Question details
The user wants to change the default export value of an unchecked PDF form checkbox from "Off" to "No".

- Product
- PDF Forms
- Device & OS
- not provided
- Scenario
- Exporting fillable PDF form data to Excel where specific unchecked values (like "No") are required for accurate data mapping and analysis.
- Observed behavior
- When the PDF form is converted to Excel, the system automatically assigns the value "Off" when a checkbox is left unchecked, rather than the desired "No" value.
Ensure your PDF form is fully editable and that you have access to the form field properties or JavaScript editing tools in your PDF editor.
Add a Hidden Default Checkbox
Create an exclusionary group by adding a second checkbox with the export value "No" and setting it as the default selection.
By default, PDF specifications dictate that when no checkbox in a group is checked, the value defaults to "Off". To bypass this, you can trick the system by providing a secondary, pre-selected checkbox that carries the value "No".
Launch your PDF editor and enter the Form Editing or Prepare Form mode to view all existing fields.
Create a new checkbox on the document. Ensure it shares the exact same field name as your original checkbox so they function as an exclusionary group.
Right-click the new checkbox and select Properties. Navigate to the Options tab and set its 'Export Value' to "No".
Still in the Options tab, check the box that says 'Check box is checked by default'. You can then make this checkbox invisible or place it off-page so it does not confuse the user.

Use a Custom Validation Script
Write a custom JavaScript validation script to force the group's value to "No" when neither checkbox is selected.
Create and Modify PDF Forms with WPS Office
WPS Office provides comprehensive PDF editing tools, allowing you to create fillable forms, modify checkbox properties, and easily export form data to Excel spreadsheets.
- 1. Open your PDF: Launch WPS Office and open your PDF document using the WPS PDF tool.
- 2. Access form tools: Navigate to the 'Form' tab on the top toolbar to reveal the interactive form editing tools.
- 3. Edit checkbox properties: Double-click any checkbox to open its Properties dialog, where you can easily modify the Export Value and default states.
- 4. Export to Excel: Use the 'PDF to Excel' conversion tool under the Tools menu to accurately extract your completed form data.

Frequently Asked Questions
Why does my PDF checkbox always export as 'Off'?
By default, the PDF specification dictates that a checkbox or radio button group returns the hardcoded value 'Off' when no option is actively selected by the user.
Can I change the default 'Off' value without using scripts?
Yes. You cannot change the hardcoded 'Off' state directly, but you can bypass it by creating a secondary, hidden checkbox with the same group name, setting its export value to your desired text (like 'No'), and making it the default selection.
How do I ensure my PDF form data aligns perfectly in Excel?
When creating the PDF form, ensure every form field has a unique and clearly defined Field Name. Use consistent Export Values for checkboxes and radio buttons. When using conversion tools to export to Excel, these field names will act as your column headers.




