Difference between revisions of "Documentation/FAQ/Calc/Files/How do I insert external data into an existing Calc spreadsheet file?"

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Files
Jump to: navigation, search
 
Line 15: Line 15:
  
 
{{SeeAlso}}
 
{{SeeAlso}}
* [[FAQ:Calc/Files#How_do_I_open_a_tab-delimited_file_in_OpenOffice.org_Spreadsheet.3F_What_if_I_have_a_different_type_of_delimiter.3F| How do I open a tab-delimited file in OpenOffice.org Spreadsheet?]]
+
* [[Documentation/FAQ/Calc/Files/How do I open a tab-delimited file in OpenOffice.org Spreadsheet? What if I have a different type of delimiter?| How do I open a tab-delimited file in OpenOffice.org Spreadsheet?]]
  
 
<section end=answer/>
 
<section end=answer/>
  
 
[[Category:Documentation/FAQ/Calc/Files]]
 
[[Category:Documentation/FAQ/Calc/Files]]

Latest revision as of 09:57, 30 December 2009


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