EN
Describe your task
Data

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 sourcesCollection−1Spreadsheet✓ duplicates removed

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.

Discuss ongoing work

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.

Fill in the brief

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
example
Before / Source data
Order and customerDate and amount, USD
104 · Northwind01.02.2026 · 120
104 · Northwind2026-02-01 · 120
105 · Beacon2026-02-03 · 180
After / Clean data
Order and customerDate and amount, USD
104 · Northwind1 Feb 2026 · 120
105 · Beacon3 Feb 2026 · 180
Report

Revenue by customer, USD

✓ Duplicate of order 104 removed, dates in one format

Northwind 120
Beacon 180

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.

Describe your task for this service

I reply in writing, in the language you write in.

No need to type: attach a file up to 10 MB or record a voice note up to 3 minutes.