How to Fix Acrobat Splitting PDF Values into Multiple Excel Cells
Question details
Users need to resolve an issue where exporting a PDF to an Excel format causes a single value or text field to be incorrectly separated into multiple cells.
- Product
- Adobe Acrobat Standard DC 2018
- Device & OS
- not provided
- Scenario
- Exporting automatically generated PDF documents to Microsoft Excel spreadsheets.
- Observed behavior
- A continuous data field in the original PDF gets fragmented and split across several distinct Excel cells during the export process, instead of remaining unified in a single cell.
Verify that your PDF document is not restricted from copying or editing, and save a backup copy of the original file before attempting to adjust its structure.
Recreate or Optimize the PDF Source Structure
Adjusting the way text fields are generated in the source document can prevent the PDF export engine from misinterpreting text boundaries.
The problem is often caused by the PDF's internal text structure or absolute field positioning. When a PDF is automatically generated, minor gaps in text spacing can cause modern conversion engines to interpret the spaces as column or row breaks.
Open the document in the original software (such as Microsoft Word or your custom reporting system) used to generate the PDF.
Ensure that the text or data values are placed inside unified table cells rather than floating text boxes or loosely spaced paragraphs.
Save or export the file to PDF again. If using a standard word processor, ensure the option 'Enable Accessibility and Reflow with tagged Adobe PDF' is checked.
Open the newly structured PDF in Acrobat and go to 'File' > 'Export To' > 'Spreadsheet' > 'Microsoft Excel Workbook' to verify the cells no longer split.
Test Conversion in an Older Acrobat Version
If the issue only started after upgrading to a newer version like Acrobat Standard DC 2018, reverting to a previous engine may provide a temporary workaround.
Use WPS Office to Prevent Split Excel Cells
If Acrobat continues to fragment your data into multiple cells, WPS Office provides an advanced, highly accurate PDF to Excel converter that preserves your tables, layouts, and cell integrity seamlessly.
- 1. Download and open WPS Office: Install WPS Office for free and launch the application, then navigate to the 'PDF' section.
- 2. Open your PDF file: Click 'Open' and select the PDF document that is causing the conversion issues.
- 3. Select PDF to Excel: Navigate to the 'Tools' or 'Convert' tab on the top ribbon and select 'PDF to Excel'.
- 4. Convert and save: Choose your desired export settings and click 'Convert'. Your data will be accurately extracted into a unified Excel spreadsheet.
Frequently Asked Questions
Why does a PDF to Excel conversion sometimes split text into multiple cells?
This happens when the PDF's internal structure uses disjointed text boxes, invisible boundaries, or absolute positioning instead of semantic tables. The conversion engine interprets minor spatial gaps as intentional column or row breaks.
Can I easily merge the split cells in Excel after the conversion?
Yes, although it can be manual work. You can use Excel's CONCATENATE function, the '&' operator, or tools like Power Query to merge the fragmented data back into single cells.
Does OCR scanning affect how cells are split during PDF conversion?
Yes. If a PDF is a scanned image, the software applies OCR (Optical Character Recognition) to guess the layout. Poor text recognition or skewed pages can misalign the layout grid, causing the export engine to generate multiple cells.
