Convert Construction Costing Excel Dataset to SQLite Database
Worldwide
I have a structured Excel dataset for construction estimating containing over 50,000 records, organized into a multi-level hierarchy with descriptions, construction work items, units, labor, material and costing data. I need it converted into a clean, structured SQLite database while preserving all existing data and relationships. Scope * Analyze the Excel structure. * Reconstruct and preserve the complete hierarchy. * Link descriptions to the corresponding elements. * Store construction work items and their associated technical and costing data. * Create proper IDs and parent/child relationships. * Check for missing, inconsistent or orphaned records. * Validate the database against the original Excel file. Deliverables * SQLite database. * Reproducible Excel-to-SQLite conversion script. * Database schema with brief documentation. * Basic data integrity validation. This database will later be used for construction estimating and project planning. For this milestone, I only need the Excel-to-SQLite conversion and data structure. No application or user interface is required.
- Less than 30 hrs/weekHourly
- < 1 monthDuration
- ExpertExperience Level
$10.00
-
$15.00
Hourly- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:50+
- Interviewing:0
- Invites sent:0
- Unanswered invites:0
About the client
- FranceSaint-Fons7:12 PM
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by