Android - Get notes created using "Notes" default app and export them to PC

Firstly, this is difficult, if not impossible, without ADB or root. However, I will try to make the adb part simple for you, so you can follow the rest of the answer.

  1. Get this package: Minimal ADB and fastboot, and install it on your computer.

  2. On your phone, go to Settings → Developer Options (On Android 4.2 and above, this option is normally hidden. Go to Settings → About Device, and tap on the build number entry 7 times. This will enable the Developer Settings option).

  3. Under Developer options, select "Allow USB Debugging".

  4. Connect your phone to the computer where you had installed ADB. If Windows starts installing drivers, let it finish.

  5. Go to the ADB install folder, and Do a Shift+Right Click on the adb installation folder, select "Open command window here", and type adb devices in the command prompt that opens.

  6. Your phone might pop up a request for authorization with an RSA Key, accept it.

  7. If the prompt shows something like:

    Connected devices:

    123456789ABCDEF device

or variants thereof, you are good to follow the steps mentioned below:

The steps are taken from @Firelord 's answer here, almost verbatim. All credits to @Firelord

  1. Take backup of your "Notes" app by issuing the following ADB command:

    adb backup <PACKAGE>
    

    where <PACKAGE> is the package name of the app whose backup you want to take. The file will be saved as backup.ab in the directory from where ADB is executed.

    In your case, you should end up with the backup file backup.ab (~1.7KiB) in your Home directory of GNU/Linux using the command:

    adb backup com.sec.android.app.memo
    

    This step is needed because I'm unaware (as a non-root user) of any other way to get your hands on an app's internal files residing in /data.

  2. The .ab file may not be able to be opened on your PC so use Android Backup Extractor (see usage in its README.txt) to convert into .tar archive which then can be opened by any archive viewer (like Ark, WinRAR, and so on).

    Some other methods to unpack the .ab file are mentioned here.

  3. Open the converted file (.tar in case you used Android Backup Extractor) and locate .db file under apps<PACKAGE>db<.db>.

  4. Open that .db in an SQL viewer like DB Browser for SQLite. You can then export the file into .csv using File → Export → Table(s) as CSV file.

  5. The resulting .csv can be viewed formatted in any spreadsheet software like MS Excel or even Google Sheets.

Tags:

Notes