CSV Names ALL CAPS and lowercase Mixed? The Lanyard Box

2026-11-04

It is 8:40 on a Thursday morning, and Mara is standing at a folding table in a hotel foyer with a box of lanyards at her feet.

The conference starts at ten. She is the freelance organiser, which means she is also the person who prints the badges, tapes down the cable and knows where the spare pens are.

The first badge slides out of the little printer. ANNA SCHMIDT.

The second: peter müller.

The third: Katrin o'brien.

The fourth: JEAN-LUC DUBOIS, in letters so large the company name has been pushed off the edge.

She holds them up in a row, like a bad hand of cards. Her stomach does the small drop she knows well.

The export that looked fine

She had opened the registration file on Tuesday. It had come from the ticket platform, with a few late sign-ups added by hand from emails. She had scrolled through it, seen names in cells, and thought: good, done.

She had not looked at it the way a guest would look at their own badge.

Some people had typed their names in capitals because the form field felt like a government form. Some had typed in lowercase from a phone, thumb in a hurry. Some had been entered by a colleague, with a capital where it should be and not where it shouldn't. Every row was correct. None of the rows matched.

Now the first guests are twenty minutes away, and a man from the sponsor's team is walking toward the table with a friendly face and a lanyard already in hand.

"Morning! Am I on the list?"

"You are," Mara says. She turns his badge over so he can't read it. "Give me one second."

The small shame nobody mentions

Here is the part she would never say out loud to the organisers she compares herself to. It isn't the badges. It is the thought underneath them.

A real company would have caught this.

A real company would have a person for data. A real company would not be holding a pen over a sticker sheet, writing "Peter Müller" by hand because the printer shouted at him. She is a one-woman business, and every small mess like this one quietly argues that she isn't running a proper one.

It has a cost beyond today. It is the Tuesday night she keeps meaning to check the file and doesn't. It is the way she dreads sending anything to the whole list, because the greeting might read "Hello ANNA" or "Hello peter", and clients notice that kind of thing, even when they are kind about it.

It is also the hour she'll lose now. Stickers, a pen, an apology for each wrong badge, and a quiet promise to herself that next time will be different.

That promise has been made before.

The sticker sheet and the thought that stuck

She writes eleven badges by hand. Her handwriting is fine, but it is not a badge. By ten past nine the doors are open and people are drifting in, taking their lanyards and smiling. Nobody says a word about the capitals. Nobody ever does, which is somehow worse. They just see it and file it away.

Around eleven, in the gap between the first talk and the coffee break, she sits down with a lukewarm tea and looks at the file again. Not at the data, but at the shape of the problem.

It wasn't a hard problem. It was the same small one every time: a name is a name, however it was typed, and nothing in her process ever tidied them into one calm style before they went out into the world. The work wasn't difficult, it was repeated. And repeated work, she realises, is exactly the kind that should never reach her at 8:40 on the morning of the event.

It doesn't have to be a heroic fix. It just has to happen before, quietly, with a clear note of what changed, so that she can glance at it and trust it. She wants names that look like names, a list of anything odd to check by eye, and nothing touched without her seeing it first.

She writes it on the back of a lanyard card, in pen. Tidy before printing. Look before it changes.

A normal Monday, afterwards

Picture the next event instead. Not a dramatic one. A Monday, ten days out.

The registration export lands in her inbox. She makes tea first, which she never used to do. She drops the file into a small routine that she trusts, and a minute later there is a short report on her screen: these names were adjusted, these two look unusual, these three could be the same person. She scans it the way you scan a shopping list.

She approves it, prints a single test badge, and holds it up.

Anna Schmidt. Peter Müller. Katrin O'Brien.

They look like people someone was glad to expect.

Then she closes the laptop and goes for a walk, because the morning of the event is no longer where this gets solved. It was solved on a quiet Monday, and the foyer on Thursday is just a foyer, with a box of lanyards and a bowl of mints.

If this was your Thursday

If you have ever stared at a list where half the names shout and half whisper, you're not careless. You are one person doing the work of a back office. That's all.

For the days when you want the cleaning to happen quietly, with a preview before anything changes and a report afterwards, there is the Clean Data in Minutes – CSV & Excel Cleaning Toolkit (Python). It includes a dry-run mode and a change report, and it carries our 30-day money-back promise. If it doesn't help, you get a full refund, no questions asked.

No rush. Just something to have ready for the next export.

An illustrative story, written with AI assistance.