Working with a two million record file — This is a follow-up to the article I wrote awhile back. Python: Using SQLite when Excel’s Limits are Surpassed
View the data and create Excel extract with SQLricky-mcbride.medium.com In that article, I wrote about loading a CSV file that is too large to load into Excel. Instead, it was loaded into an SQLite database and queries were run against it to create smaller extracts.