Wine list to Excel conversion and standardisation
₹1500-12500 INR
Paid on delivery
I need assistance gathering wine list data from restaurant websites (normally in PDF), converting to Excel and formatting into a standardised 2 column list (wine name, colour) for upload into a database.
The challenge: restaurants lists vary in presentation from restaurant to restaurant, meanwhile I need standardised information. Converting each list into the required format requires a significant amount of manual intervention. Each list is different.
Issues
There are three principal issues / challenges: Colour – Name - Formatting
Colour (white – rose – red)
Wine lists are normally organised by colour / style – typically: sparkling wine (which are mainly white, but include rose), white wines, red wine, dessert wines (normally white), fortified (mixture of red and white). Lists normally include general headers white wines – red wines, etc, but not always, meanwhile I need a colour attached to every line in the csv output file
Name
I need wine names in a standardised format that the database will recognise.
The complete list of wines in the database can be downloaded for comparison – however, Excel VLOOKUP is not sophisticated enough for matching between the two data sets
Some wines include maker name + wine name + region + vineyard name. Others just include maker name.
E.g. for Bordeaux wines producer name only: Chateau Margaux. For Burgundy producer name + village name + vineyard name
Domaine ABC + Vineyard name + reference for Premier or Grand Cru + Village name
Producer names and wine are often in different cells – sometimes the producer name will be at the top of a sub section and the concatenation therefore needs an absolute reference
Formatting
Converting accented characters to non-accented
Removing and standardising certain words, phrases and characters
Removing blanks and reducing the list to a standardised three column format
Some of the formatting processes are relatively easy to run through VBA modules (e.g. find and replace / delete)
If you would like to help me please visit [login to view URL] for an example of a particularly long and complex list. Please convert the PDF into XL, format and send me a sample 20 lines in a 2 column file (name, colour)
I need this done quickly and with 100% accuracy.
Payment will be batches at the rate of $100 / 5000 lines of lines of output. Scope: 150 restaurant lists - size varies from list to list.
If you can come up with an automated solution using VBA so much the better
Project ID: #34380243
About the project
24 freelancers are bidding on average ₹7053 for this job
HI hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects. I has done tons of projects similar to your requirement using VBA,RPA,P More
I am good at typing with high speed at good accuracy. I have good command over Excel, Power point and word softwarre. I have handled same kind of projects before.
I have all the skills and experience listed in the job description. I am confident that I can solidly contribute to the success of the company. My self drive is an assurance that I will be able to deliver within the s More
Hi Dear sir/madam I am a proffessional data entry oprator Please asign me this project i will do my job best
I ambestwriter . And all skill are prensent to this lroject requiredso plzz hired me and please one chance give me
“I am interested in this job because it will offer me an opportunity to utilize my professional skills in typing and accuracy. I can type 75 words per minute with 95% accuracy. I believe that these skills will make me More
I read your massage. I do it. Please send your data then I try it fast . Let me more Hopping to reply me Thanks
Hello sir and ma'am I am Yogandhar dewangan and I am data entry expert and ms office tools my work is neet and clean I am do your work in time and fast ..... Give me opportunity to this work thanku....
I am a Sommelier So i provided You The Best Wine List that You Are Looking For and i am good in data entry so in that project i give my best effort .
i am a experienced data entry operator and i am expertin these projects and i am sure that you be happy by my works
After reading through your requirements i belive i am the right person for the job i know exactly what needs to be done and there are better ways than vlookup
Hello, I'm well experienced in data wrangling where I can extract data from websites and convert it to excel . I do my research well before starting this project about wine history and I'm curious to learn about it to More
I believe in quality work and customer satisfaction is our motives.i know you need quality work rather then quantity.
I found this job online and decided to apply because it seemed interesting, and things at my current employer seem a little uncertain. They’re laying off a lot of people right now, so I wanted to see what other options More
hello... i'm an excel specialist Give me a chance to make this work I will have the work ready in 5 days
I am expert in data entry work from my side let you get rid of any problem and finish your work before your due time I want to work not for you but for me
I am a expert data entry operator. I am interested to do this work . please give me this project.
My name is sohel ali i am from india. I want bulid you trust in the this type work because i want knowledge in wines
Hello , I am self - disciplined person , goal - oriented and reliable . I have a detailed mind , am very flexible and always prioritise my client above all else .I always trying to get my 100 percent . I ensure all pro More