To convert a PDF to CSV, get the table into a spreadsheet first, then save that sheet as CSV. On Windows, Excel imports PDF tables directly: Data > Get Data > From File > From PDF, then File > Save As > CSV UTF-8. On a Mac, copy the table from Preview into Excel or Numbers and export it as CSV, or use the free desktop tool Tabula, which exports CSV straight from a PDF table. On iPhone and iPad, a PDF converter app or Excel's Data from Picture does the job. Scanned PDFs need text recognition (OCR) before any of this works.
Updated 7 November 2026. Microsoft's steps were checked against its Excel support pages, Apple's against the Preview and Numbers user guides, and Tabula's against tabula.technology on that date. The extraction test below was run on 7 November 2026.
What CSV is, and why PDF tables don't convert cleanly
CSV (comma-separated values) is plain text. Each line is a row, and commas separate the columns. Every spreadsheet, database and accounting tool can read it, which is why banks, tax software and import screens ask for it.
A PDF stores no rows or columns. It stores pieces of text placed at exact positions on a page, plus some lines. What looks like a grid is a picture of a grid. A converter has to work out where each column starts and which text belongs to which row. Clean tables with ruling lines convert well. Tables without lines, merged cells, wrapped text and tables that continue on the next page need checking.
Our test: what three methods produce from the same table
On 7 November 2026 we made two one-page PDFs with the same four-row table (Date, Description, Amount), one with grid lines and one without, and extracted them three ways.
| Method | Table with lines | Table without lines |
|---|---|---|
| Plain text extraction (what a simple copy often gives you) | One value per line, columns lost | One value per line, columns lost |
Text extraction with layout kept (pdftotext -layout) | Columns aligned with spaces | Columns aligned with spaces |
Table detection by ruling lines (PyMuPDF find_tables) | 4 clean rows, 3 columns | No table found |
| Table detection by text position (same tool, text strategy) | Correct values, plus empty rows in between | Correct values, plus empty rows in between |
Two lessons came out of it. First, a converter that looks for lines can miss a table that has none, so try a second mode before you give up. Second, the row "Coffee, New York" and the amount "1,200.00" both contain commas. A tool that writes CSV correctly wraps those values in quotes. A tool that does not will split them into extra columns. Check both in every converted file.
PDF to CSV methods compared
| Method | Platform | Scanned PDFs | File leaves your device | Best for | Checked |
|---|---|---|---|---|---|
| Excel, Get Data > From PDF, then Save As CSV | Windows (Excel 2016 and later, Microsoft 365) | No | No | Recurring reports in the same layout | 7 Nov 2026, Microsoft support |
| Copy from Preview, paste into Excel or Numbers, export CSV | Mac | No | No | One small table | 7 Nov 2026, Apple guides |
| Tabula | Mac, Windows, Linux | No (text-based PDFs only) | No, it runs on your computer | Many tables, free | 7 Nov 2026, tabula.technology |
| Excel Data From Picture | Mac, Windows, iPhone, iPad | Yes, it reads an image | Microsoft processes the image | A scan or a photo of a table | 7 Nov 2026, Microsoft support |
| Online converters | Any browser | Often as a paid OCR option | Yes, uploaded | Non-sensitive files | 7 Nov 2026, vendor pages |
| PDF Opus (top pick) | iPhone, iPad, Mac | Yes, with on-device OCR | No | Private tables on Apple devices | Product feature list |
How to convert PDF to CSV on Windows with Excel
Excel's PDF connector is the strongest built-in method because it reads tables directly and stays linked to the file.
- Open Excel and a blank workbook.
- Choose Data > Get Data > From File > From PDF.
- Select the PDF and click Import.
- In the Navigator, click each Table or Page entry to preview it. Tables are usually listed as Table001, Table002 and so on.
- Click Transform Data if you need to remove header rows, change column types or split a column. Otherwise click Load.
- With the table sheet active, choose File > Save As, then pick CSV UTF-8 (Comma delimited) as the file type, and save.
Excel saves only the active sheet as CSV, so repeat the last step for each table sheet. Choose CSV UTF-8 rather than the older CSV type if the data has accents, currency symbols or non-Latin names. Microsoft notes the PDF connector needs .NET Framework 4.5 or later.
The import stays linked to the PDF. Replace the file with next month's statement, choose Data > Refresh All, and the table updates. For monthly CSV exports in the same layout, that saves real time.
How to convert PDF to CSV on Mac
Microsoft's list of Power Query sources for Excel for Microsoft 365 for Mac does not include PDF (checked 7 November 2026). Mac users have three good routes instead.
Method 1: Copy from Preview, then export CSV from Numbers or Excel
- Open the PDF in Preview.
- Drag across the table to select it. Hold the Option key while you drag to select a rectangular block, which helps when text sits beside the table.
- Press Command-C.
- In Numbers, click the first cell of an empty table and press Command-V. In Excel, click cell A1 and press Command-V.
- If each row lands in one cell, split it. In Excel, choose Data > Text to Columns, pick Delimited, tick Space or Tab, check the preview and click Finish. Use Fixed width when values contain spaces, such as "New York".
- Export. In Numbers, choose File > Export To > CSV, then click Save. In Excel, choose File > Save As and pick CSV UTF-8.
When a spreadsheet holds several tables, Numbers on Mac asks whether to create a file for each table or combine them into one file. Click the disclosure arrow next to Advanced Options to set the text encoding, and pick Unicode (UTF-8).
Method 2: Tabula (free, runs on your Mac)
Tabula is an open-source tool built for exactly this job: "liberating data tables locked inside PDF files". It runs on Mac, Windows and Linux and opens in your browser at a local address, so the PDF stays on your computer.
- Download Tabula from tabula.technology and open it. On a Mac, if macOS says the app can't be opened, Control-click Tabula, choose Open and confirm. Your browser then shows Tabula at a local address (127.0.0.1:8080).
- Import the PDF.
- Drag a box around each table, or let Tabula detect the tables for you.
- Preview the extracted data. If columns are wrong, switch between the Stream method (for tables without lines) and the Lattice method (for tables with lines), or adjust the box.
- Export the data as CSV.
Tabula's own page says it "only works on text-based PDFs, not scanned documents". For a scan, run OCR first.
Method 3: Excel Data From Picture
Excel for Microsoft 365 on Mac can read a table from an image. Take a screenshot of the table (Shift-Control-Command-4 copies it to the clipboard), then choose Data > Data From Picture > Picture From Clipboard. Review the flagged cells, click Insert Data, then save as CSV UTF-8. Microsoft's page describes an AI engine reading the image and does not say where it runs, so treat it like a cloud feature for private figures. It works one table at a time. More detail is in how to convert PDF to Excel on Mac.
What the built-in methods can't do
- No PDF import on Mac Excel or Numbers. Mac users copy, screenshot or use a separate tool.
- No PDF to CSV on iPhone without an app. Preview on iPhone (iOS 26 and iOS 27) exports a PDF as an image or a PDF, and Apple's guide lists no table or spreadsheet export.
- Copy and paste loses the grid. You rebuild columns by hand.
- Scans have no text. Excel's PDF connector and Tabula both need real text in the file.
- Long statements mean many steps. A 20-page statement is 20 screenshots with Data From Picture.
How to convert PDF to CSV on iPhone and iPad
Apple's apps don't convert a PDF table to CSV. You have three practical options.
Option 1: A PDF converter app
Choose an app that lists CSV or Excel export and says where conversion happens. Open the PDF from Files, choose the CSV or Excel export, then save the result to Files. If the app only offers Excel, open the file in Numbers and export CSV (below).
Option 2: Excel's Data from Picture
The Excel app for iPhone and iPad can turn a photo or screenshot of a table into cells. Take a screenshot of the table in Preview, open Excel, choose the Data from Picture option, pick the screenshot, check the result and insert it. Then export the workbook as CSV, or open it in Numbers and export from there. Menu names move between Excel versions, so follow the labels on your screen. Like the Mac version, it works table by table.
Option 3: Paste into Numbers and export
- In Preview on iPhone, touch and hold a word in the table, then drag the handles to cover the table. Tap Copy.
- Open Numbers, create a blank spreadsheet, tap the first cell and paste.
- Fix any rows that landed in one cell.
- Tap the More button in the toolbar, tap Export, tap CSV, then choose where to save or send it.
On iPad the steps are the same. The bigger screen makes selecting a table easier, and Split View lets you keep Preview and Numbers side by side.
Online PDF to CSV converters: the privacy trade-off
Browser converters are quick and need no install. They work by uploading your PDF to the vendor's servers. iLovePDF, for example, says it keeps files for a maximum of two hours (its FAQ, checked 7 November 2026). Many online tools convert to Excel and leave the CSV step to you; scanned PDFs often need a paid OCR option.
Bank statements, payroll exports, invoices and tax forms are the files people most often turn into CSV, and they are also the files you should think twice about uploading. Read are online PDF editors safe before you send one.
Scanned PDFs: run OCR first
A scanned PDF is a picture of a page. Try to select a word: if you can't, the file has no text layer, and no table tool can read it. Options:
- Mac: In Preview on recent macOS versions, Embed Text adds a text layer. See how to make a PDF searchable (OCR).
- iPhone and iPad on iOS 27: In Preview, tap the Actions Menu button, tap Export, choose PDF and turn on Embed Text. Apple says this runs OCR on images and makes the PDF searchable. The iOS 26 export screen does not list this option.
- Excel Data From Picture: reads the image directly, table by table.
OCR makes mistakes with numbers that matter: 8 and 3, 1 and 7, a dropped decimal point. After converting a scan, total each numeric column and compare it with the totals printed in the PDF.
How to clean up the CSV
- Remove repeated headers. A table that runs over five pages often repeats its header row five times.
- Delete page footers. Page numbers and "continued" lines end up as rows.
- Merge wrapped rows. A long description that wraps onto a second line becomes two rows. Join them.
- Check commas inside values. Values such as "Smith, John" must be in quotes, or they split into two columns.
- Normalise numbers. Remove thousands separators if the target system expects 1200.00, and check that negative amounts in brackets, such as (45.00), became -45.00.
- Protect leading zeros. Account numbers and ZIP codes such as 02134 lose their zero when a spreadsheet treats them as numbers. Format that column as text before you export.
- Fix dates. Pick one format (2026-10-01 is the safest) so the importing system doesn't read 03/04 the wrong way.
- Save as UTF-8. It keeps accents and symbols intact.
Open the final CSV in a plain text editor such as TextEdit once. You will see exactly what the importing system will see.
CSV, Excel or text: which output do you need?
| You want to | Best output | Guide |
|---|---|---|
| Import into accounting, a database or a script | CSV | This page |
| Keep formatting, several sheets or formulas | Excel (.xlsx) | PDF to Excel on Mac |
| Copy paragraphs, not tables | Plain text | extract text from a PDF |
| Convert to Word, slides or images | Depends on the format | PDF converter guide |
Troubleshooting
All the data lands in one column
The tool read each row as one line of text. In Excel, use Data > Text to Columns. In Tabula, switch between Stream and Lattice mode.
Excel's Navigator shows no tables
The PDF may be a scan, or the table may have no lines. Pick a Page entry instead of a Table entry and split the columns in the Power Query editor, or run OCR first.
Names with accents look broken in the CSV
The file was saved in an older encoding. Save again as CSV UTF-8 in Excel, or choose Unicode (UTF-8) in Numbers' export options.
Numbers shift into the wrong column
A value contains a comma and was not quoted, or a cell was empty in the PDF and the converter skipped it. Check the rows around the first wrong value.
The PDF is password protected
Copying and converting can be blocked by the file's permissions. Open it with the password and save an unlocked copy first. See how to remove a password from a PDF.
PDF Opus: the best app for converting PDF to CSV (top pick)
The best app for converting PDF to CSV is PDF Opus. It turns the tables in a PDF into CSV files with layout analysis, on your iPhone, iPad or Mac. Convert PDF to Word, Excel, PowerPoint, HTML, Markdown, text or images on your device. Make scanned PDFs searchable on your device with Apple Vision; the original image stays unchanged. Your documents are processed on your device.
Two limits are worth knowing. Side-by-side blocks are written one after another, so a page with two tables next to each other comes out as two tables in sequence. Charts are dropped, since a chart is a drawing and not data.
Frequently asked questions
How do I convert a PDF to CSV for free?
On Windows, use Excel's Data > Get Data > From PDF and save the sheet as CSV UTF-8. On any computer, Tabula is free and exports CSV directly from text-based PDFs. On a Mac, copying the table from Preview into Numbers and choosing File > Export To > CSV costs nothing.
How do I convert a PDF to CSV format in Excel?
In Excel for Windows, choose Data > Get Data > From File > From PDF, pick the table in the Navigator, click Load, then File > Save As > CSV UTF-8 (Comma delimited). Excel for Mac has no PDF source, so paste the table or use Data From Picture first.
Can I convert a scanned PDF to CSV?
Yes, after OCR. Add a text layer with Preview's Embed Text, or use Excel's Data From Picture, which reads the image. Check numeric columns against the printed totals afterwards.
Why does my CSV have extra columns?
A value with a comma in it, such as "Coffee, New York" or "1,200.00", was written without quotes. Re-export with a tool that quotes values, or remove the commas from that column before export.
How do I convert a PDF bank statement to CSV?
Many banks offer a CSV download in online banking, which is cleaner than converting a PDF, so check there first. If you only have the PDF, use Excel's PDF import or Tabula, then remove repeated headers and page footers and confirm the totals.
Can I convert PDF to CSV on iPhone?
Not with Apple's apps alone. Use a converter app with CSV or Excel export, Excel's Data from Picture, or copy the table into Numbers and export it as CSV.
What is the difference between CSV and Excel?
CSV is plain text with one table, no formatting and no formulas. An Excel file can hold many sheets, formats and formulas. Systems that import data usually want CSV.
Is it safe to convert a PDF to CSV online?
The file is uploaded to the vendor's servers and kept for a period the vendor states. For bank, tax or payroll data, use a tool that runs on your own device.