To download a CSV file from GitHub, open the repository, click the file, and then click the Raw button in the upper-right corner; your browser will display the plain text data, which you can save by right-clicking and selecting "Save As" or by pressing Ctrl+S. This quick method works for any public repository without needing an account, though private repositories require you to log in or use a personal access token.
How to download a CSV file from GitHub: Introduction
Downloading a CSV file from GitHub is a common task for data analysts, researchers, and developers who need tabular data stored in a public repository. The fastest way to get a single file is through the web interface's Raw button, which eliminates the need for Git commands or third-party tools. This approach is ideal when you only need one file and want to avoid cloning an entire repository. Below, we walk through the exact steps, from finding the file to verifying its contents.
Step 1: Navigate to the repository
Open your web browser and go to GitHub.com. Use the search bar at the top of the page to type the repository name or keywords related to the project. For example, if you're looking for a dataset, search for the repository owner's name or the project title. Once you see the correct repository in the search results, click on its name to open the main page. If you already have the repository URL, you can paste it directly into the address bar. The repository's main page shows a list of files and folders, along with a description and recent commit history.
Step 2: Open the CSV file
On the repository's main page, browse through the file list to locate the CSV file. It may be in the root directory or inside a subfolder. If the file is inside a folder, click the folder's name to enter it. Once you find a file with the .csv extension, click on it. This will open a preview page that shows the first few rows of data as a table, along with the file's raw content below. The preview page also displays metadata such as file size and the number of lines, which is useful for verification later.
Step 3: Download using the Raw button
On the file's preview page, look in the upper-right corner for a button labeled Raw. Clicking this button opens a new tab or window with the raw, unformatted text of the CSV file. Your browser will not render this as a table; it will show the plain text with commas and line breaks. To save the file, right-click anywhere on the raw text page and select "Save As" (or "Save Page As" depending on your browser). Choose a destination folder on your computer, keep the filename and the .csv extension, and click Save.
Verify your downloaded CSV file
After the download completes, navigate to the folder where you saved the file. Compare this size with the one shown on the GitHub preview page; they should match closely, indicating the download was successful. Next, open the file in a spreadsheet application such as Microsoft Excel, Google Sheets, or LibreOffice Calc. Confirm that the columns and rows match the data you saw in the GitHub preview. If the data looks correct and the size matches, your file is ready to use for analysis, visualization, or any other purpose.
Downloading from private repositories
If the CSV file resides in a private repository, the steps above will not work while you are logged out. You must be signed in to your GitHub account with access to that repository. Once logged in, you can use the same Raw button method. For automated downloads or API-based access, you will need to generate a personal access token with read permissions for the repository. Go to GitHub Settings → Developer settings → Personal access tokens, create a token with the repo scope, and use it in the URL (e.g., https://@raw.githubusercontent.com/owner/repo/branch/file.csv).
