•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
What repetitive data tasks are you still doing manually?
Our take
Repetitive data tasks can drain productivity, leaving you frustrated with manual fixes. Many users, including those managing CSV files from various sources, encounter challenges like inconsistent column names, messy date formats, and duplicate or empty rows. Despite attempts to streamline processes with tools like Power Query or scripts, edge cases often disrupt the workflow. This raises an important question: What repetitive data task do you still find yourself doing manually, even when you know there’s a more efficient solution waiting to be discovered?
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?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- What's your go-to method for cleaning inconsistent CSV files from different clients?Every week I get CSV exports from about a dozen different clients. Same data categories but formatted completely differently. Date formats vary, some use comma delimiters while others use semicolons, and the column order is never the same twice. Right now I'm manually reformatting everything before it hits my main excel file and it's eating hours. I know power query exists but I haven't dug into it yet. Is that the standard solution here or do people use other approaches? Also curious how you handle files where the column names change slightly month to month. Do you just manually adjust your cleaning steps each time or is there a way to build something more flexible? submitted by /u/goxper [link] [comments]
- How to handle data from different sources when columns are in different orders?I regularly get CSV exports from multiple clients. Each client uses their own column order. One puts names in column A and dates in column B, another swaps them. Manually rearranging every time is driving me crazy. What's your go-to method for standardizing columns from different sources? Power Query seems powerful but I'm not sure where to start. I've tried INDEX/MATCH with header lookups, but it gets messy when column names vary slightly. Also open to VBA solutions if they're reusable. Any tips or templates you'd recommend? submitted by /u/biggy_boy17 [link] [comments]
- Anyone else struggle with knowing what to do with their data, not just formulas?I realized my problem isn’t just formulas—it’s understanding what the data actually needs. Like sometimes I don’t even know what formula to use or what insight I’m looking for. Do you guys just figure it out manually or is there a smarter way? submitted by /u/RazzmatazzWestern306 [link] [comments]
- Any way to automate removal of older rows of data?I have a spreadsheet with 4 columns: first name, last name, score and date. I have people who are duplicated, some with the same date which I can easily remove with "remove duplicates" but I have examples where there are people with multiple rows from where they have taken a test a few years later, and i am trying to find a way to optimise my chopping up of this spreadsheet to only have a single row per user, and showing only their most recent score for the test. The date column is dd/mm/yyyy and then a 24 hour format time stamp and I can't think of a good way to optimise that as it covers multiple years. Theres no good consistency over the old date and the most recent date I imagine excel has some way of pruning older data. Atleast I hope so or ill have to check 50000+ rows manually to remove old results 😭 submitted by /u/Skellyhell2 [link] [comments]
Tagged with
#rows.com#Excel alternatives for data analysis#data visualization tools#data analysis tools#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#real-time data collaboration#intelligent data visualization#enterprise data management#big data performance#data cleaning solutions#self-service analytics tools#Excel compatibility#business intelligence tools#collaborative spreadsheet tools#financial modeling with spreadsheets#Excel alternatives#CSV files#data tasks