1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Any point in using a no-code ETL tool to transform excel?

I'm trying to understand whether I should be using a third party tool to do some data transformation to join/filter a few spreadsheets on a regular basis or simply try and learn Power Query (which I don't like to tbh, but maybe that's because I haven't used it enough).

What do you guys think? Should I go all in Power Query for a while, or maybe explore some other tool (no code, preferably) to create a "workflow" and run them from time to time? Have you guys experienced anything similar to this?

submitted by /u/Remote-Ad-6629
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#AI-powered spreadsheet