📮 Converters

Brazilian Address Parser

Splits pasted Brazilian addresses into street, number, unit, neighborhood, city, state and postal code fields, with CSV and JSON export.

Addresses (one per line)

Free formatting: with or without commas, with or without the postal code mask. Up to 500 lines at a time.

Output format

Expand abbreviations (R. to Rua, apto to Apartamento) Fix capitalization

How the fields are found

The parser works from the most reliable clue to the least: it takes the postal code first, then the state (a two-letter code at the end of the line, or the state name spelled out), then the city right before it, then the unit, then the house number, and whatever is left before the number becomes the street. Each step removes the text it used, so a number inside a unit cannot be read as the house number.

Each row gets a confidence badge. High means street, number, city and state were all found; low means almost nothing was recognized, and the original text is kept in the "rest" column so no line is silently dropped. Lines where the state code appears in the middle of a name, as in "Rua PA de Souza", are flagged instead of guessed.

Splitting Brazilian addresses into database fields

Customer lists almost always arrive with the whole address crammed into one spreadsheet cell: Av. Paulista, 1578, Sala 12 - Bela Vista, São Paulo - SP, 01310-200. Printing labels, filling in an ERP form or quoting shipping all need that text broken into columns. Doing it by hand across two hundred rows burns an afternoon and swaps neighborhood for city in half of them.

The parser works from the most reliable clue down to the weakest: postal code, state, city, unit, house number and finally the street name built from what is left. Each step deletes the text it consumed, so the 45 in apto 45 cannot be read as the house number. Addresses typed without a single comma still come apart, because the city is matched by name when no punctuation separates it.

Every row gets a confidence badge: high when street, number, city and state were all found, low when almost nothing was recognized. Anything that fit no field stays in the rest column instead of disappearing quietly. Start your review with the red rows, then export the rest as semicolon separated CSV, the format Brazilian Excel opens without an import wizard.

Frequently asked questions

What happens to addresses with no house number?

The Portuguese forms s/n, sn, s.n. and sem número are recognized and stored as S/N, which keeps the column filled during import. Highways described by kilometer marker become km 25, with the value in the same field rather than an empty number.

Does it query the official post office database?

No. Everything runs in your browser with no external request, so your list never leaves your computer. The postal code is only located in the text and normalized to the 00000-000 mask; the tool does not confirm that the code exists or that it matches the city given.

Why are some rows flagged with an ambiguous state code?

Brazilian state codes are two letters and show up inside proper names, as in Rua PA de Souza. A code is accepted only when it is the last one on the line and sits next to the postal code or the end of the text. Otherwise the field stays empty and the row is flagged instead of guessed.

Related Tools

🔤

Excel Formula Translator (PT ↔ EN)

Translates Excel formulas between English and Portuguese function names, error values and argument separators, leaving strings and refs intact.

📄

CSV to JSON

Convert CSV to JSON. The first row becomes object keys, the rest become array items. Supports separators , ; and \t. Auto-detects numbers and booleans. Everything in your browser.

🔀

CSV Diff by Key Column

Compares two CSV files by a key column and lists added, removed and changed rows, pointing out exactly which columns differ.