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?



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