I need to save/convert excel xls files as a tab delimited file w/a csv
extension. If I save the file as csv it makes it comma delimited, if I make
it tab delimited, it saves the file as a txt file. Trying to rename the file
to change the extension just adds a ".csv" to the file name but keeps it as a
txt file. I'm using Excel 2003.

CSV files are plain text.

Are you saying that the filename becomes: somefilename.csv.txt

If yes, then maybe you're not looking at extensions in Windows Explorer.

I'd do this:
Open Windows explorer
Tools|Folder Options|View Tab
Make sure "Hide extensions for known file types" is not checked.

If this doesn't help, you may want to share what you tried and the version of
windows you're running.

(You are doing the rename in Windows Explorer, right?)

AronS wrote:

I need to save/convert excel xls files as a tab delimited file w/a csv
extension. If I save the file as csv it makes it comma delimited, if I make
it tab delimited, it saves the file as a txt file. Trying to rename the file
to change the extension just adds a ".csv" to the file name but keeps it as a
txt file. I'm using Excel 2003.

--

Dave Peterson

That worked...I was rightclicking the file and using the Rename instead of
file explorer...but is there a way to make tab delimited default to csv
rather than txt? The reason I ask is because theres an application one of
our clients will be using that requires tab delimited csv files to import,
and I want to simplify the process for them.

"Dave Peterson" wrote:

CSV files are plain text.

Are you saying that the filename becomes: somefilename.csv.txt

If yes, then maybe you're not looking at extensions in Windows Explorer.

I'd do this:
Open Windows explorer
Tools|Folder Options|View Tab
Make sure "Hide extensions for known file types" is not checked.

If this doesn't help, you may want to share what you tried and the version of
windows you're running.

(You are doing the rename in Windows Explorer, right?)

AronS wrote:

I need to save/convert excel xls files as a tab delimited file w/a csv
extension. If I save the file as csv it makes it comma delimited, if I make
it tab delimited, it saves the file as a txt file. Trying to rename the file
to change the extension just adds a ".csv" to the file name but keeps it as a
txt file. I'm using Excel 2003.

--

Dave Peterson

I just typed the name (test.csv) instead of using test (or test.txt).

(In the file|save as dialog, after choosing text (tab delimited).)



AronS wrote:

That worked...I was rightclicking the file and using the Rename instead of
file explorer...but is there a way to make tab delimited default to csv
rather than txt? The reason I ask is because theres an application one of
our clients will be using that requires tab delimited csv files to import,
and I want to simplify the process for them.

"Dave Peterson" wrote:

CSV files are plain text.

Are you saying that the filename becomes: somefilename.csv.txt

If yes, then maybe you're not looking at extensions in Windows Explorer.

I'd do this:
Open Windows explorer
Tools|Folder Options|View Tab
Make sure "Hide extensions for known file types" is not checked.

If this doesn't help, you may want to share what you tried and the version of
windows you're running.

(You are doing the rename in Windows Explorer, right?)

AronS wrote:

I need to save/convert excel xls files as a tab delimited file w/a csv
extension. If I save the file as csv it makes it comma delimited, if I make
it tab delimited, it saves the file as a txt file. Trying to rename the file
to change the extension just adds a ".csv" to the file name but keeps it as a
txt file. I'm using Excel 2003.

--

Dave Peterson


--

Dave Peterson

That worked! Thanks!

"Dave Peterson" wrote:

I just typed the name (test.csv) instead of using test (or test.txt).

(In the file|save as dialog, after choosing text (tab delimited).)



AronS wrote:

That worked...I was rightclicking the file and using the Rename instead of
file explorer...but is there a way to make tab delimited default to csv
rather than txt? The reason I ask is because theres an application one of
our clients will be using that requires tab delimited csv files to import,
and I want to simplify the process for them.

"Dave Peterson" wrote:

CSV files are plain text.

Are you saying that the filename becomes: somefilename.csv.txt

If yes, then maybe you're not looking at extensions in Windows Explorer.

I'd do this:
Open Windows explorer
Tools|Folder Options|View Tab
Make sure "Hide extensions for known file types" is not checked.

If this doesn't help, you may want to share what you tried and the version of
windows you're running.

(You are doing the rename in Windows Explorer, right?)

AronS wrote:

I need to save/convert excel xls files as a tab delimited file w/a csv
extension. If I save the file as csv it makes it comma delimited, if I make
it tab delimited, it saves the file as a txt file. Trying to rename the file
to change the extension just adds a ".csv" to the file name but keeps it as a
txt file. I'm using Excel 2003.

--

Dave Peterson


--

Dave Peterson