You will get clean public web data extracted into Excel CSV or SQL


Project details
I will extract, clean, and structure data from public websites, open data portals, or publicly available files into Excel, CSV, or SQL-ready formats.
This project is useful when you need clean public data for reporting, research, analysis, operations, dashboards, or internal decision-making.
I can work with public tables, open data portals, simple HTML pages, CSV files, Excel files, JSON files, and other publicly accessible sources that can be used without bypassing restrictions.
The work may include extracting tables or structured fields, cleaning and formatting the data, removing duplicates, standardizing columns, validating records, documenting source URLs, and preparing clean output files.
This project is only for allowed public sources. It does not include login access, CAPTCHA bypass, paywall bypass, anti-bot bypass, private databases, social media scraping, emails, contact lists, lead generation, or sensitive personal data.
Please contact me before ordering if the source is dynamic, complex, very large, or if you need a reusable Python scraper.
This project is useful when you need clean public data for reporting, research, analysis, operations, dashboards, or internal decision-making.
I can work with public tables, open data portals, simple HTML pages, CSV files, Excel files, JSON files, and other publicly accessible sources that can be used without bypassing restrictions.
The work may include extracting tables or structured fields, cleaning and formatting the data, removing duplicates, standardizing columns, validating records, documenting source URLs, and preparing clean output files.
This project is only for allowed public sources. It does not include login access, CAPTCHA bypass, paywall bypass, anti-bot bypass, private databases, social media scraping, emails, contact lists, lead generation, or sensitive personal data.
Please contact me before ordering if the source is dynamic, complex, very large, or if you need a reusable Python scraper.
Data Tool
PythonWhat's included
| Service Tiers |
Starter
$90
|
Standard
$180
|
Advanced
$320
|
|---|---|---|---|
| Delivery Time | 3 days | 5 days | 7 days |
Number of Pages Mined/Scraped | 100 | 200 | 300 |
Number of Sources Mined/Scraped | 1 | 2 | 3 |
Number of Revisions | 1 | 2 | 2 |
Optional add-ons
You can add these on the next page.
Additional Page Mined/Scraped
(+ 1 Day)
+$25
Additional Source Mined/Scraped
(+ 2 Days)
+$50
Additional Revision
+$25Frequently asked questions
About Pedro Danilo
Data Analyst | Python, SQL, Power BI | Data Cleaning & Automation
Plato, Colombia - 12:14 am local time
I help organizations, consultants, researchers, NGOs, small businesses, and academic teams transform messy or unstructured data into clean datasets, reports, dashboards, databases, and actionable insights.
I can help you with:
• Data cleaning and transformation in Excel, CSV, and databases.
• SQL queries and reports in PostgreSQL and MySQL.
• Python scripts for automation and ETL workflows.
• Power BI dashboards and data visualization.
• Data extraction, data mining, and analytical reporting.
• Geospatial data analysis with PostGIS and GeoPandas.
• Technical reports based on structured data.
My background combines more than 25 years of experience in public administration, institutional consulting, project management, and data-driven decision-making with technical skills in Python, SQL, PostgreSQL, PostGIS, GeoPandas, Power BI, pandas, and machine learning.
One of my key projects involved designing a PostgreSQL/PostGIS data repository with more than 128 million socioeconomic and violence-related records from Colombia, including Python ETL processes, source traceability, and municipal geolocation.
I work remotely by project, with clear scope, defined deliverables, structured communication, and practical results.
Steps for completing your project
After purchasing the project, send requirements so Pedro Danilo can start the project.
Delivery time starts when Pedro Danilo receives requirements from you.
Pedro Danilo works on your project following the steps below.
Revisions may occur after the delivery date.
Review the source
I review the public URL, open data portal, source type, restrictions, expected fields, and required output format.
Check feasibility
I verify whether the source can be accessed without login, CAPTCHA, paywall, anti-bot bypass, or restricted access.