Adobe PDF to CSV: The Two-Step Route That Works

Quick Answer: Adobe Acrobat does not write CSV files directly. Export the PDF to an Excel workbook first (All tools > Export a PDF > Microsoft Excel), check the sheet, then in Excel choose File > Save As and pick CSV UTF-8 (Comma delimited). Before you rely on the CSV, open it in a text editor to confirm the separator, the date format and any accented characters survived.

Getting a CSV out of Adobe means two programs: Acrobat builds the spreadsheet and Excel (or Numbers, or Google Sheets) writes the comma-separated file. Adobe's own help recommends exactly this order, because a CSV keeps no formatting and any column mistake made during conversion is frozen into it. The extra minute in Excel is where you catch those mistakes.

Why is there no CSV option in Acrobat's export list?

Acrobat's export targets are document formats: Word, Excel, PowerPoint, images, HTML, rich text and plain text. CSV is a data format, a list of values with one record per line, and turning a page layout into clean records needs decisions that a page converter cannot make on its own: which text is a header, which line is a continuation, which number is the amount. Adobe's guide on converting PDF to CSV says as much, advising you to convert to an Excel spreadsheet first because "CSV formatting is rather sensitive."

You may see older tutorials that describe choosing Spreadsheet and then a CSV file type in the export menu. Current Acrobat releases list Excel Workbook and XML Spreadsheet 2003 under the spreadsheet choice; if your version offers something else, it will still pass through the same table reconstruction, so the checks later in this article apply either way.

Step 1: export the PDF to Excel

The full Acrobat walkthrough, including the worksheet and separator settings, lives in Adobe Acrobat PDF to Excel. The short version: open the file in Acrobat Pro, go to All tools > Export a PDF, choose Microsoft Excel, click Convert to XLSX and save.

One setting matters more for CSV than for anything else: choose a single worksheet for the entire document. Excel saves only the active sheet to a CSV, so a workbook with one tab per page would force you to save, and later stitch together, a separate file for every page.

No Acrobat Pro? Use the online converter

Adobe's free online PDF to Excel tool produces an .xlsx without the desktop app. You then open that workbook in Excel, Numbers or Google Sheets and save it as CSV there. The trade-off is that the online version has no settings for worksheets or separators, and the PDF goes to Adobe's servers for processing.

Step 2: save the workbook as CSV

Clean the sheet before you save, because the CSV will keep every stray row. Delete repeated page headings, unmerge any merged cells, and make sure the first row holds one clear column name per column. Then:

1. In Excel, click File > Save As (on a Mac, File > Save As and then the File Format menu).
2. Choose CSV UTF-8 (Comma delimited). Plain CSV (Comma delimited) also exists, but it uses the older system code page and can damage characters such as é, ñ, ü or the euro sign.
3. Click Save. Excel warns that only the current worksheet will be saved and that some features may be lost. Both are expected; click to keep the CSV format.

Microsoft documents these prompts on its import or export text and CSV files page. If you use Numbers on a Mac, the equivalent is File > Export To > CSV, where Advanced Options lets you pick the text encoding and whether each table becomes its own file.

What should you check in the CSV?

Open the saved file in a plain text editor (Notepad, TextEdit in plain text mode, VS Code) rather than double-clicking it, because Excel re-interprets the file on open and hides the very problems you are looking for.

The last check is the semantic one: confirm that each line is one record. If a description wrapped onto two lines in the PDF, Acrobat may have created two rows, and the CSV will carry a half-record with no date. Filter the date column for blanks in Excel and merge those lines into the row above before saving.

Does the destination care about the CSV layout?

Usually yes. A CSV is only useful if the program reading it can map the columns. Accounting software typically wants a date, a description and either one signed amount or separate debit and credit columns, with a header row and nothing above it. Budgeting apps often reject files with a title line or a totals row at the bottom. Before you import, compare your columns with the target's template and rename the headers to match.

If your PDF is a bank or credit card statement headed for an accounting tool, the CSV detour through Acrobat and Excel often costs more time than it saves, because statement layouts generate most of the split rows and debit/credit columns described above. In that case it can be quicker to have the transactions extracted directly as one signed row each; the PDF to CSV page shows how QuickBankConvert handles it, and the free tier lets you preview the result before creating an account. For a wider look at the formatting problems bank CSVs cause and their fixes, see fix bank statement CSV formatting issues.

When is a different route better?

• The data came from a system. If the PDF is a report from accounting software, a CRM or a bank, look for an export button in that system first. A native CSV export is always cleaner than one rebuilt from a PDF.
• You only need one small table. Copying the table and pasting it into a sheet can be faster than a full export; the paste fixes are covered in copy a PDF table to Excel.
• You are on Windows with Microsoft 365. Excel can pull tables from a PDF directly with Get Data, skipping Acrobat entirely, and you can then save as CSV the same way.
• The PDF is a scan. Acrobat Pro's text recognition will run during export, but check every figure; misread digits pass silently into a CSV.

Related guides

• Adobe Acrobat PDF to Excel, step by step
• PDF to CSV bank statement conversion guide
• Convert a PDF to Excel or CSV on a Mac