Freelancer · open to new projects

Santosh Kumar Singh

I turn messy spreadsheets, data and documents into clean, working results — and design the visuals that go with them.

  • Google Sheets & Excel
  • Python · pandas
  • PDF extraction
  • Thumbnails
  • JavaScript
  • Proofreading

01 — Services

What I can do for you

Six core services, most with a real sample you can open and download below.

Google Sheets & Excel automation

Formulas that tag, clean and summarise data on their own: lookups, rule tables, dashboards, Apps Script triggers.

View sample →

Python data analysis & charts

pandas analysis, descriptive statistics and clear, labelled charts, with a short written summary of what the data shows.

View sample →

PDF / data extraction & scraping

Scripts that pull text, tables and fields out of PDFs and web pages into clean text, CSV or Excel you can reuse.

View sample →

YouTube thumbnails & graphics

Bold, readable 1280×720 thumbnails and social graphics, designed to stay legible at phone size.

View sample →

JavaScript & web development

Fast static sites, landing pages, calculators and small tools in plain HTML, CSS and JavaScript. This site is hand-written.

Code on GitHub ↗

02 — Selected work

Sample work

Each project below is sample work made for this portfolio, not client work. The data is public or synthetic, and every file can be downloaded.

Sample

Transaction auto-categorization workbook

Paste raw bank-style rows and the sheet tags each one with a category, income/expense, the matched keyword and a review flag, using an editable rules table. Works in Google Sheets and Excel.

  • 60 synthetic transactions · 3 sheets (Transactions, Rules, Summary)
  • No macros. Add a rule by adding a row
transaction_categorizer_SAMPLE.xlsx: Transactions
DateDescriptionAmount (₹)CategoryStatus
01 SepSPOTIFY INDIA−119SubscriptionsOK
03 SepUPI/RAHUL K/3122−862Transfers (UPI)OK
04 SepINTEREST CREDIT SB A/C114InterestOK
05 SepNEFT RENT TO LANDLORD−15,000RentOK
06 SepUPI REFUND FLIPKART 6098624RefundsOK
09 SepCHQ DEP 0047422,954Uncategorized⚠ Review
09 SepNEFT-SALARY ACME TECH PVT LTD65,000SalaryOK
Real rows from the sample file, values as calculated by its formulas. Rows with no matching rule get flagged, not guessed.
Sample

Descriptive analysis & trend charts: CO₂ emissions 1990–2024

A Python (pandas + matplotlib) analysis of the public Our World in Data CO₂ dataset: descriptive statistics, three labelled 300-dpi charts and a one-page PDF summary, all from one script you can run again.

Data: Our World in Data, CO₂ dataset (CC BY 4.0).

Sample

Layout-preserving PDF → text extractor

A Python/PyMuPDF script that keeps page breaks, line wraps, indentation and table alignment, and marks bold and italic as Markdown or HTML tags. Tested on a synthetic two-page document.

  • Input: a PDF with selectable text · Output: .txt with page markers
  • Scanned pages need OCR first (not included)
output_markdown.txt
===== Page 1 / 2 =====

**2. Key figures**

**Metric**                    **Q2**    **Q3** **Change**
  Orders                   12,400     14,632      +18.0%
  Avg. delivery (days)         4.1        3.6         -0.5
  Return rate                3.9%       3.7%      -0.2 pts

===== Page 2 / 2 =====

**3. Next steps**

• Pilot the new courier partner in **two cities**.
• Publish the *returns playbook* for the support team.
Actual output from the sample PDF. Table columns stay aligned.
Sample designs

YouTube thumbnails for tech & finance topics

Three 1280×720 documentary-style concepts: a 3–4 word headline readable on a phone, one accent colour per topic, and text kept clear of YouTube's timestamp corner. Background images are generated; grading, layout and type are done by hand in Python/Pillow.

03 — Also available

More ways I can help

I also take on the work below. There are no samples on this page for these yet, so tell me what you need and I'll say honestly whether it's a good fit before we start.

  • Web & app development
  • Coding & scripts
  • Video editing
  • Logo & brand design
  • Presentations
  • Copywriting & content
  • SEO basics
  • Social media content
  • Research
  • Virtual assistance & admin
  • Data entry
  • Translation

04 — How I work

Simple, clear and on time

  1. 1

    Clear brief & quote

    You share the file or the goal. I reply with what I'll deliver, the price and a delivery date, in writing, before any work starts.

  2. 2

    Fast first draft

    A first working version usually within 24 hours for small jobs, so you can react early instead of waiting until the deadline.

  3. 3

    Revisions included

    I revise until the result matches the agreed brief. Questions get a direct answer, and I tell you about problems as soon as I find them.

  4. 4

    Clean handover

    You get every source file (sheets, scripts, design files) plus short notes, so you can use and change the work without me.

05 — Contact

Have a file that needs fixing, analysing or designing?

Send a short description and, if you can, a sample file. You'll get a reply with a clear plan and quote.