PDF to CSV
Extract layout-preserved text as CSV (use Excel’s text-to-columns for tables).
Extract layout-preserved text as CSV (use Excel’s text-to-columns for tables).
PDF to CSV extracts the text of a PDF with pdftotext in layout mode, so rows stay on their lines and columns stay lined up with spaces, and saves it with a .csv ending. It does not detect tables or add commas, so you split the columns yourself in Excel or Google Sheets.
Bank statements, price lists and result sheets often arrive as PDFs when you actually need the numbers in a spreadsheet. Copying and pasting from a PDF reader usually scrambles the order. Layout-mode extraction keeps each row on one line and keeps columns in their positions, which is the hard part.
Be clear about what you get: a text file named .csv, where columns are separated by runs of spaces rather than commas. Excel's Text to Columns (Fixed width) or Google Sheets' Split text to columns turns it into proper cells in a minute or two.
Upload a text-based PDF
Choose a PDF whose text you can select in a reader; scanned pages will not work.
Run the extraction
Our server runs pdftotext -layout and returns the file.
Open in a spreadsheet
In Excel, open the file, select column A, then Data > Text to Columns > Fixed width, and set the column breaks.
Tidy up
Delete header and footer lines you do not need and check that amounts landed in the right columns.
ব্যাংক স্টেটমেন্ট, দামের তালিকা বা রেজাল্ট শিটের PDF থেকে সংখ্যাগুলো স্প্রেডশিটে নিতে এই টুল কাজে লাগে। এটা লেখার সারি আর কলামের অবস্থান ঠিক রেখে লেখা বের করে .csv নামে দেয়, তবে কলামগুলো কমা দিয়ে না, ফাঁকা জায়গা দিয়ে আলাদা থাকে। Excel-এ Text to Columns (Fixed width) দিয়ে সহজেই আলাদা ঘরে ভাগ করা যায়। স্ক্যান করা PDF-এ লেখা থাকে না, তাই সেগুলো থেকে কিছু আসবে না। ফাইল আমাদের সার্ভারে প্রসেস হয়ে সাথে সাথে মুছে যায়।
কারণ কলামগুলো ফাঁকা জায়গা দিয়ে আলাদা। কলাম A সিলেক্ট করে Data > Text to Columns > Fixed width ব্যবহার করুন।
না, স্ক্যানে লেখা থাকে না। আগে OCR করে লেখা বের করতে হবে।
Because the file uses spaces, not commas, between columns. Select column A and use Data > Text to Columns > Fixed width in Excel, or Data > Split text to columns in Google Sheets with a custom separator.
No. A scan is a picture with no text inside, so pdftotext finds nothing. Run OCR first, for example with our Extract Text from PDF tool, and then work from that text.
Only while it is converted. The file goes over HTTPS to our server, pdftotext writes the CSV into a scratch folder, and we wipe that scratch folder as soon as your download has gone out.
PDF to Excel tries to rebuild a spreadsheet file, which can look neater but often scatters cells. PDF to CSV keeps the raw row order, which many people find easier to clean. Try both on a sample page.
Some Bangla PDFs store text with fonts that do not map to real Unicode letters, so any extractor reads them wrongly. OCR is the usual fix for such files.
More like this in PDF tools. Need a version built for your business? Ask us.