Men & Mice bulk DNS import builder
Build CSV / TSV files for the Micetro web UI bulk DNS import tool (Tools → Import DNS Records). Add, modify, and remove records of any type in one paste. Auto-detects which columns to include in the header, validates per record type, and shows the exact text ready to paste. Tested against Micetro 25.1 syntax — older versions (10.x / 11.x) use the same format.
⚠ Disclaimer
This tool is provided as-is, for educational and planning purposes only. Imports should only be run on zones you are authorised to manage. Test against a non-production view or zone first — bulk DNS changes can break name resolution organisation-wide and are hard to undo at scale. Always have an export of the current zone as your rollback. The Tech Space makes no warranty and accepts no liability. Full disclaimer →
Quick start templates
Records
Hostname vs FQDN — depends on where you import
Micetro treats the
name field differently depending on the context you're importing from:
- Importing inside a specific zone (DNS → zone-name → Tools → Import DNS Records): use hostname only, e.g.
wwwormail. Micetro appends the zone suffix automatically. Entering an FQDN likewww.example.com.here createswww.example.com.example.com.— the classic double-suffix bug. - Importing from the whole DNS section (DNS → Tools → Import DNS Records at the top, no zone selected): use the full FQDN with trailing dot, e.g.
www.example.com.Micetro routes each row to the matching zone by name.
Generated CSV Updated just now
CSV — paste into Micetro web UI
How to import into Micetro
- In the Micetro web UI, navigate to DNS → either pick the target zone (use hostname-only in
name) or stay at the top level to import across zones (use full FQDN with trailing dot inname). - Open Tools → Import DNS Records.
- Either paste the generated CSV into the text area, or download it as
.csv/.tsvand upload. - Choose the matching delimiter, click Import.
- Micetro shows a preview / dry-run with errors per row. Fix any flagged rows, then commit the import.
Before you import
Export the current zone as a backup. Micetro's import is transactional per row, not per file — partial imports are possible if a few rows error. Always test in a non-production view if you have one.
Micetro CSV reference
Header fields
actionAdd (default), Modify, Remove. Aliases: Insert/Create, Update/Change, Delete/Del. Case-insensitive.namerequired. Format depends on import context — hostname only (e.g.www) when importing inside a specific zone, FQDN with trailing dot (e.g.www.example.com.) when importing from the DNS root.typerequired. A, AAAA, CNAME, MX, TXT, PTR, NS, SRV, CAA, SOA, NAPTR, …datarequired. IP, target, or rdata. Type-dependent.newdataModify only. Replacement value.ttlSeconds (default), or with units: H, D, W, M, Y. E.g.3600,1H,2D.zoneZone name. Optional when importing within a single zone.viewDNS view name (multi-view / split-horizon setups).authorityAuthority name (multi-primary setups).forestAD forest name (multi-forest setups).commentOptional save comment, shown in change history.
Data format by record type
A192.0.2.1— IPv4 addressAAAA2001:db8::1— IPv6 addressCNAMEtarget.example.com.— FQDN with trailing dotMX10 mail.example.com.— priority + targetTXT"v=spf1 -all"— quoted string (use""for embedded quotes)PTRhost.example.com.— FQDN with trailing dotNSns1.example.com.— nameserver FQDNSRV10 60 5060 sip.example.com.— priority weight port targetCAA0 issue "letsencrypt.org"— flag tag valueNAPTR100 50 "s" "SIP+D2T" "" _sip._tcp.example.com.— order pref flags service regexp replacement
Worked examples (verbatim from Micetro docs)
name,type,dataviola.illyria.coast.,A,16.0.2.2— simplest addname,type,data,viewviola.illyria.,A,16.0.2.2,first-folio— add in a specific viewaction,name,type,data,newdatamodify,viola.illyria.coast.,A,16.0.2.2,20.21.9.6— change IPaction,name,type,dataremove,malvolio.olivia.palace.,A,16.0.2.2— delete
Gotchas
- Trailing dots matter.
www.example.com(no dot) becomeswww.example.com.zone-suffix— usually wrong. Always use the absolute FQDN with trailing dot when in doubt. - Modify needs both
dataandnewdata. Thedatafield identifies the existing record;newdatareplaces it. If only one matches, Micetro will error or no-op. - TXT values must be quoted. SPF strings like
v=spf1 -allneed double quotes"v=spf1 -all". Embedded quotes are doubled:"a ""b"" c". - MX / SRV data is space-separated multi-field, not multiple CSV cells. The whole thing goes in
data:10 mail.example.com. - The CSV delimiter cannot appear inside fields unquoted. If you have commas inside data (rare but possible in TXT), use TSV mode or quote the field.
- The
actioncolumn can be omitted if every row is an Add. Including it explicitly per row is safer for mixed batches.
Source: Micetro 25.1 — Importing DNS Records. Same format applies to 10.x / 11.x with minor field differences.