How to Save a CSV Tab Delimited

mstuf

Active Member
Joined
Feb 4, 2003
Messages
321
Office Version
  1. 2016
Platform
  1. Windows
Hello --

I am using Excel 2002 ( Office XL ) -- A recent contact I have made requires that I send a file in .CSV Tab Delimited Format.

I am only offered CSV Comma Delimited , CSV Macintosh and CSV DOS as Save As Options.

The Only Save As Tab Delimited option that I am offered is as "Text (Tab Delimited) "

Is there any way to accomplish this ?

Thanks as Always
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
.CSV stands for comma separated values. In its simplest form, this requires that each field in a record has a comma between them, and each record would be followed by a carriage return. http://en.wikipedia.org/wiki/Comma-separated_values

Tab delimited format requires requires that each field in a record has a tab between them, and each record would be followed by a carriage return. http://en.wikipedia.org/wiki/Tab-separated_values

".CSV tab delimited" is a mashup of these and does not make sense. I would go back to the person that the contract is for and get an example of the data format they desire, rather than an inaccurate description.

If they continue to require ".CSV tab delimited", you could provide the data twice as .CSV and Text (Tab Delimited) and say that you read the contract as ".CSV (and) tab delimited", since the original specification did not exist.
 
Upvote 0

Forum statistics

Threads
1,224,522
Messages
6,179,297
Members
452,903
Latest member
Knuddeluff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top