Question about Microsoft Excel for PC

1 Answer

CSV file to Import correctly into Excel 2003

Hi there people

I have a csv file with some stats in , seperated by a semi-colon (;) . When I open the file , it opens directly to Excel but all in one column. Is there any way to get Excel to give me the option to open it as delimited ?

Urgently need assistance please.

Thank you

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert that gotĀ 5 achievements.


    An expert whose answer gotĀ voted for 20 times.


    An expert who has answered 20 questions.

  • Contributor
  • 35 Answers
Re: CSV file to Import correctly into Excel 2003


The key is to import the data and not open the file directly.

1. Open a Blank Workbook in Excel.
2. Data, Get External Data, Import Data. (Excel 2007 is Data, Get External Data, Data from Text)
3. Browse to your .csv file and Select "Import".
4. Import Wizard should appear.
5. Page 1 Select "Delimited"
6. Select the row which you want to start the import.
7. click "Next"
8. In the Delimiters, select "semicolon" and/or other delimiters you are using.
Note: The bottom half of the window will preview the way the data is to be imported.
9. click "Next"
10. highlight each column of your data in the window below. For each column you can specify "General", "Text", "Data", or "do not import column" using the radio buttons in the top left of the Wizard box. This is an optional step.
11. Click Finish.

I hope that helps. Please add a comment if it not clear.


Posted on Nov 22, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

2 Answers

How Ca I Import Excel Contacts into vCard?

The free Opal-Convert Excel to vCard to Excel might work for you. Opal Convert Excel to vCard to Excel

Nov 07, 2014 | Business & Productivity Software

1 Answer

Trying to import csv file.

Try opening the csv file in a text editor like Notepad++ and see if there are any special characters present in the file that might normally be invisible. There is a setting to see special characters (View > Show Symbol > Show all characters).

It looks like you might have additional carriage return or linefeed characters. You could try exporting your records again and see if the csv's match.

Apr 28, 2012 | Dmitri Karshakevich E-Z Contact Book

1 Answer

I can't find My Advanced Mail List and address book for my MAC. please help......

Here is the skinny, if you cannot find the software but still have your mml file all you have to do is download a dos program to convert your file to a csv, comma separated value file. here is the link to the database providers site:

the program dbport.exe is in the file.
Download it and unzip it in the same folder that has your mml files in it.
Then run the command dbport.exe e oldfilname.mml newfile.csv
Then open the new csv file with excel or a similar database program that will open csv files.
Then copy all the cells that have your addresses.
Paste them into notepad and then you can cut and paste from there. You can import them into outlook as contacts too. This however means you have to set up the importing correctly.

Jan 02, 2011 | Clickaction MyMailList & AddressBook...

1 Answer


Open the CSV file in an Excel spreadsheet.
Then using the Data Sort feature, you can put your data in alphabetical order.

Aug 07, 2009 | Microsoft Excel for PC

1 Answer

Is there a way to import an excel spreadsheet into quickbooks as expenses without the use of IIF?

You can save the file as a csv (comma seperated values) which will lose all the formatting in the excel sheet and save only the single worksheet. You should then be able to open this in quickbooks.

May 08, 2009 | Intuit QuickBooks: Pro 2005 for PC

2 Answers

How to convert the csv file into excel form?

When you choose to open the csv file - A pop up box will take you through the steps - You need to highlight the seperators as Excel is currently unable to do this.

Once you are going through the process you will be able to select, hash, space, comma as the seperataor into the respective columns.

Apr 27, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Opening contacts from outlook 2003 in outlook 2007

you can try this, not sure if it will work, browse to this site, and upload you .dat file

you can save it as an excel spreadsheet i believe and then use Outlook to import from a .csv and import your contacts that way....

If you need help please let me know,


Mar 01, 2009 | Microsoft Office Outlook 2007: Windows

2 Answers

Import data to excelsheet insert in mysqltable query

You can save it as csv and use the file to insert using
LOAD DATA LOCAL INFILE '/importfile.csv'
INTO TABLE test_table
(field1, filed2, field3);

Feb 20, 2009 | Microsoft Office Standard 2007: Windows

1 Answer

Converting IIF files from Quick Books Pro 2005 to CSV

Means converting IIF to CSV. Have the IIF, need it in CSV format. Can anyone propose a tool?

Jan 14, 2009 | Intuit QuickBooks: Pro 2005 for PC

1 Answer

Importing csc files

Hi freaks11,
I am DennisGladx and I hope to assist you.

This sounds like the Column of the data you want should be changed when you import the text file.
Right click on the column letter,
Left click on format cells from the drop down list and select the cell Con-tense you want to display.

Glad to be of assistance
please rate the solution - I can learn from your rating - Thanks

Oct 24, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

25,088 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides