How can I convert an ordinary text file to a .csv file, and import it to Excel?

Posted by Xavierjazz on Super User See other posts from Super User or by Xavierjazz
Published on 2010-06-16T15:43:21Z Indexed on 2010/06/17 15:24 UTC
Read the original article Hit count: 200

Filed under:

windows-xp

|

excel

|

convert

|

csv

I have a group of names and addresses that I would like to import into Outlook.

At the moment I have imported them into Excel, but all names and addresses are in one long entry.

All are already separated by a comma.

How can I get Excel to select each "value" and move it to a separate cell?

Edit: I had already tried taking a text file and saving it as a .csv file. However, all contacts load into a single cell.

I am using Excel 2003.

Thanks.

© Super User or respective owner

Related posts about windows-xp

Windows XP - Security Update for Windows XP (KB923561) (KB946648) (KB956572) (KB958644)

as seen on Super User - Search for 'Super User'
My father's computer has Windows XP, but when I try to install the service packs it always fails. What gives? Here are the errors that I get in the event log: Date: 2/6/2010 Time: 12:02:18 AM Type: Error User: N/A Computer: EVO Source: Windows Update Agent Category: Installation Event ID: 20 Installation… >>> More
Restore Bak File created on Windows XP pro in Windows XP Pro 64

as seen on Super User - Search for 'Super User'
I have a situation that I need help with. I backed up my Files on Windows XP using the System BackUp utility/wizard, and then Installed a new operating system on the machine. Now I want to restore my old files via the .bak file but it is not being recognized at all. Did I do this wrong or is there… >>> More
Installed Ubuntu 12.04.01 with Windows XP but lost access to Windows XP

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
The First time I tried to install Ubuntu the installer installed it on my D drive. This resulted in only booting to Windows XP with no access to Ubuntu. I had to download a disk partitioning program to undo all of this. A tip from the Internet said to create a partition on the C drive for Ubuntu,… >>> More
Replace dual-XP installs with single-XP install and repartition drive?

as seen on Super User - Search for 'Super User'
Hello, The Current Situation I have a hard drive that currently is split up like so: Primary Partition C: 9.77 GB NTFS Healthy (System) with XP Pro (in Polish) installed Extended Partition D: 39.82 GB NTFS Healthy (Boot) with XP Pro (in English) installed … >>> More
How do I connect two computers with a LAN cabel?

as seen on Super User - Search for 'Super User'
I have two machines - Windows XP and a laptop using Windows 7. I connected them with a WLAN cable. On the Windows XP machine, I set the IP address to 192.168.0.10. On the Windows 7 laptop, I set the IP address to 192.168.0.20. The laptop can see the Windows XP machine, but Windows XP machine cannot… >>> More

Related posts about excel

Excel error "This workbook contains Excel 4.0 macros or Excel 5.0 modules"

as seen on Super User - Search for 'Super User'
I have a workbook that was protected via the Protect Workbook feature. It was sent to someone else to modify. When they sent it back, it was unprotected and when I try to reprotect it I get this error, "This workbook contains Excel 4.0 macros or Excel 5.0 modules. If you would like to… >>> More
Open excel 2007 excel files and save as 97-2003 formats in VBA

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a weird situation where I have a set of excel files, all having the extension .xls., in a directory where I can open all of them just fine in Excel 2007. The odd thing is that I cannot open them in Excel 2003, on the same machine, without opening the file first in 2007 and going and saving… >>> More
Creating Excel or Excel compatible Spreadsheets on the server side in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format. I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed. For this web project I'm building, the server doesn't have office installed… >>> More
vba access values from excel workbook from another excel workbook

as seen on Stack Overflow - Search for 'Stack Overflow'
Any ideas why this code will not work? Workbooks.Open Filename:="C:\a.xls" Workbooks("a.xls").Activate Worksheets("b").Select Dim OutputArray(10, 10) OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value I'm trying to run a macro in one file (unnamed… >>> More
Excel workbook event order and usage when closing Excel

as seen on Stack Overflow - Search for 'Stack Overflow'
Given the following workbook events: BeforeClose BeforeSave Please tell me: - The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving. - What happen if user cancels one of the saving… >>> More