Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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!)