SQLite

Basics of Openpyxl and Ingestion of data into SQLite database

by Priya Srinivasan, 28 March 2023

In this blogpost, we will be discussing the basics of the python library openpyxl, and about how to ingest an excel spreadsheet data into database such as SQLite.

Openpyxl is a Python library for Excel spreadsheet management. It enables the reading and writing of Excel files and provides a variety of tools for manipulating spreadsheet data. This post discusses the fundamentals of openpyxl, including how to install it, open and read Excel files, and write data to Excel files.