Data entry copy text from pdf into spreadsheet - repost
This project received 86 bids from talented freelancers with an average bid price of $11 USD / hour.Get free quotes for a project like this
Need data input from 8 PDF files into a single EXCEL sheet.
Will not pay more than $30 for this job so please don't bid above that.
Job needs to be completed within 2 days.
Spreadsheet has many columns but only 6 columns need to be filled out.
Column names to be filled out are ItemSKU, ItemDesc, ItemPrice, FModel, FColor, FBrand
8 PDF's have 29 pages in total.
First 7 PDF's need the following data filled out. (OPAL documents)
ItemSKU(Excel) = Reference(PDF)
ItemDesc(Excel) = Description(PDF)
ItemPrice(Excel) = Gross Unit Price (PDF)
FModel(Excel) = First 7 characters of Reference field (PDF)
FColor(Excel) = Last 3 characters of Reference field (PDF) along with colour listed in Description field (PDF)
FBrand(Excel) = brand name can be found in the Description field (PDF)
For the other pdf the format is slightly different (allison)
Item codes/brand names key
BB = Benetton
BN = Benetton
BE = Benetton
MO = Moschino
RH = Zero RH+
SY = Sisley
fields need to be entered into the spreadsheet in the following format:
ItemSKU(Excel) = ITEM CODE(PDF)
ItemDesc(Excel) = Please fill in item code brand name at the beginning, from the key above, and then add the DESCRIPTION(PDF)
eg. if item code is BB17801 and description field is PLASTIC OPTICAL FRAMES, please fill in spreadsheet with Benetton PLASTIC OPTICAL FRAMES
ItemPrice(Excel) = PRICE - DISC.(PDF)
FModel(Excel) = first 5 characters of ITEM CODE(PDF) eg. if item code is BB17801, FModel will be BB178
FColor(Excel) = last 2 characters of ITEM CODE(PDF) eg. if item code is BB17801, FColor will be 01
FBrand(Excel) = item code brand name, so again using the key above if the item code is BB178, FBrand will be Benetton
Please bid only if you understand the requirements and are sure you can complete the project within the specified time frame (2 days).
Once winning bidder has been chosen documents will be sent.
If completed work is found to be incorrect it will need to be revised and re-completed by winning bidder until satisfactory.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online