How do I insert external data into an existing Calc spreadsheet file?
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Files
How do I insert external data into an existing Calc spreadsheet file?
2.x
You can insert tabular data from an external files into an existing Calc spreadsheet file as follows. A new sheet will be created for the inserted data.
- Select Insert - Sheet From File and select the file with the data
- If you have selected a text file with values separated by delimiters you will see an import dialog to set the corresponding options
See Also