Read data from separate CSV file in OpenOffice Calc
- by Thomi
Hi,
I have a very large CSV file (many thousands of rows) that I want to work with. Due to the size of the file, I don't want to import it into openoffice. Rather, I want to create a spreadsheet that contains formulas & graphs that read from this (or any other) CSV file I point it it.
Ideally the spreadsheet will ask me what CSV file I want to use, allowing me to change the data source dynamically.
Any ideas?