Tripadvisor

Job ID: 32719150

Budget: ₹750 – ₹1,250 INR

Tripadvisor
In this folder you'll find 87 excel files
Each of them contain 50 restaurants
The name of the file is important as it contains the location and family/lunch/dinner
Requested result:
Merge all files into one sheet, watch out, the information in the file name should be found in each record in the fields L (Type) and N (City/Town).
One sheet with all the restaurants formatted like the file template_TripAdvisor.xlsx
The first row can not be changed, this is the basis.
In the second row is indicated what information should be imported
Empty fields should stay empty
If there is just a word than this has to be in every () means it talks about a field in de source file who's content should be placed here
For de fields L (Type) and N (City/Town) de source is in the file name of the 87 excel files.
From row 4 to row 10 there is some sample data to have an idea of the result that is requested, please delete those!
Tiqets.Com
Format the file Tiqets.xlsx based on template_Tiqets.xlsx
In the template
The first row can not be changed, this is the basis.
In the second row is indicated what information should be imported
Empty fields should stay empty
If there is just a word than this has to be in every field () gives the field name in the source file who's content should be placed here, there might be extra explanation about how the formatting should be altered
From row 4 to row 10 there is some sample data to have an idea of the result that is requested, please delete those!
Getyourguide
Format the file getyourguide.xlsx based on template_getyourguide.xlsx
In the template
The first row can not be changed, this is the basis.
In the second row is indicated what information should be imported
Empty fields should stay empty
If there is just a word than this has to be in every field () gives the field name in the source file who's content should be placed here, there might be extra explanation about how the formatting should be altered
From row 4 to row 10 there is some sample data to have an idea of the result that is requested, please delete those!
booking
Format the file booking.xlsx based on template_booking.xlsx
In the template
The first row can not be changed, this is the basis.
In the second row is indicated what information should be imported
Empty fields should stay empty
If there is just a word than this has to be in every field