Importing a csv file into an Excel

K

KalyanS

Hello all,

I have the following content into a notepad which I am trying to
import into a spreadsheet. When I chose the default options
(Delimited, Tab as the Delimiter, General column data format) it
putting each line into a single column instead of putting each field
into different columns. What import options should I choose to achieve
this?

0909180735,00:1f:
41:28:fc:e0,wlan8,41414257,3973,17,8,63,31059,2100084,0,0,0,0,0,0,234,2374,0,0,0,0,0,0,2404393,134325
0909180735,00:1f:
41:28:fc:e0,wlan9,27548508,24873,0,16986,21,13197,0,1,0,0,0,0,0,0,3394,0,0,0,0,2,0,615047,7224
0909180735,00:1d:2e:16:3a:
80,wlan8,39068315,5464,5,11,741,43442,2267321,0,0,0,0,0,0,225,5888,0,0,0,0,0,0,2683222,158798
0909180735,00:1d:2e:16:3a:
80,wlan9,1540,0,0,4,0,56,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,263,31
0909180735,00:1f:
41:30:89:d0,wlan8,35962005,1896,3,5,4607,53176,2418706,4,1,0,0,0,0,2968,5932,0,1,0,0,4,0,2816038,175509
0909180735,00:1f:
41:30:89:d0,wlan9,47,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
0909180735,00:1f:41:30:5f:
10,wlan8,39602898,4827,7,4,645,37103,2081964,0,0,0,0,0,0,175,3508,0,0,0,0,0,0,2423358,152489
0909180735,00:1f:41:30:5f:
10,wlan9,18627441,9127,0,11166,296,11065,0,0,0,0,0,0,0,0,2282,0,0,0,0,2,0,410255,4605
0909180735,00:1d:2e:
02:7d:d0,wlan8,44617533,3912,29,3,126,25186,1829227,0,0,0,0,0,0,249,5,0,0,0,0,0,0,2076109,116224
0909180735,00:1d:2e:
02:7d:d0,wlan9,46513358,42078,0,27786,126,25640,0,1,0,0,0,0,0,0,5672,0,0,0,0,2,0,1020481,11606
0909180735,00:1f:
41:36:33:70,wlan8,37715394,5435,12,6,256,51418,2229355,0,0,0,0,0,0,32,5878,0,0,0,0,0,0,2656709,162430
0909180735,00:1f:
41:36:33:70,wlan9,4906,0,0,53,1,198,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,692,120

TIA
 
J

Joerg Mochikun

CSV=Comma Separated Values,
so using comma instead of Tab would seem to be a good choice...

Joerg
 

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

Top