Ask Your Question

Can I create a spreadsheet that will allow me to link websites and pull data directly from the site? I'm thinking about financial statements from different types of accounts.

asked 2017-11-12 20:24:23 +0200

RB1 gravatar image

I desire to create a spreadsheet (Financial Balance Sheet) that once opened would automatically link to my bank account and credit card accounts, and automatically download any transactions that have occurred since the last update. It allow a very quick accounting of my financial statement. It's probably obvious that I am not a proficient spreadsheet user, but I would like to know it this concept is possible.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-11-13 01:34:45 +0200

Ratslinger gravatar image


What you are asking for is somewhat of a tall order. This is for many reasons the least not being that each access may be different in both what and how the information is available. Even proceeding from there, I'm not sure you can do this without some programming (macros) most likely using Python as a language.

Now even after that there may be another method for you. Most financial institutions give the capability of downloading current (or maybe previous) transactions in cvs (comma separated data file) format. This can be imported into your spreadsheet with very little effort. You can then start with that as a basis. What you set up and what is to be accomplished is going to be the design portion you would need to complete. You should check out the LO Templates to see if anything fits your needs - click here.

If this answers your question please click on the ✔ (upper left area of answer).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-11-12 20:24:23 +0200

Seen: 87 times

Last updated: Nov 13 '17