Is there a way do export a database in a rails app to excel

I'm being faced with a task of having a button on my rails application which basically exports the entire sqlite database to an excel file. So that the client can make pretty little graphs and do excel like things with the information.

I have done a cheeky google search trying to find a gem but I have literally 0 clue how they work and if they actually do what I want them to do.

I have tried using the Axlsx gem, but it didn't work.

I know I'm probably going to get a lot of hate on here because its not your orthodox question, but I'm at wits end with this database.

Any ideas?

Cheers