We have 5,000 product descriptions in CSV format that need to be edited, revised, and cleaned up so we can update our live website with the cleaned versions. The data was scraped from 2 different sources and while the information is mostly there, it needs cleaning.
Sample of Data Attached
To start, this project is for the first 500, we will proceed with the next 500 project on successful completion of this one.
1.) Cut & Paste each description into [url removed, login to view] and look for HTML errors, typos, bad spacing, anything that looks out of the ordinary.
a. Skip products with a blank description for now (future project)
b. DO NOT Remove any HTML styling, HTML image embeds, and HTML URL links unless the HTML is broken or bad
c. DO remove all SCRIPT HTML code (only used on some products, and examples will be provided)
d. Fix any typos, bad spacing, any other visible and obvious errors.
2.) Paste the revised/clean description back into the CSV cell
3.) Using the same tool from above [url removed, login to view] take the TEXT ONLY output version (bottom part of screen) and paste it into MS Notepad / Mac TextEdit or similar program in Text Only mode, so it only pastes clean text without formatting
a. Images should automatically be removed since text only formatting doesnt support them
b. Remove any text that previously was a hyperlink (since hyperlinks will turn into non clickable text)
c. Fix any bullets or other characters that do not get properly formatted (Use * for text bullet if necessary)
d. Make sure spacing / linebreaks match the HTML description
4. Cut and Paste the TEXT only version of the Description into the TextOnly CSV field and make sure spacing, formatting is maintained.
Should be saved in UTF-8 encoding.
OpenOffice is preferred over Excel if possible
Saved in same CSV Format as delivered
Please email me with any questions! Would like to get started ASAP!