This article shows a better way to import and link CSV files into a Google spreadsheet. By using a simple technique you can protect your spreadsheet and safely query data from an external CSV even when the structure of the CSV files changes.

A collection of notes, ideas, and pictures
This article shows a better way to import and link CSV files into a Google spreadsheet. By using a simple technique you can protect your spreadsheet and safely query data from an external CSV even when the structure of the CSV files changes.
There is a better way to use Google Sheets lookup() functions With a few simple examples you will learn how to hide your data (hash tables) and use the functions in a more advanced yet simple way.