Difference between revisions of "Documentation/FAQ/Calc/Files/Why does Calc refuse to open my .txt file?"
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Files
(New page: {{DISPLAYTITLE: Why does Calc refuse to open my .txt file?}} <section begin=question/> '''Why does Calc refuse to open my .txt file?''' <section end=question/> <section begin=answer/> A ...) |
m |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 12: | Line 12: | ||
* Rename the file so that it uses the .csv file extension. | * Rename the file so that it uses the .csv file extension. | ||
or | or | ||
| − | * Select | + | * Select {{menu|File|Open}} from the menu and select '''Text CSV''' from the '''File type''' list.<br>This is quite a way down in the list, so it is easy to miss. An easy way of navigating there is to press '''T''' several times when inside the list field until the filter name comes up. |
{{SeeAlso}} | {{SeeAlso}} | ||
| − | * [[ | + | * [[Documentation/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 {{AOo}} Spreadsheet? What if I have a different type of delimiter?]] |
Latest revision as of 09:43, 6 October 2021
Why does Calc refuse to open my .txt file?
A text file with tabular values must be imported into Calc using .csv format. You cannot open it by double-clicking on the file name, unless it has the .csv extension, since a text file will automatically open in Writer.
If you want to open a .txt file with tabular data using Calc:
- Rename the file so that it uses the .csv file extension.
or
- Select File → Open from the menu and select Text CSV from the File type list.
This is quite a way down in the list, so it is easy to miss. An easy way of navigating there is to press T several times when inside the list field until the filter name comes up.
See Also
