Import data from ColorNote app? I have lost my Android phone but I have backup of my SD-card on which I have backup of my ColorNote app. How can I get all my notes from that backup?

NOTE: I am using iPhone now so don't have a Android device for now.
Yes you can, but it will be a bit convoluted: ColorNote's notes can only be exported from the SQLite colornote.db file, but it's not available from the sd card backups. So we will have to do it in two steps: first reimport the sd card backup into the ColorNote app, then extract the generated colornote.db SQLite file (note that you must have rooted your phone to access the SQLite file, but you can do it on the BlueStacks emulator). Here's the walkthrough, inspired greatly by this post by Danyil Bohdan and this one:


Install ColorNote on an Android device. Since you don't have an Android phone, you can use BlueStacks to emulate an Android phone on your computer.
Open ColorNote and import your sd card backup file. Remember that you have to disable cloud syncing in order to show the Restore option as per the ColorNote's FAQ.
Check that your notes are correctly restored inside ColorNote by opening them. If they seem ok, continue to next step.
Install Total Commander for Android on your phone or BlueStacks emulator.
Open Total Commander and browse the root/filesystem partition and then browse to /data/data/com.socialnmobile.dictapps.notepad.color.note/databases/.  You need root rights to access /data/data, but in the BlueStacks emulator it should be easy to do. Inside this folder, copy the file colornote.db to your SD card slot (I don't know how it works inside BlueStacks but you should have the possibility to setup a virtual SD card or send directly to your computer).
Transfer the colornote.db file to your computer (either via USB if you're using an Android phone, or by copying the file from the BlueStacks emulator).
Open colornote.db with a SQLite browser of your choice. A good open source and portable app for that is sqlitebrowser. You should now see something similar to this screen:





Click on the Execute SQL tab (highlighted in red above) and execute the following sql statement:

SELECT date(created_date / 1000,'unixepoch'),date(modified_date / 1000,'unixepoch'),note FROM notes ORDER BY _id
You should now see a list of records below the sql statement, and you can click on the little floppy disk icon on the right to export into CSV, as shown here:





Open the .csv file into a UNIX friendly editor such as Notepad++ (else there won't be any line returns) and check if the content of your notes was correctly exported. They should be stored in chronologically ascending order (from oldest to newest at the bottom).
You can then import your .csv file in most programs or keep it as a readable backup of your notes.


Note that this technic works for most applications, since most Android apps use SQLite to store their databases (exception being some apps like WhatsApp which uses SQLite but encrypted to, of course, avoid leaking your private data to anyone).