What is actually inside your customer list CSV, column by column

You exported the file because an article told you to. It opened in a spreadsheet, showed a wall of email addresses and some columns you did not look at closely, and you closed it. It has been sitting in your downloads folder ever since, doing nothing, which is a shame, because it is the only document you own that can tell you who is actually paying you and why.

Why the file feels unreadable at first

A CSV is a plain text file pretending to be a spreadsheet, and spreadsheets do rude things to it on the way in. Dates get reformatted into whatever your machine's locale prefers. Long numbers occasionally become scientific notation. Names with accents can arrive mangled if the file opens in the wrong character encoding. None of this is your data being wrong, but it is enough to make a first look feel like a failure.

The second obstacle is that nothing labels itself as important. Every column looks equally significant in a grid, and the two or three that matter are sitting next to several that you will genuinely never use. Knowing which is which is most of the skill.

The last difficulty is honest and worth stating: exports evolve. Fields get added as the product grows. Anything you build on top of the file should read the header row rather than assuming the third column is what it was last spring.

What makes this export different

A list exported from a general newsletter tool is a record of who signed up. This one is a record of what people did with you, which is a different and more useful thing.

The fields, and what each is worth

Open the file and read the header row properly before anything else. The exact wording is whatever the current export uses, but the substance falls into these groups.

Identity: name and email

The email address is the primary key of your entire business, and it is the field every other tool will match on. The name is what makes a message readable. Both are worth a quick clean: emails with obvious typos and names typed entirely in capitals are the two things that make a mail merge look automated.

Money: lifetime value

This is the field to sort on. It is the total that person has spent with you, tracked per person in the customer list, so a sort from high to low gives you your best customers in the order that matters, and a filter for zero gives you everyone who has only ever taken free things. Almost every useful decision in this file starts with one of those two views.

Provenance: what they bought or claimed

This is the field people ignore and should not. It tells you which product is doing the recruiting rather than the earning, which are often not the same product. If most of your highest-value customers first appeared through one free download, that download deserves promotion, a better title and possibly a sequel.

Time and status: when they arrived, and where they stand

Dates let you slice the list by cohort: compare people who arrived in one month against another and you can see whether a launch, a video or a collaboration brought in people who actually spend rather than simply people who counted. If you run a membership or community, the list also knows who is currently in it, which gives you a third group worth treating differently: paying now, versus paid once, versus never paid. See memberships for how that side records itself.

Three questions the file answers in five minutes

Suppose the file has 1,400 rows. Sort by lifetime value, high to low, and read the top thirty names. If you recognise a fifth of them, you have a relationship business and should be writing to those people individually rather than in a broadcast. Filter to lifetime value greater than zero and count the rows: 96 out of 1,400 is your paying share, and it is the number to track month on month rather than list size.

Then take that same paying group and look at the product each of them first arrived through. If 60 of the 96 came in through one free checklist, you have found the front door of your business, and everything about that checklist deserves attention: its position on your storefront, its title, and what sits directly beneath it. Those figures are invented to demonstrate the sorts. Your own answers may be duller or considerably more surprising, which is the point of looking.

The mistake most people make

They treat the export as a backup and never as a document. A backup is something you save; a document is something you read. Ten minutes with a sort and a filter, once a month, will change more about your next quarter than another hour spent staring at a dashboard, because the dashboard shows you totals and the file shows you people. The second mistake is exporting once, deciding the file is confusing, and never repeating the exercise. The second export is much easier than the first, and the third takes two minutes.

Open the file. Sort it once by lifetime value. Whatever you see in that first screen is the most honest description of your business you will read this month, and it was sitting in your downloads folder the whole time.