Data and reports
Open data collected or your spreadsheet tidied up, with a report that recalculates itself.
You need data from open sources, or your own spreadsheet is a mess: duplicates, mixed formats, empty fields.
Open sources → Collection → Spreadsheet
✓ duplicates removed
What this service covers
Web data collection from open sources
A spreadsheet of the agreed data from open sources, with the duplicates I find removed.
- Collection from open APIs and pages.
- Filtering and duplicate removal.
- A spreadsheet and short report.
Data cleaning and entry
Your spreadsheet in one consistent format, with the duplicates I find removed and errors fixed.
- Removing duplicates.
- Consistent formats for dates, phone numbers and addresses.
- Entering data from your source material.
Reports in Excel and Google Sheets
A report built from your spreadsheet that recalculates when new data is added.
- A report based on your sample.
- Updates from the source data.
Long-term work comes first
For companies that need data regularly: I collect, clean and refresh reports on a schedule - weekly or monthly.
Turnaround and price
Turnaround: quoted in writing together with the exact price.
Price estimate: 20-80 USD. The exact price is based on your completed brief or specification.
Revisions: I adjust the spreadsheet columns until they fit your task.
What is not included
- Closed data and bypassing website protections.
- Private contact details of individuals.
- Inventing missing data.
- Complex integrations with accounting or ERP systems.
What I need from you
- What data to collect and where from - or your source spreadsheets.
- Rules for what counts as a duplicate or an error.
- The result format and how often to update it.
- A sample of the report you need.
How you accept the work
A paid trial sample at a price quoted before starting, followed by the full scope.
How I check
I compare a sample of rows with the source and count duplicates before and after.
What I have done before
- Collection from open job-platform APIs, with filtering, duplicate removal and reports.
- Google Sheets reports that recalculate after every new data run.
What I will do for you
- Collection from your chosen source if it is open and its rules permit it.
- Cleaning and entry in your spreadsheet under agreed rules.
- Pivot tables and formulae based on your sample, with the scope to be agreed.
Examples
Example spreadsheet with fictional data
Revenue by customer, USD
✓ Duplicate of order 104 removed, dates in one format
Why not do it yourself with AI
- We agree on the source, then I collect the data myself and check the result. AI can't do that without access to the source.
- I count duplicates before and after, not by eye.
- I check each source's rules before collecting, so you don't get blocked.
What is easy to miss: a spreadsheet can look finished while a third of its rows are duplicates under different names - I count and remove them before handover.
Questions about this service
Can I work with you on an ongoing basis?
Yes, that is what I want most. I work hourly, on a monthly retainer or from a task list - as part of your team, using your tools. You can start with a paid trial task.
Which sources?
Open sources: platform APIs and pages without a login.
Can you do this regularly?
Yes - we agree the frequency and the maintenance price.
Do you collect people's contact details?
No, I do not collect private contact details of individuals.
What format will I get the result in?
Excel, Google Sheets or CSV.
Do you enter data manually?
Yes, from your source material, with checks.
Related services: Python developer · E-commerce and marketplace specialist
Describe your task for this service
I reply in writing, in the language you write in.