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

  • 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...

×

Ad

1 Answer

  • 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

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

Posted on Nov 22, 2007

×

Ad

1 Suggested Answer

Anonymous

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

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.

Mar 19, 2015 | pcAmerica Retail POS system

3 Answers

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.

Aug 03, 2014 | Google Gmail

1 Answer

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!

Feb 18, 2011 | Xerox WorkCentre Pro 123/128 Printer

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:
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.

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

1 Answer

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.

Dec 27, 2010 | Acer TravelMate 2300 Notebook

3 Answers

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!

Feb 03, 2010 | Xerox WorkCentre C2424DN All-In-One Laser...

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

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
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(field1, filed2, field3);

Feb 20, 2009 | Microsoft Office Computers & Internet

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

25,224 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

ThaMp3Doctor
ThaMp3Doctor

Level 3 Expert

8597 Answers

Scoee Scoffer

Level 2 Expert

162 Answers

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

Answer questions

Manuals & User Guides

Loading...