Export iPhone SMS to the Excel worksheet

Posted on January 19, 2011

Folks, today I am going to share a trick with you, The trick is – How to Export iPhone SMS to Excel spreadsheet. This trick is quite simple though and you need not to be a technical person to do this. Just follow the guidelines from bellow to export iPhone SMS to Excel spreadsheet.

Export iPhone SMSHow to export iPhone SMS to Excel spreadsheetDownload a software called – SQLite (a Database browser)  from here

Well, SQLite Database browser is a light GUI editor for SQLite databases, built on top of QT. The main goal of the project is to allow non-technical users to create, modify and edit SQLite databases using a set of wizards and a spreadsheet-like interface.Now backup your iPhone information in iTunes before startingNow find SMS database file located in a backup folder on your computer. The file is named – 3d0d7e5fb2ce288813306e4d4636395e047a3d28.mddata- In Windows 7/ Vista the file is stored in this path – C:\Users\\AppData\Roaming\Apple Computer\MobileSync\Backup\(some random id)\_ In Windows XP the file is stored in this path – C:\Documents and Settings\\Application Data\Apple Computer\MobileSync\Backup\(some random id)\

Export iPhone SMS Excel

NOTE – Generally the iPhone messages are stored in an SQLite database formatNow Copy 3d0d7e5fb2ce288813306e4d4636395e047a3d28.mddata file from the folderNow Save iPhone SMS db file as SQLite file and to do that, Save 3d0d7e5fb2ce288813306e4d4636395e047a3d28.mddata in desktop and rename it to sms.sqliteNow Open downloaded SQLite zip file and extract SQLite Database Browser.exe and Run it

Export iPhone SMSNow Click File menu >> Open Database>> and Open sms.sqlite file from the desktopNow click File >> Export>> Table as CSV fileSelect table name as message from the Drop down>>Select exportAnd Save the CSV File as Sms.csv

Export iPhone SMS

Now Simply Open the Sms.Csv file in Microsoft Excel and Save it as the file name as Sms.xlsNow Open the Sms.xls file and see few fields that you are interested in -address: This holds the phone number of the person that sent you or you sent the message to.date: This is a Unix timestamp of when the message was sent.text: The actual message.flags: This should be either 2 or 3. The messages flagged 3 are messages that you sent (outgoing), while the messages flagged 2 are incoming messages.

Export iPhone SMSNow insert a new column after the date column and insert this formula

=(((C2/60)/60)/24)+DATE(1970,1,1)+(-5/24)) and drag the formula for all cellsNow select all cells and right click select Format all cells>>Number>>Custom>>MM/DD/YYYY as shown image bellow

Export iPhone SMS Excel

Export iPhone SMSAnd that’s it. You have simply done it.

Well, Stay tuned with us for more updates like this, and if you have any questions or comments, or find any errors in the process just leave a comment

Caller ID spoofing – iPhone Application Allows to Fake Number

Posted on January 19, 2011

Caller ID spoofing has been around for several years now and the controversy surrounding it has not waned. Call spoofing is the act of changing the phone number that appears on someone’s call display when you place a call to them. Instead of blocking or revealing your real number, you choose the number that is displayed.

Although it is still somewhat unknown to the general public, this type of service has continued to gain in popularity and is used by everyone from regular individuals to professionals, law enforcement, and even celebrities. It’s a tool that allows people to retain anonymity and keep their identity, or at least their phone numbers, private. Even when placing a call to someone that is familiar and trusted, there is a chance that the person’s telephone could be lost or stolen with your number contained on it. For celebrities in particular, this could be disastrous.

There are several providers that offer the call spoofing service to anyone. In addition to call spoofing, other services and calling features have been added over the years. Some of these include voice changing, call recording, SMS spoofing, personal Spoof Numbers, and, most recently, mobile applications.

SpoofTel, one caller ID spoofing provider, has recently released an iPhone application that allows you to use its service from your iPhone. Due to its controversy, it has not become available on the iPhone store but is still available for download on other sites. Although it is still fairly new, the application has already been downloaded by thousands of iPhone users.

Caller ID spoofing has appeared in various news stories over the years, typically related to some type of proposal to ban or outlaw the service. There is a lot of controversy surrounding call spoofing because it has been know in the past to be used by scammers. Certain individuals have used spoofing services for fraudulent and illegal purposes in the past. However, most providers have become quite successful at preventing scammers from exploiting their services and it has not been as large of a problem as it was in the past. As well, spoofing services are used by many individuals for a multitude of purposes. The majority of individuals use spoofing services legitimately.

With spoofing providers continuously producing additional services and features, it doesn’t look like caller ID spoofing is going anywhere any time soon.

iPhone: If you can’t send or receive text messages

Posted on December 29, 2010


This article outlines how to troubleshoot issues with sending and receiving SMS or text messages using the Messages application on the iPhone. If you are having difficulty sending or receiving MMS messages, see this article.

f you can’t send or receive text messages

  • Check the top left corner of iPhone’s display to make sure you have a strong signal: If you don’t have a strong signal, try moving to a different location. If you’re indoors, try going outdoors or moving close to a window.
  • Update to the latest iPhone Software. For more info, see Backing Up, updating, and restoring your iPhone and iPod touch software.

If you still can’t send or receive text messages:

  • Ensure that you are first tapping in the text-entry field at the bottom of the screen (highlighted below) to bring up the keyboard. Until you begin typing, the Send button will remain grayed out.

[Text-entry field screenshot]

  • Power off iPhone, then turn iPhone back on.  Press and hold the Sleep/Wake button until the red slider appears. Slide your finger across the slider to turn off iPhone. To turn iPhone back on, press and hold the Sleep/Wake until the Apple logo appears.
  • Make sure that every phone number in your contacts list includes an area code.
  • Make sure Airplane Mode isn’t on. From the Home screen choose Settings, then turn Airplane Mode off.
  • If you are trying to send a text message to multiple recipients and you type in each number manually instead of using the contacts list, make sure you tap return instead of space to separate each one. For more info, see Sending SMS messages require a valid 10-digit mobile number (United States).
  • If you have recently ported your number from another carrier, please contact your current carrier to verify that the porting process has completed successfully.

Note: Both SMS and MMS support text messaging. If Show Subject Field is enabled in Settings > Messages > MMS > Show Subject Field, you can only send messages after you have typed content in the Body field. Until then, the Send button will be grayed out, and you will be unable to send the message. If you add text to the Subject and Body field you will automatically send via MMS. If you wish to send via SMS, not MMS, either type text in the Body field only, or disable the Show Subject Field option. The following table illustrates this relationship:

Subject Field only Will not send
Body Field only SMS
Subject Field and Body Field MMS

Additional Information

You may also see the message, “Error sending message”. Troubleshoot as above.

For more information on SMS, see the iPhone User’s Guide (you can also view the iPhone User Guide with your iPhone: tap Safari, then Bookmarks, and then iPhone Users Guide).

Recovery Utility for Deleted iPhone Text Messages

Posted on December 29, 2010

I’ve been getting barraged with so many requests to help folks retrieve deleted text messages from their iPhone backups that I decided to write a small utility to help out — fumbling around with a text editor was a little daunting for some.

Those using Windows can download my iPhone SMS Retriever here.

[Update 09/23/2009] – there have been many reports of installation problems. Thank you to those folks who have reported the issue — I’m working on an update to the utility within the next week to fix this problem. Thanks for your patience and understanding. I’ll keep you updated here.

iPhone SMS Retriever Screenshot

Here’s how to use it:

  • Download and unzip the file
  • First, run the SQLite Setup.exe file — this is a pre-requisite for iPhone SMS Retriever to work.
  • Second, run the iPhone SMS Retriever Setup.exe file
  • The app will install and run. It will appear under your Programs as iPhone SMS Retriever
  • You do need to know how to get the iPhone SMS backup file so you can point the app to load it. If you need help locating this file here’s some help — please read carefully as this step is where most folks get hung up:
    • First, connect up your iPhone, run iTunes (if it doesn’t autostart), and start a sync. iTunes should say “Backing up iPhone…” or something to that effect. Let the backup process finish.
    • If you’re running Windows XP: go to the c:\Documents and Settings\[your username]\Application Data\Apple Computer\MobileSync\Backup\ directory. There will be at least one directory with a very long and cryptic name — this is the backup directory that contains all the backup files from your iPhone. If you see more than one of these directories that’s fine — it just means you have several backups, each from a different time and/or iPhone on your computer. Go into the backup directory of your choice and locate the file 3d0d7e5fb2ce288813306e4d4636395e047a3d28.mddata.Copy that file to your Desktop or some other easily remembered location.
    • If you’re running Windows Vista or Windows 7: go to the c:\Users\[your username]\AppData\Apple Computer\MobileSync\Backup\ There will be at least one directory with a very long and cryptic name — this is the backup directory that contains all the backup files from your iPhone. If you see more than one of these directories that’s fine — it just means you have several backups, each from a different time and/or iPhone on your computer. Go into the backup directory of your choice and locate the file 3d0d7e5fb2ce288813306e4d4636395e047a3d28.mddata. Copy that file to your Desktop or some other easily remembered location.
    • If you cannot find the Application Data or AppData directory make sure you go into the Tools menu in your Windows Explorer window, select Folder Options and be sure the enable Show hidden files, folders, and drives.
  • Click the “Load iPhone SMS Backup File” button in the iPhone SMS Retriever app and select the file 3d0d7e5fb2ce288813306e4d4636395e047a3d28.mddata you saved a few steps above.
  • Voila! The messages in the file will appear in the window for you to browse.

This is a v1.0 app, I wrote it in about an hour, there are no bells and whistles, but you should find that it serves the basic function of loading an unencrypted iPhone SMS backup file and displaying all messages sent from/received by the iPhone in question and the date/time of the messages.

I’ll add more features over time — would love to hear your ideas for features to add. Finally, I’m providing this as a free utility, use it at your own risk and only on your own iPhone backup files or those of others only with their permission.

[Update 09-10-2009]

There was a bug in the original installer I posted. I have updated the download link in the following post to point to the new installer package.

Using Text Messages

Posted on December 29, 2010

Products Affected

iPhone (original)

You can send and receive text messages anytime you’re in range of the cell network. If you can make a call, you can send a text message. All iPhone plans include a certain number of free text messages. Depending on your phone plan, you may be charged for additional message you send or receive.

You can send text messages to anyone with an SMS-capable phone. The recipient is notified of the message and can read it and reply at any time.You can also send text messages to multiple people at the same time.

Send a new text message

Tap , then enter a phone number or name, or tap and choose a contact from your contacts list. Type a message and tap Send.

The Text button on the Home screen shows the total number of unread text messages you have.

As you text back and forth with a person over time, your conversation is saved in the Text Messages list. Conversations that contain unread messages have a blue dot next to them. Tap a name in the list to see or add to that conversation.

Send a text message to multiple people

    Tap , then add people one at a time. If you enter a phone number manually (instead of selecting it from Contacts), you must tap Return before entering another entry.

    Note: Replies from any of the recipients are sent only to you; the other people you texted won’t see anyone else’s reply.

Reply to a text message or send one to someone you’ve texted before

    Tap a name or phone number in the Text Messages list, then type a message and tap Send.

Delete a conversation from the Text Messages list

    Tap Edit, then tap next to a conversation and tap Delete.

    You can also delete a conversation by swiping left or right over a conversation and tapping Delete.

Send a text message to someone in your favorites list or to a recent caller

    From the Home screen tap Phone, then tap Favorites or Recents. Tap next to a name or number and tap Text Message.

Call or email someone you’ve texted

    Tap a message in the Text Messages list. Scroll to the top of the conversation and tap Call to call the person. Tap Contact Info, then tap an email address to send an email. The person’s email address must already be in your contacts list.

Follow a link in a message

    Tap the link. Tap a web address to open a webpage in Safari, a phone number to make a call, an email address to open a preaddressed email in Mail, or a street address to see a map in Maps. To return to your text messages, press the Home button and tap Text.

Add information in a link to a contact, or see the contact information of the person associated with the link

    Tap next to the message.

Add someone you’ve texted to your contacts list

    Tap a name or phone number in the Text Messages list, then tap “Add to Contacts.”

Set whether iPhone makes an alert sound when you get a text message

    From the Home screen choose Settings > Sounds, then turn New Text Message on or off.

    If the Ring/Silent switch is off, iPhone won’t make alert sounds even if they’re turned on in Settings.

How to Send MMS Messages on an iPhone

Posted on December 29, 2010

iPhone offers several options for sending emails or text messages. But there is no direct link or icon to send multimedia messages, or MMS messages. You can still send photos or videos through email.

The difference is that you must use the mail recipient’s phone number as part of the email address. Difficulty: Easy Instructions 1. 1 Follow the instructions for sending an email on the iPhone.

Make sure that the recipient has an MMS-capable phone. 2. 2

Tap the note pad icon on the main page to compose a message.

Type a name in the “To” field. 3. 3 Include the recipient’s phone number and the phone carrier’s prefix as the first part of the email address in the “To” field. Enter the number as a 10-digit string, such as “1234567890@mms.att.com.”

Prefixes vary according to the recipient’s phone carrier.

Enter a brief message to go with your photo or video. 4. 4 Go to the home screen and choose “Photos.” Pick the photo that you would like to use, tap the right arrow icon, then tap “Email Photo.

” Hit “Send” once you’ve typed your message and attached your photos or videos.

Tips & Warnings

  • Make sure to set up and sync an email account to your iPhone so that you can take advantage of the features. Choose your settings from the home page, your account type and other account information. MMS messages are sent using this default account.
  • Select the “Sound” feature if you want to be alerted when a photo message has been sent successfully. At the sound menu, turn the setting on or off. Change the settings to on or off whenever you want to send a copy of the message to yourself.
  • Don’t confuse the phone carrier’s 3-digit prefix with a regular telephone area code.