How to map excel keywords to their specific folders?
I have a list of supermarket items in excel say 6000 products for example. I run a software which takes one product name at a time and performs a google search, and then downloads the most relevant image for that particular keyword and places it in a sub-folder created using the same keyword name as the folder name. The Software i run does not always return back with the same number of product list(As some images of products are not found). Approximately for 6000 products, 5800 product images are downloaded.
My Question here is "Is there a way to get these sub-folders to match with their respective keyword in the excel sheet, so that i know which images haven't been downloaded"?
Check out the PICS :-
This is the Excel List for Example
These are the Images in sub-folders with the same keyword as excel name
microsoft-excel microsoft-excel-2010 windows-explorer microsoft-office user-folders
edited Dec 2 at 7:21
Mureinik
2,31751525
asked Dec 2 at 5:56
Zaid
31
add a comment |
I have a list of supermarket items in excel say 6000 products for example. I run a software which takes one product name at a time and performs a google search, and then downloads the most relevant image for that particular keyword and places it in a sub-folder created using the same keyword name as the folder name. The Software i run does not always return back with the same number of product list(As some images of products are not found). Approximately for 6000 products, 5800 product images are downloaded.
My Question here is "Is there a way to get these sub-folders to match with their respective keyword in the excel sheet, so that i know which images haven't been downloaded"?
Check out the PICS :-
This is the Excel List for Example
These are the Images in sub-folders with the same keyword as excel name
microsoft-excel microsoft-excel-2010 windows-explorer microsoft-office user-folders
edited Dec 2 at 7:21
Mureinik
2,31751525
asked Dec 2 at 5:56
Zaid
31
1
You need method (Macro) to get file names from folder to Excel sheet to match with existing names.
– Rajesh S
Dec 3 at 5:56
Other option besides macros would be to create a list of all folders and match them to current list using formula (e.g. MATCH).
– Máté Juhász
Dec 3 at 12:38
I am a noob and dont know what is a macro and how to implement macro and Match, can you guys please help me step by step?
– Zaid
Dec 3 at 17:55
add a comment |
I have a list of supermarket items in excel say 6000 products for example. I run a software which takes one product name at a time and performs a google search, and then downloads the most relevant image for that particular keyword and places it in a sub-folder created using the same keyword name as the folder name. The Software i run does not always return back with the same number of product list(As some images of products are not found). Approximately for 6000 products, 5800 product images are downloaded.
My Question here is "Is there a way to get these sub-folders to match with their respective keyword in the excel sheet, so that i know which images haven't been downloaded"?
Check out the PICS :-
This is the Excel List for Example
These are the Images in sub-folders with the same keyword as excel name
microsoft-excel microsoft-excel-2010 windows-explorer microsoft-office user-folders
edited Dec 2 at 7:21
Mureinik
2,31751525
asked Dec 2 at 5:56
Zaid
31
I have a list of supermarket items in excel say 6000 products for example. I run a software which takes one product name at a time and performs a google search, and then downloads the most relevant image for that particular keyword and places it in a sub-folder created using the same keyword name as the folder name. The Software i run does not always return back with the same number of product list(As some images of products are not found). Approximately for 6000 products, 5800 product images are downloaded.
My Question here is "Is there a way to get these sub-folders to match with their respective keyword in the excel sheet, so that i know which images haven't been downloaded"?
Check out the PICS :-
This is the Excel List for Example
These are the Images in sub-folders with the same keyword as excel name
microsoft-excel microsoft-excel-2010 windows-explorer microsoft-office user-folders
microsoft-excel microsoft-excel-2010 windows-explorer microsoft-office user-folders
edited Dec 2 at 7:21
Mureinik
2,31751525
asked Dec 2 at 5:56
Zaid
31
edited Dec 2 at 7:21
Mureinik
2,31751525
asked Dec 2 at 5:56
Zaid
31
edited Dec 2 at 7:21
Mureinik
2,31751525
edited Dec 2 at 7:21
Mureinik
2,31751525
edited Dec 2 at 7:21
Mureinik
2,31751525
2,31751525
asked Dec 2 at 5:56
Zaid
31
asked Dec 2 at 5:56
Zaid
31
asked Dec 2 at 5:56
Zaid
31
31
1
You need method (Macro) to get file names from folder to Excel sheet to match with existing names.
– Rajesh S
Dec 3 at 5:56
Other option besides macros would be to create a list of all folders and match them to current list using formula (e.g. MATCH).
– Máté Juhász
Dec 3 at 12:38
I am a noob and dont know what is a macro and how to implement macro and Match, can you guys please help me step by step?
– Zaid
Dec 3 at 17:55
add a comment |
1
You need method (Macro) to get file names from folder to Excel sheet to match with existing names.
– Rajesh S
Dec 3 at 5:56
Other option besides macros would be to create a list of all folders and match them to current list using formula (e.g. MATCH).
– Máté Juhász
Dec 3 at 12:38
I am a noob and dont know what is a macro and how to implement macro and Match, can you guys please help me step by step?
– Zaid
Dec 3 at 17:55
1
1
You need method (Macro) to get file names from folder to Excel sheet to match with existing names.
– Rajesh S
Dec 3 at 5:56
You need method (Macro) to get file names from folder to Excel sheet to match with existing names.
– Rajesh S
Dec 3 at 5:56
Other option besides macros would be to create a list of all folders and match them to current list using formula (e.g. MATCH).
– Máté Juhász
Dec 3 at 12:38
Other option besides macros would be to create a list of all folders and match them to current list using formula (e.g. MATCH).
– Máté Juhász
Dec 3 at 12:38
I am a noob and dont know what is a macro and how to implement macro and Match, can you guys please help me step by step?
– Zaid
Dec 3 at 17:55
I am a noob and dont know what is a macro and how to implement macro and Match, can you guys please help me step by step?
– Zaid
Dec 3 at 17:55
add a comment |
1 Answer
1
active
oldest
votes
Start > type "cmd" > Run . Then navigate to your pics folder using cd or cd ..
when you reached the folder, type dir to verify the content is the same as the folder view link you shared.
if it is correct, type in : dir /a:d /b > foldername.txt
then using notepad, open the newly created "foldername.txt" file (in the same folder), or you may type notepad foldername.txt directly to open it.
Once opened, copy all the listed folder names to B2 cell of your excel file .
Assuming there is 6000 products (in column A) , type this in C2, and drag it until C6001.
=COUNTIF(B:B,A2)
If the value is 1, there is a folder created. If 0, then no folder is created.
Hope it helps.
answered Dec 4 at 6:54
p._phidot_
54928
Hey Buddy, everything worked well until the last part, when i Copied 5300 folder names in Column B next to 6000 keyword names. Firstly the keyword and the Folder Names dint match as 700 keywords are missing and secondly since Column B ends at 5300. Every value after 5300 gives 0 as Column B is empty after 5300.
– Zaid
Dec 4 at 7:11
sorry.. error in the formula.. it should be=COUNTIF(B:B,A2)instead. My bad. :|
– p._phidot_
Dec 4 at 9:06
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1380111%2fhow-to-map-excel-keywords-to-their-specific-folders%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Start > type "cmd" > Run . Then navigate to your pics folder using cd or cd ..
when you reached the folder, type dir to verify the content is the same as the folder view link you shared.
if it is correct, type in : dir /a:d /b > foldername.txt
then using notepad, open the newly created "foldername.txt" file (in the same folder), or you may type notepad foldername.txt directly to open it.
Once opened, copy all the listed folder names to B2 cell of your excel file .
Assuming there is 6000 products (in column A) , type this in C2, and drag it until C6001.
=COUNTIF(B:B,A2)
If the value is 1, there is a folder created. If 0, then no folder is created.
Hope it helps.
answered Dec 4 at 6:54
p._phidot_
54928
Hey Buddy, everything worked well until the last part, when i Copied 5300 folder names in Column B next to 6000 keyword names. Firstly the keyword and the Folder Names dint match as 700 keywords are missing and secondly since Column B ends at 5300. Every value after 5300 gives 0 as Column B is empty after 5300.
– Zaid
Dec 4 at 7:11
sorry.. error in the formula.. it should be=COUNTIF(B:B,A2)instead. My bad. :|
– p._phidot_
Dec 4 at 9:06
add a comment |
Start > type "cmd" > Run . Then navigate to your pics folder using cd or cd ..
when you reached the folder, type dir to verify the content is the same as the folder view link you shared.
if it is correct, type in : dir /a:d /b > foldername.txt
then using notepad, open the newly created "foldername.txt" file (in the same folder), or you may type notepad foldername.txt directly to open it.
Once opened, copy all the listed folder names to B2 cell of your excel file .
Assuming there is 6000 products (in column A) , type this in C2, and drag it until C6001.
=COUNTIF(B:B,A2)
If the value is 1, there is a folder created. If 0, then no folder is created.
Hope it helps.
answered Dec 4 at 6:54
p._phidot_
54928
Hey Buddy, everything worked well until the last part, when i Copied 5300 folder names in Column B next to 6000 keyword names. Firstly the keyword and the Folder Names dint match as 700 keywords are missing and secondly since Column B ends at 5300. Every value after 5300 gives 0 as Column B is empty after 5300.
– Zaid
Dec 4 at 7:11
sorry.. error in the formula.. it should be=COUNTIF(B:B,A2)instead. My bad. :|
– p._phidot_
Dec 4 at 9:06
add a comment |
Start > type "cmd" > Run . Then navigate to your pics folder using cd or cd ..
when you reached the folder, type dir to verify the content is the same as the folder view link you shared.
if it is correct, type in : dir /a:d /b > foldername.txt
then using notepad, open the newly created "foldername.txt" file (in the same folder), or you may type notepad foldername.txt directly to open it.
Once opened, copy all the listed folder names to B2 cell of your excel file .
Assuming there is 6000 products (in column A) , type this in C2, and drag it until C6001.
=COUNTIF(B:B,A2)
If the value is 1, there is a folder created. If 0, then no folder is created.
Hope it helps.
answered Dec 4 at 6:54
p._phidot_
54928
Start > type "cmd" > Run . Then navigate to your pics folder using cd or cd ..
when you reached the folder, type dir to verify the content is the same as the folder view link you shared.
if it is correct, type in : dir /a:d /b > foldername.txt
then using notepad, open the newly created "foldername.txt" file (in the same folder), or you may type notepad foldername.txt directly to open it.
Once opened, copy all the listed folder names to B2 cell of your excel file .
Assuming there is 6000 products (in column A) , type this in C2, and drag it until C6001.
=COUNTIF(B:B,A2)
If the value is 1, there is a folder created. If 0, then no folder is created.
Hope it helps.
answered Dec 4 at 6:54
p._phidot_
54928
edited Dec 4 at 9:07
answered Dec 4 at 6:54
p._phidot_
54928
answered Dec 4 at 6:54
p._phidot_
54928
answered Dec 4 at 6:54
p._phidot_
54928
54928
Hey Buddy, everything worked well until the last part, when i Copied 5300 folder names in Column B next to 6000 keyword names. Firstly the keyword and the Folder Names dint match as 700 keywords are missing and secondly since Column B ends at 5300. Every value after 5300 gives 0 as Column B is empty after 5300.
– Zaid
Dec 4 at 7:11
sorry.. error in the formula.. it should be=COUNTIF(B:B,A2)instead. My bad. :|
– p._phidot_
Dec 4 at 9:06
add a comment |
Hey Buddy, everything worked well until the last part, when i Copied 5300 folder names in Column B next to 6000 keyword names. Firstly the keyword and the Folder Names dint match as 700 keywords are missing and secondly since Column B ends at 5300. Every value after 5300 gives 0 as Column B is empty after 5300.
– Zaid
Dec 4 at 7:11
sorry.. error in the formula.. it should be=COUNTIF(B:B,A2)instead. My bad. :|
– p._phidot_
Dec 4 at 9:06
Hey Buddy, everything worked well until the last part, when i Copied 5300 folder names in Column B next to 6000 keyword names. Firstly the keyword and the Folder Names dint match as 700 keywords are missing and secondly since Column B ends at 5300. Every value after 5300 gives 0 as Column B is empty after 5300.
– Zaid
Dec 4 at 7:11
Hey Buddy, everything worked well until the last part, when i Copied 5300 folder names in Column B next to 6000 keyword names. Firstly the keyword and the Folder Names dint match as 700 keywords are missing and secondly since Column B ends at 5300. Every value after 5300 gives 0 as Column B is empty after 5300.
– Zaid
Dec 4 at 7:11
sorry.. error in the formula.. it should be
=COUNTIF(B:B,A2) instead. My bad. :|– p._phidot_
Dec 4 at 9:06
sorry.. error in the formula.. it should be
=COUNTIF(B:B,A2) instead. My bad. :|– p._phidot_
Dec 4 at 9:06
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1380111%2fhow-to-map-excel-keywords-to-their-specific-folders%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
You need method (Macro) to get file names from folder to Excel sheet to match with existing names.
– Rajesh S
Dec 3 at 5:56
Other option besides macros would be to create a list of all folders and match them to current list using formula (e.g. MATCH).
– Máté Juhász
Dec 3 at 12:38
I am a noob and dont know what is a macro and how to implement macro and Match, can you guys please help me step by step?
– Zaid
Dec 3 at 17:55