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

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

Kurt Van Etten Nov 22, 2007

Here is the official Microsoft help.

http://office.microsoft.com/en-us/excel/...

kpenguin

Add Your Answer

Upload

Upload an image from your computer

Uploading: 0%

my-video-file.mp4

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

Loading...

Include an image. It's worth a thousand words.

prev next

Related Questions:

0helpful

4answers

How do you convert CSV files to vCard?

Google is your friend.

Maybe this helps convert to what you want:

https://support.office.com/en-us/article/import-contacts-from-an-excel-spreadsheet-to-outlook-f6483469-0684-4c30-82c5-c881930f5451

Read full answer

Feb 28, 2019 • Individual Computers & Internet

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.

Read full answer

Mar 19, 2015 • pcAmerica Retail POS system

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.

Read full answer

Aug 03, 2014 • Google Gmail

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!

Read full answer

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

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.

Read full answer

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

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.

Read full answer

Dec 27, 2010 • Acer TravelMate 2300 Notebook

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!

Read full answer

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

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.

Read full answer

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

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.

Read full answer

Apr 27, 2009 • Microsoft Office Excel 2003 for PC

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);

Read full answer

Feb 20, 2009 • Microsoft Office Computers & Internet

Not finding what you are looking for?

View Most Popular

Excel for PC

Computers & Internet

How do you convert CSV files to vCard?

Individual Computers & Internet

Open Questions:

0answers

I have three columns that equal a sum column. I now want to take the sum column and find out what 3.33 percent will be. This is a commission.

Read full answer

Be the first to answer May 12, 2016 • Microsoft Excel for PC

0answers

How do you float a bar in a barchart that starts at 2% so it doesn't sit on the 0% axes line One of our bars starts at 2% the bar is sitting on the 0% line - we wish to have white space between the 0% line and where the bar starts at 2%. Please advise how we go about this. Ta

Read full answer

Be the first to answer Jan 28, 2016 • Microsoft Excel for PC

0answers

apphangxprocb1 excel Description: A problem caused this program to stop interacting with Windows. Problem signature: Problem Event Name: AppHangXProcB1 Application Name: EXCEL.EXE Application Version: 14.0.7109.5000 Application Timestamp: 522a4031 Hang Signature: dce7 Hang Type: 128 Waiting on Application Name: lsass.exe:lsapolicylookup Waiting on Application Version: 0.0.0.0 OS Version: 6.1.7600.2.0.0.256.4 Locale ID: 1033 Additional Hang Signature 1: dce7acd044f5a3dc818b2b4d62cced33 Additional Hang Signature 2: e669 Additional Hang Signature 3: e6693f359cc13219823494a4b3d07098 Additional Hang Signature 4: dce7 Additional Hang Signature 5: dce7acd044f5a3dc818b2b4d62cced33 Additional Hang Signature 6: e669 Additional Hang Signature 7: e6693f359cc13219823494a4b3d07098 Read our privacy statement online: http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409 If the online privacy statement is not available, please read our privacy statement offline: C:\Windows\system32\en-US\erofflps.txt

Read full answer

Be the first to answer Dec 12, 2013 • Microsoft Excel for PC

0answers

Panduit Easymark does not acknowledge Excel 2010 When importing data from Excel 2010 spreadsheet to Panduit Easy Mark a message appears saying "you must install Excel"

Read full answer

Be the first to answer Nov 05, 2013 • Microsoft Excel for PC

See all Microsoft Excel for PC Questions

25,250 views

Ask a Question

Usually answered in minutes!

Check Out the Mobile Browsers Report

View all Fixya Reports

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

Answer questions

Manuals & User Guides

Have a manual for Microsoft Excel for PCs? Or just drag it here!

Related Topics:

CSV file to Import correctly into Excel 2003