How to open a tab-delimited text file in Google Sheets from a URL
These instructions describe how to quickly and easily open small, tab-delimited text files from a URL in Google Sheets for easy viewing.
- Log in to Google Sheets
- Click the + Blank template under Start a new spreadsheet
- Click on cell A1 (the top-left cell)
- Type the following:
Be sure to replace the sample URL with your own URL.
- Type the Enter key
- You will see a Loading... message, and then the data will appear in the spreadsheet
Note, if the file is too large, the cell will contain #N/A and it will have a note attached saying Error - Resource at url contents exceeded maximum size. The file size limit is not documented, but it appears to be less than 4 MB.
Free Feed Generator
Lasted Updated: January 4, 2019Send Feedback