Excel-Claude Integration Script

@webmasters486

Hey, I’ve reviewed your requirement for a clean Python workflow that reads company names from Excel, queries Claude via API, and writes structured multi-contact results back into Excel. The focus here is strict JSON handling, reliability, and a clean, restartable pipeline. I’ll build this using Python with requests for API calls and pandas/openpyxl for Excel processing. The script will iterate row-by-row, send structured prompts to Claude enforcing strict JSON output, then validate and parse responses into normalized rows—handling multiple contacts per company by expanding them into separate entries. I’ll include retry logic with exponential backoff, rate-limit safety, structured logging, and a checkpoint/resume mechanism (e.g., last processed row saved locally) so runs can continue without duplication or data loss. You’ll receive a fully commented script, clear column mapping aligned to your JSON schema, and a concise setup guide covering dependencies, environment variables, and restart instructions. Everything will be modular so you can adjust fields or extend the workflow easily. Best regards Muhammad Adil Portfolio: https://www.freelancer.com/u/webmasters486

@Rsolitario

Hello, I can do this work for you. I will deliver a monolith in Python with pandas and a connection to the cloud API to process the data and output results in Excel. You will only need to provide me with the cloud API keys. I will offer it at a low price, so don't hesitate to contact me.

@Sahyadri96

@SahyadriTech #SahyadriTech Completed Projects: 1. Hotel Booking Management & Tracking System (Excel + VBA Script) 2. Appsheet: ERP system for textile business 3. MNGL Gas Incident Tracker & Dashboard (Google Sheets + Google Data Studio) 4. Daily Expenses Tracker (Google Sheets) 5. Option Scalping Strategy Automation (Excel VBA) 6. Nifty50 Live Option Chain Dashboard (Google Sheets) 7. Binary Trading Sheet (Google Sheets) 8. Customer Data Cleaning & Sorting Tool (Excel VBA & Python) 9. Historical Stock Closing Price Analysis for 2,600 Stocks (Excel & Python) 10. Power Bi dashboard for F1 Car racing insights 11. GOLD Loan tracking in Google sheet and Google Data studio 12. Local Taxi Tracking System (Google Sheets + Google Data Studio) 13. Appsheet Milk Drivers wages and attendance system (Appsheet + Google sheet ) Key Highlights: 1. Pay only if satisfied with the work 2. Expert in Power BI, Excel, VBA Macros, Google Sheets, Google Apps Script, and Python 3. Experience in 3 American MNCs 4. Skilled in Data Analytics, Automation, and Visualization 5. Proficient in Statistical Analysis 6. Offer Long-Term Support for all projects 7. Quick Delivery with multiple revisions I can deliver any project related to Data Analytics, Automation, and Reporting with precision and reliability.

@ukokab

I will build a compact, resumable Python script that reads company names from Excel, calls the Claude API for each, enforces your strict JSON schema, and expands every discovered contact into its own row – with parent company data repeated across columns. My approach is grounded in reliability and clarity: ✅ **Stack:** Python 3.x with `requests` (API), `pandas` + `openpyxl` (Excel), and `time` for graceful backoff. Environment variables store the Claude API key. ✅ **JSON‑first workflow:** For each company, I will prompt Claude to return **only** your defined JSON structure (website, email, phone, title, etc.). Multiple contacts produce an array; the script unrolls it into separate Excel rows. ✅ **Resilience:** I will implement exponential backoff for rate‑limit responses, log errors to a file, and add a resume checkpoint so you can restart from the last successfully processed row – no data loss. ✅ **Output discipline:** Every JSON field maps to a dedicated column. No copy‑paste dumps, no merged cells, just clean, query‑ready Excel. Best, Usman Kokab

@Hrolgar

A fixed JSON contract on every call and row-level checkpointing are the two things I'd build before any Excel wiring. Without both, a crash at row 180 of a 200-row run means starting over and paying for the first 180 twice. The script: openpyxl reads your input, each company name goes into the research prompt with a strict output schema enforced so every row returns the same fields, no freeform text. Exponential backoff handles rate limits without supervision. Every N rows, progress checkpoints so a restart picks up mid-sheet rather than from the top. A CSV log tracks row, status, and token count per run so you can audit cost and spot which companies returned thin results. For smaller or less-known names, a fallback pre-fetch step before the main call cuts down on empty responses significantly. M1: Schema design, prompt tuning, Excel I/O skeleton, INR 3500, 2d. M2: Full loop with rate limiting, checkpointing, and cost log, INR 3500, 3d. M3: Testing on your actual sheet, edge case handling, final delivery, INR 3500, 2d. What does your Excel look like row-by-row, and roughly how many companies are in the list?

@manoval09

Hi, You have a spreadsheet of company names that needs processing through Claude—manually batching this work isn't scalable, and a custom workflow cuts out the repetition. I'll build you a Python script that reads your Excel file, feeds company names into Claude in efficient batches, and writes the results back to a new sheet. I'll use pandas for Excel I/O, the Claude API SDK for the core integration, and implement request batching to manage rate limits and costs across large datasets. The script tracks which companies succeeded, includes timestamps, and separates any errors for easy debugging—so you get a clean output sheet plus a log of what failed. My first step is seeing your Excel template and learning exactly what you want Claude to extract or generate for each company name. Once I understand the output format, I'll have a tested, working script back to you within 24 hours. What's the intended output for each row? Best regards, Val

@oimrqs

I can build this as a compact Python workflow with no UI automation. I would read the workbook, call Claude through the API with your strict prompt/schema, validate the JSON, and write one normalized Excel row per contact found. Plan: Python 3, requests, openpyxl/pandas, env var for the API key, configurable model/delay/columns, retry/backoff for rate limits, per-company error log, and a resume checkpoint so a failed batch restarts from the last completed row. Output will keep each field in its own explicit column. I can deliver the first working version in 2 days for ₹3,300. To start I need a sample Excel file, the exact JSON schema, and one expected output example.

@qianq5

Hi — this is a good fit for a compact Python script rather than UI automation. I can build a Python 3 workflow that reads company names from Excel, calls the Claude API with your strict JSON schema, validates/parses the JSON, and writes one row per discovered contact back into Excel while repeating the parent company fields. I would include: - openpyxl/pandas Excel handling - requests-based Claude API calls only, no browser automation - rate-limit backoff and retry handling - JSON validation with clear error rows/logs - resume mode so a long batch can continue from the last successful company - a small config file for API key/model/schema settings I can deliver a working script plus a sample input/output workbook and README. One question: will you provide the exact Claude JSON schema/prompts, or should I draft the first schema for you based on the contact fields you need?