Title: Can spreadsheet do calculations of a link? How to extract and compute data from URLs?
Hey folks!
So, I’ve been scratching my head over this—can spreadsheet do calculations of a link *directly*? Like, if I have a URL with some numbers or data in it, can I pull that into Excel/Sheets and crunch it automatically?
For example, say a link has "example.com/data?value=100&tax=20"—can I extract "100" and "20" and then calculate stuff (like 100+20)?
I’ve tried some formulas, but no luck yet. Maybe IMPORTXML or regex? Or is this just wishful thinking?
If anyone’s cracked this, pls share! Even a "nah, not possible" would save me time lol.
Thanks in advance!
(Ps. Using Google Sheets, but Excel tips welcome too!)
Hey folks!
So, I’ve been scratching my head over this—can spreadsheet do calculations of a link *directly*? Like, if I have a URL with some numbers or data in it, can I pull that into Excel/Sheets and crunch it automatically?
For example, say a link has "example.com/data?value=100&tax=20"—can I extract "100" and "20" and then calculate stuff (like 100+20)?
I’ve tried some formulas, but no luck yet. Maybe IMPORTXML or regex? Or is this just wishful thinking?
If anyone’s cracked this, pls share! Even a "nah, not possible" would save me time lol.
Thanks in advance!
(Ps. Using Google Sheets, but Excel tips welcome too!)