Page 1 of 1
Spreadsheet to text
Posted: Tue May 10, 2011 4:50 am
by rtvano
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.
Re: Spreadsheet to text
Posted: Tue May 10, 2011 4:59 am
by FJCC
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.
Re: Spreadsheet to text
Posted: Sat May 14, 2011 6:42 am
by l1l1ll1l1l
Does it can be saved into a notepad format ?
Re: Spreadsheet to text
Posted: Sat May 14, 2011 8:46 am
by Villeroy
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.