XL2Web
Home Privacy Add to Chrome

XL2Web Documentation

XL2Web helps you auto-fill web forms from Excel or CSV. This guide covers installation, setup, field selection, header mapping, filling pages, and import/export.

Overview

What XL2Web does

  • Loads Excel (.xlsx) or CSV (.csv)
  • Stores configurations per website
  • Supports multi-page flows
  • Fills inputs, dropdowns, checkboxes, and clicks buttons
  • Includes wait steps for dynamic pages

What you configure

  • Website profile (e.g., xyz.com)
  • Pages (URL match + actions)
  • Selectors (captured by clicking fields)
  • Excel mapping (via refresh-loaded headers)

Install

  1. Open the Chrome Web Store
  2. Search for XL2Web
  3. Click Add to Chrome
  4. Pin XL2Web to the toolbar (recommended)
Tip: Pinning makes it easier to open XL2Web while working through multi-page forms.

Quick Start

1) Load Excel / CSV

  • Open XL2Web from the Chrome toolbar
  • Upload your .xlsx or .csv
  • Select (or create) a Website profile
  • For Excel files: enter the Sheet name if required for your spreadsheet
  • Set Header row number and Row (data row) number

2) Configure Pages

  • Add a Page
  • Enter a pageRef (a stable URL fragment)
  • Click Select fields and click the form fields on the page

3) Load headers and auto-map (recommended)

  • Open Field settings for a page
  • Click the Refresh icon near “Col / Text”
  • XL2Web loads header names into the dropdowns and auto-selects best matches for unmapped fields

4) Fill

  • Use Fill this page for manual fill
  • Or enable Auto-fill on navigation to fill as you browse through the flow

Core Concepts

Website profiles

A Website profile groups everything for a domain/workflow: pages, selectors, header mapping, and row settings.

  • Example profile name: xyz.com or qwerty.com
  • Each profile stores its own Auto-fill preference

Pages

Each page contains a URL match rule (pageRef) and an ordered list of actions.

Actions

Actions run in sequence when filling. You can mix field actions and wait actions.

UI Walkthrough

Step 1: Load file

  • Upload Excel/CSV
  • Select Website profile
  • Enter Sheet / Header / Row

Step 2: Configure pages

  • Add page and set pageRef
  • Select fields or modify fields
  • Use Fill this page for manual fill

Auto-fill toggle

  • Auto-fill on navigation is stored per website profile

Field Settings

Field settings let you control how each selector behaves during fill.

Auto

Fills from Excel/CSV mapping. Header dropdown is available after Refresh.

  • Best for standard inputs and textareas

Text

Static text typed into the field.

Dropdown

Selects a static option by visible text/value best-effort.

Checkbox

Sets checked/unchecked using a static True/False choice.

Button

Clicks or double-clicks a selector with an optional delay.

Wait

Pauses between actions (useful for dynamic UIs and dependent fields).

Header Mapping (Refresh)

Headers are loaded only when you click Refresh to avoid unexpected remapping.

How Refresh works

  1. Set the Sheet (Excel) and Header row
  2. Open Field settings for a page
  3. Click the Refresh icon
  4. Headers load into dropdowns and XL2Web auto-selects best matches for empty mappings
You should see a toast message like “Headers loaded ✅” after refresh completes.

Header scanning rule

  • Stops after 10 consecutive blank header cells
  • Empty headers are not shown in dropdown options

Manual Fill vs Auto-fill

Manual fill (Fill this page)

  • Runs actions in order for the selected page
  • Uses your configured mappings and static values

Auto-fill on navigation

  • Fills as you navigate through the flow
  • Chooses the best matching page using URL match and selector presence
  • Typically avoids overwriting fields that already contain values

Import / Export

Export

  • Exports the current Website profile to JSON
  • Includes pages, selectors, actions (including waits), and mappings

Import

  • Imports a saved JSON configuration as a Website profile
  • After import, load your Excel/CSV file separately
  • If needed, click Refresh to load headers from the current spreadsheet

Row & Auto-increment

Row

The Row value selects which data row from your spreadsheet is used for filling.

Auto-increment

Row auto-increment runs in the background so it can still complete even if you close the popup.

  • Manual fill can increment after completing actions on the last configured page
  • Auto-fill can increment after the final page/actions complete

URL Matching (pageRef)

pageRef is a “contains” match against the current URL. Use stable fragments.

Good examples

  • /user-form
  • stage=details
  • flow=setup
  • /create-profile

Avoid

  • Session IDs
  • Random tokens
  • Time-based query parameters

Website Safety

XL2Web helps prevent filling on the wrong site.

Domain-style profile names

  • If your profile name looks like a domain (contains a dot), XL2Web limits fill to that domain and its subdomains.
  • Examples: xyz.com, qwerty.com
Best practice: name each Website profile using the website’s domain.

Troubleshooting

Header dropdown is empty

  • Open Field settings
  • Click Refresh

Fill this page does nothing

  • Confirm your file is loaded
  • Confirm Row is valid
  • Confirm fields are selected for the page
  • Confirm you’re using the correct Website profile
  • Confirm pageRef matches the current URL (for auto-fill)

Selector stopped working

  • Websites change over time—re-run Select fields / Modify fields

Dynamic fields don’t fill correctly

  • Add a Wait step
  • Use button delays
  • Split into multiple actions

Limitations

  • Some highly dynamic sites may require additional wait steps or selector updates
  • Extensions cannot force-open the Chrome popup using global OS hotkeys
  • Complex custom widgets may behave differently across websites

Best Practices

  • Name Website profiles using the site’s domain
  • Set a pageRef for each page using stable URL fragments
  • Click Refresh once after setting Sheet + Header row
  • Use Wait steps for dynamic pages
  • Export your configuration as a backup