Excel Help and Problems

[etech0]

I have a google sheet with a column with links to an mp3, a column for artist and a column for title, is there any way to have it automatically download all the mp3s with the filename based on the artist and title column?

This extension might help https://www.downthemall.net/

I don't know how it determines the file names of the downloaded files - but if it uses the display text, you could use formulas to prep an html file with all the links, save locally on your computer, and then use the extension to download them

[Yo ssi]

This extension might help https://www.downthemall.net/

I don't know how it determines the file names of the downloaded files - but if it uses the display text, you could use formulas to prep an html file with all the links, save locally on your computer, and then use the extension to download them

Thanks that's exactly the question, I doubt it has the ability to custom name it. I assume it would just use the file name as uploaded

[etech0]

Thanks that's exactly the question, I doubt it has the ability to custom name it. I assume it would just use the file name as uploaded

I figured as well. If you do end up downloading them with the existing filenames, you can use the program mp3tag to rename them and set the metadata. It's a great program.

[Yo ssi]

I figured as well. If you do end up downloading them with the existing filenames, you can use the program mp3tag to rename them and set the metadata. It's a great program.

Thanks. The problem is the original file names are very random, so I won't know what's what..

[etech0]

Thanks. The problem is the original file names are very random, so I won't know what's what..

Based on your google sheet. How long is the list?

[Yo ssi]

Based on your google sheet. How long is the list?

My precise use case is for hundreds of files, the above was an example to make it clear. (wouldn't be asking otherwise )

[etech0]

My precise use case is for hundreds of files, the above was an example to make it clear.

Hmm, it might be worth looking into writing a google apps script for that. IDK for sure that it could do this but I would hope it can.

[lubaby]

https://twitter.com/justinmilleresq/status/1183135489471082497

[AsherO]

I have a google sheet with a column with links to an mp3, a column for artist and a column for title, is there any way to have it automatically download all the mp3s with the filename based on the artist and title column?

If it’s a one time thing, download to Excel and find a macro that does this,  I’m confident Google will locate one.

[Yo ssi]

If it’s a one time thing, download to Excel and find a macro that does this,  I’m confident Google will locate one.

Thanks.

I ended up paying a professional since it was time sensitive. If anyone would like the code PM me.

[Definitions]

Any reliable way that I can insert a screenshot into a cell then either manually make it smaller or have it pop out only when clicked on.

It has to be obvious which row it's on.

Will just pasting it into the cell mess up the positioning once I email the file?

[Definitions]

Nevermind. It seems to be working fine

[justaregularguy]

I dont really have a question as much as an insight.

Vlookup is NOT case sensitive. I know in general this isn’t a problem for most ppl using vlookup. But I had to match hundreds of ID’s and I thought i got it right w the vlookup. Then I noticed an ID  like aeB300000nK was being matched with a file that’s ID was really aeB300000nk (Notice the lower case k)
So it messed up the vlookup for those .
So there are some ways to vlookup case sensitive I’m curious to know ddfers methods on doing this. One formula I found for some reason was not working using exact() and row()

Anyway, I found a cool small macro that’s does the job quite well and works just like vlookup

If anyone’s interested in the macro let me know

[etech0]

I don  really have a question as much as an insight.

Vlookup is NOT case sensitive. I know in general this isn’t a problem for most ppl using vlookup. But I had to match hundreds of ID’s and I thought u got it right w the vlookup. Then I noticed an ID  like aeB300000nK was being matched with a file that’s ID was really aeB300000nk (Notice the lower case k)
So it messed up the vlookup for those .
So there are some ways to vlookup case sensitive I’m curious to know ddfers methods on doing this. One formula I found for some reason was not working using exact() and row()

Anyway, I found a cool small macro that’s does the job quite well and works just like vlookup

You can use a combination of INDEX and MATCH for this. I don't know it offhand, I just google it when relevant and copy/paste.

[justaregularguy]

You can use a combination of INDEX and MATCH for this. I don't know it offhand, I just google it when relevant and copy/paste.

it’s funny I’m familiar w some formulas and totally not others
I never use index match
What wud the formula be?

[aygart]

it’s funny I’m familiar w some formulas and totally not others
I never use index match
What wud the formula be?

Index match is much more powerful

[bubbles]

Check out the new xlookup. Takes care of all the issues with vlookup and much more straightforward than index match

[etech0]

Check out the new xlookup. Takes care of all the issues with vlookup and much more straightforward than index match

Right I forgot about that one. Still need to try it out (IIRC it comes with office 2019)

[justaregularguy]

Check out the new xlookup. Takes care of all the issues with vlookup and much more straightforward than index match

what the heck is that ? Does it come w office 365?

As an aside does anyone know what LAMBDA is?

[Yo ssi]

what the heck is that ? Does it come w office 365?

As an aside does anyone know what LAMBDA is?

GIYF, my friend.