About how to extract tables
To copy table comot from PDF dey usually turn am to text wey scatter. This tool dey look for tables with the ruling lines and how the text line up, then e go write each table wey e find row by row and column by column. Choose Excel to get one sheet for each table, wey be the easiest format to work with. Choose CSV when you need load the data into accounting software, database or script. E dey work for PDFs wey get real text, like reports and statements wey dem export from software. Scanned pages no get text to read, so for those ones use Scan to Word or Excel, wey dey run OCR first. Tables wey get clear lines and one header row dey extract well pass; merged cells, tables wey split across pages and figures inside cells fit need small cleaning after. Numbers dey come out as dem be, including currency symbols and thousands separators, so you fit need format the columns before you calculate.
Limits: one PDF for each task, reach 25 MB on Free, 200 MB on Pro and 500 MB on Business, with reach 2,000 pages. Free get 10 server tasks every day.
Before you sign in, files fit reach 25 MB and you fit run 10 server tasks every day. Free account go raise am to 25 MB and 10 tasks every day.
Privacy: your file dey upload through encrypted connection go our UK servers, e dey process by itself without any person opening am, and we go delete am inside 2 hours (1 hour on Free), or sharp sharp with Delete now.
How to use the PDF tools: Step-by-step help with every tool, limits and your files.
Extract tables: questions wey people dey ask
I suppose choose Excel or CSV?
Excel if you go work for spreadsheet, CSV if you dey import am into another software. Excel dey keep tables for separate sheets.
Why e no find any table?
Maybe the PDF na scan wey no get text layer, or the data no get table structure. Try Scan to Word or Excel for scans.
This one dey use Office conversion?
No. Extract tables no dey count for your Office conversions, e no be like PDF to Excel.
I fit extract tables from bank statements?
Yes, if you download dem as PDFs from online banking. Check the totals against the original.