Kapalı

Wine list to Excel conversion and standardisation

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

Beceriler: Excel, Veri Girişi, Veri İşleme, Web Scraping, Excel VBA

Müşteri Hakkında:
( 19 değerlendirme ) Edinburgh, United Kingdom

Proje NO: #34353565

Bu iş için 130 freelancer ortalamada £974 teklif veriyor

(118 Değerlendirme)
8.9
(467 Değerlendirme)
8.3
(553 Değerlendirme)
8.4
(199 Değerlendirme)
7.1
(103 Değerlendirme)
7.2
hdlong66

Hello, I can assist you in gathering wine list data from restaurant websites. My price is £100 per 2,000 names. I have prepared and posted a sample here [login to view URL] Daha Fazla

£750 GBP in 30 gün içinde
(189 Değerlendirme)
7.2
(394 Değerlendirme)
6.8
(143 Değerlendirme)
6.8
mananraja

hi I checked the restaurant list you attached. I can automate this process, and therefore complete this in shortest timeframe. I'm interested to discuss more details with you in chat. Abdul H.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(258 Değerlendirme)
7.0
(117 Değerlendirme)
7.0
ibrahimstk

Hi  Richard , I am ready to start Data entry work to Wine list to Excel conversion and standardisation as per the details in your project and able to make it professional within a short time frame. I checked your detai Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(258 Değerlendirme)
6.6
(46 Değerlendirme)
6.7
(104 Değerlendirme)
6.7
best4best

Hi, I am very efficient and accurate Excel expert. I need to discuss with you before starting the project to understand how to standardize these different formats. However here are some sample rows for your quick revi Daha Fazla

£1125 GBP in 7 gün içinde
(212 Değerlendirme)
6.6
(71 Değerlendirme)
6.4
Devrits

Hello! I am an expert Python developer with skills including Web Scraping, Excel, Data Processing, Excel VBA and Data Entry. - web scraping, data mining, data extraction, data transformation, - writing scripts and uti Daha Fazla

£1500 GBP in 4 gün içinde
(86 Değerlendirme)
6.3
(103 Değerlendirme)
6.2
PoojaRautela417

Hi there, I can develop script in Python to gather wine list data from restaurant websites. I am an expert in C#, Python, Automation, Django, Flask, JavaScript, Node.js, Chrome Extension, Web Scraping, MYSQL. You can Daha Fazla

£1000 GBP in 7 gün içinde
(100 Değerlendirme)
6.4
Logo199

Hi Good day I am professional data entry operator here who wants to work with you to make Wine list in excel I will do manually with high accuracy Thank you

£1000 GBP in 7 gün içinde
(97 Değerlendirme)
6.0
(129 Değerlendirme)
6.2