Go Back   Tech Support Forum > Microsoft Support > Microsoft Office support

EXCEL How do I order csv data into columns?

This is a discussion on EXCEL How do I order csv data into columns? within the Microsoft Office support forums, part of the Tech Support Forum category. Hi I have exported data from our software package into a csv document. However, all the data is squished into


Closed Thread
 
Thread Tools Search this Thread
Old 02-04-2009, 02:14 AM   #1
Registered Member
 
Join Date: Feb 2009
Posts: 2
OS: Windows XP



Hi
I have exported data from our software package into a csv document. However, all the data is squished into column A and separated by commas.

I would like to separate the data into separate columns. Does anyone know how I can do this??

thanks
Nicole

__________________
jerezgirl is offline  
Old 02-04-2009, 06:17 AM   #2
Registered Member
 
Join Date: Feb 2009
Posts: 3
OS: Windows XP & Vista



Try this...

Open Excel. Go to File --> Open.

Search for the csv file, 'change file of type' to 'all files' if necessary.

When you select the file and open it, you should run the text import wizard.

Select Delimited and Next

Change the delimiters to Comma and Next.

Click finish.

If it still doesn't work, open the csv file into NotePad. Save as a different file name and then run through this procedure

__________________
simjambra is offline  
Old 02-05-2009, 04:05 AM   #3
Registered Member
 
Join Date: Feb 2009
Posts: 2
OS: Windows XP



Many thanks for taking the time and trouble to answer my question.

Nicole
__________________
jerezgirl is offline  
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Post a Question


» Site Navigation
 > FAQ
  > 10.0.0.2


All times are GMT -7. The time now is 04:14 AM.


Copyright 2001 - 2014, Tech Support Forum

Windows 7 - Windows XP - Windows Vista - Trojan Removal - Spyware Removal - Virus Removal - Networking - Security - Top Web Hosts