Software

Ask something
Discussion Locked

Comma Delimited...

0 helpful
9 replies

by keepbelieving

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Greetings,

By any chance, is anyone familiar with what a comma delimited file is? If so, how could it be transferred to Excel?

9 replies

by syscokid

It's simply a text file where each field in a record is separated by a comma and usually has the entension .csv..

In Excel, click file, open, and in the drop-down box for "Files of Type", select Text Files (*.prn, *.txt, *.csv).

by keepbelieving

Hi SyscoKid,

Thank you so very much. Your response was on the mark. I have not had any problems since following your procedure.

Have a good one.

by dklippert

If you have any trouble with how the fields look when they are imported, Change the extention to something like .DAT
Now wehen you open it with Excel the parsing wizard will walk you through the process.

by alpha-male

Comma delimited files are pretty much "generic spreadsheets". The comma separates the different fields so you can import the data into whatever you are working with. Excel can open and export this kind of file without any problems. They will typically have teh .csv extension.

Here is a pretty good file talking about the format etc:

http://www.homestore.com/shop/welcomewagon/merchtools_pdf/HelpCSV-v2.pdf

(delete any spaces in the URL)

This kind of thing is very useful in creating mail merges or porting data between unlike applications.

Good luck...hope this helps!

by joe

Have you tried to open Excel and go to DATA tab and import external data and choose that file? It will configure it for you. HTH

This discussion is closed to new replies.