# How to export notes from ColorNote on rooted Android

This is a short instruction manual on how to export the text of your notes from [ColorNote](https://play.google.com/store/apps/details?id=com.socialnmobile.dictapps.notepad.color.note) to your computer locally, without setting up online synchronization in ColorNote.

This method was tested with data from ColorNote version 3.9.51 on Android 4.1 in 2014. I have not used ColorNote since I got my notes out. **The instructions may be outdated.**

1. Get [root access](!W "Rooting (Android)") on your Android device where you have been using ColorNote. You will need it to access the app data directly. **Warning! This will void your warranty with most manufacturers.**

2. Use a root-enabled file manager like Root Explorer or the Android version of [Total Commander](http://www.ghisler.com/android.htm) on the device to copy the file `colornote.db` from the directory `/data/data/com.socialnmobile.dictapps.notepad.color.note/databases/` to somewhere you can access normally, like the `Documents` directory on some devices (`storage/emulated/0/Documents`) or the SD card if you have one.

3. Transfer `colornote.db` to your computer over a USB cable, using a cloud service like Google Drive or Dropbox, or in some other way.

4. Install Sqliteman on your computer. ([Mac OS X instructions](http://blog.fmachado.com/sqlite-and-sqliteman-with-mac-os-x/). [Windows download](http://portableapps.com/apps/development/sqliteman-portable). On Linux get it from your distribution's repositories.)

5. Open `colornote.db` in Sqliteman. You will see a window that looks like the screenshot below.

![A screenshot showing Sqliteman.](/media/colornote/sqliteman.png){.center-block}

6. Copy the following text into the query box (top-right) and click the green "Run SQL" button or press F9:

```sql
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".

![A screenshot of the Sqliteman export window.](/media/colornote/sqliteman-export.png){.center-block}

8. That's it. You're done.

## Page metadata

URL: <https://dbohdan.com/colornote.md>

Published 2014-08-26, updated 2023-10-27.

Tags:

- Android
- how-to
- old blog

Index: [Old blog](/old-blog).