Share via

Is there a way to Extract bank statements to excel automatically

Anonymous
2025-05-22T05:50:09+00:00

I would like to know if there is a way for me to connect my bank statements to excel to automatically extract my data to excel for like accounting purposes. If there is no such way I believe it could be a valuable feature as it will help lots of people who can't afford to pay 100's of apps, these days you have apps for everything and as life is nothing is for free but adding up the costs of all apps you have to pay for to do one thing probably will end up eating up all you cash. If you know what I mean.

Microsoft 365 and Office | Excel | For home | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 143.8K Reputation points Volunteer Moderator
    2025-05-22T08:27:07+00:00

    There are many ways to import data into Excel, but since bank data is usually very well protected, a direct import will not be possible due to security reasons of your banking software.

    The usual way in banking software is to export the data using a CSV file, this file can easily be imported into Excel.

    If you have trouble to import the CSV because of wrong values have a look here:

    Power Query - How to import a CSV file that does not match your locale - Microsoft Community

    Andreas.

    0 comments