How to transfer notes from ColorNote on Android with root access to a PC/Mac
This is a short instruction manual on how to export the text of your notes from ColorNote to your computer locally, i.e., without setting up online synchronization in ColorNote. The method has been tested with data from ColorNote version 3.9.51 on Android 4.1.
1. Get root access on your Android device where you've been using ColorNote. You will need it to access the app data directly. Warning! This may void your warranty.
2. Use a root-enabled file manager like Root Explorer or the Android version of Total Commander on the device to copy the file
colornote.db from the directory
/data/data/com.socialnmobile.dictapps.notepad.color.note/databases/ to the SD card (usually something like
3. Transfer that file to your computer over a USB cable or using a cloud service like ownCloud or Dropbox.
colornote.db in Sqliteman. You will see a window that looks a lot the screenshot below.
6. Copy the following text into the query box (top right) and click the green "Run SQL" button or press
SELECT date(created_date / 1000,'unixepoch'),date(modified_date / 1000,'unixepoch'),note FROM notes ORDER BY _id
7. Click the "Export Data" button below the query window. A dialog will appear.
Select the export format (HTML table, SQL, CSV, Excel spreadsheet) and click "OK".
8. That's it. You're done.
Tags: Android, how-to, old blog