Member Avatar for markyorose

Who bought "Apolsoft Android SMS Transfer" of this software? Can give me some advice?
I want to be able to export my Android SMS database to my pc in a friendly txt, html or pdf format that is easy to read. I have the sms.db file ready to use, i just want to be able to easily convert it. What applications that are completely free can I use? I have over 10000 sms in this database. My phone Version is android 4.3.3. Thanks.

  • 5 Contributors
  • 4 Replies
  • 339 Views
  • 2 Years Discussion Span
  • Latest Post Latest Post by markmullen

Dani AI

Generated

Short, practical route for : because you already have the raw sms.db file you do not need to buy anything. A free, local SQLite workflow will export your messages quickly (10k+ rows is fine), keep your data private, and produce CSV/HTML that any browser or office program can print to PDF. Some replies recommended backup apps or PC utilities (see , , , ); below is a direct, no‑cost method using SQLite and a tiny Python exporter.

Make a safety copy and inspect the DB, then export a CSV with human dates:

cp sms.db sms.db.bak
sqlite3 sms.db ".tables"
sqlite3 -header -csv sms.db "SELECT datetime(date/1000,'unixepoch','localtime') AS date, address AS contact, body FROM sms ORDER BY date DESC;" > sms_export.csv

Two easy ways to get a readable PDF: (A) open sms_export.csv in LibreOffice/Excel and Export/Print to PDF; or (B) create a simple HTML that preserves line breaks and view it in a browser, then Print -> Save as PDF. Example Python exporter (Python 3):

#!/usr/bin/env python3
import sqlite3, html
con = sqlite3.connect('sms.db')
cur = con.cursor()
cur.execute("SELECT datetime(date/1000,'unixepoch','localtime'), address, body FROM sms ORDER BY date DESC")
with open('sms.html','w',encoding='utf-8') as f:
    f.write('<table><tr><th>Date</th><th>Contact</th><th>Message</th></tr>\n')
    for d,a,b in cur:
        f.write('<tr><td>{}</td><td>{}</td><td><div style=\"white-space:pre-wrap\">{}</div></td></tr>\n'.format(html.escape(d or ''), html.escape(a or ''), html.escape(b or '')))
    f.write('</table>\n')

Notes and cautions: always work on a copy. If .tables shows no sms table run PRAGMA table_info(<table>) on candidates. Android dates are usually milliseconds (hence /1000); if your date values look small, remove the /1000. If there is a -wal or -journal file alongside sms.db, copy it too before exporting. Keep UTF‑8 throughout so emojis and accents survive. This approach is free, transparent, and reproducible across Windows/Mac/Linux.

Recommended Answers

All 4 Replies

Member Avatar for Mjendo

Why not use sms backup & restore or sms backup +? They are free.

Member Avatar for Kelly Burby

Well, I haven't used Apolosoft whenever I ran onto such situation then I usually used Dr. FoneWondershare. So, I would say you can use that to do that same !

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.