Exporting PDF bank statement to Excel results in messy Excel file...

Community Beginner ,
Jun 06, 2020 Jun 06, 2020

Copy link to clipboard

Copied

I am trying to export a PDF (bank statement) to Excel but the results are far from being good... Acrobat creates all sorts of multiple columns (20+ columns) and merges when there is only a need for 3 columns : date, description and amount (see screenshot)...

 

Is there a smart way to get around this? Is there a tool that allows for telling Acrobat where I would like to get my columns delimited?

 

Screenshot_161.png

Screenshot_162.png

 

TOPICS
Edit and convert PDFs

Views

1.5K

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jun 07, 2020 Jun 07, 2020

Copy link to clipboard

Copied

It might be possible to do that with a custom-made script.

If you're interested I'd be happy to have a look at a sample file and let you know if I think it's doable, and if so for how much.

You can email it to me via [try6767 at gmail.com] to discuss it further.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jun 07, 2020 Jun 07, 2020

Copy link to clipboard

Copied

Thanks for your offer let me consider. Since it's for personal use I would rather find a way to do this by myself... If there is a good tutorial or resource on this topic, appreciate if you can share it.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jun 07, 2020 Jun 07, 2020

Copy link to clipboard

Copied

You should try to tag (manually or automatically) the PDF before exporting as XLS.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jun 07, 2020 Jun 07, 2020

Copy link to clipboard

Copied

Cool, is there some resources I could look up on this topic? I google pdf tagging but returned a lot of results, perhaps I should be more specific...

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jan 14, 2022 Jan 14, 2022

Copy link to clipboard

Copied

Capture_69.png

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Jul 07, 2020 Jul 07, 2020

Copy link to clipboard

Copied

 Hi,

 

Thank you for reporting the issue, it will help us in finding more areas of improvements.We are continuously working on improving the export to excel experience. Can you please provide us the details of the following:

 

  1. Acrobat Version

Go to help -> About Acrobat 

  1. Operating system (Mac/Win)
  2. Input PDF Files and its exported output if possible

 

Regards,

Akanksha Garg

Software Engineer II

Adobe Acrobat Team

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 05, 2021 Mar 05, 2021

Copy link to clipboard

Copied

I went through this same mess a few months ago with my BofA acct.  Today I wanted to start dealing with my 2020 tax stuff and I couldn't see going through the same nonsense.  On my BofA acct, I could only see the pdf version.  But I got some help and it might be transferrable to other banks.  In statements there are several columns with one being amount.  When I click on download which is a button above the amount, I get a new window that gives transaction dates and type of download.  I got the excel spreadsheet and it gave me just the information we need for the work we want to do - 3 columns and nothing more.  It makes me very happy to save a mountain of time.  I hope this gets you what you want even if it is past the time you need it.  Be well.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 01, 2021 Dec 01, 2021

Copy link to clipboard

Copied

A workaround I've found is to crop the PDF pages so that each page is only the transactions, not any of the bank/balance info usually above them. And then delete any pages without transactions, and export.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jan 12, 2022 Jan 12, 2022

Copy link to clipboard

Copied

Hi, have you find a solution? I'm with the same issue... it's incredible that some other online convertersworks better at this than Adobe! the creators of PDF...

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jan 14, 2022 Jan 14, 2022

Copy link to clipboard

Copied

LATEST

Use those other convertors, then. No single tool can handle all possible PDF files. Some will work better with one type, others with another. If you found something that works for you, stick with it.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines