Share this content
22

Recommended pdf to excel converter?

Tried a few and they are garbage

Didn't find your answer?

I'm looking for a pdf to excel converter mainly for converting bank statements. I've tried Adobe and various online ones but they all seem to chuck out garbage where the lines are split in to different rows. 

Does anyone have a recommendation that they use?

Replies (22)

Please login or register to join the discussion.

avatar
By jpf1101
22nd Jan 2020 16:07

I messed around for years moving from product to product.

Bit the bullet and started using StatementRec (now comes under AutoEntry umbrella)a few years ago, god knows why I didn't do it sooner. Yeah it costs money, but you can save yourself so much faffing whilst waiting for the conversion.

Thanks (0)
Replying to jpf1101:
avatar
By SXGuy
22nd Jan 2020 16:19

That is kinda pricey for what I need. At most I need it for about maybe 25 pages of statements every quarter.

Edit. Oops must have checked another software by mistake. Actually auto entry seems OK for the level I'd need. 3 credits per page. 75 credits a quarter, could buy 500 for £75 should cover the year.

Thank you.

Thanks (1)
Replying to SXGuy:
avatar
By PERMON
14th Feb 2020 14:46

Autoentry seems popular - you'd need to watch how you purchase. If you go for the subscription I think you can only carry the credits forward for months ? You can buy as you go for a slightly higher per credit price.

Only slight issue I have is I dont like the idea of sensitive documents like bank statements "in the cloud". Ocrex also have their AutoRec desktop product which also has a more functionality having converted the pdf's- in that case you buy the credits upfront for a year but unused credits die at the end of the twelve months

Thanks (0)
Replying to SXGuy:
avatar
By [email protected]
14th Feb 2020 14:56

Another vote for Auto Entry. We started with it 6 years ago and have never looked back

Thanks (0)
By SteLacca
22nd Jan 2020 16:20

LibreOffice - will open Excel files (sometimes, better than Excel will) and has a built in save as pdf function.

Thanks (0)
Replying to SteLacca:
avatar
By SXGuy
22nd Jan 2020 16:32

Thanks but that's the wrong way round. I need pdf to excel.

Thanks (0)
By Paul D Utherone
22nd Jan 2020 16:20

Try copying into Word and then from Word to Excel. For some strange reason Word sometimes seems to do a better job of creating tables correctly that can then be copied to Excel.

Thanks (1)
Replying to Paul D Utherone:
avatar
By SXGuy
22nd Jan 2020 16:33

Good call! Never thought about that and your right word does seem to handle tables very well. Thanks.

Thanks (0)
avatar
By Mulsey
22nd Jan 2020 17:24

I have used various options including Word but this seems to be the best I've come across.
https://www.pdftoexcel.com

Thanks (1)
avatar
By legerman
22nd Jan 2020 18:15

Try using Weeney. I've just converted 75 pages of a bank account and although I have to do some deletion of empty rows, it handled it quite well.

Best of all, it's free. weeneysoft dot com

Thanks (1)
avatar
By jpf1101
22nd Jan 2020 18:18

don't you need to be careful with some of these free ones re GDPR etc?

Thanks (1)
David Winch
By David Winch
22nd Jan 2020 20:46

We use ALTIA but it's not cheap. We need to do this a lot for Crown Court work so it is one of our most used tools. (We don't prepare annual accounts, tax returns, etc so your needs may be different.)
David

Thanks (1)
avatar
By sarah douglas
23rd Jan 2020 10:52

The best software to do this and we use it all the time is AbletoExtract.

https://www.investintech.com/prod_a2e.htm

It is excellent, and we have been using it for years, fantastic for converting everything very accurately and converting everything to OCR. Automatically does table, but allows you to define and preview before saving to save time.

We have converted for quite a few colleagues in the industry.

It is much better at converts then adobe DC. They do a trial version if you want to try it, but we use for everything, so we purchased it.

Thanks (1)
Replying to sarah douglas:
avatar
By Howard Walters
14th Feb 2020 16:27

I totally agree with you Sarah. I've also been using a purchased version for years and would be lost without it.

Thanks (1)
avatar
By ospevack
23rd Jan 2020 07:53

I use Abbyy FineReader if it is for working papers prepared or excel sheets, will also move to other formats. If its a bank statement AutoEntry or any of those types of products are more cost effective than wasting time trying to get the layout correct for success in OCR software IMO

O

Thanks (1)
avatar
By daniel_
23rd Jan 2020 09:41

Another vote for Investintech Able2Extract
It's the best OCR tool for bank statements I've seen as it's the only one which can handle the different row-splitting methods that each of the banks use on their statements.
You can set the row splitting method to "document horizontal lines" but not every statement has these. You can use a "key column" i.e. whenever there's an entry in the key field, add a row break. (e.g. date column)

The other option is just to use Autoentry if you're happy with the per-page costs.

Thanks (1)
avatar
By SXGuy
23rd Jan 2020 10:24

Thanks for all the recommendations guys, ive taken a look at a few of them and Able2Extract seems to be the best choice, its a lifetime licence which in the longrun will work out cheaper than the other pay per page ones.

Some of the free ones doesn't seem to handle the line splitting of the statement descriptions, but I like the idea that Able2Extract uses a table which you can adjust before exporting, which seems to handle line splitting pretty well. It also means I can remove all the company logos and other information displayed on a statement that's not needed.

Ran a test, and only needed to adjust 2 entries out of 4 pages. Which is going to save me a lot of time in the future.

Thanks (1)
Replying to SXGuy:
avatar
By sarah douglas
23rd Jan 2020 10:55

Good choice, it was one of the best software buys we ever did.

Thanks (1)
avatar
By carnmores
23rd Jan 2020 19:43

agreed Able2extract used it first 20 years ago to database long long royalty statemenys. fantastic software

Thanks (0)
Replying to carnmores:
avatar
By PERMON
14th Feb 2020 14:48

Interesting. I tried a product last year - I'm nearly sure it was Able2extract - and I had mixed results - ended up spending too much time tidying up the excel spreadsheet.

Thanks (0)
avatar
By STCCS
14th Feb 2020 16:30

Why not just get excel/csv export from originator/bank?

Thanks (0)
Replying to STCCS:
avatar
By SXGuy
14th Feb 2020 16:33

Because no amount of asking a client changes the fact they they either never listen or don't know how to. So rather than banging my head against a wall this is the easiest solution.

Thanks (1)
Share this content