Fix PDF to Excel Export Converting Numbers to Text
Question details
Users experience an issue where numeric data exported from a PDF file formats as text strings in Excel, breaking formulas and preventing calculations.

- Product
- PDF to Excel Converters
- Device & OS
- not provided
- Scenario
- Converting a PDF document containing tabular data or numbers into an editable Excel spreadsheet for data analysis.
- Observed behavior
- Numeric values in the resulting Excel file are recognized as text rather than numbers, often indicated by an apostrophe before the value or a green triangle error indicator.
Check your original PDF document to determine if the text is selectable or if it is a scanned image, as scanned documents require OCR (Optical Character Recognition) prior to conversion.
Convert Text to Numbers Using Excel's Built-in Features
The quickest way to resolve the issue if the export is already complete is to force Excel to re-evaluate the text cells as numeric values.
When a basic PDF converter fails to identify data types correctly, it defaults to exporting numeric characters as text. You do not always need to re-convert the file; Excel provides several quick ways to convert these strings back into usable numbers.
Select the cells containing the text-formatted numbers (these often have a small green triangle in the upper-left corner). Click the yellow warning icon that appears next to the selection and choose 'Convert to Number'.
Type the number '1' into any empty cell and copy it (Ctrl+C). Highlight all the text-formatted numbers, right-click the selection, choose 'Paste Special', check the 'Multiply' operation under the Paste Special menu, and click OK.
Select the entire column of text numbers. Navigate to the 'Data' tab on the ribbon, click 'Text to Columns', and simply click 'Finish' without changing any settings. This forces Excel to process the column as standard numbers.

Run Optical Character Recognition (OCR) Before Exporting
If your source PDF is a scanned document, standard converters cannot recognize the text properly and will output formatting errors.
Convert PDF to Excel Accurately with WPS Office
Avoid formatting errors and broken formulas by using WPS Office. Its intelligent PDF to Excel converter accurately parses table structures and recognizes numeric data natively, ensuring your spreadsheets are immediately ready for calculations without requiring manual fixes.
- 1. Open your document in WPS PDF: Launch WPS Office and open your target PDF file using the built-in PDF viewer.
- 2. Select the PDF to Excel tool: Navigate to the 'Tools' tab on the top ribbon and click the 'PDF to Excel' conversion button.
- 3. Configure conversion settings: In the dialog box, select your desired language for OCR (if prompted) and choose the pages you want to convert, then click 'Convert'.
- 4. Work seamlessly in WPS Spreadsheet: The converted file will automatically open in WPS Spreadsheet, with your numeric data perfectly formatted and ready for complex formulas.

Frequently Asked Questions
Why do numbers from PDFs convert as text in the first place?
PDF files are designed to prioritize visual layout over underlying data structure. When converting, basic software may interpret the visual representation of a number as a standard text string rather than a calculable numeric value, especially if the original file lacks structural tags.
Does the formatting of the original PDF affect the Excel export quality?
Yes. If the original PDF was created from an image, a scanned physical document, or uses complex overlapping text boxes, the converter struggles to parse the tabular data properly. This frequently leads to text-formatted numbers, merged cells, or misaligned columns.
How do I remove the green triangles on my Excel cells after exporting?
The green triangles are Excel's error indicators alerting you that a number is stored as text. You can resolve this by selecting the affected cells, clicking the yellow warning icon that appears next to them, and choosing the 'Convert to Number' option from the dropdown menu.




