Data Extraction and Excel Spreadsheet Creation
Budget: $30 – $250 USD
I am looking for a detail-oriented Excel expert or data analyst to help extract information from one market research PDF document into a structured Excel spreadsheet with multiple tabs and charts exactly as the source material provided.
The task includes:
- Extracting and organizing data from PDF reports
- Creating multiple tabs based on topics or sections
- Generating charts and visualizations (bar graphs, pie charts, line charts, etc.)
- Inserting formulas where applicable (e.g., growth %, CAGR, year-over-year comparisons, totals, etc.)
- Ensuring clean formatting, easy-to-read structure, and good use of labels and headers
Optionally: Suggesting improved ways to represent the data (pivot tables, dashboards, etc.)
Ideal Candidate:
- Strong proficiency in Microsoft Excel (including formulas, charts, and formatting)
- Experience with PDF-to-Excel extraction tools and/or manual data entry for structured reports
- Background in market research, business analysis, or related fields is a plus
- Attention to detail and layout aesthetics
Bonus if you can automate repetitive patterns with macros or scripts
Deliverables:
- A clean, editable Excel file with multiple tabs.
- Clear chart representations of key figures
- Embedded formulas (not just raw values)
Attachments:
1 PDF will be shared upon award of the project. it is 120 pages long and contain market trends, forecasts, tables, and segment analyses.
To apply, please include:
- A brief note about your experience with similar projects
- Samples of past Excel work (especially with charts or structured datasets)
Time estimate to complete ~1 PDF documents
Looking forward to working with someone who can turn raw data into insightful and usable spreadsheets!
The task includes:
- Extracting and organizing data from PDF reports
- Creating multiple tabs based on topics or sections
- Generating charts and visualizations (bar graphs, pie charts, line charts, etc.)
- Inserting formulas where applicable (e.g., growth %, CAGR, year-over-year comparisons, totals, etc.)
- Ensuring clean formatting, easy-to-read structure, and good use of labels and headers
Optionally: Suggesting improved ways to represent the data (pivot tables, dashboards, etc.)
Ideal Candidate:
- Strong proficiency in Microsoft Excel (including formulas, charts, and formatting)
- Experience with PDF-to-Excel extraction tools and/or manual data entry for structured reports
- Background in market research, business analysis, or related fields is a plus
- Attention to detail and layout aesthetics
Bonus if you can automate repetitive patterns with macros or scripts
Deliverables:
- A clean, editable Excel file with multiple tabs.
- Clear chart representations of key figures
- Embedded formulas (not just raw values)
Attachments:
1 PDF will be shared upon award of the project. it is 120 pages long and contain market trends, forecasts, tables, and segment analyses.
To apply, please include:
- A brief note about your experience with similar projects
- Samples of past Excel work (especially with charts or structured datasets)
Time estimate to complete ~1 PDF documents
Looking forward to working with someone who can turn raw data into insightful and usable spreadsheets!