All B2B solutions boil down to "How I import your Excel"

Or export to excel,
Or macro in excel,
Or excel.... fuck me dead so much excel, seriously I do more excel then I do anything else 😢

I do enjoy csv to sql imports though, big data just got easy, and then export back to excel and make everyone think your the excel master 😁

@C0D4 One time, about 14 years ago, I was esked to make a server monitoring excel shit which sends emails ;p ;p ;p

I was young. I did it. But no... that shouldn't exists

Thank God for powerbi

Storytime: In early 2021 I interviewed with 3 or 4 different companies, all extremely well paying and very successful, but yes, their apps all boiled down to "import or export your data into our tables or *GASP*, even import your CALENDAR data, and we'll add a layer of fun easy drag and drop logic!" yawn.

@tosensei CSV is not much better, fucking customers never encode them properly...
- UTF-8 encoded ISO-8859-1 chars, sometimes the opposite
- newlines (0x0a) within strings making most CSV parsers to read it as a new row
- missing column spearators
- too many column setarators
- mixed column separators

In the case of the newline problem, I had to write my own CSV parser with a custom state machine. I'm not a huge fan of Excel either, but at least shit like this doesn't happen there.

@tosensei Yeah, that's a valid point, f the customers 😄

Also pdf
Fuck pdf

Excel: the database, programming environment and client app all in one single sharable file!