•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I’m researching how people automate repetitive Excel/CSV workflows in day-to-day work.
Our take
I'm researching how professionals automate repetitive Excel and CSV workflows in their daily tasks. I'm in the process of developing a desktop tool designed to visually streamline these processes, but I want to gain insights into the challenges users face today. If you have experience with automating these workflows, I would greatly appreciate your feedback. Please share your most recent automation project, its frequency, and the specific frustrations you encountered, as well as the tools you currently use. Thank you for your valuable input!
I’m building a desktop tool to set up these processes visually, but before going further I want to understand what actually hurts today. I’m not selling anything in this post, just trying to learn from real-world cases.
If you work with this kind of thing, I’d really appreciate your input:
- What was the last annoying Excel/CSV workflow you automated?
- How often does it run?
- What was the most frustrating part: combining files, cleaning data, standardizing columns, deduplicating, exporting, etc.?
- Are you the only one who runs it, or do other people need to run it too?
- What do you use today: Power Query, VBA, Python, Power BI, something else?
Thanks!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- What’s the most frustrating part of cleaning messy Excel/CSV data?I’ve been working with a lot of messy spreadsheets lately (duplicates, inconsistent formatting, mismatched columns, etc.), and it feels like everyone runs into slightly different issues depending on their data. Some people rely on Power Query, while others do things manually, but I still see workflows break when the data isn’t consistent to begin with. Curious what tends to slow you down the most when cleaning or organizing data? Is it duplicates, formatting issues, inconsistent columns, or something else? submitted by /u/SmitleyData [link] [comments]
- What repetitive data tasks are you still doing manually?Lately I've been working a lot with CSV files from different sources (banks, exports, random tools), and I keep running into the same issue: - inconsistent column names - messy date formats - duplicate / empty rows I end up fixing things manually more often than I’d like, even though I know it should be automatable. I’ve tried Power Query and some scripts, but it still feels like there are always edge cases that break the flow. Curious — what’s a repetitive data task you still do manually even though you know it shouldn’t be? submitted by /u/CodigoSinBugs [link] [comments]
- Do you use VBA regularly or have you moved entirely to Power Query and formulas?I have been using Excel for years and VBA was always my go to for automation. Lately I have been seeing more people say they barely touch VBA anymore because Power Query and dynamic arrays cover most of what they need. I still use VBA for things like automating reports across multiple files or generating custom email bodies from data. But I am wondering if I am behind the curve. For those of you who work in data heavy roles, what is your current workflow? Do you still use VBA regularly or have you replaced it with other tools? Curious if I should be spending more time learning Power Query and the newer formula features instead of maintaining my VBA skills. submitted by /u/ProfessionalOk4935 [link] [comments]
- 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]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#real-time data collaboration#data cleaning solutions#rows.com#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#automated anomaly detection#financial modeling with spreadsheets#intelligent data visualization#real-time collaboration#data visualization tools#workflow automation#enterprise data management#big data performance#data analysis tools#automation in spreadsheet workflows#Excel