Spreadsheet to text
Spreadsheet to text
I see many references to converting text to spreadsheet, but none about the opposite. Would like to convert simple 3 column spreadsheet to comma dilineated text with lines separated by paragraph, to be received easily my mobile devices.
OpenOffice 3.3 on Windows 7
Re: Spreadsheet to text
Select File -> Save As. In the dialog that appears choose Text CSV from the Save As Type list. You can also select Edit Filter Settings to make sure the file will use the column separator that you want. If you want the file to have an extension other than .csv, uncheck the Automatic File Name Extension box and include the desired extension in the File Name.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
-
l1l1ll1l1l
- Posts: 5
- Joined: Sat May 07, 2011 9:00 am
Re: Spreadsheet to text
csv is plain text. The text editor called "Notepad" opens plain text. Just open the file with whatever text editor you like. There are much better text editors though.
http://csved.sjfrancke.nl/ is a 12MB download and a better csv editor than any spreadsheet program.
http://csved.sjfrancke.nl/ is a 12MB download and a better csv editor than any spreadsheet program.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice