Export Librelink android app data to excel (no need to root your phone)

librelink.sql

-- 1. Install ADB on your computer
-- 2. adb backup -noapk com.freestylelibre.app.it
-- 3. Decompress data with zlib support:
--    printf "\x1f\x8b\x08\x00\x00\x00\x00\x00" |cat - /tmp/data |gzip -dc >/tmp/out 
-- 4. go to apps/com.freestylelibre.app.it/f/
-- 5. open apollo.db and sas.db in a sqlite editor 
-- 6. copy notes.data into sas.db
-- 7. run this query to have a diary with sensor scans and notes:

SELECT strftime('%d/%m/%Y %H:%M:%S', datetime(timestampLocal/1000, 'unixepoch')), comment, glucoseValue, fastInsulinDose, slowInsulinDose, foodCarbs, foodType
FROM notes
JOIN realTimeReadings ON realTimeReadings.timestampUTC = notes.timestampUTC
WHERE notes.deleted = 0
ORDER BY notes.timestampUTC ASC
                                              
-- export to .csv or xls