Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Convert a Excel to comma deliminated text file

Posted on 1999-06-25
Medium Priority
Last Modified: 2012-06-27
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.
Question by:kkeegler
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Expert Comment

ID: 1607291
Hi kkeegler!

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!


Author Comment

ID: 1607292
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.

Accepted Solution

Triskelion earned 400 total points
ID: 1607293
If you file/Save As
Pick CSV
Change the name to {whatever}.Txt, the contents will still be CSV.

Author Comment

ID: 1607294
Isn't great when things are so simple you just overlook the obvious.
Thanks for the quick help.

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question