.csv Format Questions


B

Bob

Hi,

I am having difficulties Importing into a radio program's database a
..csv Excel 2007 spreadsheet I created. Have the following questions,
please:

a. For .csv spreadsheets in general, should the entire sheet be
formatted as Text ?

(or should a column, that contains actual numbers, be formatted as
Numbers, like it would be for a regular .xls Excel format ?)

I opened up the spreadsheet in Notepad, and see that there are zillions
of commas all over the place.

Other than the commas between fields, which one would expect, what might
all these other ones be ?
Are they correct, or some artifact that got put in when I did a Copy
from a list that came off some site that I opened), Paste, and .csv
format ? Should they be removed ?

Are there (other) symbols that shouldn't be in a .csv formatted
spreadsheet ?

I was hoping to include a small snip of a part of the Notepad opening,
but apparently it won't let me put it here. Would be very helpful in
explaining what I see there.

Any suggestions on how to Post it ?
Could do offline, of course, if anyone would like to see it ?

Thanks again for all the past help; much appreciated.

Bob
 
Ad

Advertisements

G

Gord Dibben

I would suggest you open the file in Notepad and save as a *.txt file.

Open that with Excel and use the Text Wizard to parse, most likely comma
delimited.

You can designate what each column format is to be...............Text, numeric,
date.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Differences Between Two Spreadsheets ? 2
open UTF8 CSV 0
Excel And Notepad 3
.csv Commas ? 2
Hidden Formating Or Delimiters: Showing Of ? 2
Creating a csv 4
Excel CSV Files; Creating Of 3
Quote Marks Question 2

Top