Saving Excel files as delimited text

You can save Excel files as delimited text for use in other databases, such as CARS. You may choose to save the files as either tab or comma delimited (meaning either a tab character or a comma would separate each field column).

To save as tab delimited text :

Go up to "File" and down to "Save As".

Then, in the "Save as File Type:" box, click the down arrow and choose "Text (tab delimited)(*txt)".

Excel will warn you that this tab delimited text files do not support multiple worksheets. It will ask if you want to save only the active sheet. Click "Ok."

Excel will then warn you that you may lose some formatting, since tab delimited text files cannot maintain certain Excel formatting, such as special fonts, bold or itallic, or borders and shading. It will ask if you want to proceed. Click "Yes".

To save as comma delimited text :

Go up to "File" and down to "Save As".

Then, in the "Save as File Type:" box, click the down arrow and choose "CSV (Comma delimited) (*csv)".

Excel will warn you that this comma delimited files do not support multiple worksheets. It will ask if you want to save only the active sheet. Click "Ok."

Excel will then warn you that you may lose some formatting, since comma delimited files cannot maintain certain Excel formatting, such as special fonts, bold or itallic, or borders and shading. It will ask if you want to proceed. Click "Yes".

To save as fixed width :