tblinc
asked on
auto import csv in excel
Hello
I receive multiple CSV file every week I and want to know if there is a way to automatically format them to fit an excel spreadsheet using multiple column instead of having all the data in only one column when I open the CSV ?
Thanks
I receive multiple CSV file every week I and want to know if there is a way to automatically format them to fit an excel spreadsheet using multiple column instead of having all the data in only one column when I open the CSV ?
Thanks
ASKER
it looks like this:
150551, ,CC32PC-24V PWR TO CC,D,EACH,,,,,0,0,0,0,0,04 -JUN-2012, Weekly,
150551, ,CC32PC-24V PWR TO CC,D,EACH,,,,,0,0,0,0,0,04
In your Windows regional settings, what do you have listed as the List Separator?
ASKER
semicolumn ;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
"Michael Smith",1,2,3,"x"
or like this:
"Michael Smith,1,2,3,x"
If the latter, Excel is interpreting it as one value that has commas in it, and the answer is to fix the formatting at the source.