Documentation Index
Fetch the complete documentation index at: https://mintlify.com/Miguelcds/App_AsignadorZonasBilbao/llms.txt
Use this file to discover all available pages before exploring further.
Prerequisites
- A modern browser: Chrome, Edge, Firefox, or Safari
- An Excel file (
.xlsxor.xls) with a column namedCallecontaining street names
No installation, no account, and no server required. The app runs entirely in your browser.
Process your first file
Open the app
Navigate to the hosted URL in your browser. The app loads instantly — no login needed.To run it locally during development:Or simply open
index.html directly in your browser.Prepare your Excel file
Your Excel file must have at least one column called
Additional columns are allowed and will be preserved in the output.
Calle. The column header must be spelled exactly as shown (capital C, lowercase alle).Example file structure:| Calle |
|---|
| Gran Vía Don Diego López de Haro |
| Calle Iparraguirre |
| Avenida Madariaga |
Upload the file
On the 📁 Procesar Excel tab (active by default), either:
- Drag and drop your
.xlsxor.xlsfile onto the upload zone - Click the upload zone to open the file picker
Click Procesar Archivo
Press the Procesar Archivo button. The app reads the file in-browser using SheetJS, runs each street through the zone dictionary, and appends a
Zona column.Processing is instantaneous for typical files (hundreds to thousands of rows).Review the results
After processing, the page shows:
- Statistics bar — total streets, identified, not found, and coverage %
- Zone breakdown — count of streets per zone, sorted by frequency
- Unmatched streets — streets that had no zone match (click any to add it)
- Preview table — paginated view with search and filter controls
What the output looks like
Your downloaded file will have the same structure as the input, with aZona column added:
| Calle | Zona |
|---|---|
| Gran Vía Don Diego López de Haro | Bilbao Centro |
| Calle Iparraguirre | Bilbao Centro |
| Avenida Madariaga | Deusto |
| Calle Desconocida | (empty — not matched) |
Zona cell.
Handle unmatched streets
If some streets were not found, they appear in the Calles No Identificadas section below the statistics bar.- Click any unmatched street to jump to the ➕ Nueva Calle tab with the street name pre-filled
- Select the correct zone and click Guardar Calle
- The entry is saved to
localStorageand will be used in all future processing runs - Re-upload your Excel to get the updated assignments
Next steps
Add streets to the dictionary
Permanently extend coverage by adding custom street entries
Look up a single street
Check which zone any street belongs to without uploading a file
Browse the full dictionary
View, search, and filter all ~500 base entries
Deploy the app
Host the app on GitHub Pages, Netlify, or Vercel