Get External Data from CSV? [closed]

asked 2014-05-10 23:20:28 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I'm trying to make the transition from Excel and I'm struggling with the way External Data is handled. I get a CSV file output from Quicken that contains all my investment information. I overwrite this file a few times a week and let my spreadsheet calculate the returns. The way I have Excel set up is that it will reimport the data whenever I open the file. The equivalent functionality in Calc (I think) requires me to have an intermediate step of converting that CSV to a spreadsheet file that supports named ranges (which is a deal breaker until I'm forced to upgrade MS Office).

Is there a way I can get automatically pull an entire CSV file automatically on opening the file?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-22 15:27:39.151768