Spreadsheet for storage of financial .csv data from the web

Discuss the spreadsheet application
Post Reply
nycpaulll
Posts: 1
Joined: Fri Mar 11, 2016 7:55 pm
Location: New York City

Spreadsheet for storage of financial .csv data from the web

Post by nycpaulll »

For me the OpenOffice spreadsheet has become a single storage medium for all the .csv downloads now possible from bank, broker, credit card and other financial institutions. Rather than storing PDF statements I add .csv downloads from my account web page to a sheet of my spreadsheet where I can see a year's worth of data with the ability to manipulate, add notes and adjust as I find helpful. I have a sheet for my income and expense, credit card, debit card, IRA account, regular broker, as well as sheets used to computer RMD and taxes and more. I can even insert a copy of my tax return as a graphic. How great that is.

What would be very helpful is to be able to insert a text file created on OpenOffice Write into this Financial Spreadsheet. Having this portable Spreadsheet with all this data in one file (backed up regularly) is terrific. It's very much like a virtual file cabinet that gets rid of a lot of paper. Thank you OpenOffice.

NYCPaul
Last edited by nycpaulll on Mon Apr 08, 2019 3:37 pm, edited 1 time in total.
OpenOffice 4.1.2 on Windows 7
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Spreadsheet for storage of financial cvs data from the w

Post by RusselB »

Welcome to the Forums.
You could use Insert -> Sheet from File
or you could keep the Writer documents separate, and link to the Writer document in the spreadsheet, or to the spreadsheet page/cell in Writer. Personally, this is the method I would recommend as you won't have all of your information in one file, thus if something happens, you (probably) wouldn't lose everything.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
FJCC
Moderator
Posts: 9231
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Spreadsheet for storage of financial cvs data from the w

Post by FJCC »

You can insert a Writer document into a spreadsheet by using the menu Insert -> Object -> OLE object. Click the Create From File radio button near the top of the dialog to insert an existing document. After insertion, you can double click on the object to see it in a window.
I would be cautious about making a Calc document too complicated. The previous advice about using links is a good idea.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Post Reply