CODEWITHSUNDEEP
csvopenoffice-calc
Bill Poitras
Bill Poitras

Reputation: 667

Link to External Data using URL to CSV file

I am using OpenOffice Calc 4.1.1 on Windows 7.

I am trying to use Link to External Data to load an external CSV file from a gaming website Wowuction.com. If I open the URL in my browser I get a CSV file saved to disk. But when I use that exact same URL in the "URL of external data source" box and hit enter, there is a short pause like its loading, but then nothing happens. Nothing appears in the "Available tables/ranges" box, the OK button is still disabled.

Does OpenOffice Calc not support CSV as an external data source?

Upvotes: 1

Views: 1332

Answers (1)

Rocchi
Rocchi

Reputation: 26

In short: Calc doesn't support loading a CSV file externally, only HTML, ODS, XLS, maybe another.

But if you are confortable writing a dos script, you can download the CSV file and convert it to HTML continuously. Then you can just direct the 'Link to External Data' to you local HTML file.

It's been done on ubuntu linux, in case you want a little reference.

Upvotes: 1

Related Questions