excel can read and write plain delimited files
Post on 01-Jul-2015
190 Views
Preview:
DESCRIPTION
Two slide pep talk re: reading and writing delimited files with Excel. As in, csv (comma delimited) and tsv (tab delimited).
TRANSCRIPT
Excel and delimited filesUse Excel responsibly ... and perhaps much less
Dr. Jennifer (Jenny) BryanDepartment of Statistics and Michael Smith LaboratoriesUniversity of British Columbia
jenny@stat.ubc.ca@JennyBryanhttps://github.com/jennybchttp://www.stat.ubc.ca/~jenny/
Excel is great for browsing delimited files.Even OK for editing, in certain situations.
if the desired file is greyed out when you try to open ...
use the “enable” drop-down menu to expand what Excel considers open-able
you can even go nuts and enable “All Files”
in particular, Excel is unnecessarily squeamish about the *.tsv extension commonly used with tab-delimited files
File > Open...
top related