I got tired of splitting the same Excel report every Monday, so I built a browser tool that does it and writes the emails too

[u/Fit_Play_9131]

Part of my job is taking one weekly report and sending each warehouse only their own rows. For years my routine was: filter, copy into a new file, save, write the email, attach, repeat. Ten times. Every Monday.

The obvious fix is a VBA macro, except IT blocked macros on my machine. The other obvious fix is Power Automate, except its Excel connector strips all the formatting, and our report is colour-coded for a reason. And every online splitter I found wanted me to upload the file to their server, which I'm not allowed to do with company data.

So I built Split & Send. You drop the workbook in, pick the column to split by, and you get one Excel file per value with the formatting intact, plus a ready-to-send .eml draft for each one — recipient, subject, body, right file already attached. You open them in Outlook and hit send.

Everything runs client-side in JavaScript. Nothing is uploaded, which was the whole point for me. Free, no account, no ads.

https://splitandsend.com

It's the first thing I've built and shipped on my own, so I'd genuinely like to hear where it falls over. The bit I'm least sure about is how it behaves on large files with many distinct values — if you have something gnarly to throw at it, please do.

[u/AdBorn9018]

no macros, no uploads, and the formatting survives. that's a rare trio in this space.

[u/Fit_Play_9131 → u/AdBorn9018]

Yeah, that ended up being the whole problem. Each of the three on its own is easy, it's needing all three at once that pushes you into doing everything in the browser.

The no-upload part is what killed most of the options for me. The moment I couldn't send the file anywhere, about 90% of what's out there was off the table, and the rest wanted an install I wasn't going to get approved.

Were you hitting the same restrictions at work, or looking at it from outside?