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:
- Browse to https://www.google.com/settings/takeout and sign in to your Google Voice account and you should see:
- Click on the “Create an archive.” button, deselect ‘Select all”, then select only “Voice”. Your screen should look like this:
- 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.
- Your new archive should now be living in your Downloads folder.
- Navigate to your Downloads folder and double-click on your new Google archive zip file to open the Archive Manager:
- 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.
- 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.
- 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.
- Download my “GV_Calls_to_Tab_Delimited_Files” exe file here
- Copy the “GV_Calls_to_Tab_Delimited_Files.exe” file into your “Calls” folder and double-click it to execute it.
- 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
- Remember that these three files are ‘Tab’ delimited and not CSV. (comma separated values)
- 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:
Note that I have selected:
- Separated by
- Detect special numbers.
Spread sheet 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:
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! 🙂