Exporting PiHole Stats for use in Excel

That's a problem to tackle with SQLs CASE statement.
Something like the following should allow you to achieve it without resorting to create tables in a 3rd-party database. You might have to adjust it in places for SQLite, as I am not familiar with it (e.g. I don't know which characters that would be using for string literals).

SELECT 
    ...
    CASE status 
         WHEN  0 THEN 'unknown'
               1 THEN 'blocked : gravity', 
               2 THEN 'permitted : forwarded', 
               3 THEN 'permitted : cached',
               4 THEN 'blocked : wildcard',
               5 THEN 'blocked : blacklist',
               6 THEN 'blocked : upstream known blocking page IP',
               7 THEN 'blocked : upstream 0.0.0.0 or ::',
               8 THEN 'blocked : upstream NXDOMAIN with RSA bit unset',
         ELSE '<UNDEFINED>'
    END as status_txt
FROM ...