How do I convert a .csv file to a .txt file in Windows 7

 

Under Windows Vista, I could change a file from a .csv format to a .txt format merely by renaming the suffix. Piece o' cake.
I now have Windows 7 and to make the same change I have to open a DOS window and issue the following kind of command:
ren "rest areas.csv" "Rest Areas.txt" Depending on the length of the file name, this could be fairly cumbersome. Is there any other ways in Windows 7 to rename the suffix of a file?

--
Phil in Mentor, Ohio -- Garmin Nuvi 1450

Open file in note pad

plunder wrote:

Under Windows Vista, I could change a file from a .csv format to a .txt format merely by renaming the suffix. Piece o' cake.
I now have Windows 7 and to make the same change I have to open a DOS window and issue the following kind of command:
ren "rest areas.csv" "Rest Areas.txt" Depending on the length of the file name, this could be fairly cumbersome. Is there any other ways in Windows 7 to rename the suffix of a file?

Open in notepad, click on file, save as, drop down to txt and also remove the .csv from the file name.

--
All the worlds indeed a stage and we are merely players. Rush

That's easy enough

Thanks, d-moo70. I'm always amazed when I learn something new that everybody else in the whole world already knows.

--
Phil in Mentor, Ohio -- Garmin Nuvi 1450

Windows Explorer

plunder wrote:

Under Windows Vista, I could change a file from a .csv format to a .txt format merely by renaming the suffix. Piece o' cake.
I now have Windows 7 and to make the same change I have to open a DOS window and issue the following kind of command:
ren "rest areas.csv" "Rest Areas.txt" Depending on the length of the file name, this could be fairly cumbersome. Is there any other ways in Windows 7 to rename the suffix of a file?

I don't quite understand why you just can't rename it while in Windows Explorer? I do it all of the time.

To have full view of your files In Explorer ...
. select "Tools > Folder Options"
. select the "View" tab
. select "Hidden filles and folders"
choose "Show hidden files, folders and drives"
. uncheck "Hide empty drives in the Computer folder"
. uncheck "Hide extensions for known file types"
. uncheck "Hide protected operating system files"

Right click the file you want to change and select "Rename"

--
Harley BOOM GTS, Zumo 665, (2) Nuvi 765Ts, 1450LMT, 1350LM & others | 2019 Harley Ultra Limited Shrine - Peace Officer Dark Blue

Changing file name suffixes

That also works. Matter of fact, it works exactly like Windows Vista which I'm fairly used to. Thanks for the info.

--
Phil in Mentor, Ohio -- Garmin Nuvi 1450

Explorer Mouse Clicks

You can also left click a file once to highligh it, wait 1 second and click it again. This will enter rename mode and highlight just the filename to the left of the period without the file extension. I use this to copy my filenames when renaming my BMP and WAV files to match. Or I just reclick at the end of the file extension to move the cursor to the end when renaming just the extensiopn.

--
Harley BOOM GTS, Zumo 665, (2) Nuvi 765Ts, 1450LMT, 1350LM & others | 2019 Harley Ultra Limited Shrine - Peace Officer Dark Blue

I justdouble click on the

I justdouble click on the csv file name and view it with Excell.

I right-click the file,

I right-click the file, select "Open With" and select Notepad. If I want to ensure I don't lose the existing file association (Excel 2010) I make sure the "Always use this program to open files of this type" checkbox is not checked.

--
"Anyone who is capable of getting themselves made President should on no account be allowed to do the job." --Douglas Adams

csv files are txt files

csv files are text files, just with a different extension on the name. You can rename it, as you point out the command line rename is cumbersome if the name is long, but you should just be able to do an "F2" inside a file manager like explorer and rename it (as long as you don't foolishly let Windows hide the extensions). That way you just replace the csv and you're done. You can also just load it into a text editor and save it back out as a txt file (making a copy rather than renaming it). There is really no need to rename it though, as you can do anything with a csv file that you cound do with a txt file.

Wow , how easy. Thanks

Wow , how easy. Thanks

yup

bear007 wrote:
plunder wrote:

Under Windows Vista, I could change a file from a .csv format to a .txt format merely by renaming the suffix. Piece o' cake.
I now have Windows 7 and to make the same change I have to open a DOS window and issue the following kind of command:
ren "rest areas.csv" "Rest Areas.txt" Depending on the length of the file name, this could be fairly cumbersome. Is there any other ways in Windows 7 to rename the suffix of a file?

I don't quite understand why you just can't rename it while in Windows Explorer? I do it all of the time.

To have full view of your files In Explorer ...
. select "Tools > Folder Options"
. select the "View" tab
. select "Hidden filles and folders"
choose "Show hidden files, folders and drives"
. uncheck "Hide empty drives in the Computer folder"
. uncheck "Hide extensions for known file types"
. uncheck "Hide protected operating system files"

Right click the file you want to change and select "Rename"

It's because Microsoft assumes everyone is dumb and hides the extensions from the end user by its stupid default view settings.

--
http://www.poi-factory.com/node/21626 - red light cameras do not work