I will automate your excel data, match product codes, and build custom formulas
Operations Sales Coordinator
About this Gig
Struggling with messy inventory spreadsheets, mismatched product codes, or manual sales reports that eat up your week? I can help.
I specialize in Excel automation for retail, e-commerce, and small business operations. With hands-on experience coordinating inventory and sales across multiple store locations, I know exactly how frustrating it is when EAN, SKU, or MSKU codes don't match between your price lists, transfer files, and warehouse system and how much time gets lost fixing it manually every week.
Here's what I can do for you:
- Match and reconcile product codes (EAN/SKU/MSKU) across multiple files
- Build custom formulas for stock transfers, order quantities, and inventory calculations
- Spot and flag discrepancies between systems (e.g. 1C, price lists, warehouse data)
- Automate recurring weekly sales tables and reports
- Design clean, easy-to-maintain dashboards so you're not starting from scratch every week
I care about precision every formula is checked. Whether you need a one-time fix or a fully automated system your team can update weekly, I'll build it clearly and explain how it works.
Message me with your file (or a description) and I'll tell you exactly how I can help!
Platform:
Excel
•
Google Sheets
Development technology:
Excel
•
VLOOKUP
Expertise:
Formatting
•
Fixing
•
Pivot tables
•
Formulas
•
Functions
FAQ
What file formats do you work with?
I work with Excel (.xlsx, .xls, .xlsm), Google Sheets, and CSV files. If your data comes from a system like 1C or another database, just export it to Excel/CSV and I can take it from there.
I don't have clean data, some of my product names/codes don't match at all. Can you still help?
Yes, this is actually my specialty. I regularly work with messy real-world data, abbreviated product names, inconsistent codes, missing entries, and build logic to match them accurately, flagging anything that needs your manual review.
Do I need to know Excel to use what you build?
No. I design everything to be simple to use, just drop in new data where indicated, and the formulas/reports update automatically.
How many files/rows can you handle?
Basic covers up to 500 rows in 1 file, Standard up to 3,000 rows across 5 files, and Premium has no row limit, just message me first if your dataset is very large so I can confirm timing.
What do you need from me to get started?
Please send your file(s) along with a short explanation of what you're trying to match, calculate, or automate, and what the current problem is (e.g. "SKU codes don't match between these two sheets"). The more context, the faster and more accurate the result.
Can you fix an existing spreadsheet instead of building from scratch?
Absolutely, just send me the file and I'll review, fix, and clean up existing formulas or structure rather than starting over, where possible.
What if I need revisions after delivery?
Each package includes revisions (1 for Basic, 2 for Standard, 3 for Premium). I'm happy to make adjustments to make sure the result fits exactly what you need.

