Jiaheng Sui

WHAT I DO — CONCRETE TASKS & DELIVERABLES

Data entry: I manually enter and verify data into Excel, Google Sheets, CRMs (HubSpot, Zoho) and e-commerce backends. Typical jobs: 500-10,000 rows of product catalogs, contact lists, invoice records, real-estate listings. You receive a clean XLSX/CSV with a QA report (spot-check sample, duplicate count, error rate).

Web scraping & data extraction: I build custom scrapers with Python (Scrapy, BeautifulSoup, Selenium/Playwright) that extract product prices, business directories, real-estate listings and review data. Output: structured CSV/Excel/JSON, or auto-delivery to Google Sheets or your API. For sites without an API I handle pagination, login-protected pages and anti-bot delays.

Data cleaning & formatting: deduplication, standardizing names/addresses/phone formats, splitting merged fields, converting PDF/image tables into editable spreadsheets (OCR + manual verification).

TOOLS & STACK
- Python: Scrapy, BeautifulSoup, Selenium, Playwright, Pandas
- Spreadsheets: Excel (formulas, pivot tables, VLOOKUP/XLOOKUP), Google Sheets (IMPORTRANGE, Apps Script)
- Databases: MySQL, PostgreSQL (import/export, simple queries)
- OCR: for scanned-document data entry

WHAT YOU GET
- Fixed or hourly, milestone-based delivery
- A test sample of the first 20-50 rows before full run, so you can approve quality early
- Source files + summary sheet + a short documentation of the process

Example projects I can handle end-to-end: scrape 5,000 products from a competitor site into a priced spreadsheet; clean a 20,000-row mailing list to a valid, deduplicated format; daily automated price monitoring delivered to Google Sheets.