My question is:
What is the most quickest way to acquire/gather URL’s in Googlesheets to begin using IMPORTXLM?
I have 2,000 URL’s that I want to use in Googlesheets, (which I will be integrating into Airtable) to import certain information from each website, they have to be in a particular sequence, but they are not one after the other. I started to bookmark the sites that I needed, in sequence, but that can be tedious. Then I noticed that I could drag the URL’s from one site, in a split screen on my iPad, into Googlesheets, but I wasn’t sure if I could use those same website links, that I dragged and dropped, when I use IMPORTXLM on my MacBook.
I found out about a formula:
Could this formula.be tailer made for selecting individual URL’S, by date or month and year? I was using it, but I could not delete the records that I did not need, it would delete a bunch of records, even after just selecting random records. Then when I tried to put in a different year, I would just duplicate the URL’S in the same year (2001) as the sample given. from the formula.
Then I thought I would post this to find out if there is a quick and easy way to do this phase of the operation, before I use IMPORTXLM or am I off the mark.
Any help would be appreciated.