Open a csv file in Excel 2010 - a semi colon as the separator

Posted on 2014-09-22
Medium Priority
Last Modified: 2014-09-23
I've downloaded information that is in a csv format, one that uses a semi colon as the separator character.  (Commas are part of the real text in a column).
When I try to open it in Excel (a german language version) then it splits into columns based on the comma.  Not what I want.
How can I open the csv file and instruct excel 2010 to use a semi colon as the basis for splitting into columns, not the comma.

(I know I could edit the csv file, replace comma with something else then change ; to , and then open it in excel but that would get to be a pain when doing the same thing for file after file....)
Question by:AndyAinscow
  • 2
LVL 27

Accepted Solution

Glenn Ray earned 2000 total points
ID: 40338477
Use the Text Import Wizard to import the CSV file instead.

Sorry, these instructions refer to the English version of Excel 2010, but I presume they will translate to similar functions in German.

1) Open a blank workbook.
2) Excel 2010 Menu: Data, Get External Data section, "From Text"
This will open a browser window that will filter to text and delimited files.  
3) Locate your file and click the "Import" button.
This will display the first screen of the Text Import Wizard
4) Choose "Delimited" on the top and then click the "Next" button.
5) Select "Semicolon" under the "Delimiters" section on top, then click the "Next" button.
6) Define any sections as date or text, as needed, then click the "Finish" button.
This will display a final dialog box
7) Click the "OK" button.

The file should be imported into the blank workbook.

LVL 45

Author Closing Comment

ID: 40338507
So that is where it was hidden.
Excellent, thanks
LVL 27

Expert Comment

by:Glenn Ray
ID: 40338555
You're welcome.

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

607 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