Click here to close this tab and return to the app.

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:
    =importdata("http://sample.com/sample.tsv")
    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.

Topic:

Free Feed Generator

Updated: January 4, 2019