I have 25 individual language CSV files of keyword phrases with the matching word in English.
We have a second CSV with around 180,000 English keyword phrases that have been classified into multiple categories.
The goal s to merge the two files (language + classifications) into a single .csv so we can assign all of the keyword categories to the local language equivalent keyword phrase
This process will be done for each of the 25 individual language files.
Example – Combing the German File with the English Classification file
Local Language to English (file 1) has 2 columns
Local Language English
Anwendungsserver application server
English Categorization Data (File 2) has up to 10 columns
Keyword Phrase Architecture Buy Cycle Keyword Category
application server Data Center Inspiration Rack-Mount Servers
Resulting in a single CSV file
Keyword Phrase English Architecture Buy Cycle Keyword Category Keyword Priority Keyword Type Model
Anwendungsserver application server Data Center Inspiration Rack-Mount Servers Tier 4 Technology Unclassified
13 freelancers are bidding on average $346 for this job
This is quite easy task and my estimate is 2 hours. No need to prepay to start and complete the work. I will practically do it for reputation. Regards, Svetlin