Excel SQL Sync Developer Needed for a Two-Way Workbook Macro
The client wants an excel SQL sync developer to build a one-click workbook that pushes and pulls changes between Excel sheets and SQL Server 2019. This brief covers the sync rules, the deliverables and how to bid.
- Open · checked 12 Nov 2026
- Visual Basic
Is the budget fair? Looks workable for a few sheets and one SQL table with clear sync rules. Tight if deletions, conflicts and several tables must all be handled on this budget.
What the client needs
- Build a one-click macro that syncs chosen Excel sheets with SQL Server.
- Use MERGE or upsert logic that keeps primary keys and avoids duplicates.
- Keep the newest version of each record using a hidden timestamp.
- Deliver a macro-enabled .xlsm workbook with commented VBA and Power Query steps.
Skills the client asked for: Visual Basic, Data Processing, Excel, SQL, Microsoft Access, Data Integration, Automation, Database Management.
Where to aim your bid
The sweet spot sits about 40% of the way up the client's range, the same rule AutoBidPilot uses for its own price suggestions. Go higher when the scope is large or unclear; go lower only when you can show close, finished work. Check what you keep after fees with the bid price calculator.
Across the 7 Visual Basic briefs we have written in USD, the median budget is $500. We wrote 10 Visual Basic briefs in the last 7 days.
What the project involves
The client needs a small, reliable system keeping chosen sheets of a master Excel workbook in sync with SQL Server 2019. A single button click in Excel should push new or updated rows to SQL and pull changes from SQL back into the same sheets.
Sync rules
- Conflicts always keep the newest version of a record
- A hidden date-time stamp is added whenever a row changes so the macro can tell which side is fresher
- MERGE or UPSERT logic preserves primary keys, treats NULLs, dates and numbers correctly and avoids duplicates
Deliverables
- A macro-enabled workbook (.xlsm) with clean, commented VBA and Power Query steps
- SQL scripts that create or adjust target tables and indexes
- An error log listing rows that fail to sync and why
- A concise hand-over PDF so an analyst can maintain the solution
Environment and timing
Work can be done on Windows 11 with Office 365, matching the client's setup. A first working build within a couple of days would be ideal for quick testing.
How to win this project
- Explain how you will handle NULLs, dates and numeric types, since the client names them as risk points.
- Share a short example of a sync macro you have written, with comments and error handling visible.
- Ask for a sample of the sheets and the SQL table layout before quoting, so the sync rules are clear.
Questions to ask the client
A specific question in your first message shows you read the brief. Pick one or two:
- Which sheets and SQL tables must be kept in sync?
- How should a record be treated if it is deleted on one side only?
- Is a test SQL Server 2019 instance available for trials?
Common questions
How much does an excel sql sync developer cost?
The listed budget is $250–750 USD. The number of sheets and tables will decide how much of that range is realistic.
What skills does an excel sql sync developer need?
The listed skills include Visual Basic, Excel, SQL, Microsoft Access, data integration, automation and database management.
Is this project still open?
We checked this project on 10 November 2026. Projects get awarded, so apply soon; we take a brief down when it closes.
This page is our own summary of a project posted online, written to help you decide and to write a better bid. Projects get awarded or closed, so apply soon; we take a brief down when it closes. No job or income is guaranteed.