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
Project Budget
Total Bids
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:


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.

Skills Required

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