Closed

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
Employer working
Skills Required
Project Budget
N/A
Total Bids
86
Project Description

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online