Banner Image

All Services

Programming & Development

Data Cleansing and Document Processing

Do you need to clean up names, addresses and more in Excel spreadsheets? Don't waste time doing it manually, let me take care of it. (Click on Data Cleansing and Document Processing to read more.)

The most time-consuming part of cleaning your data is knowing what's missing, duplicated or inconsistent. With thousands of rows of data, you can't just scroll through your spreadsheet and expect to catch everything.

Excel provides powerful tools to help. If you don't have the time or manpower to dig through the menus, you can send me your detailed requirements, sample inputs and outputs and let me see if I can help you.

I use Excel and a variety of other programs to automate workbook cleansing. Turn-around time is typically 24 to 48 hours, depending on the complexity of your requirements.

While most of my projects involve Excel workbooks, I can clean HTML, CSV, TXT and other plain-text files.

Here are just a few types of cleaning you can request:

* Name, Address, Contact information clean-up (excluding web lookups)

* De-duplicate rows

* Merge multiple files into one output file

* Extract relevant data buried in text, HTML, Word and Excel files

* Strip unwanted garbage from files, including web links and strange symbols

* Convert from one file format to another (CSV, XLS, XLSX, TXT)

(Please note: this is a DOCUMENT DELIVERY service. Contact me about software development.)

Skills & Expertise

CleanCSV (Comma Separated Values)ExcelMs ExcelPattern RecognitionProcessingSoftware DesignSpreadsheets

16 Reviews for This Service

Sign up or Log in to see more.