Phone Bill Import to Excel

[JH1424]

Hello, I haven’t used Excel for anything other than work info recently and need to import my phone bills into Excel. I’ve tried converting them to .txt files prior to importing and the results are…not great. Does anyone have any tips on a better way to import? The phone bill is for multiple phone lines and is from T-Mobile if that’s relevant. I’m trying to organize the data to see what phone numbers are called/texted the most frequently from each phone line. Any assistance is much appreciated! Thank you.

 

[RICH937]

what file format do you have when you download the call log from t-Mobile?

 

[JH1424]

Hi RICH937, I originally received it is a PDF. I’ve been able to export it to Excel from Adobe, but it comes out all over the place due to the way the bill is set up with some images/different text boxes. Any advice?

 

[alansidman]

Import your file with Power Query either from the web or from a PDF. Formatting should be maintained when you do this. Power Query is called Get and Transform Data and is found on the Data Tab of the ribbon.

 

[JH1424]

Import your file with Power Query either from the web or from a PDF. Formatting should be maintained when you do this. Power Query is called Get and Transform Data and is found on the Data Tab of the ribbon.

Hi Alansidman, thank you very much for this guidance! I’m poking around a bit with the phone bill and your advice has been the most helpful!

 

[RICH937]

Hi RICH937, I originally received it is a PDF. I’ve been able to export it to Excel from Adobe, but it comes out all over the place due to the way the bill is set up with some images/different text boxes. Any advice?

If that doesn't work, have you tried to save as an html file? you can then open it in web format and simply select what you need and paste to excel.

 

[JH1424]

If that doesn't work, have you tried to save as an html file? you can then open it in web format and simply select what you need and paste to excel.

Hi RICH937, thank you for your assistance as well. I have several phone bills to analyze, so I will be trying this method as well to see how it goes. Thanks again!