What a Data Analyst Did on Fiverr: From Excel to Python

A client sent over a spreadsheet with 31,000 rows, duplicate entries scattered everywhere, missing values, dates written in three different formats depending on which region entered them. Took five hours to manually untangle it. Paid Rs 950 for the whole job.

Three months later, a similar request came in from a different client. This time I had a Python script ready, close to a reusable template. Same kind of mess, cleaned in under six minutes.

That shift, moving from doing everything by hand in Excel to scripting it in Python, changed what freelancing actually looked like for me.

---

The Excel phase lasted a while

After finishing college, I worked at a small logistics company doing reporting and data entry. VLOOKUP, pivot tables, conditional formatting, all of it was second nature by then. The job itself was fine, the pay wasn't. Something like Rs 16,000 a month.

A colleague mentioned once, almost in passing, that Python could handle what Excel couldn't at scale. I nodded along and forgot about it within a week.

Then the company downsized and that job disappeared. Suddenly there was time, and not much else to do with it.

---

Learning Python wasn't the smooth process people describe

The first few weeks were genuinely confusing. No programming background at all, and error messages that meant nothing to me. An embarrassing chunk of week one went into just getting "print hello world" to actually run.

Honestly, there were a couple of nights I nearly gave up entirely. One tutorial would click, the next would feel like starting from zero again.

Pandas eventually started making sense once I realized it was basically Excel with different syntax, columns, filters, sorting, all the same underlying ideas dressed up differently. That reframing is what actually got things moving.

---

The first gig on Fiverr

Set up a gig titled "Excel & Python Data Cleaning." Mentioned Python specifically because it felt like it added something most Excel-only freelancers weren't offering.

Nothing happened for the first month. Second month brought one small order, Rs 480, cleaning maybe 400 rows. Tiny, but it was real.

Third month is when the 31,000-row project landed. The client said flatly, "nobody else on here seems to want to touch this properly." I took it on and did it manually, because Python wasn't strong enough yet to trust with something that size.

---

The mistake that actually taught me something

Handed a client a Python script once and told them to just run it themselves. Their system didn't have the right libraries installed, so nothing worked, and I got a confused message saying it just wasn't doing anything.

Spent two days screen-sharing to walk them through setup from scratch. That whole episode made it clear that a working script isn't enough on its own if the person receiving it can't actually run it.

Now every script comes with a short screen recording showing exactly how to run it. Adds maybe twenty minutes to each delivery, but it cuts the confusion down to almost nothing.

---

What the work looks like now

Somewhere around three or four gigs go out each week. Mostly data cleaning, a handful of dashboards in Excel or Google Sheets, and increasingly some small automation scripts too.

The same logic that worked for building a portfolio with self-initiated projects applied here as well. I put a few practice projects up on GitHub, mostly to show prospective Fiverr clients what the actual code and output looked like before they hired me.

Last month's total from data analysis gigs came to Rs 24,190. More than double the old logistics job's pay, with a schedule I actually control.

---

A client asked yesterday if I knew SQL. I don't, not really, just the basics I've picked up here and there. Said "I'll learn it" without thinking it through much. Now there's a queue of SQL tutorials open in another tab. No idea how long that one will take, but it's started.