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
(New page: {{DISPLAYTITLE: How do I insert external data into an existing Calc spreadsheet file?}} <section begin=question/> '''How do I insert external data into an existing Calc spreadsheet file?'...) |
m |
||
(2 intermediate revisions by 2 users not shown) | |||
Line 6: | Line 6: | ||
<section begin=answer/> | <section begin=answer/> | ||
− | |||
You can insert tabular data from an external files into an existing Calc spreadsheet file as follows. | 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. | A new sheet will be created for the inserted data. | ||
− | * Select | + | * Select {{menu|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 | + | * If you have selected a text file with values separated by delimiters, you will see an import dialog to set the corresponding options |
{{SeeAlso}} | {{SeeAlso}} | ||
− | * [[FAQ | + | * [[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 {{AOo}} Spreadsheet?]] |
<section end=answer/> | <section end=answer/> | ||
[[Category:Documentation/FAQ/Calc/Files]] | [[Category:Documentation/FAQ/Calc/Files]] |
Latest revision as of 09:38, 6 October 2021
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