HOW TO View Large CSV File From A GitHub Repo Without Downloading It Locally
Here are quite a few ways to view large CSVs from a GitHub repo without downloading them locally -
1) Flat Viewer is a free online viewer for CSV, JSON, and other tabular files stored in public GitHub repos — it displays them in a sortable, filterable table without you having to download them.
The FlatGithub URL format is:
https://flatgithub.com/OWNER/REPO?filename=PATH_TO_FILE
If your file is:
https://github.com/mvark/indiafoodstats/blob/main/Brands/Amul.csv
The FlatGithub link will be:
https://flatgithub.com/mvark/indiafoodstats/blob/main/Brands/Amul.csv
What you can do with Flat Viewer -
- View the CSV as a table (no GitHub size preview limit)
- Sort columns
- Search in the dataset
- Download the filtered view as CSV or JSON
2) GitHub + Raw + CSV Explorer
Go to your CSV in GitHub
Click Raw
Copy the URL (it will look like https://raw.githubusercontent.com/.../file.csv)
Go to CSV Explorer (requires sign up)
Import the data using Raw CSV file
3) Through your own Datasette instance. This will give you SQL search + filters in the browser
4) Using GitHub.dev which is basically VS Code running in your browser. If you need search & filtering inside GitHub.dev, you can install the "Excel Viewer" or "Rainbow CSV" VS Code extensions from the Extensions sidebar — even inside the web version.
If the URL of your CSV file in a GitHub Repo looks like this -https://github.com/mvark/indiafoodstats/blob/main/Brands/Amul.csv
then the link to open it directly in GitHub.dev is this -
https://github.dev/mvark/indiafoodstats/blob/main/Brands/Amul.csv
Comments
Post a Comment