WhatsApp Extractor: Complete Guide to Recovering Chats & Media

Extract WhatsApp Data from Backups: Simple Methods for Windows & macOS

Below are straightforward, step-by-step methods to extract WhatsApp messages, contacts, and media from backups on Windows and macOS. I assume you have a local backup file (Android: Google Drive or local file like msgstore.db.crypt; iPhone: iTunes/Finder backup or iCloud). If you need instructions for acquiring backups, request that separately.

1) Extracting from Android local backup (msgstore.db.crypt) — Windows & macOS

1. Locate the backup file
   • Android local backups: /WhatsApp/Databases/msgstore-YYYY-MM-DD.1.db.crypt or msgstore.db.crypt on device storage or SD card. Copy it to your computer.
2. Obtain the WhatsApp key
   • On Android 6+: the encryption key is at /data/data/com.whatsapp/files/key (requires root). For some phones you can use ADB backup or third-party tools to extract the key without rooting (results vary).
3. Use a decryption tool
   • Recommended tool: WhatsApp Viewer (Windows) or open-source scripts (Python) that support crypt12/14. Example command with a Python tool:

   Code
   Copy CodeCopied
   python3 decrypt_whatsapp.py –key /path/to/key –db /path/to/msgstore.db.crypt –out decrypted.db 

4. Open decrypted SQLite file
   • Use DB Browser for SQLite (Windows/macOS) to open decrypted.db. Messages are in the messages table; media references in media/locations columns.
5. Extract media
   • Copy media files from WhatsApp/Media folder and match filenames to database entries or use tools that export messages with embedded media.

2) Extracting from Android Google Drive backup — Windows & macOS

1. Limitations
   • Google Drive WhatsApp backups are tied to the WhatsApp account and phone number. Direct download is not provided by Google for privacy reasons.
2. Workaround: restore to Android device
   • Install WhatsApp on an Android device with the same phone number and Google account, restore backup, then create a local backup or pull files via USB.
3. Then follow steps in section 1 to decrypt local backup and extract messages/media.

3) Extracting from iPhone iTunes/Finder backup — Windows & macOS

1. Create a local backup
   • Use Finder (macOS Catalina+) or iTunes (Windows/macOS Mojave and earlier). Prefer an unencrypted backup for easier extraction; if encrypted, remember the backup password.
2. Locate WhatsApp data in backup
   • WhatsApp stores chat DB and media under app domain: /Applications/WhatsApp/Documents/ or library/Application Support/… in the backup. Use a backup browser tool to navigate (see tools below).
3. Use a backup extractor
   • Recommended tools: iMazing (paid, macOS/Windows), iExplorer, or free tools like iphone_backup_decryptor.
4. Convert SQLite and attachments
   • Extract ChatStorage.sqlite or ChatStorage.sqlite-wal and Media files. Open the SQLite DB in DB Browser for SQLite to view messages. Match media by file names referenced in the database.

4) Extracting from iCloud backup — Windows & macOS

1. Limitations
   • Direct access to raw app files in iCloud backups is restricted by Apple.
2. Use an iCloud extractor
   • Tools like iMazing or specialized cloud backup extractors can fetch WhatsApp data if you provide Apple ID credentials and 2FA code.
3. Then follow steps in section 3 to open and parse extracted files.

5) Cross-platform tools & automated options

• WhatsApp Viewer — decrypts Android DBs and shows chats (Windows; can run on macOS via Mono).
• iMazing — extracts and exports WhatsApp conversations from iPhone backups (macOS/Windows, paid).
• BackupExtractor/Elcomsoft — enterprise-grade extractors (paid).
• Open-source scripts on GitHub — several projects decrypt crypt12/14 files and parse ChatStorage.sqlite.

6) Legal & privacy notes

• Only extract data from devices and backups you own or have explicit permission to access.
• Encrypted backups may require passwords or device keys; bypassing protections can be illegal.

7) Quick checklist (Do this sequence)

1. Locate backup (msgstore or iTunes/Finder/iCloud).
2. Copy backup to computer.
3. Obtain decryption key or backup password if required.
4. Decrypt database (Android) or extract ChatStorage.sqlite (iPhone).
5. Open SQLite DB with DB Browser for SQLite.
6. Copy media files and match to DB entries.
7. Export messages as CSV/HTML using tools or SQL queries.

Tools & links (examples)

• DB Browser for SQLite (free)
• WhatsApp Viewer (Windows; runs on macOS with Mono)
• iMazing (paid)
• GitHub: repositories for decrypting WhatsApp crypt12/14

If you want, I can provide step-by-step commands for one specific platform (specify Android or iPhone and Windows or macOS), or generate the exact SQL queries to extract messages and timestamps.