How do I insert external data into an existing Calc spreadsheet file?

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Files
Jump to: navigation, search


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:


Personal tools