We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

binding a range of cells to simple csv data file [closed]

asked 2017-01-10 01:53:35 +0200

jjj4 gravatar image

This really is so simple but I can't figure it out. I have a simple text file with a 3x3 matrix of csv numbers i.e.


I want to bind a grid of nine cells on my spreadsheet (say A1:C3) to that file.

if the file changes, i refresh the spreadsheet, the spread sheet changes. simple. i can do this all day long in *xcel.

this should be so simple its ridiculous but "sheet"->"link to external data" doesnt work.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-20 21:40:38.049099

4 Answers

Sort by » oldest newest most voted

answered 2017-01-11 00:37:50 +0200

karolus gravatar image

updated 2017-01-11 18:08:14 +0200

David gravatar image

It is possible to link the .csv into one sheet, via → Sheet → insert Sheet from file[1] with [x] Link option in Import-dialog.

To refresh the sheet after changing the CSV file, use → Fiile → Reload

[1] In prior Versions of LO it was → insert → insert Sheet from File

edit flag offensive delete link more

answered 2017-01-10 18:48:20 +0200

pierre-yves samyn gravatar image


Sorry, I only have a short connection time and could not explain in detail but what is requested is possible...

  • Follow the FAQ I've created showing how to link a text file to a database.
  • Register the database: ToolsOptionsLibreOffice BaseDatabasesNew (select the database)
  • Then, in the spreadsheet, ViewData Sources
  • Unfold the Database▸Tables▸Click at the intersection of the row and column headers to select all data
  • Click Data to Text in the Table Data toolbar: data is inserted into the sheet and one database range is created (default Import1) as you can see in the navigator.

Then just do DataRefresh Range to update the data

Longer to explain than to do ... :)


edit flag offensive delete link more

answered 2017-01-10 22:51:08 +0200

m.a.riosv gravatar image

You can link to the csv file as it was a spreadsheet.

Opening both files it's easier, and you can see how the sheet name it's assigned.

edit flag offensive delete link more


Yes of course, but the question was not how to link a range of cells?

pierre-yves samyn gravatar imagepierre-yves samyn ( 2017-01-12 07:18:53 +0200 )edit

I'm not sure, but anyway with this method there is no limit on the range (sheet limits), it's easier using arrays to link.

m.a.riosv gravatar imagem.a.riosv ( 2017-01-13 03:49:05 +0200 )edit

answered 2017-01-10 14:55:26 +0200

Lupp gravatar image

I don't think there ever was an option to link in a csv as a table (data source).
You can link to tables contained in spreadsheets of Calc or Excel style or those contained in HTML files.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-01-10 01:53:35 +0200

Seen: 1,055 times

Last updated: Jan 11 '17