Ask Your Question
0

How to append new data to existing data in a Calc spreadsheet

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

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 close merge delete

2 Answers

Sort by » oldest newest most voted
0

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

Lupp gravatar image

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

A
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.

B
In the place where the data to import should start enter a formula like
='file:///C:/Users/MyUserID/Documents/MyFolderPath/MyCSV.csv'#$MyCSV.A2:C41
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.==

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

D
Better way you found? (Please report!)

edit flag offensive delete link more
0

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

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 680 times

Last updated: Jan 23 '18