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
m |
m |
||
Line 15: | Line 15: | ||
{{SeeAlso}} | {{SeeAlso}} | ||
− | * [[Documentation/FAQ/Calc/Files/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%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