You have a table stuck in a PDF and the program you are feeding next wants a CSV: an accounting import, a database load, a script, a bank-feed upload. The question that keeps coming up is whether Excel can do this on its own, without a separate converter. It can, on the right setup, and this is the exact path. It also has two real limits worth knowing before you start, because hitting them blind is where most of the wasted time goes. Not sure CSV is even the right target? Our look at PDF to Excel or CSV helps you decide before you convert.
The short version: bring the PDF table into a worksheet with Excel's Get Data From PDF feature, check the columns, then use Save As to write a .csv file. Below is each step, the Windows-versus-Mac catch, what to do with scanned PDFs, and the fix for the classic problem where the CSV opens with everything jammed into column A.
How do I convert a PDF to CSV in Excel?
Open a blank workbook, go to the Data tab, click Get Data, then From File, then From PDF, and pick your PDF. Excel scans the file and lists every table it found. Select the one you want in the Navigator, click Load, check the columns landed right, then choose File, Save As, and pick CSV (Comma delimited) as the type. That writes a clean comma-separated file.
The Get Data From PDF connector reads the PDF's text layer and rebuilds it as a real table, which is why it keeps columns intact far better than a copy and paste. Once the data is sitting in proper rows and columns in the worksheet, the Save As step is just changing the file type. The work is getting a clean table on the sheet first.
Which versions of Excel have Get Data From PDF?
Get Data From PDF is in Excel for Windows on Microsoft 365 and Office 2021 and later. It is not in Excel for Mac, and it is not in the free Excel for the web, even on a 365 subscription. If you do not see Data, Get Data, From File, From PDF, you are on a version that does not have it, and you need a different route to your CSV.
If you are on a Mac or an older Windows build, the cleanest option is to run the PDF through an online PDF to CSV converter, which produces the CSV directly and works the same in any browser. You then skip Excel entirely for the conversion and only open the finished CSV if you want to look it over.
How do I save the file as CSV in Excel?
With the data on the sheet, click File, then Save As, choose a folder, and in the file-type dropdown select CSV (Comma delimited) (*.csv). Name the file and click Save. Excel warns that CSV keeps only the active sheet and drops formatting; that is expected, since a CSV is plain text with no fonts, colors, or formulas, only values separated by commas.
If your data has accented characters, currency symbols, or non-English text, choose CSV UTF-8 (Comma delimited) instead. Plain CSV can garble those characters when another program reads the file; UTF-8 preserves them. For most US financial tables of dates, descriptions, and dollar amounts, either works, but UTF-8 is the safer default.
Why does my CSV open with everything in one column?
That happens when the separator Excel wrote does not match the separator your computer expects when reopening the file. Excel picks the CSV separator from your Windows regional settings: US settings use a comma, but some regions use a semicolon because they reserve the comma for decimals. Open the CSV in a plain text editor to see which character actually separates the fields.
If the raw file uses commas but Excel still dumps it into column A on reopen, your system list separator is set to something else. The reliable fix is to not reopen the CSV by double-clicking. Instead, in a new workbook, use Data, From Text/CSV, and tell the import wizard the delimiter is a comma. That parses the columns correctly regardless of your regional setting and is the same habit that keeps a downstream import clean.
Can Excel convert a scanned PDF to CSV?
No. Get Data From PDF reads a text layer, so it works on digital PDFs exported from software but returns nothing usable from a scanned page or a photographed document, because those are images with no selectable text. Excel has no built-in OCR, so a scan needs a tool that reads the pixels first.
For scanned statements, receipts, or any PDF where you cannot select the text with your cursor, use a converter with OCR, which recognizes the characters in the image and then builds the table. Our converter runs OCR automatically when it detects a scan, so the same upload handles both digital and scanned files. See how to convert a scanned PDF to Excel for the full walkthrough, then save the result as CSV.
Why are my numbers stored as text after converting?
Numbers come in as text when they carry a character Excel will not read as part of a number: a leading currency symbol baked into the value, a thousands comma, parentheses around a negative, or a stray space. The values look right but sit left-aligned in the cell, and SUM quietly ignores them, so totals come out wrong or zero.
The quick test is to select a column of amounts and look at the status bar at the bottom of Excel: if Sum shows a figure, they are real numbers; if only Count appears, they are text. To fix a whole column at once, select it, go to Data, Text to Columns, and click Finish, which forces Excel to re-read each cell as a number. For the parentheses and symbol cases specifically, see fixing numbers that import as text. Clean the numbers before you save the CSV, so the next program gets real values.
What is the fastest way to get a clean CSV from a PDF?
The fastest route depends on your file. For a digital PDF on Excel for Windows 365, Get Data From PDF then Save As CSV is quick and stays inside Excel. For a scanned PDF, a Mac, the web version, or a batch of files, a dedicated converter that outputs CSV directly is faster because it skips the worksheet step and handles OCR.
Whichever route you take, run one check before the import: compare the row count in the CSV against the PDF, and add up a numeric column to confirm it ties to the printed total on the document. A silent dropped row or a column read as text is the failure that surfaces later as a reconciliation that will not balance. Catch it here, in seconds, rather than after the data is loaded.
A quick checklist before you import the CSV
- Confirm the columns split correctly: open the CSV with Data, From Text/CSV and a comma delimiter, not a double-click.
- Use CSV UTF-8 if the data has symbols or accents; plain CSV otherwise.
- Check amounts are real numbers (status bar Sum), and fix any text numbers with Text to Columns before saving.
- Reconcile the CSV row count and a column total against the PDF.
- Match the column order and date format to whatever the receiving program expects.
Once you have a clean CSV of transactions, the next step is usually loading it somewhere. If your accounting lives in Xero rather than QuickBooks, see how to convert a PDF to CSV for Xero for the exact column layout it expects. If your books are in QuickBooks and you need a bank-feed file rather than a plain table, you can take a CSV straight into a CSV to QBO converter. If the source is a bank statement and you want the Excel version alongside the CSV, convert the bank statement PDF to Excel from the same file, then export whichever format each step needs.