Download your Google Voice minute usage.

Google Takeout allows you to download an archive file containing the information from your various Google applications such as all your emails in your Gmail account and all your calls and texts in your Google Voice account.

Unfortunately, each Google Voice call is in a separate file, making such tasks of adding up your total minutes used or sorting by phone number called very tedious. The following will provide a way to load these individual files into a single spread sheet. Once that is done, you can total, sort and analyse to your heart’s content!

For our purposes, we only download an archive containing your Google Voice calls –Β  here is how to do it:

  1. Browse to https://www.google.com/settings/takeout and sign in to your Google Voice account and you should see:takeout welcome screen
  2. Click on the “Create an archive.” button, deselect ‘Select all”, then select only “Voice”. Your screen should look like this:configure your data archive
  3. Now click the large red “CREATE ARCHIVE” button near the top of the screen and you will be sent to the “Download a copy of your data” page where you simply click the “Download” button and then select “Save file” in the window that appears.Download archive
  4. Your new archive should now be living in your Downloads folder.
  5. Navigate to your Downloads folder and double-click on your new Google archive zip file to open the Archive Manager:Archive manager
  6. Your Archive Manager may look different from the image above but just click on “Extract” in whatever manager you have and follow along with the instructions to extract the archive. Normally, the default will extract to a file folder in your Downloads folder that will have the same name, more or less, as did the archive file – but it will be a file folder.
  7. Open your new file folder and you will see a sub-folder called ‘Voice’ – open it. Now you will see another sub-folder called “Calls” and probably 2 files: Bills.html & Phones.vcf. We’re interested in the “Calls” sub-folder but feel free to open the 2 files to have a look.
  8. Open the “Calls” folder and you will find an html file for each phone call that took place on your Google Voice account. You can open any file in you default browser by just double-clicking on it.

I have created a Pascal program (don’t laugh) that ‘reads’ through all the html files in the “Calls” folder and extracts the relevant information and places it into three files: Placed_Calls.txt, Received_Calls.txt & Missed_Calls.txt.

These files can then be opened/Imported by Excel or LibreOffice Calc (and probably other programs) where you can analyse your usage of Google Voice.

IMPORTANT: These two files are ‘Tab’ delimited.

Here’s how to do it:

Note to “Chrome Browser” users: When you download my exe file, you may get a message that the file may be ‘malicious’; it is not! In the Chrome browser, you will need to go to: Settings -> Show advanced settings -> and under ‘Privacy’ you will need to deselect “Enable phishing and malware protection“. Then Chrome will allow the download.

  1. Download my “GV_Calls_to_Tab_Delimited_Files” exe file here
  2. Copy the “GV_Calls_to_Tab_Delimited_Files.exe” file into your “Calls” folder and double-click it to execute it.
  3. The program will create a new sub- folder, within your “Calls” folder, named: “GV_CSV_Files”. Within that folder, it will create the three files mentioned above: Placed_Calls.txt,Received_Calls.txt & Missed_Calls.txt
  4. Remember that these three files are ‘Tab’ delimited and not CSV. (comma separated values)
  5. Open either file with Excel or LibreOffice Calc.

I do not own Excel, so I use LibreOffice Calc. Here is a screen shot of the “Text Import” window that opens when I open a .txt file with it:

Text Import

Note that I have selected:

  1. Separated by
  2. Tab
  3. Detect special numbers.

Spread sheet example:

Placed Example

TRM (Total Rounded Minutes) is the “Duration” column rounded up to whole minutes – 00:2:10 becomes 3 minutes.

Both is simply the first 6 digits of any North American phone number, without the country code. (Country codes other than ‘1’ are not distribute to “Area”, “RC” or “Both”.)

Once the file opens into your spread sheet, you will need to “Format” two columns:

  1. Time
  2. Duration

Format to: TimeΒ  00:00:00 – example: 13:37:46

Also, the “Date” column will probably need to be widened.

If you use Linux, you can read hwdsl2’s Blog here – he is a real whiz!

If you promise not to laugh at my rusty programming skills, you can download my source files from my DropBox here.

For those not familiar with Pascal, the file that contains the main program is “Unit1.pas” which may be opened with any text editor.

Feel free to install Lazarus on your PC and then, have your way with my code! πŸ™‚

24 Responses to Download your Google Voice minute usage.

  1. Dan T says:

    Do you have something that can sort texts instead of calls? I have thousands of texts and have no way to sort them into a spreadsheet πŸ™

  2. Meghan says:

    Thank you for this application. It has been super useful. Have you or anyone else had issues with the extraction not working on all of the files. I have over 8,000 files in my “calls” folder yet the software is only processing 1,600 of those. Thanks for any suggestions.

  3. Todd says:

    Did the ability to have a column of notes ever get included? I make notes with many of the calls.

    • Rob says:

      Hi Todd:

      I have been away from my programming for quite a while but I am “heading back in” during the next few months.

      I will let you know when it does “Notes”.

      Thanks for the wake up call.

      Rob.

  4. RSUN says:

    Appreciate your great work! Thanks a lot!

    It parses all call log files with “Placed”, “Received”, and “Missed”. However, the calls made using Hangouts leave log files named as below (no “placed” cotained in the file name):
    +1XXXXXXXXXX – 2015-03-01T00_32_24Z.html

    Is it possible to parse those logs as well? That will make all_calls list perfect.

    Thanks,

    Rick

    • Rob says:

      Hi Rick;
      I will look into this tomorrow – out of town at the moment.
      I also plan to attempt to outload the “notes’ as well.
      Rob.

  5. TVC says:

    This was so immensely helpful! Bless you for making this publicly available. It worked fantastically.

  6. ELEOS Support says:

    Thank you so much for this tool! It is fantastic. I really appreciate you making it available to everyone. Thank you! Thank you! I really needed something like this to help us keep track of our tech support calls.

    If you are still tweaking the program and are looking for suggestions…it would be fantastic if the transcript and the notes could also import into the spreadsheet. We use the notes to record a bit about how we resolved the support issue, so it would be nice to have that available in the spreadsheet for analysis.

  7. Ben says:

    Hey Rob,

    In the google voice history, you can add notes about each call – I use it to write what job function I did relative to each one. It would be cool if it also came into the spreadsheet as another column related to that entry.

    Thanks,
    Ben

  8. Ben says:

    Thank you so much for this tool. We are using google voice as a help line for an upcoming event, and I needed the call data to give to my client. It took me an hour searching around online and I finally stumbled by this post – thank you, thank you!

    p.s. It would be even cooler if it preserved the notes πŸ˜‰

    • Rob says:

      Hi Ben:

      I am glad that it was useful to you. πŸ™‚

      I’ll take a look at ‘preserving the notes’ but I am not too sure that I know what you mean.

      Rob.

  9. Rick says:

    I really want this to work! But it won’t unfortunately. I hit start and it wont run. It created the folder, but tells me I am denied and don’t have access…then says to hit cancel to kill the program or hit OK to run and risk ruining the files. I hit OK, and waited, but it still wouldn’t start “counting” files. I’m running Windows 7. I definitely need this solution for my GV call history into excel! Hope you can help..

    • Rob says:

      Hi Rick:
      I am sorry that you are having difficulty.
      I just ran through the tutorial again, step by step, and could not duplicate your situation.
      It is important that you ‘extract’ the take-out achive and then copy my exe file into the ‘Calls’ sub folder created by extracting the archive.
      Did you do this?
      Rob.

    • Rob says:

      Hi Rick:
      What is the exact wording of the ‘access denied’ message that you get?
      I would really like to get to the bottom of this problem in case it is affecting other people as well.
      Rob.

  10. ryan says:

    getting an error that says your exe “is not a valid Win32 application”. I’m running Windows XP 32 bit.

    • Rob says:

      Hi ryan:

      I am sooooo sorry. I mixed up the 64-bit version with the 32-bit version – my apologizes.

      The 32-bit version is now available for download.

      Pls let me know if you have a problem.

      Rob.

  11. jsmoov says:

    any way to get this thing to scrape the missed calls. Those are the ones i need a list of, or does anyone else have any other ideas on how to do this?

Leave a Reply

Your email address will not be published.