Controlled Excel Import Screen
A supplier or branch file can arrive with changed column names, dates or product codes.
How the Controlled Excel Import Screen can work
I can provide a mapping and validation step that highlights rows needing attention before import, then records what was accepted or skipped. Duplicate handling should match your own definition of a repeat record, rather than guessing from one column alone.
Uploading an Excel file or Google Sheets export directly can hide renamed columns and problematic rows. An import screen can put mapping and checking first.
As Oğuz Erol, I develop custom web apps for this workflow. After seeing sample files and column mappings, I aim to prepare an initial import screen quickly; data quality shapes the scope. The review can also report the rows that were imported successfully.
Frequently Asked Questions
What happens to problematic Excel rows?
They can be listed before import, corrected and re-uploaded, or skipped according to the agreed rule.
Will a renamed column break the import?
The mapping step shows the difference, and import does not complete until the new column is confirmed.
Discuss your workflow
Explore custom web apps for your team
Related services
How do I work?
Work-hour packages
Tell me about your website and what you need on WhatsApp or by phone; we agree on a work block of somewhere between 5 and 40 hours and I start doing what is needed. What you get is not a calendar window — it is net working hours spent directly on your business. I can use 40 hours working three days straight, or deliberately spread it out and finish it over a year — whatever the work calls for. I do not spend my time estimating how long something will take, I spend it doing the work; every hour I spend has a lasting result on your site. We keep going for as long as you find it useful.
Why not monthly?
Is 40 hours a week?
On a fixed monthly fee both sides are watching the wrong thing: you watch a fixed cost, the other side watches how many more contracts like this they can line up. Working by the hour puts us both in front of the same thing — the real value of the work that got done. I know not having an upfront answer to "how much will this cost in total?" is the natural cost of this model. But instead of paying a fixed fee for months to a setup that is not producing results, you only pay for the qualified time spent on your work — and you see exactly where that time went, start to finish. That is why my clients keep coming back.