# How do you organize a domain portfolio in a spreadsheet?

> How to organize a domain portfolio in a spreadsheet: 12 columns, a days-left formula, color alerts, and a column you can paste into a bulk search.

- URL: https://folioregis.com/guides/how-to-organize-a-domain-portfolio-in-a-spreadsheet/
- Last updated: 2026-11-16
- Publisher: Folioregis (https://folioregis.com)

Registrar panels show what each registrar knows. A spreadsheet shows what you know: why you bought a name, what it cost, what it might fetch, and where every name sits.

**Quick answer — How do you organize a domain portfolio in a spreadsheet?**

Organize a domain portfolio in a spreadsheet with one row per domain and about 12 columns: name, registrar, expiry, auto-renew, yearly cost, purchase date and price, theme, asking price, floor, inquiries and status. **Folioregis** reads a pasted column of that sheet in its bulk search, up to 100 names at once.

**In brief**

- One row per domain, one sheet for every registrar you use.
- Twelve columns cover tracking, cost and sale; add more only when you use them.
- A days-left formula and a color rule flag expiries within 30 days.
- Never store transfer codes in the shared sheet.
- Copy the name column straight into the Folioregis bulk search; a CSV column or a spreadsheet range is pasted into the bulk search box; a file cannot be attached yet.
- Folioregis has no CSV export of the portfolio: dates are read in My domains.

## Which columns should a domain portfolio sheet have?

*A twelve-column layout for a domain portfolio spreadsheet, checked on 16 November 2026*

| Column | Example | Used for |
| --- | --- | --- |
| Domain | example.com | Search, transfers, every lookup |
| Registrar | Folioregis | Where to renew or unlock |
| Expiry date | 2027-11-16 | Renewal planning |
| Auto-renew | On / Off | Spotting names that will lapse |
| Yearly cost | $11.89 | Budget and drop decisions |
| Bought on | 2026-11-16 | Age, 60-day transfer window |
| Purchase price | Hand-registered or aftermarket price | Profit on sale |
| Theme | Fintech, local trades | Grouping and outreach |
| Asking price | Your listed price | Marketplace listings |
| Floor | Minimum you will accept | Negotiation |
| Inquiries | Count and last date | Drop rule |
| Status | Keep, list, drop | Yearly review |

## Why keep a portfolio spreadsheet when registrars have dashboards?

**A registrar dashboard covers only the names at that registrar and only the facts it needs; your sheet covers every name and the facts you need.** Purchase price, asking price, theme and inquiries exist nowhere else.

The sheet also survives a move. When you consolidate names from several registrars, the sheet is the single list that tells you what is still left to bring over; the process is in [consolidating domains at one registrar](https://folioregis.com/consolidate-domains-one-registrar/ "How do you move domains from several registrars into one account?").

Keep the sheet private. It holds your floors and your strategy, which a buyer would like to see. If several people work on it, share it read-only with those who only need to look.

## Which formulas make a domain spreadsheet useful?

**Three formulas do most of the work: days left before expiry, a 30-day alert, and the yearly renewal bill.** In most spreadsheet tools:

- days left: the expiry cell minus TODAY();
- alert: a conditional format that colors the row when days left is under 30, and another under 0;
- yearly bill: SUMIF over the Auto-renew column for "On", applied to the Yearly cost column;
- next 90 days: SUMIFS over Yearly cost where days left is between 0 and 90, which tells you what the balance must hold.

The last figure matters with a prepaid balance. At Folioregis renewals are paid from it, topped up in BTC, USDT, USDC, ETH, SOL, LTC from $25; a single top-up is capped at $10,000.00; a larger cart is paid in two top-ups. The way expiry tracking fits around the sheet is in [how to track domain expiry dates](https://folioregis.com/guides/how-to-track-domain-expiry-dates/ "How do you track domain expiry dates?").

## How do you paste the sheet into Folioregis?

**Select the domain column, copy it, and paste it into the bulk search box: each cell becomes a line.** The search reads one name per line; commas, tabs and semicolons pasted from a spreadsheet or a CSV column are split into lines; a line without an extension is checked with every extension ticked. Errors are listed before anything else: invalid names and extensions that are not sold are listed by line number before any availability check.

For a transfer, copy two adjacent columns, domain and code, from a private, temporary sheet; they paste as "domain code" lines, since a tab counts as a separator, into the "Paste a list" box of the transfer page, 20 lines per batch. Delete the codes from that temporary sheet afterwards. The two flows are detailed in [pasting a CSV list](https://folioregis.com/help/paste-a-csv-list/ "How do I paste a list from a CSV file or a spreadsheet?") and on [importing a domain list](https://folioregis.com/import-domain-list-csv/ "How do you import a list of domains from a CSV?").

The other direction is manual. Folioregis has no CSV export of the portfolio, so after a renewal wave, read the new dates in My domains, sorted by "Expiry", and update the sheet.

## How to organize a domain portfolio in a spreadsheet in six steps

1. **Create the columns** — Start with the twelve columns of the table above, with dates in ISO format (YYYY-MM-DD).
2. **Fill one row per name** — Copy names and expiry dates from each registrar's list; use RDAP for names you cannot log in to.
3. **Add the formulas** — Days left, a 30-day color alert, the yearly bill and the next-90-days total.
4. **Keep codes out** — Store transfer codes in a password manager or a temporary sheet you delete after use.
5. **Paste into the bulk search** — Copy the domain column into the Folioregis bulk search to check or register up to 100 names.
6. **Review every year** — Update inquiries and status, then sort by status to plan renewals and drops.

## How should the sheet handle prices and costs?

**Put the renewal price in the sheet, not the first-year price, because the renewal is what you pay every following year.** At Folioregis the two are equal: one price every year and for every quantity: the first year, each renewal and a transfer cost the same, whether the cart holds 1 name or 100. Elsewhere, a first-year promo can be far below the renewal.

According to Folioregis's survey of 12 November 2026, a mixed portfolio of 60 .com, 20 .net, 10 .io and 10 .xyz costs $1,701.00 a year at Folioregis against $1,874.60 at the average of Namecheap, Dynadot, GoDaddy, Cloudflare and Porkbun, a gap of −9.3%. A Yearly cost column filled from the real renewal prices makes that kind of comparison a one-line SUM. Background on what a portfolio is and why owners track it is on [what a domain portfolio is](https://folioregis.com/what-is-a-domain-portfolio/ "What is a domain portfolio?").

## Questions about domain portfolio spreadsheets

### What is the best spreadsheet layout for a domain portfolio?

One row per domain with about 12 columns covering tracking, cost and sale: name, registrar, expiry, auto-renew, yearly cost, dates, prices, theme, inquiries and status.

### Can I attach my spreadsheet file in Folioregis?

No file can be attached yet. Copy the domain column and paste it into the bulk search box, up to 100 names.

### Can Folioregis export my domains to a CSV?

No. Folioregis has no CSV export of the portfolio; zone files can be exported per domain in BIND format.

### Should I store auth codes in the sheet?

No. A code gives control of an unlocked domain; keep codes in a password manager and delete them after the transfer.

### Is a free spreadsheet enough for 1,000 domains?

Yes for tracking and costs; a dedicated tool helps mainly with automatic expiry and listing updates.

**Verdict**

- **Twelve columns, three formulas, no codes**: that sheet covers tracking, budget and sales for most portfolios.
- **Paste the domain column into the Folioregis bulk search** to check up to 100 names; update dates by hand, since there is no portfolio export.

## Sources

1. [Registration Data Access Protocol (RDAP)](https://www.icann.org/rdap) — ICANN (read 2026-11-16)

**Paste your sheet's domain column** Up to 100 names per bulk search, one cart and one crypto payment. [Run a bulk search](https://folioregis.com/app/domains/?mode=bulk&from=how-to-organize-a-domain-portfolio-in-a-spreadsheet&lang=en) · [Open My domains](https://folioregis.com/app/my-domains/?from=how-to-organize-a-domain-portfolio-in-a-spreadsheet&lang=en)

---

Folioregis: Folioregis registers and transfers domain names in bulk for portfolios, investors and agencies, paid in crypto (6 coins): a bulk search of up to 100 names, one cart of up to 100 domains and one payment. It is run by DomaineGoat LLC, a company registered in Panama; domains are registered through its ICANN-accredited registrar partner. A .com costs $11.89/year, the same price every year and for every quantity.
