I will clean and format excel CSV data and remove duplicates
CA Finalist, QuickBooks and Xero Bookkeeper, Bank Reconciliation
About this Gig
I will clean, organize and format your Excel or CSV data so it is consistent and easy to use.
Services include removing duplicates using your rules, trimming spaces, standardizing text casing and date/number formats, organizing headers and flagging missing or uncertain values. I flag uncertainty rather than guess. Premium also includes agreed splitting or merging of text fields.
Each package covers one sheet and up to 10 columns: Basic 100 rows, Standard 200 rows, Premium 300 rows. Delivery: 2 days for Basic and Standard, 3 days for Premium. Basic and Standard include one revision; Premium includes two, within the agreed scope.
You receive a cleaned Excel or CSV file, a source copy and a short change summary. Send your file, cleaning rules and preferred output format. Message first for larger files or multiple sheets.
Web research, contact verification, scraping, macros and dashboards are outside this gig. AI-assisted tools may be used with output checks; discuss data-processing restrictions before ordering. Gallery examples use fictional data.
FAQ
What is included in the Basic package?
One worksheet or CSV, up to 100 data rows and 10 columns, cleaning and formatting, a source copy, a change summary, and one revision within the agreed scope. Message before ordering for larger files or additional tasks.
What files can you clean?
I accept Excel and CSV files. Each package covers one sheet with up to 10 columns. Please send a sample and cleaning instructions before ordering if your file has multiple sheets or needs extra tasks.
Can you handle larger files or multiple sheets?
Yes, please message me with a sample, row count, column count and instructions first. I will confirm scope, price and delivery before you order.
Do you guess missing data or create macros?
No. Missing or uncertain values are flagged for review. This gig does not include VBA, scripts, web scraping or dashboards. Corrections follow the rules you provide.

