Convert PDF to XLSX Free: XLSX or XLS, and Why It Matters

To convert a PDF to XLSX free, upload the file to a free converter and choose XLSX, the current Excel format, over the older XLS. Then check one thing before you trust the sheet: whether the amounts are numbers or text. Text amounts make a SUM return zero, and they are easy to fix.

XLSX vs XLS from free PDF converters: what's different?

XLSX is the current Excel file format, used since Excel 2007. XLS is the older format that Excel used before that. A free converter that offers both is giving you a choice between a modern file and a legacy one, and for a bank statement the modern one is almost always the better pick.

The differences that matter for a statement are practical:

• Row limit. An XLS sheet holds 65,536 rows. An XLSX sheet holds over a million. A single statement rarely reaches the old limit, but a year of statements merged into one sheet can.
• Compatibility. Current Excel opens both, but it opens an XLS in a compatibility mode and may warn you when you save. Google Sheets, Numbers and LibreOffice read both.
• File size. XLSX files are compressed, so they are usually smaller than the same data in XLS.
• Support. XLSX is the format that current software expects, including accounting imports and budgeting apps. Some of them refuse an XLS.

If you search for "pdf to xls free" because an old program asks for it, check first whether that program really needs XLS. Many tools that ask for "Excel" accept XLSX today, and a few accept CSV, a plain text format that any spreadsheet opens. When a free tool offers only XLS, it is telling you something about how it was built, not about your statement.

The format does not decide the quality

A common mistake is to assume the format fixes problems. It does not. A converter can write correct numbers into an XLS file and wrong text into an XLSX file. The format is the container; the quality of the rows inside depends on how well the tool read the PDF. That is why the next section matters more than the format choice.

For judging tools against each other on every criterion, not just format, use the five-minute test and scoring rubric for free PDF to Excel converters.

Why free XLSX files store amounts as text

Free XLSX files store amounts as text because many free tools copy what they see on the page character by character. A PDF has no cells or numbers, only drawn characters. A tool that writes "1,204.50" into a cell as a string produces text that looks like a number but is not one.

Excel tells you which is which, if you know where to look. A number aligns to the right of its cell by default. Text aligns to the left. A small green triangle in the corner of a cell often means "number stored as text". And the status bar shows a Sum for selected numbers but only a Count for text.

Statements add their own traps that push tools toward text:

• Thousands separators and currency signs. "$1,204.50" has a dollar sign and a comma, which a careless tool leaves in the string.
• Trailing minus signs. Some statements print "45.00-" for a withdrawal. Excel does not read that as a negative number in every case.
• Parentheses for negatives. "(45.00)" is a common accounting style. A tool may keep the brackets as text.
• CR and DR suffixes. Some statements print "45.00 DR". The letters turn the cell into text.
• Hidden spaces. A non-breaking space at the end of a value is invisible and still makes the cell text.

The symptom: a total of zero

The visible sign is a SUM that returns 0, or a total that ignores most of your rows. Excel skips text when it adds. If half your amounts are text and half are numbers, the total is not zero but wrong, which is worse because it looks plausible. Always compare a SUM against the statement's own totals before you rely on it.

Fixing text numbers in a free XLSX export

You fix text numbers by converting each text cell to a real number. Two methods cover most cases: Text to Columns for a whole column in one move, and the VALUE function when the text has extra characters. Try the first, and use the second if the first leaves cells unchanged.

Step list: Text to Columns

1. Click the header letter of the amount column to select the whole column.
2. Open the Data tab and choose Text to Columns.
3. In step 1 of the wizard, choose Delimited and select Next.
4. In step 2, clear every delimiter box and select Next.
5. In step 3, set the column data format to General and select Finish.
6. Check the column. The values should now align right, and the status bar should show a Sum.

Text to Columns makes Excel re-read each cell as if you had typed it, which turns clean text numbers into real ones. It does not clean stray symbols such as a trailing "DR".

Step list: the VALUE function

1. In an empty column beside the amounts, enter =VALUE(C2) where C2 is the first text amount.
2. If the cell shows an error, the text has a symbol Excel cannot read. Use =VALUE(SUBSTITUTE(SUBSTITUTE(C2,"$",""),",","")) to strip a dollar sign and a comma.
3. For a trailing minus such as "45.00-", use =IF(RIGHT(C2,1)="-",-VALUE(LEFT(C2,LEN(C2)-1)),VALUE(C2)).
4. For a non-breaking space, add SUBSTITUTE(C2,CHAR(160),"") inside the formula.
5. Fill the formula down the column, copy the results, and use Paste Special, Values, to replace the originals.
6. Delete the helper column once the values sit in place.

Before and after: three statement rows

These example rows are made up. They show what a free export might return and what the same rows look like after the fix.

The three rows hit three different problems: a currency sign with a comma, a trailing minus, and brackets. After the fix, the SUM of the amount column for these three rows is 847.32, which you can check by hand: 1,204.50 minus 45.00 minus 312.18.

Check the result against the statement

A fix is only done when the total ties out. Add the signed amounts, add the opening balance, and compare with the closing balance on the statement. If the two differ, a row was lost or a sign was lost, and no formatting step will bring it back. In that case convert again with a different tool instead of repairing the sheet.

The date column often has the same problem as the amount column, and dates that stay as text will not sort. The same Text to Columns step with a Date format in step 3 handles most of them.

Is a free XLS file still usable today?

A free XLS file is still usable. Current Excel opens it, Google Sheets and Numbers read it, and the data inside is the same as it would be in XLSX. The cost is friction: a compatibility banner, a smaller row limit and occasional refusals from software that expects the newer format.

You can keep working in the XLS and save as XLSX when you are done. Open the file, choose Save As, and select the Excel Workbook type. That upgrade takes a few seconds and removes the compatibility mode. Check the sheet once afterward, since the conversion occasionally changes how dates or number formats appear.

The XLS file is fine in these cases:

• You need one statement for a one-time check, and nothing will import it.
• The sheet is small, with well under 65,536 rows.
• The free tool gives you the XLS and the correct numbers, and the XLSX option is locked behind a signup.

It is a poor choice when you plan to merge many statements, when a program must import the file, or when you want to keep the sheet for years. An old format also has an uncertain future: software gradually drops support for formats it no longer needs.

When not to accept an XLS export from a free tool

Do not accept an XLS export when the file will go into another program, when it will grow past the row limit, or when it is the sign of a bigger problem. A tool that still writes XLS by default may also be using older reading methods that mishandle dates and amounts.

Convert again instead of repairing in these cases:

1. The import fails. If an accounting or budgeting program rejects the file, converting to XLSX or CSV is faster than hunting for the cause.
2. The balance does not tie out. A format change will not restore a missing row.
3. Every amount is text and the signs are gone. Fixing text is easy, but guessing which amounts were withdrawals is not.
4. The file carries a watermark or a header row of advertising. Those rows break sorting and sums, and removing them by hand on every statement wastes time.
5. You are merging a year of statements. Start with the newer format so you never hit the row limit.

When a second free tool also fails, the question changes from "which free tool" to "is the cleanup worth my time". Two routes help here. If your file is a scan, the problem may be the image, not the format, so read about free OCR limits for scanned PDFs. If you worry that a "free" tool will turn into a charge, read how to convert PDF to Excel free without a trial that bills you later.

Other ways to get XLSX without an upload

Excel can read a PDF itself on some versions, which keeps the statement on your machine. The Get Data from PDF steps walk through it, and the guide to importing a PDF into Excel free says which statement layouts it handles. If the sheet has merged cells that break sorting, see the fix in the merged cells section of the Office 365 post.

If you would rather skip the cleanup, CheapBankConvert is built around the XLSX result: its homepage says the Excel file stores amounts as numbers, so sums and filters work on opening. It previews the first two pages free and charges once per statement, and it is getting ready to open, so check Get started for current availability.