My CSV file:
Google sheet I got is
My desired Google sheet
The question is what csv will generate the desired google sheet. Please help me with that.
Thanks in advance. uv.
CodePudding user response：
You should be able to do that with =HYPERLINK ( "url", "label" )
Alternatively here’s how you can do that from the Insert menu.
Select the cell where you want to insert the hyperlink. You can also do this by double-clicking on the cell
Go to the Insert menu. Select the Link option from the menu.
After clicking on the Link option from the dropdown menu, you will get a dialogue box that looks exactly like the one in the above image.
In the Search and paste a link box, type the link you want to insert or you can copy the webpage’s link from the search bar of your browser and paste it here.
Click on the Apply button.
After you click on Apply, you should see the above pop-up. There are two things you should note here that will serve as a check to know whether or not you’ve done the right thing.
- The anchor text (the text to which the URL or web link is applied) will be automatically highlighted in blue. This is how Google sheets indicate to users of the data that the character in the cell contains a link to an external source.
- There will be a preview of the weblink at the bottom of the cell. This is going to be visible if you have the cell selected, or you place the cursor on the hyperlinked cell.
CodePudding user response：
It seems like you are trying to insert formulas into a google sheet from a CSV. I cant say I've seen or used CSV this way before, but here are a couple (untested) things you might be able to try to make this work:
- Use something other than a comma as the delimiter
since it seems like your "data" (i.e. the values you want to put inside each cell) can also possibly include commas, you may want to try changing the delimiter (the character that is used to split the data, which is usually a comma).
I'm not sure if google docs will allow you to easily import this, but maybe using this as your source data this might help:
1234;=HYPERLINK("https://www.google.com", "LINK");abcd (note that the delimiter between cells is now ; and not ,)
If google docs does not allow you to import this, you might be able to try opening it in a program such as Microsoft Excel or 
or:
="HYPERLINK(""https://www.google.com"",""LINK"")"
update:
try your CSV like:
123,=HYPERLINK("google.com";"LINK"),abcd
semicolon ; will be autocorrected to a comma , within english sheets after the formula gets activated
so when you import it you will use comma , split separator which will either get you exactly what you want or it will look like this:
eg. without an active link, so you will need to add some character in front of the equal = sign:
and then remove it:
to automate it you could harness the power of scripts or run some macro