Bank Details Format in Excel: Fields, Setup and Safety

How-to basics · Updated November 21, 2026

A practical bank details format in Excel is a table with one row per person or business and separate columns for the account holder, bank, account identifier, country-specific routing code, currency, and verification status. There is no single format that works for every country or payment type; format account and routing identifiers as text so Excel does not remove leading zeros or alter long numbers.

What a bank-details spreadsheet is for

A bank-details spreadsheet is usually a working register for recording or checking payment information, not a universal banking form. It might support an accounts-payable team, a payroll process, or a list of suppliers who have asked to be paid by bank transfer. The fields needed depend on the country, the type of transfer, and the rules of the organisation receiving the details.

It helps to decide what the file is meant to do before creating columns. A register used to track whether a supplier has submitted payment details needs less information than a payment file prepared for a bank. Some banks and payroll systems require data in a specific upload template; an ordinary Excel table may not meet those requirements. Use the receiving institution’s current template and instructions whenever a file will be uploaded to a payment system.

Keep the spreadsheet limited to its purpose. A general contact list does not need full account details, and a payment register may not need personal information unrelated to the payment. The less sensitive data the workbook contains, the less there is to expose if it is misplaced or shared incorrectly.

Recommended columns for a basic template

For a simple register, create a clear header row and use one row for each account record. A useful starting set of columns is:

  • Record ID: An internal reference that helps identify a row without relying on the account number.
  • Account holder name: The name supplied by the account holder, entered as text.
  • Bank name: The institution’s name, if needed for your process.
  • Country or region: Useful for choosing the correct routing fields and payment method.
  • Account number or local account identifier: Enter as text, not as a numeric value.
  • Routing or clearing code: Use a clearly named column for the relevant country’s code, such as a sort code, routing number, or IFSC code.
  • IBAN: Include this column when the account uses an International Bank Account Number; it is not applicable to every account.
  • SWIFT/BIC: Include this when required for an international transfer, rather than assuming it is needed for every domestic payment.
  • Currency: Record the currency when the payment process needs it.
  • Verification status and date: Track whether details were checked and when, without putting authentication secrets in the workbook.

Do not treat every suggested column as mandatory. For example, an account may use a local account number and a separate clearing code instead of an IBAN. A country’s payment system may require fields that another country does not use. Clear labels such as UK sort code or US routing number are less ambiguous than a generic heading like Bank code.

Country-specific fields and terminology

Bank-transfer identifiers are not interchangeable. In the United States, a domestic transfer may use an account number and a routing number, while international transfers can require other information. In the United Kingdom, a domestic account is commonly identified using an account number and sort code. In India, an IFSC code is used for many electronic transfers. IBANs are used in many countries, but not all. SWIFT/BIC identifies a financial institution for relevant international transactions; it does not replace every country’s account-level information.

These examples describe common terminology, not a complete set of payment instructions. Requirements can differ by transfer type, bank, and destination. Ask the bank or payment recipient which fields to use, and label them accurately. Do not rename an unfamiliar identifier to make it appear equivalent to a field used in another country.

When the workbook covers multiple countries, include a country field and keep country-specific codes in distinct, named columns. A single column called Account number is not a good place to mix IBANs, domestic account numbers, and routing codes. If a payment provider supplies an official template, do not add, remove, or reorder columns unless its instructions allow it.

Set up Excel to preserve account identifiers

Excel may interpret an identifier entered as a number as a quantity. That can remove leading zeros, display the value in scientific notation, or change digits in very long numeric strings. An account identifier is a label, not a number to calculate with, so store it as text.

  1. Enter the column headings, then select the cells or whole columns intended for account numbers, routing codes, IBANs, and other identifiers.
  2. In Excel for Microsoft 365 on Windows, choose Home > Number Format and select Text.
  3. Enter or paste the identifiers after setting the cells to Text. For a one-off entry, beginning the value with an apostrophe also tells Excel to treat it as text; the apostrophe is not displayed in the cell.
  4. Check several entries against the original source, especially values that begin with zero or contain many digits.

Changing a cell to Text after Excel has already altered a number does not restore missing zeros or digits. Correct the value using the original verified source. Avoid relying on a custom number format to preserve identifiers: it can change how a value looks, but it does not turn a numeric value into a reliable text identifier.

To set the format for a selected cell on Windows, Ctrl+1 opens Format Cells; on Mac, use Command+1. In the Format Cells dialog, choose the Text category. For new entries, setting the format before pasting is the important part. If you import a CSV, review the import preview and ensure identifier columns are treated as text; do not assume a CSV will preserve Excel’s cell formats when another person opens it.

Enter, check, and maintain records

Use a single header row, avoid blank rows inside the data, and keep one record per row. Select the data and choose Home > Format as Table to make filtering and sorting easier. Give the table a descriptive name if the workbook has several tables. A table makes the register easier to manage, but it does not validate that the bank details are correct.

For a controlled status field, use a short, consistent list such as Pending, Verified, and Needs review. In Microsoft 365 for Windows, select the status cells and choose Data > Data Validation; use the List option to provide permitted status values. This reduces accidental variations such as verified, Verified, and Complete being used for the same state. On Mac, the Data Validation control is also on the Data tab, though its position can differ with the ribbon layout.

Record what verification means in your process. A status should not imply that Excel checked an account with a bank: a spreadsheet cannot confirm that an account exists, belongs to the named person, or is currently open. Verification must follow an appropriate independent process, such as checking details through a trusted channel. If bank details change, confirm the change through a known contact method rather than relying only on a new email or a note in the workbook.

Common Excel problems and misconceptions

  • Leading zeros disappear: This usually happens when Excel interprets the entry as a number. Set the cells to Text before entering or importing the data, then compare affected values with the source.
  • A long number changes: Excel’s numeric precision is limited to 15 significant digits. Store long identifiers as text; formatting a number as Text afterward cannot recover digits Excel has already changed.
  • Scientific notation appears: The cell may contain a numeric value that is too long for the current display. Widening the column can change the display, but it does not solve the underlying issue if Excel stored the identifier as a number.
  • Spaces appear in an IBAN: IBANs are often displayed in groups for readability. Do not remove or add spaces unless the bank or payment system’s instructions specify the required input format. Keep a consistent convention and verify it before submitting.
  • Duplicate warnings cause confusion: Two records can legitimately use the same account, for example when they belong to the same account holder. A duplicate highlight is a review prompt, not proof of an error.

Be cautious with formulas or automatic cleanup on identifiers. Removing spaces, converting text to numbers, or changing letter case may not be appropriate for every field or recipient system. Preserve the original details as supplied and follow the receiving bank’s instructions if a different display or upload format is required.

Protect sensitive banking information

Bank details are sensitive personal or business information. Store the workbook only in an approved location, restrict access to people who need it, and use the organisation’s approved sharing and retention practices. A password on a workbook can add a barrier, but it should not be treated as a substitute for access control or secure storage. Avoid sending an unprotected file through a channel that is not approved for sensitive information.

Never store online banking passwords, PINs, one-time passcodes, security-question answers, card security codes, or full login credentials in a bank-details spreadsheet. Those are authentication secrets, not payment-routing details. Be careful with backups, email attachments, printouts, and temporary copies: deleting a visible worksheet or hiding a column does not make information securely unavailable to someone with access to the file.

Use separate files or restricted worksheets only when that fits your organisation’s security process; hidden sheets are not a dependable privacy control. If a workbook must be shared with someone who only needs status information, make a separate copy containing only the necessary fields rather than relying on hidden columns. Check the recipient and attachment before sending, and remove obsolete copies according to the applicable retention policy.

When an Excel template is not the right choice

Excel is useful for a small, controlled register or for preparing data in a format an organisation has explicitly requested. It is not automatically a secure payment system, a bank verification service, or a guarantee that a transfer file meets payment-network rules. A spreadsheet can be copied, edited, or sorted incorrectly, and it can become difficult to control as the number of users and records grows.

For recurring payroll or supplier payments, consider whether an approved accounting, payroll, or payment platform offers access controls, audit history, and a validated import process. If the bank requires a specific upload file, use its official template and validation guidance. For an individual who only needs to give another person details for a transfer, use the bank’s approved method of sharing those details rather than creating a broad spreadsheet with extra information.

Frequently Asked Questions

What is the standard bank details format in Excel?
There is no single worldwide standard. A basic register can include account holder, bank, country, account identifier, applicable routing code, currency, and verification status. Use the specific bank or payment provider’s template for uploads.

Should I format an account number as text or a number?
Format it as Text. Account numbers and routing codes identify an account or institution; they are not values for arithmetic. Text formatting also helps preserve leading zeros and long digit strings.

Can Excel remove zeros from a bank account number?
Yes, if it interprets the entry as a number. Set the destination cells to Text before entering or pasting the details. If zeros have already disappeared, check the original source and correct the value rather than guessing.

Can I use one Excel template for every country?
A general register can track accounts from different countries if it has clearly labelled, separate fields. It cannot replace country-specific payment instructions. Confirm the required codes and file layout for each transfer type with the relevant bank or payment provider.

Is it safe to email an Excel file with bank details?
Not by default. Follow your organisation’s approved method for sharing sensitive data, limit access to necessary recipients, and avoid including unneeded fields. A workbook password alone does not make an unsuitable sharing channel safe.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.