kkeegler
asked on
Convert a Excel to comma deliminated text file
How is an excel spread sheet converted to a comma delimited text file. I have a software package to access credit bureau reports. Basically this is a fancy access database program. To speed up input and cut down on typing I can import comma delimited text files. Everyone sends me spreadsheets and I am having trouble with the conversion process.I do not need field names for the import.
ASKER
Argmyster
You are absolutely right and I did know that but I really need to get the data into a file like note pad.
The program I am using will not accept the spreadsheet conversion to file type "CSV" for some reason. It will only accept ehe extension "txt". That is what is causing my problem. I am sorry I was not more precise.
You are absolutely right and I did know that but I really need to get the data into a file like note pad.
The program I am using will not accept the spreadsheet conversion to file type "CSV" for some reason. It will only accept ehe extension "txt". That is what is causing my problem. I am sorry I was not more precise.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Isn't great when things are so simple you just overlook the obvious.
Thanks for the quick help.
Ken
Thanks for the quick help.
Ken
It's really very simple for Excel to convert to CSV (comma delimited) text file.
When are on the sheet you want to be converted to a CSV, simply click on File, Save as and from the Save as type pick CSV (Comma delimited) (*.csv) and follow along with Excel's process.
It's really very simple, unless you have specific CSV requirements, then it gets a little more trickey.
Hope this clears things up!
Argmyster...