
Closed
Posted
Paid on delivery
WHEN YOU BID, PLEASE BID FOR THE ENTIRE PROJECT - NOT PER PAGE!! URGENT DATA CONVERSION PROJECT: 24-HOUR DEADLINE WHO IS SUITABLE FOR THIS JOB (CRITICAL CRITERIA): Expert in Advanced Data Cleaning: You must have extensive experience using regular expressions (Regex), text-parsing tools, or advanced scripting to split messy addresses. If you plan to type this out manually row-by-row, do not apply. You will not finish in time. Flawless Attention to Detail: You must know how to cleanly isolate data fields without leaving broken lines, trailing commas, or raw code formatting artifacts inside cells. High Availability: You must be able to start immediately upon hiring and dedicate the necessary hours to deliver the complete file on time. Proven Track Record: You must show past proof of managing massive data scrubbing/extraction projects (thousands of lines) with high accuracy ratings. TIMELINE & DELIVERY: Strict Deadline: Exactly 24 Hours from project award. Mandatory Milestone Check: You must submit a sample test of the first 3 converted pages within 2 hours of starting. We will check your column formatting. If the formatting is correct, you will be cleared to finish the project. If it is wrong, the project will be canceled immediately. PROJECT OVERVIEW & INSTRUCTIONS You are required to extract raw text profiles from a 688-page FMM Directory flipbook and convert them into a clean, highly structured Google Sheet. THE DATA CONSTRAINT: Total Factory Count: The finalized Google Sheet across all tabs must contain a total count of exactly 4,200 factories. Every single company must be accounted for. Do not skip entries to rush the deadline. 1. Structure of the Google Sheet (Tabs by State) The Google Sheet must be split into tabs. Each tab must contain data for only one specific state. Sort each company into its respective tab based on where its physical Factory is located. Create these exact tabs: Selangor Johor Pulau Pinang Perak Negeri Sembilan Melaka Kuala Lumpur Kedah Pahang Terengganu Kelantan Perlis Sarawak Sabah 2. Exact Columns Required Every company entry must be on a single row, cleanly separated into these exact columns. Do not combine information into a single cell. Column A: Company Name (Full registered name) Column B: Office Address (Street address only; do not include city or state here) Column C: Office City (The city/town of the office only) Column D: Office State (The state of the office only) Column E: Factory Address (Street address of the actual factory; do not include city or state here) Column F: Factory City (The city/town where the factory is physically located) Column G: Factory State (The state where the factory is located—this must match the tab name) Column H: Number of Employees in Factory (The workforce count at the factory site) Column I: Number of Employees in Office (The corporate/administrative staff count) Column J: Product Manufactured (Brief description of products made) Column K: Phone Number (Primary contact number) Column L: Email (Primary corporate contact email) Column M: Key Executive Name (CEO / Managing Director / Factory Director) Column N: Key Executive Title (Their exact role title) Column O: Business Enquiry Details (Any secondary contact names, extra lines, or commercial notes) 3. Absolute Data Quality Rules Perfect Address Splitting: You must extract and separate the street addresses from the City and State columns. Full, un-separated block addresses inside a single cell will be rejected. Missing Information: If an entry lacks a specific field (like an email or employee count), leave that cell blank, but do not skip the company. We need the row entry to maintain our target total count. Clean Layout: Capitalization must be consistent (e.g., "Sdn Bhd", not "SDN BHD"). Remove all raw code fragments, awkward text wrapping, or extra spaces.
Project ID: 40583742
33 proposals
Remote project
Active 1 day ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
33 freelancers are bidding on average $27 USD for this job

HI there already i have checked project details i am able to collect all information from in google sheet so please contact me then i will show you sample, thank you
$20 USD in 1 day
8.8
8.8

Hello, I can start **immediately** and deliver this project within your **24-hour deadline**. I specialize in **Python automation, Regex, text parsing, and large-scale data extraction**. I have over **10 years of experience** processing thousands of records from PDFs, directories, and flipbooks into clean Excel and Google Sheets. Manual entry is not practical for this project—I will build a parsing workflow to automate extraction, then perform manual quality checks. My approach: * Extract text from the flipbook using Python. * Use Regex and parsing logic to split company data into the required fields. * Clean addresses, separate street/city/state, normalize formatting, and remove duplicates. * Organize all **4,200 companies** into the required state tabs. * Perform manual verification before delivery. I understand your requirements: ✔ Sample of first 3 pages within 2 hours. ✔ Exactly 4,200 companies. ✔ Proper address splitting. ✔ Clean formatting with blank cells for missing data. ✔ Google Sheets ready for use. I have completed many similar large-scale data extraction and cleaning projects and can begin as soon as the project is awarded. Best regards, Python | Regex | Data Extraction Specialist
$20 USD in 1 day
8.1
8.1

Hi There, Ready right now I'm ready to Quick! Transform Raw Data 688 page flip-book into Organized Google Sheet. I will show you sample for your satisfaction and project accuracy then we will go to start, so please contact me and share more details thanks. Check My Profile: https://www.freelancer.pk/u/WelcomeClient I would like to work on this project and can complete with 100% accuracy within the time frame. https://www.freelancer.pk/projects/excel/business-profit-loss-reporting-excel/reviews https://www.freelancer.pk/projects/data-entry/copy-listings-from-website-another/reviews Thanks, Umer
$20 USD in 1 day
7.1
7.1

Yes,I have good working experience with Python, regular expressions (Regex), text-parsing tools and scripting. Message me here to discuss more about this project. I am looking forward to an early and positive response. Regards, Shalu
$50 USD in 2 days
6.6
6.6

Hi, I’ve read the full brief — including the exact 4,200-record count and mandatory 3-page test. I would not process this manually. I can use Python, Regex and structured text parsing to separate office/factory addresses, cities and states, then run validation checks for missing records, formatting errors and incorrect state tabs. I can start immediately, submit the first 3 pages within 2 hours and complete the full project within 24 hours. My bid is for the entire project. Let’s start with the sample.
$30 USD in 1 day
6.5
6.5

Hello I can start immediately and use Python with Regex, OCR, and text-parsing tools to accurately extract, clean, and structure all 4,200 factory records into the required state-based Google Sheet tabs. I’ll deliver the 3-page sample within 2 hours, maintain data integrity, and complete the project within the 24-hour deadline. Regards, Muhammad
$30 USD in 1 day
6.0
6.0

With 5-star ratings and a strong client feedback loop, I come with a proven track record in project management, data extraction, cleaning, and organization. My extensive experience with advanced data cleaning tools such as regex and text-parsing gives me an edge for this particular task, guaranteeing clean and well-structured results. Moreover, I have flexible availability which aligns perfectly with your time constraints. Right away I can start your project and give it my undivided attention. Efficiency is at the heart of what I do so while keeping regular communication (day & night), rest assured about receiving updates on milestones achieved (i.e., the first 3 converted pages) at every two-hour interval as you've mandated. My aim would be to ensure that every single company among the 4,200 factories surveyeded, is accounted for without sacrificing quality or oversight. In conclusion, from my expertise in MS Excel and Google Sheets to web scraping skills and relentless attention to detail - everything equips me to deliver your project professionally and efficiently. If you value accuracy alongside quality project delivery within stipulated timeframes, then look no further. Let's begin transforming those 688-page flip-book into organised Google Sheets today!
$50 USD in 1 day
5.5
5.5

Hi, I can start immediately and automate the extraction and cleaning using Python (Regex, pandas, OCR/text parsing) to accurately process all 4,200 factory records, split addresses into structured fields, organize them by state tabs, and deliver the required 3-page sample within 2 hours before completing the full conversion within your 24-hour deadline.
$30 USD in 1 day
5.4
5.4

A continuación detallo la herramientas que he utilizado a lo largo de mi experiencia laboral, conocimientos y habilidades especificas: Experiencia en Rad Studio (Delphi) ,Visual Basic/ado/adodb , Visual Foxpro, Microsoft Access. C#, Java. Lenguaje Web: HTML5, CSS, Php, Javascript, Jquery, NodeJS. Python. Móvil: Android Studio, Capacitor. Manejo Avanzado de programas de ofimática Open Office y Microsoft Office. Implementación de Servidores Web con Apache. Bases de datos: SQLite, Mysql, Posgresql, Oracle. Pl/sql, manejo sentencias SQL. Experiencia avanzada en raspado web. Mantenimiento, Ensamblaje Y Configuración De Computadoras, Windows Server 2003, Inteligencia de Negocios y Data Warehouse (Análisis de Base de datos transaccional para la Identificación de tabla a utilizar, Creación de repositorio de datos para la puesta en marcha de Kettle o cualquier método de extracción, transformación, traslado y carga disponibles, Creación del área temporal y tabla temporal que alimentara a la tabla de hechos o fact tabla, Identificación y creación de dimensiones, Diseño y estructuración de la tabla de hechos con sus respectivas medidas, Construcción de Cubo OLAP (Mondrian) (XML)). Desarrollo musical en teclado y guitarra.
$30 USD in 1 day
5.2
5.2

I can do it in 6hours or less if you provide me the project I will immediately start to work on it. I have reviewed your excel
$20 USD in 1 day
4.8
4.8

I am very interested in applying for your job since it seems to fit very will with my experience and skills. Regards SamirBanna
$30 USD in 1 day
4.9
4.9

Hello I’m ready to tackle your urgent 24-hour data conversion. I will transform the 688-page FMM Directory into a clean, organized Google Sheet using Web Scraping, Data Extraction, and Regular Expressions to ensure precise row splits and fields, with no trailing commas or artifacts. I’ll build a robust pipeline that isolates Company Name, Addresses, Factory details, contacts, and product data, distributing rows into the required state tabs and preserving 4,200 entries with consistent capitalization and formatting. A 2-hour sample of the first 3 pages will validate column formatting before full delivery, then I’ll complete the remainder within the 24-hour window. I can start immediately and maintain a strict, documented process to meet the deadline, including a final quality check pass and a clean export to Google Sheets including the exact columns you listed. Best regards, Freelance Specialist -
$100 USD in 1 day
4.2
4.2

Hello, I can extract and parse all 4,200 factory profiles from your 688-page FMM Directory and deliver the clean, structured Google Sheet within your 24-hour deadline. As an automation developer, I will not type this manually. I will bypass the visual flipbook completely by scraping its underlying search-index JSON/XML text configuration files. This retrieves the complete raw text of all 688 pages in under 15 minutes. I will then run a custom Python script to: 1. Address Splitting (Regex): Isolate street addresses, cities, and states (e.g., separating Selangor, Johor, Pulau Pinang, etc.) to split them cleanly into their respective columns. 2. Structured Classification: Extract the 15 required fields (Company, Employees, Products, Contacts, Executives, and Enquiry details) using regex patterns. 3. State Tab Sorting: Automatically sort the rows into the 14 required state tabs based on factory location. 4. Capitalization & Clean-up: Apply consistent title-casing (e.g., "Sdn Bhd") and remove code artifacts. 5. Milestone Sample: I will deliver the fully formatted spreadsheet sample of the first 5 pages within 1 hour of the project award—well before your 2-hour checkpoint. I am based in Kochi and ready to begin immediately. Salaj Augustine
$30 USD in 1 day
3.5
3.5

Hi There, I came across your project requiring raw data transformation from a 688‑page flip‑book into a structured Google Sheet and wanted to offer my support. With 5 years of professional experience in accounting and data management, I specialize in handling large volumes of information with precision and consistency. Here’s how I would approach your project: -Manually extract and enter all data from the flip‑book into a clean, well‑structured Google Sheet. -Follow your formatting rules and column order to ensure consistency and usability. -Double‑check entries to eliminate transcription errors and duplicates. -Provide a concise change log noting any ambiguous entries and how they were resolved. -Share brief progress updates so you can track completion with confidence. Clients describe me as meticulous and dependable—I take pride in producing outputs that are error‑free and professional. I am available to begin immediately and can deliver the completed sheet quickly without sacrificing accuracy. Looking forward to collaborating with you, Oluwatobiloba
$15 USD in 1 day
3.4
3.4

Hi, With 5+ years of freelancing experience and 500+ completed projects, I have handled large-scale data cleaning, extraction, web scraping, and spreadsheet structuring involving thousands of records. I can process the 688-page directory using Python, Regex, and text-parsing methods rather than manual row-by-row entry. I will split office and factory addresses into separate street, city, and state fields, clean capitalization and spacing, remove formatting artifacts, and place every factory under the correct state tab. I understand the file must contain exactly 4,200 factory records, with no skipped companies. Missing details will remain blank while each company is still included as a complete row. I will also preserve the exact 15-column structure and verify factory-state consistency against each tab. I can start immediately and submit the first three converted pages within two hours for your formatting review before continuing with the full directory. The final Google Sheet will be checked for duplicates, missing entries, broken addresses, trailing commas, and inconsistent formatting. Best regards, Mahnoor
$30 USD in 1 day
2.9
2.9

Hi, I can complete your FMM Directory extraction within your strict 24-hour deadline. As a Computer Science graduate with extensive experience in automated data scraping, text-parsing, and regular expressions (Regex), I never perform manual row-by-row typing for projects of this scale. Instead, I use custom Python scripts to ensure 100% accurate data extraction. I am ready to start immediately and will submit the 3-page sample milestone within the first 2 hours for your formatting clearance. Here is my technical workflow for your project: 1. Text Extraction: I will convert the flipbook pages using high-accuracy PDF-text extractors (or OCR engine if it is an image-only flipbook). 2. Regex & Pattern Parsing: I will run a Python script with tailored regular expressions to isolate variables like "Chief Executive," "Tel," "Email," "No. of Employees," and "Products Manufactured." 3. Smart Address Splitting: Using clean string manipulation, I will split physical addresses, isolating the street, city, and state into separate columns, ensuring zero code fragments or trailing commas. 4. State-wise Sheet Tabs: Using Python's Pandas library, I will automatically group and export the 4,200 factories into their respective state tabs (Selangor, Johor, etc.) as requested. I am fully available to dedicate the next 24 hours to this project and deliver a flawless Google Sheet. Best regards, Muhammad Mueez
$20 USD in 1 day
1.9
1.9

Hi, I went through your project details regarding your target lead generation dataset requirement involving the gathering and extraction of firmographic attributes for 4,000 corporate records. I am fully aware of your urgent 24-hour deadline constraint and have an immediate execution workflow set up to deliver highly accurate, structured CSV sheets without delays. I maintain strict formatting consistency to ensure data arrays line up perfectly across target columns like company names and localized tags without leaving any missing rows. Let's connect in chat for further details regarding your data source or index link so we can initiate a batch template.
$40 USD in 1 day
2.1
2.1

I will extract and clean all 4,200 factory entries from the 688-page flip-book using regex to split addresses into the required columns. Each entry will be sorted into the correct state tab with consistent formatting. Let’s chat about starting immediately.
$20 USD in 7 days
1.9
1.9

Hi there, Your project "Quick! Transform Raw Data 688 page flip-book into Organized Google Sheet" instantly caught my attention — it's exactly the kind of work we love to take on. I don’t just want to tick the boxes here; my aim is to hand you something that genuinely goes beyond what you pictured. From your brief I can see this involves data entry, scraping, excel — all areas we handle in-house. We specialise in Data Processing, Data Entry, Excel, Web Scraping, which lines up directly with what you need. How we'd approach it: - Define the exact fields, sources and output format - Build the collection / processing pipeline - Validate accuracy and clean the data - Deliver in your preferred format with a short summary I also noted you don’t need leaving broken lines — that’s clear, and I’ll keep the work clean and strictly on-brief. Delivering at the scale of 688 page is no problem for us — we're set up for volume without dropping quality. Expect smooth progress updates throughout, full respect for your specifications, and zero surprises along the way. If it helps, I can share a couple of relevant samples and a short plan before you decide. Looking forward to it! Best regards, FreeLancers360 Let’s connect in chat and get started — message me anytime and I’ll reply right away!
$10 USD in 5 days
1.7
1.7

Hello, I’d like to take on this project and can start immediately. I have experience handling large-scale data extraction, data cleaning, and spreadsheet organization using advanced Excel/Google Sheets functions, Regex-based text parsing, and automated workflows to process thousands of records accurately within tight deadlines. I understand the requirements: * Extract all **4,200 factory profiles** from the **688-page** flipbook without missing any entries. * Organize the data into separate **Google Sheets tabs by state**. * Split addresses accurately into street, city, and state fields. * Populate all 15 required columns while leaving unavailable fields blank. * Standardize formatting, remove extra spaces/wrapping, and ensure consistent capitalization. * Deliver the **first 3 converted pages within 2 hours** for approval, then complete the full project within the **24-hour deadline**. I pay close attention to detail and prioritize accuracy over shortcuts. You can expect clear communication, regular progress updates, and a final Google Sheet that is clean, organized, and ready for use. I look forward to the opportunity to work with you. Thank you.
$30 USD in 7 days
1.6
1.6

Cheras, Malaysia
Member since Jul 11, 2026
₹400-750 INR / hour
₹12500-37500 INR
₹12500-37500 INR
₹750-1250 INR / hour
$15-25 USD / hour
$30-250 USD
$30-250 CAD
$30-250 USD
₹12500-37500 INR
₹750-1250 INR / hour
$30-250 NZD
$250-750 USD
₹12500-37500 INR
$15-25 USD / hour
$30-250 AUD
₹750-1250 INR / hour
₹600-1500 INR
€30-250 EUR
$10-30 USD
$500-700 USD