I am looking to copy data from website into an excel sheet. This is regarding the restaurants. I need the restaurant menu in a specific format.
We need to copy the restaurant food menu and enter this menu into the excel spread sheet.
For each restaurant we will have a separate folder names.
The format of the excel sheet is as below:
Name Category Sequence Price Currency Image Description
Aloo Paratha Parathas 1 3.99 $ [login to view URL] This is a description of the food item
Name is the name of the individual food item.
Category is the category of the food item such as Rice, Roti, Vegetables, soups etc.. under which each individual item will be listed.
Sequence is the order in which the categories should be listed.
Price of the individual food item
Currency as $
Image: Some of the menu items have images associated. So if the food item has a image associated, from the below menu links, please save it on your disk locally.
Description of the food item as listed
Attached upload format is in excel sheet. The images of the food items and the excel sheet have to be in the same folder and in zipped format. The excel sheet should be named as menu.xlsx.
For each restaurant you need to have a separate folder, The folder name should be same as the restaurantName_CityName
For example. [login to view URL] The folder name will be favoriteindia_san-Ramon.
If you look at the menu we find that the categories are "Appetizers", "Tandori Dishes" "Chicken", "Lamb", "Seafood" etc.
For reference, I have attached a sample Excelsheet
Initially for testing purpose you can do 10 restaurants, eventually in coming weeks we will have to do this for least 200 restaurants.
[login to view URL] (City : San Ramon )
[login to view URL] (City : San Ramon )
[login to view URL] (City : San Ramon )
[login to view URL] (City : San Ramon )
Note : Salad, Appetizer, Lunch, Dinner, Shushi, Specialties , Desser are categories
[login to view URL] (City : Livermore )
Note: Lunch menu, Dinner menu, Wine menu etc are categories.
[login to view URL] (City : Livermore )
[login to view URL] (City : Livermore )
[login to view URL] (City : Livermore )
[login to view URL] (City Livermore)
[login to view URL] (City: Livermore)