Solved

Exporting data from Excel to a Comma-delimited text file

Posted on 2011-09-08
2
337 Views
Last Modified: 2012-05-12
I see there is an option in Excel to import data from a comma delimited text file.  Is there a way to export data to a comma-delimited text file?
0
Comment
Question by:morinia
2 Comments
 
LVL 10

Assisted Solution

by:Fayaz
Fayaz earned 125 total points
ID: 36504240
You can save the file as Comma Delimited, i.e. Open the Excel file, choose save as and then select the file type as CSV-Comma Delimited and save it. Open the file using notepad to see comma delimited values.
0
 
LVL 31

Accepted Solution

by:
Rob Henson earned 125 total points
ID: 36504763
If the file has multiple worksheets, only the active sheet will be copied to the CSV file.

Ideal if you want to export certain data for transferring to another system.

See similar:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27292477.html

Thanks
Rob H
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

707 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now