Skip to main content

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 (.xlsx or .xls) with a column named Calle containing street names
No installation, no account, and no server required. The app runs entirely in your browser.

Process your first file

1

Open the app

Navigate to the hosted URL in your browser. The app loads instantly — no login needed.To run it locally during development:
npx serve .
Or simply open index.html directly in your browser.
2

Prepare your Excel file

Your Excel file must have at least one column called 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
Additional columns are allowed and will be preserved in the output.
3

Upload the file

On the 📁 Procesar Excel tab (active by default), either:
  • Drag and drop your .xlsx or .xls file onto the upload zone
  • Click the upload zone to open the file picker
Once a file is selected, the Procesar Archivo button activates.
4

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).
5

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
6

Download the result

Click Descargar Resultado to download Calles_Asignadas.xlsx — your original file with the Zona column appended.The download works offline; no data is ever sent to a server.

What the output looks like

Your downloaded file will have the same structure as the input, with a Zona column added:
CalleZona
Gran Vía Don Diego López de HaroBilbao Centro
Calle IparraguirreBilbao Centro
Avenida MadariagaDeusto
Calle Desconocida(empty — not matched)
Rows where no zone was found have an empty 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 localStorage and will be used in all future processing runs
  • Re-upload your Excel to get the updated assignments
Use Exportar .txt in the unmatched section to save all unidentified streets as a plain-text file — useful for batch review or sharing with a team.

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

Build docs developers (and LLMs) love