xlwings Newsletter #41

How to query SQL databases from your Spreadsheet

Query SQL Databases Directly from Spreadsheets

If you're exporting CSV files from your database so your users can open them in Excel or Google Sheets, you might want to make it easier for them. This series of tutorials shows you how you can query your favorite database with Python and SQLAlchemy directly from your spreadsheet:

While the tutorials are written for Google Sheets in connection with the xlwings remote interpreter, they can also be used with Excel (Windows/macOS/Web) with minimal changes.

One of the benefits of using the new xlwings remote interpreter is the fact that you don't need to store database credentials in your spreadsheets or on your computer. You also don't have to fiddle around with installing the correct ODBC drivers on each user's machine.

For a quick video introducing Google Sheets and SQLite, check out the xlwings YouTube channel:

In-person Meetup in London

It's been a very long time, but we're finally back with an in-person meetup next month in London.

When: 19 September 2022, 6:30pm (London time)

Where: The Microsoft Reactor London

You can reserve your spot here (please note again that this is NOT a webinar but a live event):

Thanks for reading along!

~ Felix