Data Extraction from CSV

I need help extracting text data from CSV files and inputting it into a specified format or system.

Requirements:
- Experience with data extraction and manipulation
- Proficiency in handling CSV files
- Attention to detail to ensure accuracy
- Ability to work within the specified budget

Ideal Skills:
- Data entry
- Familiarity with spreadsheet software (e.g., Excel)
- Basic understanding of data organization principles

Looking for freelancers who can complete the task efficiently and accurately.

this is the full requirment for the project

Your Operational Requirements (Summary)
1) Quote & Job Intake

Create quotes (Q-files) and job packs (J-files) as you do today

Save them into SharePoint folders

System automatically reads them and creates:

Quote records

Assets

Tasks per asset

Quotes should appear in planner even when waiting approval

2) Status & Workflow Management

Status should be controlled in the planner, not inside documents

Quote lifecycle:

Waiting approval

Ready to plan

Planned

Completed

Task lifecycle:

Ready to plan

Planned

In progress (optional)

Completed

Cancelled (client change)

System must handle:

assets removed after approval

assets added later

quotes split into multiple quotes

3) Planning & Scheduling

Planner needs a single view of all tasks

Must be able to:

filter by postcode/location

group geographically

assign teams

set planned dates

Future goal:

automatic route optimisation

skill-based team assignment

minimum weekly value per team

4) Team Capability & Productivity

Each team has:

skills

base location

weekly value target

Tasks require specific skills

Planner must ensure teams only receive work they can do

5) Materials & Stock Control

Maintain yard stock only

Track:

materials required for each task (planned)

materials actually used on site

Materials should link to:

Quote

Asset

Task

Allow variation between planned and actual usage

6) Labour & Field Costs

Labour cost model per team:

Day rate

Completion bonus

Overnight stay bonus

Track labour per quote so real job cost is visible

7) Expenses Tracking

Track non-labour costs per quote:

Travel

Mileage

Hotels

Subsistence

Other site expenses

8) Commercial & Margin Visibility

Need a page showing per-quote:

Sell value from quote

Task sell value

Materials cost

Labour cost

Travel/expense cost

Total cost

Margin £ and %

This should update automatically from the operational data.

9) Automation Goals

System should eventually:

auto-ingest quotes & job packs from SharePoint

auto-populate planner

auto-update statuses based on activity

support future route optimisation