csv file import

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

d_kight - 14 Jul 2006 17:41 GMT

I have tried and succeeded in importing a .csv file into excel. This file has
numerical values. After converting the file, I try and add a few of the
numbers in one of the colunms and my answer is always #VALUE; which tells me
those numbers are being read as values and not numbers. HOW do I import the
file or what changes do I need to make in order to get those numbers to be
seen as Numerical after the file is imported?

Reply to this Message

Gail - 14 Jul 2006 17:46 GMT

If you can change the name of the file you are importing into excel to one
ending in .txt you will get the import wizard open and that will allow you
to change formatting for columns.

If this is not a solution, there is an Add-in available (free) called ASAP
Utilities that can help in changing the numbers to actual numbers rather
than text

>I have tried and succeeded in importing a .csv file into excel. This file
>has
[quoted text clipped - 5 lines]
> file or what changes do I need to make in order to get those numbers to be
> seen as Numerical after the file is imported?

Reply to this Message

d_kight - 14 Jul 2006 18:26 GMT

thanks Gail, However, the import wizard seems to work fine coming form a .csv
file going to a .xl file (or so it seems). Are you suggesting that I re-save
the .csv file as a .txt file THEN use the Import wizard in Excel?

> If you can change the name of the file you are importing into excel to one
> ending in .txt you will get the import wizard open and that will allow you
[quoted text clipped - 13 lines]
> > file or what changes do I need to make in order to get those numbers to be
> > seen as Numerical after the file is imported?

Reply to this Message

JLatham - 15 Jul 2006 16:19 GMT

Try this method? I think step 3 of this wizard is where you will find a
solution.
From the menu bar
Data | Import External Data | Import Data
When the open file window comes up, choose File Types with the .csv entry in
it. Continue on and identify your file and then the Wizard gets started for
real. Make sure that you set things along the way, like the separator
itself. In Step 3 of 3 make sure that all columns are set to "General" type.
That should import numbers as numbers, text as text, dates as dates, etc.

Before you start you might want to select all the cells on your worksheet
and use Edit | Clear | Format
to make sure that the cells/columns on it are not formatted as Text. I'm
not certain if the choice made with the data import wizard overrides any
formatting already on a sheet or not right at this moment.

> thanks Gail, However, the import wizard seems to work fine coming form a .csv
> file going to a .xl file (or so it seems). Are you suggesting that I re-save
[quoted text clipped - 17 lines]
> > > file or what changes do I need to make in order to get those numbers to be
> > > seen as Numerical after the file is imported?

Reply to this Message

d_kight - 17 Jul 2006 16:38 GMT

Thanks Latham, I will definitely give that a go! and Steve, the format is in
.csv. Is that what you are refering to?

> Try this method? I think step 3 of this wizard is where you will find a
> solution.
[quoted text clipped - 33 lines]
> > > > file or what changes do I need to make in order to get those numbers to be
> > > > seen as Numerical after the file is imported?

Reply to this Message

d_kight - 17 Jul 2006 17:07 GMT

JLatham,
I did everything that you suggested and I tried to add a couple of simple
numbers. I continue to come up with #VALUE!.
Is there something I am missing?

D_Kight

Reply to this Message

SteveW - 15 Jul 2006 19:43 GMT

If it's a comma seperated file - it should load correctly.

what format is the data ?

and as mentioned - is it plain text

Steve

> I have tried and succeeded in importing a .csv file into excel. This
> file has
[quoted text clipped - 6 lines]
> be
> seen as Numerical after the file is imported?

Reply to this Message