Is the file named something like myfile.csv - in otherwords, does it have an
extension of .CSV?

--
Regards,
Tom Ogilvy

Katherine wrote in message
...
I have a java application that uses toCSV method for
taking a string and putting it in a csv format file. What
happens is I see most of the data go into first cell of
the spreadsheet instead of comma delimited style.

This is what it looks like in A1



AFFILIATE_ID,ASU_ID,FIRST_NAME,MIDDLE_NAME,LAST_NA ME,CURREN
TLY_ENROLLED_FLAG,SEMESTER,COLLEGE_CAMPUS_CODE,COL LEGE_OR_D
IVISION_CODE,COLLEGE_DESCRIPTION,DEGREE_CODE,DEGRE E_DESCRIP
TION,MAJOR_CODE,MAJOR_DESCRIPTION,DARS_MINOR_1,DAR S_MINOR_2
,DARS_MINOR_3,DARS_CONCENTRATION_1,DARS_CONCENTRAT ION_2,DAR
S_CONCENTRATION_3,DARS_CERTIFICATE_1,DARS_CERTIFIC ATE_2,DAR
S_CERTIFICATE_3,ACADEMIC_LEVEL_CODE,ACADEMIC_LEVEL _DESCRIPT
ION,ARIZONA_RESIDENCY_DESCRIPTION,CONDITIONAL_ADMI T_FLAG,CO
NDITIONAL_ADMIT_REASON_DESC,HIGH_SCHOOL_DEFICIENCY _FLAG,HIG
H_SCHOOL_ENGLISH_DEFICIENCY,HIGH_SCHOOL_ARTS_DEFIC IENCY,HIG
H_SCHOOL_LANGUAGE_DEFICIENCY,HIGH_SCHOOL_MATH_DEFI CIENCY,HI
GH_SCHOOL_LAB_SCIENCE_DEFICIENCY,HIGH_SCHOOL_SOCIA L_SCIENCE
_DEFICIENCY,HIGH_SCHOOL_NAME,HIGH_SCHOOL_STATE_DES CRIPTION,
HIGH_SCHOOL_CLASS_RANK_PERCENT,HIGH_SCHOOL_GPA,ABO R_HS_GPA,
ACT_COMPOSITE_EXAM_SCORE,SAT_COMBINED_EXAM_SCORE,E NROLLED_H
OURS,CHANGED_MAJOR_FLAG,CENSUS_MAJOR_CODE,CENSUS_M AJOR_DESC
RIPTION,LIVING_ON_CAMPUS_FLAG,RESIDENCE_HALL_NAME, RESIDENCE
_HALL_WING,RESIDENCE_HALL_FLOOR,DIRECTORY_RELEASE_ CODE,DIRE
CTORY_RELEASE_DESCRIPTION,LOCAL_LINE_1,LOCAL_LINE_ 2,LOCAL_C
ITY,LOCAL_STATE_CODE,LOCAL_ZIP_CODE,LOCAL_PHONE_NU MBER,EMAI
L_ADDRESS,ASU_EMPLOYEE_FLAG,ASU_JOB_TITLE,ASU_TOTA L_FTE_PER
CENTAGE,ASU_HR_DEPARTMENT_NAME,ADVISOR_LAST_NAME,A DVISOR_FI
RST_NAME,ADVISOR_EMAIL_ADDRESS,ADVISOR_EMPLOYEE_PH ONE,BELOW
_2_GPA_FLAG,CUMULATIVE_GPA,LOW_MID_TERM_GRADE_FLAG ,TAKING_G
ATEWAY_COURSE_FLAG,NEXT_SEM_PRE_REGISTERED_FLAG,NE XT_SEMEST
ER_REGISTERED_FLAG,PROBATION_FLAG,PROBATION_DESCRI PTION,COM
PLETE_WITHDRAW_FLAG,COMPLETE_WITHDRAW_DATE,COMPLET E_WITHDRA
W_REASON,ROOMMATE_ASU_ID,ROOMMATE_FIRST_NAME,ROOMM ATE_LAST_
NAME,ROOMMATE_MAJOR_DESCRIPTION,EARLY_WARNING_FLAG
1000742627,600231697,JOANNE,COY,WORTH,Y,20037,M,PP ,PUBLIC
PROGRAMS,21,BACHELOR OF ARTS,0611,JOURNALISM/MASS
COMM,null,null,null,null,null,null,null,null,null, 01,FRESHM
AN,ARIZONA RESIDENT FOR TUITION PURPOSES,N,UNKNOWN/NOT
APPLICABLE,N,,,,,,,CAMELBACK,ARIZONA,0.0,3.28,3.11 ,18,0,12.
0,N,0611,JOURNALISM/MASS COMM,N,UNKNOWN,,,,RELEASE ALL
DIRECTORY INFORMATION,2801 N 30TH
STREET,,PHOENIX,AZ,85008,602-230-
,,HUFF,KIMBERLY,Ki mberly.Hu
1000738290,601840816,TONY,HAMES,SILVAR,Y,20037,M,E S,ENGR &
APPLIED SCIENCES,32,B.S. IN ENGINEERING,0910,MECHANICAL
ENGINEERING,null,null,null,null,null,null,null,nul l,null,01
,FRESHMAN,ARIZONA RESIDENT FOR TUITION
PURPOSES,N,UNKNOWN/NOT APPLICABLE,N,,,,,,,CENTRAL-
PHOENIX,ARIZONA,0.0,3.47,3.32,20,1120,14.0,N,0910, MECHANICA
L ENGINEERING,Y,PALO VERDE MAIN,B,03,,RELEASE ALL
DIRECTORY INFORMATION,0125 PALO VERDE
MAIN,,TEMPE,AZ,85281,480-532-
,,SQUIRES,K,Email not
available,NotAvailable,N,0.0,N,Y,N,N,N,,N,,,993760 009,EVAN,
FUJAD,NONE,N,