+- hashcat Forum (https://hashcat.net/forum)
+-- Forum: Support (https://hashcat.net/forum/forum-3.html)
+--- Forum: hashcat (https://hashcat.net/forum/forum-45.html)
+--- Thread: Recovered hashes spreadsheets help (/thread-9033.html)
Recovered hashes spreadsheets help - buza - 03-11-2020
Hi, i'm fairly new to the picture, just got a handle on output files and management. I run an attack on a file that has usernames and hashes formatted like
Code:
username:hashafter the attack if remove the dictionaries and run
Code:
--username --show outputfile.txtCode:
username:hash:recoveredPassThe question is the following, can anybody reccomend a way to pull the results from the file into an excel file divided by ordinated columns : username / hash and recovered passes?
RE: Recovered hashes spreadsheets help - philsmd - 03-11-2020
I'm pretty sure you can just open the outfile/potfile with any spreadsheet viewer/editor as a CSV file where the separator is just ":" (or the -p command line value).
I'm not sure why some people need to have large list within a spreadsheet, though. I would say it's discouraged to do so... it most of the time doesn't make any sense (but of course there could be exceptions). The format is already good and you could just open it in any fast/advanced text editor... or even parse/filter/grep it with command line tools (for instance "cut"/"grep" on linux)
RE: Recovered hashes spreadsheets help - buza - 03-11-2020
Thanks for the help, i guess i just like to browse easily through the results to sort and analize with more ease. Regarding that excel file it's just because i'm comfortable with browsing and modifying in that environment.
I'll update the thread later in case i'll ever write a python script for pulling the fields from the outfile into an excel spreadsheet.
RE: Recovered hashes spreadsheets help - philsmd - 03-11-2020
just to be very clear: you do NOT need any python script to do this.
just open the document as a CSV file (with : as a separator).. Comma-separated values (CSV) files can typically use any sepataor that you specify (excel, openoffice, libreoffice, etc)
RE: Recovered hashes spreadsheets help - buza - 03-11-2020
(03-11-2020, 11:42 PM)philsmd Wrote: just to be very clear: you do NOT need any python script to do this.Oh! Thanks for being very clear because it actually went over my head the first time.
just open the document as a CSV file (with : as a separator).. Comma-separated values (CSV) files can typically use any sepataor that you specify (excel, openoffice, libreoffice, etc)
Thanks for the help!