Ask Your Question

External data source with csv [closed]

asked 2013-12-12 17:17:40 +0100

PatrickH gravatar image

updated 2015-11-16 16:17:05 +0100

Alex Kemp gravatar image

Hi, I'm trying to create a calc sheet from a webservice. The webservice provides the data as CSV content. Downloading the result and then importing via Insert-> Table from File works just fine. However neither using the URL nor the downloaded file via Insert->link to external data works. I tried the same with MS Excel on a different computer, where this works. Any hints what can be done to get it to work with Libreoffice?
The URL is:
I'm on Libreoffice (german).


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-16 16:17:22.958880

2 Answers

Sort by » oldest newest most voted

answered 2013-12-12 20:29:49 +0100

m.a.riosv gravatar image

Well I have done a try, and it works for me with Win7x64 Version, with Insert from file. Link to external data seems to need a html file.

I think the issue is that it seems doesn't work and some steps take a while.

How I did it?
- Menu/Insert/Sheet from file
- In address bar enter the path [enter]
- Wait for Open button.
- Click Open and wait, in my case near a minute.
- Window for set up the import appears.
- Ok
- Wait until you can mark link option.
- Ok

image description

edit flag offensive delete link more


if insert sheet only allowed to enter something .. no .. it needs a "hard" file on disk .. simply stupid .. if even microsoft managed to do it

eagle275 gravatar imageeagle275 ( 2018-09-18 20:53:28 +0100 )edit

answered 2013-12-12 18:11:38 +0100

Pedro gravatar image

Apparently it wont work with CSV. It expects a named table and CSV doesn't have named tables. If you open the CSV, and give a Name to the range (Insert > Names > Define) and save it as ODS (or XLS, etc) then you can use it as a source to Insert the Link in another file :)

But I think this defeats the utility of the External link...

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-12-12 17:17:40 +0100

Seen: 4,968 times

Last updated: Dec 12 '13