Nettoyage des données Jobs

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.

I have several Excel workbooks that already contain raw customer information, but they’re scattered across different tabs and follow no consistent structure. I need someone to consolidate every record into a single, clean master sheet, standardise the column headers, and ensure all values (names, phone numbers, email addresses, addresses, etc.) are formatted uniformly. Accuracy is critical, so I will be checking for duplicates and incomplete fields. You are free to rely on functions such as VLOOKUP/XLOOKUP, Power Query, or pivot tools—whatever speeds up the process without compromising quality. When you finish, I expect one tidy .xlsx file ready for import into our CRM plus a short note outlining any assumptions, data issues you encountered, and how you resolved them. If th...

Job Description We need a disciplined SQL/data engineer to produce a deterministic, re-runnable script-based build (lean MVP, not enterprise infra). Goal Create a single canonical, one-row-per-company dataset anchored on UEI, then enrich it using exact UEI matches (no name guessing). Inputs (provided) USAspending extract / source tables (L24M window) DSBS export (CSV) with UEI + owner contact fields SAM Active Entity extract (CSV) with UEI + phone + officer names Written Segment B & C rules (explicit) Deliverables 1. USAspending segmentation + canonical vendor table >Filter to last 24 months >Vendor-level aggregation → one row per UEI >Apply Segment B & C logic exactly as written >Deterministic CSV output >Basic QA checks: a. no duplicate UEIs in outp...

I need thousands of mixed-format scanned documents turned into searchable Excel format. High accuracy is essential. Requirements: - All documents have consistent formatting - Must maintain high accuracy in data entry - Must connect a photo to each document line (as a column in the excel sheet) Ideal skills and experience: - OCR and Excel - Some coding experience will be necessary - Attention to detail and commitment to accuracy Looking forward to your bids!

I have a collection of paper-based reports filled with numerical figures that I need captured accurately in a clean, well-structured Excel workbook. Your task is straightforward: read each sheet, key every number into the correct columns and rows I will provide, double-check totals as you go, and flag any values that are unclear or illegible so I can review them later. The final Excel file must mirror the original layout, preserve any subtotals or grand totals, and be free of transcription errors. I will scan and share the documents as high-resolution PDFs; you simply return the completed spreadsheet plus a brief note of any issues you encountered. Attention to detail and solid Excel skills are essential because these figures feed directly into our monthly reporting. If you have experien...

Quiero digitalizar el inventario de mi empresa y necesito ayuda para capturar la información de menos de 500 productos en hojas de cálculo de Excel. Qué necesito: • Copiar con exactitud descripción, SKU, cantidad disponible, precio y cualquier nota relevante de cada referencia. • Seguir paso a paso la plantilla y las reglas que compartiré (formato de celdas, validación, orden alfabético y separación por categorías). • Entregar un archivo limpio, sin fórmulas innecesarias, listo para que yo lo suba a nuestro sistema interno. Lo que te entrego: – Plantilla de Excel vacía con los encabezados definidos. – Manual corto con el flujo: verificación doble, colores para alertas y ch...

I have four small companies whose books have been tracked only in separate Excel sheets. Over the last two financial years I logged roughly 300–400 transactions in total, covering sales & revenue, expenses & purchases, and a handful of loan entries. I now need a one-off clean-up that brings every ledger into balance and gives me clear financial statements for each entity. The work involves importing or re-structuring the existing Excel data, classifying each transaction correctly, checking for duplicates or omissions, reconciling against bank statements, and then producing a tidy trial balance, profit-and-loss, and balance sheet for each company. I only have basic excel spreed sheets from the bank Deliverables • Balanced ledgers for all four companies covering the last...

Saya memiliki kumpulan dokumen berbentuk gambar/foto yang perlu diubah menjadi data terstruktur dalam spreadsheet Excel. Tugasnya murni entri data dari file fisik yang sudah kami pindai, sehingga ketelitian dan konsistensi penulisan sangat penting. Ruang lingkup: • Menyalin setiap elemen teks angka maupun huruf persis seperti dalam gambar/foto. • Menyusun data ke dalam kolom dan baris Excel sesuai template yang akan saya berikan. • Melakukan pengecekan cepat untuk memastikan tidak ada salah ketik atau nilai terlewat. Deliverable: • Satu file Excel lengkap dan sudah diverifikasi, siap dipakai untuk analisis selanjutnya. Saya menyediakan semua gambar beresolusi cukup tinggi agar proses pengetikan lebih mudah. Silakan ajukan jika Anda terbiasa bekerja dengan data be...

I need a verified list of 100 LinkedIn contacts who sit at mid-management level—think Managers and Directors and Vice Presidents—inside grocery, retail and beverage store chains across the country. I will give you the exact companies and job titles to hunt for, so your job is purely about smart searching and clean data capture. Once you locate a match, record the person’s full name, current title, company,, LinkedIn profile URL and any publicly available work email (if it can be found) you can source. Please keep everything tidy in a spreadsheet (Excel or Google Sheets is fine) and make sure there are no duplicates, no consultants, and nobody outside the United States. If you use tools like LinkedIn Sales Navigator, Apollo, Hunter, etc., mention that when you bid so I k...

I have a stack of paper documents that contain both text and numerical information. I need every line carefully transcribed and organised into a clean, well-structured Excel spreadsheet. Please keep the original order of the records, label the columns clearly, and double-check totals or calculations so the numbers match exactly what appears on the page. Accuracy and legibility are more important to me than speed, but I would like regular updates so I can spot-check your work as we go. Once complete, I expect a single .xlsx file that is ready for analysis with no stray characters or formatting issues.

I am rolling out Odoo in my company and will start with the Sales and Inventory modules. The goal is a clean, production-ready instance configured to match our current workflows and stocked with all historic data. Scope of work • Configure and fine-tune Odoo Sales and Inventory so that quoting, order processing, stock moves, and replenishment mirror the way we operate today. • Import every record—customers, suppliers, products, price lists, stock levels, open orders, and transaction history—so there is no break in reporting or traceability. This is a full data migration from our legacy ERP; mapping, cleansing, and validation are part of the job. • Train my team on the new environment and leave clear documentation so we can maintain basic settings ourselves. ...

I have a collection of websites that contain the text I need organised in a single Excel spreadsheet. Your task is straightforward: visit each assigned site, copy the required text exactly as it appears, and paste it into the correct columns and rows of the workbook I supply. Accuracy and consistency matter more than speed. Please keep original spellings, line breaks, and capitalisation, and double-check that no unseen characters or extra spaces slip in. The spreadsheet already has headers; all you do is populate the empty cells beneath them. I will share: • The list of URLs • A short field-by-field guide so you know which snippet of text belongs in which column • The blank .xlsx file You return: • The completed Excel file, ready for me to import into our system ...

I have a collection of digital files—mostly PDFs and existing spreadsheets—filled with numerical information that must be transferred into a single, well-structured worksheet. Because everything needs to be keyed in manually, absolute accuracy is critical; even a small typo could throw off later calculations. You will receive the source files, a template in Excel or Google Sheets (whichever you prefer), and clear field-by-field instructions. Your task is to: • Manually enter every number exactly as it appears • Apply the specified formatting rules (decimal places, thousand separators, currency symbols) • Double-check totals against the originals to catch discrepancies before delivery I’ll be available for quick clarifications and spot-checks as you w...

Saya memiliki kumpulan data penjualan yang perlu segera dipindahkan ke Google Sheets. Sumber datanya berupa File Excel dan Dokumen PDF; tugas Anda adalah menyalin, memeriksa, dan merapikan setiap baris agar formatnya konsisten serta angka-angka akurat. Ruang lingkup pekerjaan: • Copy-paste data dari file sumber ke Google Sheets. • Validasi kesesuaian setiap kolom (tanggal, produk, jumlah, harga). • Rapikan tata letak—header seragam, pemisahan ribuan, serta pemakaian rumus dasar bila perlu. • Laporkan anomali atau duplikasi yang ditemukan. Harapan saya: – Ketelitian tinggi dan kecepatan kerja. – Komunikasi responsif di jam kerja. – Penyelesaian tepat waktu sesuai instruksi bertahap yang akan saya berikan. Saat melamar, sertakan ringka...

Saya memiliki kumpulan data penjualan yang perlu segera dipindahkan ke Google Sheets. Sumber datanya berupa File Excel dan Dokumen PDF; tugas Anda adalah menyalin, memeriksa, dan merapikan setiap baris agar formatnya konsisten serta angka-angka akurat. Ruang lingkup pekerjaan: • Copy-paste data dari file sumber ke Google Sheets. • Validasi kesesuaian setiap kolom (tanggal, produk, jumlah, harga). • Rapikan tata letak—header seragam, pemisahan ribuan, serta pemakaian rumus dasar bila perlu. • Laporkan anomali atau duplikasi yang ditemukan. Harapan saya: – Ketelitian tinggi dan kecepatan kerja. – Komunikasi responsif di jam kerja. – Penyelesaian tepat waktu sesuai instruksi bertahap yang akan saya berikan. Saat melamar, sertakan ringka...

I’m working with a sizable dataset that contains both numbers and text, and I need every record entered faithfully into a Google Sheet. Before anything goes in, each numerical field has to be checked against the specific upper- and lower-bound ranges I’ll provide; if a value falls outside that range, simply flag it in a separate “Issues” column instead of altering it. The flow is straightforward: validate, enter, double-check. You may rely on Google Sheets’ built-in data-validation rules, filters, or even quick formulas to speed up the range checks, but accuracy always overrides speed. Because the sheet mixes text columns and numeric columns, please beware of mis-aligned cells, accidental truncations, or copied formatting that could skew the data type. Del...

Hola, busco personas dispuestas a ayudarme a completar mi proyecto a tiempo. Proporcionaré toda la información necesaria para comprender y realizar el trabajo. Se prefieren principiantes. Gracias.

We are looking for an experienced Excel specialist to help organize and automate our monthly sales tracking workbook. Currently, we maintain multiple sheets containing product-level sales data, but the file lacks structure and automated summaries. We need someone who can clean up the structure and create a simple but reliable dashboard. This is not an advanced BI project, but it requires solid Excel logic and clean structuring skills. Scope of Work Review existing workbook (multiple sheets with sales records) Consolidate data into a structured master table (if necessary) Create automated monthly summary calculations Build a simple interactive dashboard including: Total sales by month Sales by product category Top 5 products Monthly trend (line chart) Use Pivot Tables, SUMIFS, X...

I have a collection of raw information that must be keyed into the correct digital format with zero transcription errors. All source files and clear, step-by-step instructions will be provided once the project begins. Your task is simply to capture the data exactly as it appears, double-check for consistency, and return the completed file ready for immediate use. Attention to detail and respect for confidentiality are vital. Familiarity with common spreadsheet tools—Excel or Google Sheets—is helpful, but the most important requirement is accuracy. If you are comfortable working to a deadline and can maintain tidy, well-structured records throughout the process, this assignment should be straightforward.

I’m working with a sizable dataset that contains both numbers and text, and I need every record entered faithfully into a Google Sheet. Before anything goes in, each numerical field has to be checked against the specific upper- and lower-bound ranges I’ll provide; if a value falls outside that range, simply flag it in a separate “Issues” column instead of altering it. The flow is straightforward: validate, enter, double-check. You may rely on Google Sheets’ built-in data-validation rules, filters, or even quick formulas to speed up the range checks, but accuracy always overrides speed. Because the sheet mixes text columns and numeric columns, please beware of mis-aligned cells, accidental truncations, or copied formatting that could skew the data type. Del...

제가 보유한 방대한 숫자 데이터를 한눈에 보기 쉽도록 깔끔하게 정리해 주셨으면 합니다. • 데이터 유형: 숫자 데이터만 포함되어 있으며, 파일 여러 개를 통합해야 합니다. • 분량: ‘많음’에 해당할 정도로 큼직한 규모라서 자동화 스크립트(Excel Power Query, Python pandas 등)를 활용해 빠르고 정확하게 처리해 주시면 좋겠습니다. 작업 범위 1. 원본 데이터 수집·통합: 엑셀·CSV·구글시트 등 서로 다른 소스에 흩어진 파일을 하나로 모읍니다. 2. 오류 및 중복 검수: 잘못된 포맷, 누락값, 중복 행을 식별해 수정 또는 제거합니다. 3. 구조화 및 정렬: 분석이나 보고서에 바로 사용할 수 있도록 컬럼 체계와 필터를 일관성 있게 맞춥니다. 4. 최종 산출물: 정리된 마스터 파일(Excel 또는 CSV)과 간단한 정리 규칙 문서. 신청 시 ‘숫자 데이터 정리’와 관련된 경험을 중심으로 알려 주세요. 유사 프로젝트 사례나 사용하셨던 도구, 처리 규모를 공유해 주시면 선정에 큰 도움이 됩니다.

I have a ready-made Excel template and will forward the raw figures whenever they come through. Your job is straightforward: paste each new batch of information into the correct columns, make sure the SUM formula at the bottom keeps rolling forward so the running total updates automatically, then send the file back to me. The workload is light—usually about an hour per session—but it is recurring. There’s no fixed timetable; some weeks may bring several uploads, other stretches none at all, so I need someone who can jump in “when required” and turn the sheet around quickly. Accuracy and basic Excel know-how (editing cell references, checking that the sum totals still capture the latest rows) are all that’s needed. I’ll supply the data in a clean ...

Federal Data Operations Specialist (Canonical Company Lists, Upstream of CRM) Engagement Type Contract / Part-time Remote Ongoing or project-based, depending on workload Engagement: Fixed-price, per-deliverable (project-based) Role ObjectiveGraviton builds outbound and CRM systems on top of canonical company role exists to create those datasets upstream of CRM, by correctly merging multiple raw data sources into clean, deterministic, company-level tables using stable , correctness, and discipline matter more than speed. Core Responsibilities You will: Merge multiple datasets with different levels of granularity into a single canonical table Enforce a primary identifier (e.g., UEI, CAGE, or equivalent) as the identity anchor Aggregate transaction-level data to the entity...

I need help transferring information into online registration forms. Every form has between 10 – 20 fields—basic text, numeric entries, and a few dropdown selections. I’ll supply scans or spreadsheets of the source data plus credentials for the secure web portal where the forms are hosted. The work is straightforward: open each source record, copy the values into the matching fields, double-check for spelling or formatting errors, then submit the form. Consistency and accuracy are far more important than raw speed, though I do want the first batch turned around the same day it’s assigned. Deliverables • All assigned registration forms filled out and successfully submitted in the portal • A brief completion report noting total forms processed and an...

Saya membutuhkan bantuan untuk menangani pengetikan dan entri data yang volumenya cukup banyak, tetapi prosesnya terbilang mudah. Data yang akan Anda masukkan berupa kombinasi angka dan teks yang berasal langsung dari formulir online. Lingkup tugas: • Mengakses setiap formulir online yang saya sediakan. • Menyalin semua kolom numerik dan teks dengan teliti ke lembar kerja Google Sheets/Excel yang sudah saya format. • Memastikan konsistensi penulisan (kapitalisasi, tanda baca, dan penempatan desimal) agar data siap diproses lebih lanjut. Kriteria keberhasilan: • Akurasi minimum 99 %. • Tidak ada baris kosong atau duplikat. • File akhir dikirimkan tepat waktu, lengkap dengan log singkat mengenai entri yang diragukan (jika ada). Saya akan memberikan ...

I have a collection of PDFs that need to become a single, reliable Excel file. After the tables are extracted, the real priority is cleaning: fixing any odd characters, aligning column formats, checking for obvious entry errors, and making sure the final sheet is ready for downstream analysis. What you’ll hand over: • An Excel workbook converted from the source PDFs. • A fully cleaned version of that workbook, clearly labelled and free of errors. If you have automated routines (Power Query, Python / pandas, VBA, etc.) that speed the job up, all the better—just let me know what you plan to use. When you respond, point me to similar PDF-to-Excel or data-cleaning work you’ve completed in the past so I can gauge fit quickly. I’ll supply the PDFs and any a...

I’m working with a sizable dataset that contains both numbers and text, and I need every record entered faithfully into a Google Sheet. Before anything goes in, each numerical field has to be checked against the specific upper- and lower-bound ranges I’ll provide; if a value falls outside that range, simply flag it in a separate “Issues” column instead of altering it. The flow is straightforward: validate, enter, double-check. You may rely on Google Sheets’ built-in data-validation rules, filters, or even quick formulas to speed up the range checks, but accuracy always overrides speed. Because the sheet mixes text columns and numeric columns, please beware of mis-aligned cells, accidental truncations, or copied formatting that could skew the data type. Del...

have a collection of digital PDFs, spreadsheets, and text files that need to be consolidated into a single, well-structured spreadsheet. The content is mixed—both text and numerical values—so each entry must be handled carefully to preserve formatting, accuracy, and consistency. All source documents are already in a shared Google Drive; you’ll also find an Excel/Google Sheets template there with the required column headers and basic validation rules. Your job is to open each file, extract every relevant field, normalise obvious inconsistencies (dates, capitalisation, number separators), and key the information into the template without loss or alteration. Because there’s no strict deadline, you can work at a pace that ensures meticulous quality. I only ask for ste...

I need help to tabulate data from 1-5 Excel spreadsheets. The data is to be used for customer productivity and incentive calculation. Key tasks include: - Tabulating sales figures - Tabulating performance metrics Ideal skills and experience: - Proficiency in Excel - Experience with data tabulation and automation - Attention to detail

I have a collection of digital PDFs, spreadsheets, and text files that need to be consolidated into a single, well-structured spreadsheet. The content is mixed—both text and numerical values—so each entry must be handled carefully to preserve formatting, accuracy, and consistency. All source documents are already in a shared Google Drive; you’ll also find an Excel/Google Sheets template there with the required column headers and basic validation rules. Your job is to open each file, extract every relevant field, normalise obvious inconsistencies (dates, capitalisation, number separators), and key the information into the template without loss or alteration. Because there’s no strict deadline, you can work at a pace that ensures meticulous quality. I only ask for s...

I have a single PDF that holds roughly 50 scanned business cards, all in English. I need every card transcribed into a clean Excel sheet so I can import the contacts into my CRM without manual re-typing. Here’s what has to come across from each card: • Name • Job title • Company name • Company logo (please paste the image into its own cell or include a link to the extracted file) • Direct phone number(s) • Email address • Physical address Lay everything out in a standard column format—one row per card, one clearly labeled column per data point. Accuracy is key, so I’ll spot-check against the PDF; inconsistencies or missing fields will need correcting before final hand-off. I’m fine with whatever method you prefer&m...

I’m working with a sizable dataset that contains both numbers and text, and I need every record entered faithfully into a Google Sheet. Before anything goes in, each numerical field has to be checked against the specific upper- and lower-bound ranges I’ll provide; if a value falls outside that range, simply flag it in a separate “Issues” column instead of altering it. The flow is straightforward: validate, enter, double-check. You may rely on Google Sheets’ built-in data-validation rules, filters, or even quick formulas to speed up the range checks, but accuracy always overrides speed. Because the sheet mixes text columns and numeric columns, please beware of mis-aligned cells, accidental truncations, or copied formatting that could skew the data type. Del...

Saya membutuhkan bantuan untuk menangani pengetikan dan entri data yang volumenya cukup banyak, tetapi prosesnya terbilang mudah. Data yang akan Anda masukkan berupa kombinasi angka dan teks yang berasal langsung dari formulir online. Lingkup tugas: • Mengakses setiap formulir online yang saya sediakan. • Menyalin semua kolom numerik dan teks dengan teliti ke lembar kerja Google Sheets/Excel yang sudah saya format. • Memastikan konsistensi penulisan (kapitalisasi, tanda baca, dan penempatan desimal) agar data siap diproses lebih lanjut. Kriteria keberhasilan: • Akurasi minimum 99 %. • Tidak ada baris kosong atau duplikat. • File akhir dikirimkan tepat waktu, lengkap dengan log singkat mengenai entri yang diragukan (jika ada). Saya akan memberikan ...

I have a batch of source files that need to be keyed into my existing template exactly as they appear. The work is strictly manual—no macros, OCR, or automated scraping—because accuracy down to every character matters. The information you will be handling is a mix of letters and numbers (product codes, IDs, reference strings, etc.). I’ll provide the Excel template with locked headers, drop-down validation where needed, and a short set of field notes so you always know what belongs in each column. Your task is simply to open each source file, copy the alphanumeric value, and paste it into the correct cell without altering the formatting. Deliverable • The completed template populated with all entries, saved in the same file structure I provide. • A br...

I have a backlog of information that must be transferred quickly and accurately into an online database. The task is strictly data entry—no analysis or design work—so your attention to detail and consistency are what matter most. Here’s what the job involves: • Receive raw worksheets, PDFs, or scanned notes from me. • Enter each record into the designated fields of the database interface I provide. • Double-check for typos, duplicate records, and missing values before submitting. Although my main focus is database entry, if you feel comfortable with light spreadsheet clean-up or transcription, let me know—I may have additional work later. Deliverable: a fully populated database table that matches my source files 100 % in content and order, ...

I have several spreadsheets of raw sales data that need to be merged into a single, reliable source. Your first task is to remove duplicates, fix mis-aligned headers, standardise date and currency formats, and generally make sure every column is analysis-ready. Once the data is spotless, I want clear, interactive visuals—think slicers, pivot-based charts, or a compact dashboard—built either in Excel or Power BI (I’m open to whichever tool you work fastest and most creatively in). When you’re done, include a concise handoff note that walks through the key formulas, any Power Query steps, and how I can refresh the visuals with new data. Please highlight your experience doing similar consolidation and dashboard work; that’s the main thing I’ll use to ...

I have a collection of digital PDFs, spreadsheets, and text files that need to be consolidated into a single, well-structured spreadsheet. The content is mixed—both text and numerical values—so each entry must be handled carefully to preserve formatting, accuracy, and consistency. All source documents are already in a shared Google Drive; you’ll also find an Excel/Google Sheets template there with the required column headers and basic validation rules. Your job is to open each file, extract every relevant field, normalise obvious inconsistencies (dates, capitalisation, number separators), and key the information into the template without loss or alteration. Because there’s no strict deadline, you can work at a pace that ensures meticulous quality. I only ask for s...