I'm trying to upload a product to Google Marketplace. It says I can do it with Google Sheets. Two fields require a URL. When I import my tab-delivered text file into the sheet, everything goes in just fine, except the URL fields. It's like it completely ignores them. I don't get an error message at all. Any ideas?

  • one thing I tried to fix this that did work was.. instead of just importing the URLs in the fields, I tried importing =IMPORTDATA("https://www.example.com") that didn't work either
    – CheeseFlavored
    Commented Mar 20 at 19:59
  • I also just tried importing =HYPERLINK("https://www.example.com", "link")
    – CheeseFlavored
    Commented Mar 20 at 20:03
  • Please edit your question to include some sample data in markdown or a link to a CSV file.
    – Blindspots
    Commented Mar 22 at 3:36

1 Answer 1


Your tab-delimited file might have formatting problems.

If you generated this file using code found in the wild, look for another code or use another code to fix it.

A workaround might be converting the tab-delimited file to a comma-separated one using a good conversion tool. Use Google or another search engine to find one. Tip: You might ask for as software recommendation in https://softwarerecs.stackexchange.com.

Another workaround is to use a text editor with find-and-replace features that support regular expressions.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.