Solved

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

Posted on 2014-09-22
3
273 Views
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....)
0
Comment
Question by:AndyAinscow
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 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.

Regards,
-Glenn
0
 
LVL 44

Author Closing Comment

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

Expert Comment

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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
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.
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…

685 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