text to excel

toddgregory · 03-23-2007, 05:27 PM

is there a way to open the text files in excel so they are easier to work with?? Sorry, not a big computer whiz.

Dogzilla · 03-23-2007, 05:45 PM

Sure.
Start Excel. Open-->Files
Change "Files of type" to text files, then open the file you want
It will bring up a "text import wizard", page 1 of 3
Page 1 will default to "delimited", thats OK, hit "next" button
Page 2 you need to change "tab" to "comma", then hit finish
Edit away...but when you're done--
You need to change it back, that's easy too.
save your file as a .csv:
Save as-->change "Files of type" to .csv, save
You file have a .csv suffix, ie "names.csv"
Just rename it to "names.txt" and you're done

03-23-2007, 05:27 PM	#1 (permalink)
toddgregory Minors (Triple A) Join Date: Apr 2006 Posts: 295 Thanks: 12 Thanked 6x in 5 posts	text to excel is there a way to open the text files in excel so they are easier to work with?? Sorry, not a big computer whiz.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

03-23-2007, 05:45 PM	#2 (permalink)
Dogzilla Major Leagues Join Date: May 2004 Location: Colorado USA Posts: 322 Thanks: 0 Thanked 5x in 5 posts	Sure. Start Excel. Open-->Files Change "Files of type" to text files, then open the file you want It will bring up a "text import wizard", page 1 of 3 Page 1 will default to "delimited", thats OK, hit "next" button Page 2 you need to change "tab" to "comma", then hit finish Edit away...but when you're done-- You need to change it back, that's easy too. save your file as a .csv: Save as-->change "Files of type" to .csv, save You file have a .csv suffix, ie "names.csv" Just rename it to "names.txt" and you're done