Microsoft Excel for PC Logo
Posted on Nov 22, 2007

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

  • water610 Nov 21, 2008

    It will not separate from each other. I am using delimited and comma but it still remains together?

  • Anonymous Mar 16, 2014

    power point file in my computer ****** and f:/ drive in .ppt files encrypted? how to dycrypt .ppt (power point files) pls me your important and urgent guidline sir...

×

1 Answer

Kurt Van Etten

Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

Governor:

An expert whose answer got voted for 20 times.

Hot-Shot:

An expert who has answered 20 questions.

  • Contributor 35 Answers
  • Posted on Nov 22, 2007
Kurt Van Etten
Contributor
Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

Governor:

An expert whose answer got voted for 20 times.

Hot-Shot:

An expert who has answered 20 questions.

Joined: Sep 20, 2007
Answers
35
Questions
14
Helped
54303
Points
99

Rudils,

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.

kpenguin

×

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1helpful
2answers

I have a .csv file with include counted items numbers. How can I add my pcamerica inventory system easily?

most spreadsheet programs have the ability to import .csv files. Be sure to use a blank sheet.
0helpful
3answers

How do I add an email address to "other contacts" in my gmail contacts?

That probably depends upon the 3rd party. You MIGHT try exporting your contacts list (as a .csv, or Comma Separated Values, file). You can then open that file with Excel or OpenOffice Spreadsheet and change it around however you like. Your 3rd party software may be able to import the .csv file, or you may be able to reimport it into gMail and have it automatically rearrange your contacts.
0helpful
1answer

I"m trying to import a addresses using a csv Excel

The problem occurs, only when the CSV file was edited and saved by MS Excel. The solution: use only Notepad, Excel never!
0helpful
1answer

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:
http://vermontdatabase.com/mymail.htm

the program dbport.exe is in the dbport.zip 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.
0helpful
1answer

Configure.csv

CSV means:
A comma-separated values or character-separated values (CSV) file is a simple text format for a database table. Each record in the table is one line of the text file. Each field value of a record is separated from the next by a character (typically a comma, but some European countries use a semi-colon as a value separator instead). Implementations of CSV can often handle field values with embedded line breaks or separator characters by using quotation marks or escape sequences. CSV is a simple file format that is widely supported, so it is often used to move tabular data between different computer programs that support the format. For example, a CSV file might be used to transfer information from a database program to a spreadsheet.
A comma-separated values or character-separated values (CSV) file is a simple text format for a database table. Each record in the table is one line of the text file. Each field value of a record is separated from the next by a character (typically a comma, but some European countries use a semi-colon as a value separator instead). Implementations of CSV can often handle field values with embedded line breaks or separator characters by using quotation marks or escape sequences. CSV is a simple file format that is widely supported, so it is often used to move tabular data between different computer programs that support the format. For example, a CSV file might be used to transfer information from a database program to a spreadsheet.
1helpful
3answers

Xerox 7345 Address Book

The problem occurs, only when the CSV file was edited and saved by MS Excel. The solution: use only Notepad, Excel never!
0helpful
1answer

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.
1helpful
2answers

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.
0helpful
2answers

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
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(field1, filed2, field3);
Not finding what you are looking for?

25,278 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...