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

Ask Your Question

How to append new data to existing data in a Calc spreadsheet [closed]

asked 2018-01-22 17:04:57 +0200

ve3oat gravatar image

(New Calc user here) I have an existing Calc spreadsheet (3 columns, many rows) and need to append new data (3 columns, many rows) to the existing data (it is contiguous in date/time). The new data is in csv fomat, identical to the format of the original data. How do I append the new data beginning at row N+1 of the existing spreadsheet?
All of my attempts so far have placed the new data in cell (1,1) of the existing spreadsheet.

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-10-27 02:41:55.745140

2 Answers

Sort by » oldest newest most voted

answered 2018-01-22 18:09:37 +0200

Lupp gravatar image

I can only suggest a few ways all requiring more than one step:

Create a new sheet 'From file'. In the opening "Text import" dialogue set the options thoroughly as needed.
Copy the data you want to import from the new sheet.
Paste (Special... ?) them into the target sheet.
Delete the intermediary sheet again.

In the place where the data to import should start enter a formula like
for array-evaluation (with Ctrl+Shift+Enter).
Copy the complete output range and Paste Special... it to the same range (without the formula, of course)
==For csv tables referenced as if spredsheets the virtual sheet name is the file name again.==

Open the csv with Calc, copy the data, Paste Special...

Better way you found? (Please report!)

edit flag offensive delete link more

answered 2018-01-23 01:28:42 +0200

ve3oat gravatar image

Thanks very much, Lupp. I used your method "C", as it seemed simplest, and it worked fine (of course). I have printed your answer for future reference in case I need another method. Thanks. I have used QuattroPro comfortably for several decades and am now struggling to learn how to "do it all" with Calc instead. :-)

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-01-22 17:04:57 +0200

Seen: 2,413 times

Last updated: Jan 23 '18