
Completed
Posted
Paid on delivery
I need a clean, single-worksheet Excel file that brings together every traveller’s key details so I can track trips at a glance. You’ll be working with a set of confirmation emails and attached documents; from those you’ll pull three kinds of information—personal info (name, phone or email), the full travel itinerary, and all booking references for flights and hotels. Because everything has to sit on one sheet, the layout must be logical and scroll-friendly: fixed column headers, freeze-panes for easy viewing, and light conditional formatting to flag missing data. Feel free to automate the extraction with Outlook rules, Python, VBA or any parsing tool you trust, as long as the final workbook lands in .xlsx format and every record is accurate. Deliverables • An Excel template with clearly labelled columns ready for ongoing use • The populated file containing the data you have extracted • A brief note (or commented code) explaining any script or macro used so I can rerun it later if needed I’ll share sample emails as soon as we start, and I’m happy to clarify field definitions before you dive in. Accuracy matters more than speed, but I’d like the first draft within a couple of days so we can make any quick tweaks.
Project ID: 40629520
7 proposals
Remote project
Active 2 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hi, Your project "Consolidate Traveler Data in Excel" is a good fit -- Python backend and automation work is my main line of work. How I would run it: 1. Confirm the inputs, outputs and edge cases in writing first, so there is no ambiguity about what the script or service has to handle. 2. Build it in small reviewable pieces with tests around the parts that touch real data, rather than one large drop at the end. 3. Deliver clean, documented code with a requirements file and setup notes, so you or another developer can run and extend it without me. Matching your listed skills: Data Extraction, Data Analysis, Data Management, Automation, Excel, Python, Visual Basic, Data Processing. My bid is ₹1020, within your ₹600-1200 range. Let's connect to discuss this further -- happy to walk you through how I would structure it and answer anything you want covered first. Thanks for your time. Best regards, Ashish & Team
₹1,020 INR in 7 days
4.6
4.6

Hi! I'd love to help with this project. I have experience organizing and cleaning data in Excel and can accurately extract traveller details, itineraries, and booking references from your emails and attachments into a well-structured single worksheet. The final workbook will include clear column headers, freeze panes, light conditional formatting for missing data, and be delivered in .xlsx format. If automation is the best approach, I'll also provide the script or macro with simple instructions so you can easily reuse it in the future. I pay close attention to accuracy and can provide the first draft within a couple of days for your review and any adjustments. Looking forward to seeing the sample emails and getting started!
₹1,000 INR in 7 days
0.8
0.8
7 freelancers are bidding on average ₹1,181 INR for this job

Hi, this travel tracking Excel workbook can be prepared in a clean, easy-to-use format with all traveller details, itineraries, flight and hotel references organized on one sheet. I can extract the required information from confirmation emails and attached documents, then structure it with fixed headers, freeze panes, and missing-data highlights for quick review. The final file will include both a reusable template and a populated .xlsx workbook ready for ongoing trip tracking. A short note or commented script can also be included so the same process is easy to rerun later.
₹1,050 INR in 2 days
2.8
2.8

Hi, I hope you're doing well. I understand you're looking to consolidate traveler information from confirmation emails and documents into a structured Excel workbook that provides a clear overview of trips, personal details, and booking references. The goal is to create an accurate, easy-to-manage sheet that can also support future updates and ongoing tracking. I will extract and organize the required traveler details, design a clean Excel structure with fixed headers, freeze panes, and helpful formatting, and automate the extraction process using Python, VBA, or suitable parsing methods where needed. I will also provide clear notes or commented scripts so the workflow can be reused for future data additions. My focus is on delivering an accurate, well-organized Excel solution with reliable data processing, easy navigation, and a smooth handover for long-term use. Best regards, Heorhii
₹1,500 INR in 1 day
1.4
1.4

Hello, I can accurately extract traveller information from emails and attachments and organize it into a clean, well-structured Excel workbook. I can also automate the process using Python or VBA if needed and provide a reusable script with the final delivery. I am ready to start immediately. Thank you.
₹600 INR in 1 day
0.0
0.0

The key to this project is turning travel confirmations from multiple emails and attachments into a single, well-structured Excel sheet that is easy to search, filter, and maintain. I can extract traveller details, itineraries, and flight/hotel booking references, then organize everything into a clean, scroll-friendly workbook. The template will include fixed headers, freeze panes, light conditional formatting to highlight missing information, and a logical column structure for ongoing use. If automation is appropriate, I can use Python or another suitable approach to streamline the extraction while ensuring the final deliverable is a standard .xlsx file. Any script used will be documented so you can rerun the process in the future. My experience includes Excel, data extraction, data cleaning, data processing, reporting automation, and structured data management, with a strong focus on accuracy and consistency.
₹2,500 INR in 7 days
0.0
0.0

Gurugram, India
Payment method verified
Member since Oct 19, 2022
₹600-1500 INR
₹600-1500 INR
₹600-1500 INR
₹25000-30000 INR
₹1500-12500 INR
₹12500-37500 INR
£250-750 GBP
₹1500-12500 INR
₹750-1250 INR / hour
$30-250 CAD
$10000-25000 USD
₹600-1500 INR
$15-25 USD / hour
$15-25 USD / hour
$125-200 USD
$10-30 USD
min $50 USD / hour
$20-60 USD
₹600-1500 INR
$15-25 USD / hour
₹600-1500 INR
₹600-1500 INR
₹750-1250 INR / hour
₹750-1250 INR / hour
₹750-1250 INR / hour