Automate CSV Sales Data Entry
Budget: $10 – $30 USD
I have a growing collection of CSV exports that record every completed sale— each file includes the user name, sale amount, date, and product sold. Manually copying those rows into my master workbook is now slowing me down, so I want the process automated inside Excel.
Here is what I need:
• A macro-enabled workbook (or an add-in, if that is cleaner) that lets me select one or multiple CSV files and instantly imports the data into the correct worksheet, appending new rows without disturbing existing formulas or formatting.
• During import the code must map each CSV column to its matching Excel column: User Name → Column A, Sale Amount → Column B, Date → Column C, Product → Column D.
• Duplicate prevention: if a sale with the same user, amount, date, and product already exists, the script should skip or flag it rather than add it twice.
• A simple button on the sheet labelled “Import Sales” is fine; no complex ribbon customisation is necessary.
• Clear, commented VBA so I can tweak paths or column letters later.
Acceptance criteria: run the macro with a sample CSV I provide, watch it populate the table accurately, verify no duplicates appear on a second run, and confirm that all existing formulas remain intact.
If this sounds straightforward to you, let’s get it done quickly.
Here is what I need:
• A macro-enabled workbook (or an add-in, if that is cleaner) that lets me select one or multiple CSV files and instantly imports the data into the correct worksheet, appending new rows without disturbing existing formulas or formatting.
• During import the code must map each CSV column to its matching Excel column: User Name → Column A, Sale Amount → Column B, Date → Column C, Product → Column D.
• Duplicate prevention: if a sale with the same user, amount, date, and product already exists, the script should skip or flag it rather than add it twice.
• A simple button on the sheet labelled “Import Sales” is fine; no complex ribbon customisation is necessary.
• Clear, commented VBA so I can tweak paths or column letters later.
Acceptance criteria: run the macro with a sample CSV I provide, watch it populate the table accurately, verify no duplicates appear on a second run, and confirm that all existing formulas remain intact.
If this sounds straightforward to you, let’s get it done quickly.