I have a Google voice phone number ([login to view URL]) and by using
Google takeout ([login to view URL]) I am able to export the SMS text and voice calls made to the Google voice number.
The data is downloaded in a manner that I cannot use it.
I have attached a zip file which shows the format of the data.
I need to be able to take each phone number and place them in a text file or excel spreadsheet in the following format listed below:
If the solution you propose is a spreadsheet, I need to have 1 column with the date of the call and the other column with the numbers as below.
If the solution you propose is a text file, then I only need the numbers placed as in the example below.
I don't need any of the other data included in the zip file.
I need a program or method to extract the info I need.
Either a spreadsheet or a simple text file with the data as a solution is fine.
Can you do this?
12253755432
12288366788
16788266543
17899977654
13455034567
13378200987
Hi,
I am available to work on this for you.
I will provide you a Excel Macro [login to view URL] based solution(Which ever you prefer).
Lets start...
Thanks
$40 USD em 1 dia
5,0 (30 avaliações)
4,8
4,8
7 freelancers estão ofertando em média $91 USD for esse trabalho
Hello Sir
I can create a function to display the data either as html table or as downloadable excel csv.
Please check my profile for work and experience.
Regards
Ashwin
Hello
I'm an Excel expert and I suggest creating an Excel workbook with a macro which would get list of files in a folder and for each file put a row in a sheet - phone number + time + type of event + path to a mp3 file. By clicking the cell with a audio file path it can be played. And you could sort by phone number or date.
So you unzip the archive to a specified folder, run the macro and get updated data in Excel
Best regards,
Denis Poduzov
I'm pretty good with stuff like that. I'm very well versed at JavaScript, PHP, and Software Architecture, and I'm sure I can complete without any problems