copying bank account information into excel / google sheets, lists all info in 1 column instead of grid formation

Question

My bank account informaiton on the website is in a grid formation (ie: name of transaction, value, total in bank)

When I copy and past this information into google sheets or excel, it lists all this information into a single column instead of that grid formation.

How do I prevent this from happening?

Answer 1

First check to see if your bank website has a feature to export to Excel or CSV format. This would be ideal, and many bank websites do have this feature. If not, you can use a browser extension to copy the table properly:

• Chrome: Table Capture
• Firefox: Dafizilla Table2Clipboard