How to Extract Tables from PDF to Excel & CSV Online
Back to Blog

How to Extract Tables from PDF to Excel & CSV Online

P
Plainscan Team
October 23, 2026
4 min read
Share

A friend of mine works in accounts at a small company. Every month, she gets a bank statement as a PDF, and every month she used to type it into Excel. Line by line. Two hours, give or take, plus a lot of sighing. One month she mistyped a single digit and spent another hour hunting for the error. When I showed her how to convert the PDF in about a minute, she looked genuinely annoyed. “Why didn’t anyone tell me this years ago?” So here it is, for anyone in the same boat. This is how to extract tables from PDF to Excel and CSV online, what to watch out for, and a few mistakes I’d skip if I were you.

Why Copy and Paste Fails on PDF Tables

Try it once and you’ll see. You select a table in a PDF, paste it into Excel, and everything lands in one column. Or the numbers shift sideways by a cell. Or you get a wall of text that looks like a cat walked on the keyboard.

Here’s why. A PDF is made to look right, not to hold data in an organized way. That neat table you see is really a pile of tiny text pieces, each sitting at an exact spot on the page. Your computer has to guess where one column ends and the next begins. Sometimes it nails it. A lot of the time it doesn’t.

A good PDF to Excel converter makes a smarter guess and gives you real rows and columns you can sort, filter, and add up.

Why Copy and Paste Fails on PDF Tables

Excel or CSV? Here’s How I’d Choose

If you plan to work with the numbers yourself, pick Excel. You can sort, color, chart, and write formulas. It’s the friendly option, and it’s what most people want.

If another program needs the data, pick CSV. It stands for comma-separated values, which sounds scarier than it is. It’s a plain text file where every line is a row and commas split the columns. No colors, no styles. But almost every app can read it, which is why accounting tools and databases ask for it.

Still not sure? Go with Excel. Turning it into a CSV later takes about ten seconds, and I’ll show you how in a minute.

Is Your PDF Text-Based or Scanned?

Quick test. Click and drag your mouse over a number in the table.

If it highlights, you’re in good shape. The PDF has real text in it, and conversion usually goes smoothly.

If nothing happens, you’ve got a scan, which is basically a photo of a table. A scanned PDF to Excel job needs one extra step first, called OCR (optical character recognition). Think of it as a very quick reader that looks at the picture and types out what it sees. Once that’s done, the file can be converted like any other.

How to Extract Tables from PDF to Excel & CSV Online with Plainscan

How to Extract Tables from PDF to Excel & CSV Online with Plainscan

Plainscan runs in your browser and has over 100 document tools. Nothing to install, which is nice if your computer is already stuffed. It works on a laptop, a tablet, or your phone.

First, open the tool. Go to the tools page and choose PDF to Excel. If your file is a scan, run it through Scan & OCR first.

Next, upload the file. Drag it in or browse your device. Free accounts can upload up to 50 MB, which is more than enough for most reports and statements.

Then convert. Press the button and give it a few seconds. Bigger files take longer, and I know it’s tempting to refresh the page when nothing seems to happen. Don’t.

Download and open it. Take a look at the Excel file. Does it make sense? Great.

Need a CSV instead? Open the Excel file, click File, then Save As, and choose CSV from the file type list. That’s the whole trick.

So what does free really mean?

You can start without paying. After you make a free account, you can process up to 4 documents a day with the basic PDF tools, and that resets every 24 hours. For a few statements or a school project, it’s plenty. If you want AI features or unlimited use, there’s a paid plan, or you can buy credits and only use them when you need to.

Small Things That Make a Big Difference

Small Things That Make a Big Difference

Honestly, the PDF matters most. Simple tables with clear lines convert the best. If your table has tiny text, boxes inside boxes, or a layout that makes your eyes hurt, expect to do some cleanup afterward. That’s normal and not a sign you did something wrong.

Look at the top rows when it’s done. Headers and totals tell you quickly whether things went well. It takes ten seconds, and it’s saved me from a few embarrassing mistakes.

Don’t expect formulas. A PDF only keeps the numbers you see, not the math behind them. So you’ll get plain values, and you’ll need to type the formulas in again. Annoying, but that’s how PDFs work.

If you only need page three of a thirty-page report, upload just page three. It’s faster, and you won’t have a mountain of extra rows to delete. And if a page is sideways, fix it first with the Rotate PDF tool, or the result will be a mess.

Who Gets the Most Out of This?

My accountant friend, obviously. But also students who need data from a lab report to make a chart. Small shop owners who want to compare price lists from two suppliers side by side. Developers who need a CSV to feed into something else and would rather not build a parser for it.

Really, it’s for anyone who has stared at a PDF table and thought, “I do not want to type this.”

Safe and Secure PDF Table Extraction

Is It Safe to Upload Your PDF?

Good thing to ask about any online tool. Plainscan uses encrypted HTTPS connections, and uploaded files are deleted automatically within 24 hours.

That said, I’d still be careful with anything really private. Full bank account numbers or ID documents, for example, deserve a second thought before going on any website. Skim the privacy policy of a new tool first. It’s boring, but it’s worth two minutes.

Mistakes I’d Avoid

Skipping OCR on a scan. The tool can’t read a picture, so you’ll get nothing back and wonder why.

Trusting every number. A single shifted column can change a total. Check the important ones.

Ignoring the limits. Look at the file size and your daily cap before starting a big batch. Hitting it halfway through is a bad feeling.

Conclusion

You don’t have to retype tables anymore. Check whether your PDF is text-based or scanned, upload it, convert it, and save it as Excel or CSV. Most files take a minute or two. If you’ve got a PDF full of numbers sitting in your downloads folder, try Plainscan on it today. It’s an easy way to extract tables from PDF to Excel and CSV online, and there are plenty of other free PDF tools worth poking around in while you’re there.

Related insights

How to Convert Word to PDF (and Keep Everything Looking Right)

ARTICLE

How to Convert Word to PDF (and Keep Everything Looking Right)

My friend Rohan spent a whole evening polishing his resume. Clean layout, neat columns, a font he was proud of. He emailed it as a Word file and went to bed happy. The recruiter wrote back the next day: “I think your file got scrambled.” On her computer, the columns had slid apart, the font had changed to something plain, and his name sat in the middle of a bullet list like a typo. His file was fine. Word documents just look different depending on the computer, the app, and the fonts installed. A PDF would have looked the same everywhere. So here’s how to convert Word to PDF, and what to check first.

Plainscan Team·October 26, 2026
4 min read
How to Convert PDF to Word (and Keep Your Layout Looking Right)

ARTICLE

How to Convert PDF to Word (and Keep Your Layout Looking Right)

My cousin needed to update her resume. Easy job. Change one phone number, add one new job. But all she had was a PDF, because the Word file died with her old laptop. So she retyped the whole thing. Every line, every bullet. An hour and a half later she was still fixing the spacing, and one of her job dates had somehow turned into 2019. When I told her she could have converted the PDF to Word in about a minute, she just stared at me. Then she said, “Why does nobody tell you this?” So here it is. How to convert PDF to Word, what to expect, and what to fix afterward.

Plainscan Team·October 26, 2026
4 min read
Free PDF Invoice Generator Online: Make a Professional Invoice in Minutes

ARTICLE

Free PDF Invoice Generator Online: Make a Professional Invoice in Minutes

A friend of mine does freelance photography. She’s really good. Weddings, birthdays, the occasional dog in a tiny bow tie. Her photos are the kind that make you stop scrolling. Her invoices, though? Chaos. For a long time she’d open a blank document, type INVOICE in huge letters, guess at the layout, save it, and hit send. Sometimes she forgot her phone number. Once she forgot to put the total. Yes, the actual amount you owe. I’m not joking. Then one client took three weeks to pay her. When she finally asked what was going on, he said, “Oh, I didn’t see a due date, so I figured there was no rush.” Three weeks of waiting because of one missing line. That’s the moment she decided to get serious. Here’s how a free PDF invoice generator online can help, what every invoice needs, and a few habits that get you paid faster.

Plainscan Team·October 26, 2026
4 min read
Free PDF Repair Tool: How to Fix a Corrupted PDF Online

ARTICLE

Free PDF Repair Tool: How to Fix a Corrupted PDF Online

My brother-in-law is a freelance accountant. A few weeks ago a client sent him a 60-page report as a PDF. He downloaded it, double-clicked, and got a message: the file is damaged and can’t be opened. The report was due the next morning. He tried again. Same error. Different app. Same error. He called me at 10 p.m. and asked, “Is it just gone?” It wasn’t. A broken PDF can often be saved, or at least partly saved. Here’s how to use a free PDF repair tool, and how much to expect from one.

Plainscan Team·October 26, 2026
4 min read
Print Optimize PDF: How to Get Sharp, Clean Printouts Every Time

ARTICLE

Print Optimize PDF: How to Get Sharp, Clean Printouts Every Time

My sister designed flyers for her yoga class. On her screen, they looked fantastic. She sent the PDF to a print shop, paid for fifty copies, and picked them up the next day. The logo was blurry. The text near the edge was sliced off. And the soft pink background she picked had turned into a muddy brown. Fifty flyers, straight into the recycling bin. She was not happy, and the print shop guy just shrugged and said, “Your file wasn’t print-ready.” That phrase confuses a lot of people. So here’s what it means, how to print optimize PDF files, and a checklist you can use before you hit print.

Plainscan Team·October 24, 2026
4 min read
PDF to Grayscale: How to Turn Any PDF Black and White Online

ARTICLE

PDF to Grayscale: How to Turn Any PDF Black and White Online

My uncle once printed a 40-page report for a meeting. Colorful charts, a blue header on every page, a green footer. Halfway through, the printer made a sad noise and quit. The cyan cartridge was empty. He still had plenty of black ink. The printer just wouldn’t use it, because the pages were in color. That’s when people find out about grayscale. Here’s how to turn a PDF to grayscale, and the one catch that can make your charts hard to read.

Plainscan Team·October 24, 2026
4 min read
What Is an N-up PDF? (And How to Make One Online)

ARTICLE

What Is an N-up PDF? (And How to Make One Online)

Last-minute printing is a special kind of stress. You’ve got a 40-page PDF, a meeting in twenty minutes, and a printer that’s already making that grinding noise. Then you notice the stack of paper growing. And growing. Here’s the thing most people don’t know. You can fit two, four, or even six pages on a single sheet. It’s called N-up, which sounds like something from a math test, but it’s really not. I’ll show you what it means, when it’s worth using, and how to make an N-up PDF online without any software.

Plainscan Team·October 24, 2026
4 min read
How to Crop PDF Pages (Cut the Extra Stuff Out)

ARTICLE

How to Crop PDF Pages (Cut the Extra Stuff Out)

A friend of mine downloaded a recipe PDF to read on her tablet while cooking. Great recipe. Awful layout. The actual text sat in the middle of each page, wrapped in about two inches of empty white space on every side. On a small screen, that meant zooming in, sliding the page around, zooming out, and losing her place. Meanwhile the onions were burning. She texted me a photo of the tablet with the caption, “Why is it like this?” I told her to crop it. She said, “Crop a PDF? You can do that?” Yes, you can. It takes less time than chopping an onion. Here’s how to crop PDF pages, when it’s worth doing, and the one thing cropping can’t do that catches a lot of people off guard.

Plainscan Team·October 24, 2026
4 min read
How to Flatten PDF Files (and Why Your Forms Need It)

ARTICLE

How to Flatten PDF Files (and Why Your Forms Need It)

A friend of mine fills out a lot of paperwork for her small business. One day she typed answers into a PDF form, saved it, and emailed it to a supplier. The supplier wrote back, “This form is empty.” It wasn’t empty on her computer. Every box was full. But on the supplier’s phone, the typed answers had vanished, because the phone didn’t read the form fields right. The fix was one word: flatten. Here’s what it means to flatten PDF files, when to do it, and what to watch out for.

Plainscan Team·October 24, 2026
4 min read
How to Compare PDF Files Online (and Catch Every Change)

ARTICLE

How to Compare PDF Files Online (and Catch Every Change)

A friend of mine works at a small property company. Last year a landlord sent back a lease with a note: “Just a couple of tiny edits.” She read it twice. Looked the same. It wasn’t. The rent increase date had moved up a month, and a line about repairs had quietly disappeared. She only caught it because her boss remembered the old date. Nobody should have to rely on luck for that. Here’s how to compare PDF files online, and what to check first.

Plainscan Team·October 24, 2026
4 min read

Get the Plainscan App for iOS & Android