Job Description
I am looking for an experienced Excel specialist to populate missing book metadata in a target spreadsheet using data from a provided source spreadsheet.
This is a straightforward data-mapping and cleanup task, but accuracy is critical as the file will be used for publishing and distribution.
Scope of Work
You will be provided with:
Source Excel file containing complete metadata
Target Excel file with missing fields that need to be filled
Your task is to match rows by Title and populate the following fields in the target file using the source data:
Columns to Complete in the Target File
Column O – Height (mm)
Column P – Width (mm)
Column Q – Depth / Spine (mm)
Column R – Weight (kg)
Convert from grams if necessary
Column CG – Main Description
Column CR – RRP including VAT (GBP)
Requirements
Strong Excel skills (VLOOKUP / XLOOKUP / INDEX-MATCH)
Experience working with book or product metadata (preferred)
Ability to:
Match records accurately by Title
Convert units correctly (grams → kilograms)
Preserve formatting and existing data
Attention to detail — no overwriting of incorrect columns
Deliverables
A completed Excel file with all specified columns filled
No images, screenshots, or PDFs — Excel file only
Any unmatched titles should be clearly flagged (e.g., highlighted or listed separately)
Estimated Time
1–2 hours for an experienced Excel user.
How to Apply
Please include:
A brief description of your Excel experience
Confirmation you can deliver an actual Excel file, not screenshots
Any relevant experience with product or publishing metadata
Apply Now
Apply Now