Simple excel export script?

webrunner · 10-17-2004

I still haven't found a simple way to import Netstumbler data into Excel, preserving information like MAC address, SSID, Channel, detected speed, Vendor name, type, AP/AH, Encryption type, and the other fields available in Netstumbler.

I've tried to import the summary export data from Netstumbler, as well as importing data converted into MapSource (.wpt) etc...

I would *really* like to see some tool/script that could export all the available fields as seen in Netstumbler using semicolon (

as the separator into a simple textfile. Since i'm completely braindead on programming, i'm writing this to ask if anyone should have something like this already available...

Regards,
Webrunner

King_Ice_Flash · 10-17-2004

Why can't you just import the summary export from NetStumbler into Excel?

Just import it from excel using "tab" as the delimiting character. Works for me.

wrzwaldo · 10-17-2004

Not sure what you are doing but I just opened a summary text file in Excel and everything is there.

hoosierguy · 03-07-2006

I have the same problem this guy does. Exporting gives me: # Latitude Longitude ( SSID ) Type ( BSSID ) Time (GMT) [ SNR Sig Noise ] # ( Name ) Flags Channelbits BcnIntvl DataRate LastChannel

The ones I really need are WEP and Vender. Any ideas how I can accomplish this? Thanks!

streaker69 · 03-07-2006

Quote:

Originally Posted by hoosierguy

I have the same problem this guy does. Exporting gives me: # Latitude Longitude ( SSID ) Type ( BSSID ) Time (GMT) [ SNR Sig Noise ] # ( Name ) Flags Channelbits BcnIntvl DataRate LastChannel

The ones I really need are WEP and Vender. Any ideas how I can accomplish this? Thanks!

Yep, you can do the same thing I did when I needed an answer to that question. I searched the forums.

beakmyn · 03-07-2006

Quote:

Originally Posted by webrunner

I still haven't found a simple way to import Netstumbler data into Excel, preserving information like MAC address, SSID, Channel, detected speed, Vendor name, type, AP/AH, Encryption type, and the other fields available in Netstumbler.

I've tried to import the summary export data from Netstumbler, as well as importing data converted into MapSource (.wpt) etc...

I would *really* like to see some tool/script that could export all the available fields as seen in Netstumbler using semicolon (

as the separator into a simple textfile. Since i'm completely braindead on programming, i'm writing this to ask if anyone should have something like this already available...

Regards,
Webrunner

Points to Signature

streaker69 · 03-07-2006

Quote:

Originally Posted by beakmyn

Points to Signature

Reminds Beak to look at the date of the OP's post. I don't think you had that in your sig when it was posted.

beakmyn · 03-07-2006

Quote:

Originally Posted by streaker69

Reminds Beak to look at the date of the OP's post. I don't think you had that in your sig when it was posted.

Ah crap, there goes my Karma.

10-17-2004	#1 (permalink)
webrunner Registered Member Join Date: Sep 2004 Location: Norway Posts: 2	Simple excel export script? I still haven't found a simple way to import Netstumbler data into Excel, preserving information like MAC address, SSID, Channel, detected speed, Vendor name, type, AP/AH, Encryption type, and the other fields available in Netstumbler. I've tried to import the summary export data from Netstumbler, as well as importing data converted into MapSource (.wpt) etc... I would really like to see some tool/script that could export all the available fields as seen in Netstumbler using semicolon ( as the separator into a simple textfile. Since i'm completely braindead on programming, i'm writing this to ask if anyone should have something like this already available... Regards, Webrunner

10-17-2004	#2 (permalink)
King_Ice_Flash Alien Paranoid Stumbler Join Date: May 2003 Location: WI Posts: 2,688	Why can't you just import the summary export from NetStumbler into Excel? Just import it from excel using "tab" as the delimiting character. Works for me. __________________ "Yeah," said a voice from under the table, "you go to pieces so fast people get hit by the shrapnel."

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

10-17-2004	#3 (permalink)
wrzwaldo I amuse you? Join Date: Dec 2003 Posts: 9,147	Not sure what you are doing but I just opened a summary text file in Excel and everything is there.

03-07-2006	#4 (permalink)
hoosierguy Registered Member Join Date: Mar 2006 Posts: 1	I have the same problem this guy does. Exporting gives me: # Latitude Longitude ( SSID ) Type ( BSSID ) Time (GMT) [ SNR Sig Noise ] # ( Name ) Flags Channelbits BcnIntvl DataRate LastChannel The ones I really need are WEP and Vender. Any ideas how I can accomplish this? Thanks!