Difference between revisions of "Documentation/FAQ/Calc/Files/How do I insert external data into an existing Calc spreadsheet file?"
From Apache OpenOffice Wiki
|Line 15:||Line 15:|
* [[FAQCalc/Files-.| How do I open a tab-delimited file in OpenOffice.org Spreadsheet?]]
Latest revision as of 09:57, 30 December 2009
How do I insert external data into an existing Calc spreadsheet file?
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