Download pictures from URL en masse

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3161200%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EDownload%20pictures%20from%20URL%20en%20masse%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3161200%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20have%20a%20spreadsheet%20that%20looks%20something%20like%20this%3A%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3CTABLE%20border%3D%22%5C%26quot%3B1%5C%26quot%3B%22%20width%3D%22%5C%26quot%3B100%25%5C%26quot%3B%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22%5C%26quot%3B50%25%5C%26quot%3B%22%20height%3D%22%5C%26quot%3B30px%5C%26quot%3B%22%3EItem%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B50%25%5C%26quot%3B%22%20height%3D%22%5C%26quot%3B30px%5C%26quot%3B%22%3EFile%20URL%26lt%3B%5C%2FTD%26gt%3B%26lt%3B%5C%2FTR%26gt%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22%5C%26quot%3B50%25%5C%26quot%3B%22%20height%3D%22%5C%26quot%3B30px%5C%26quot%3B%22%3ETree%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B50%25%5C%26quot%3B%22%20height%3D%22%5C%26quot%3B30px%5C%26quot%3B%22%3E%3CA%20href%3D%22%5C%26quot%3Bhttp%3A%2F%2Fwww.fubar.com%2Ftree1.jpg%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnofollow%20nofollow%20noopener%20noreferrer%22%20noopener%3D%22%22%20noreferrer%3D%22%22%3Ewww.fubar.com%2Ftree1.jpg%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2FTD%26gt%3B%26lt%3B%5C%2FTR%26gt%3B%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22%5C%26quot%3B50%25%5C%26quot%3B%22%20height%3D%22%5C%26quot%3B30px%5C%26quot%3B%22%3ETree%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B50%25%5C%26quot%3B%22%20height%3D%22%5C%26quot%3B30px%5C%26quot%3B%22%3E%3CA%20href%3D%22%5C%26quot%3Bhttp%3A%2F%2Fwww.fubar.com%2Ftree2.jpg%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnofollow%20nofollow%20noopener%20noreferrer%22%20noopener%3D%22%22%20noreferrer%3D%22%22%3Ewww.fubar.com%2Ftree2.jpg%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2FTD%26gt%3B%26lt%3B%5C%2FTR%26gt%3B%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22%5C%26quot%3B50%25%5C%26quot%3B%22%20height%3D%22%5C%26quot%3B30px%5C%26quot%3B%22%3EPig%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B50%25%5C%26quot%3B%22%20height%3D%22%5C%26quot%3B30px%5C%26quot%3B%22%3E%3CA%20href%3D%22%5C%26quot%3Bhttp%3A%2F%2Fwww.fubar.com%2Fpig1.jpg%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnofollow%20nofollow%20noopener%20noreferrer%22%20noopener%3D%22%22%20noreferrer%3D%22%22%3Ewww.fubar.com%2Fpig1.jpg%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2FTD%26gt%3B%26lt%3B%5C%2FTR%26gt%3B%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22%5C%26quot%3B50%25%5C%26quot%3B%22%20height%3D%22%5C%26quot%3B30px%5C%26quot%3B%22%3EPig%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B50%25%5C%26quot%3B%22%20height%3D%22%5C%26quot%3B30px%5C%26quot%3B%22%3E%3CA%20href%3D%22%5C%26quot%3Bhttp%3A%2F%2Fwww.fubar.com%2Fpig2.jpg%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnofollow%20nofollow%20noopener%20noreferrer%22%20noopener%3D%22%22%20noreferrer%3D%22%22%3Ewww.fubar.com%2Fpig2.jpg%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2FTD%26gt%3B%26lt%3B%5C%2FTR%26gt%3B%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22%5C%26quot%3B50%25%5C%26quot%3B%22%20height%3D%22%5C%26quot%3B30px%5C%26quot%3B%22%3EFlower%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B50%25%5C%26quot%3B%22%20height%3D%22%5C%26quot%3B30px%5C%26quot%3B%22%3E%3CA%20href%3D%22%5C%26quot%3Bhttp%3A%2F%2Fwww.fubar.com%2Fflower1.jpg%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnofollow%20nofollow%20noopener%20noreferrer%22%20noopener%3D%22%22%20noreferrer%3D%22%22%3Ewww.fubar.com%2Fflower1.jpg%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2FTD%26gt%3B%26lt%3B%5C%2FTR%26gt%3B%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22%5C%26quot%3B50%25%5C%26quot%3B%22%20height%3D%22%5C%26quot%3B30px%5C%26quot%3B%22%3EFlower%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B50%25%5C%26quot%3B%22%20height%3D%22%5C%26quot%3B30px%5C%26quot%3B%22%3E%3CA%20href%3D%22%5C%26quot%3Bhttp%3A%2F%2Fwww.fubar.com%2Fflower2.jpg%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnofollow%20nofollow%20noopener%20noreferrer%22%20noopener%3D%22%22%20noreferrer%3D%22%22%3Ewww.fubar.com%2Fflower2.jpg%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2FTD%26gt%3B%26lt%3B%5C%2FTR%26gt%3B%26lt%3B%5C%2FTBODY%26gt%3B%26lt%3B%5C%2FTABLE%26gt%3B%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20download%20all%20the%20pictures%20in%20the%202nd%20column%20en%20masse%20into%20the%20corresponding%20folder%20in%20the%201st%20column%20(%22tree1.jpg%22%20and%20%22tree2.jpg%22%20into%20folder%20name%20%22Tree%22%2C%20etc).%20Is%20there%20a%20straightforward%20way%20of%20doing%20so%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThanks%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3161200%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EMacros%20and%20VBA%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

I have a spreadsheet that looks something like this:

 

ItemFile URL
Treewww.fubar.com/tree1.jpg
Treewww.fubar.com/tree2.jpg
Pigwww.fubar.com/pig1.jpg
Pigwww.fubar.com/pig2.jpg
Flowerwww.fubar.com/flower1.jpg
Flowerwww.fubar.com/flower2.jpg

 

I'd like to download all the pictures in the 2nd column en masse into the corresponding folder in the 1st column ("tree1.jpg" and "tree2.jpg" into folder name "Tree", etc). Is there a straightforward way of doing so?

 

Thanks

0 Replies