Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 617
  • Last Modified:

Import CSV file to Excel 2010

Import CSV file to Excel 2010

I am trying to import CSV file to Excel 2010, but I cannot get the separated columns. it puts all fields that are separated with comma in one column of Excel. I need them separated in columns.
in the wizard I selected comma, but still does not work.

Any help ?

Thanks
0
jskfan
Asked:
jskfan
2 Solutions
 
Missus Miss_SellaneusCommented:
Can you attach the first couple of lines of the CSV file here? Copy the file to a different name and delete the extra lines instead of copying and pasting text, just in case the problem is related to unseen characters.
0
 
Spyder2010Commented:
Open your .csv file like you have been, so that all data is in column1.  Highlight column1.  Click on the 'Data' tab on the Ribbon. Click on the 'Text to Columns' button.  Choose 'Delimited', click Next.  In the Delimiters area, highlight only 'Comma', click Next.  Format column data on the next screen if you want, if not, click Finish.  This will separate your data into columns delimited by commas.

If this does not work, you might want to try opening your .csv file in a word editor, and verify that you actually have comma separated data, and not some other delimiter.  Find and Replace can help fix this if this is the issue.
0
 
jskfanAuthor Commented:
thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now