The Scenario
It's Monday morning and you're looking at an Excel workbook with fifteen country codes in column A — GB, DE, US, JP, BR, and ten more — each representing a target region for a batch of rotating-session scraping jobs that need to go live by end of day. The team configured the scraper infrastructure last week. What's missing is the actual Smartproxy connection strings.
The bad version:
- You open the Smartproxy dashboard, navigate to the endpoint generator, and copy the format documentation into a sticky note so you don't lose it
- You manually construct each connection string — username, password, host, port — for all fifteen country codes, switching between the dashboard and the workbook fifteen times, checking the port number each time for rotating versus sticky sessions
- You paste each string into column B, realize at row 9 that you used the wrong port for JP (rotating uses a different range than sticky), and go back to fix rows 1 through 8 to make sure you didn't apply the wrong format earlier
The scraping team is waiting on these strings to finish the microservice config. Every hour of delay is an hour those jobs aren't running. This is data-entry work being done by someone whose job title does not say "data entry."
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your data, understands the structure, and through its built-in Smartproxy integration can generate formatted endpoint strings for every row and write them directly into your workbook. No dashboard switching, no manual string construction.
For each country code in column A (rows 2–16), generate a Smartproxy backconnect endpoint using rotating session type and write the full connection string in the format 'http://user:pass@host:port' into column B
What You Get
- Column B fills with a properly formatted Smartproxy connection string for each row — username, password, host, and port concatenated in Smartproxy's expected format for rotating sessions
- Country-specific endpoints are used where Smartproxy supports them, with the correct port range for rotating-session proxy type
- If a country code in column A isn't recognized or doesn't have a matching Smartproxy endpoint, that row is flagged in column C so you can review it rather than discovering a broken connection at runtime
What If the Data Is Not Quite Ready
Country codes are mixed format — some are two-letter ISO, some are full country names
Normalize the values in column A to ISO 3166-1 alpha-2 country codes (e.g. "United Kingdom" → "GB", "Germany" → "DE"), then generate Smartproxy rotating-session backconnect endpoint strings for each normalized code and write the connection strings into column B
The workbook needs both rotating and sticky session endpoints per country
For each country code in column A (rows 2–16), generate two Smartproxy endpoint strings — one for rotating session type and one for sticky session — and write the rotating endpoint into column B and the sticky endpoint into column C
Country codes are split across two worksheets — EU Targets and APAC Targets — and need to be combined into one output
Pull country codes from column A on both the EU Targets worksheet and the APAC Targets worksheet, combine them into a single deduplicated list, generate Smartproxy rotating-session backconnect endpoints for each, and write the results into columns A and B of the All Endpoints worksheet
The endpoint strings also need to have username and password pulled from a credentials table in column D before generation
For each row in rows 2–16, use the username from column B and the password from column C, combine with the country code in column A to generate a Smartproxy rotating-session endpoint in the format 'http://[username]:[password]@[host]:[port]', and write the full connection string into column D — flag any rows where username or password is blank
Ask for the credential injection, the format normalization, and the endpoint generation in a single prompt instead of running them as separate steps.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of country codes or proxy target regions, then ask it to generate Smartproxy backconnect endpoint strings for every row. Link back to the hub: How to Connect Smartproxy to Excel. Or see the related spoke: Pull All Smartproxy Endpoints Into an Excel workbook for Infrastructure Planning.