Open a bank statement CSV in Excel without changing its data

Choose import settings before trusting the display

A CSV contains text records, not Excel cell types. Microsoft notes that opening a CSV directly makes Excel interpret columns using its current defaults. An import preview gives you a chance to inspect the separator and how each column will be treated.

The desktop route is usually Data, then From Text/CSV. Labels and available controls vary by Excel version and platform. If the preview contains one long column or visibly shifted values, stop there and resolve the delimiter before loading the worksheet.

Decide the job of each column

Classify columns by meaning rather than by whether they contain digits. A reference such as 000426 is an identifier; it should not become 426 just because all its characters are numeric. An amount such as -84.50 needs a numeric interpretation if you plan to calculate a total.

In a fictional import, keep Reference 000426 as text, Description Sample office supplies as text, and Amount -84.50 as a number. Inspect Date separately using a known source date. Seeing a plausible date on screen is not enough to confirm that its month and day were interpreted correctly.

• Identifiers: preserve leading zeros and all characters.
• Amounts: confirm the decimal separator and negative sign.
• Dates: compare at least one unambiguous date with the source.
• Descriptions: ensure punctuation has not split a single field into extra columns.

Compare records, not just the visible row number

Count transaction records after excluding the header and any bank-provided summary rows. A visible sheet row number is not a reliable transaction count when a file includes a title block, blank rows or totals. Do not turn the closing-balance summary into a transaction.

Compare first and last dates, money-in and money-out totals, and a handful of distinctive references with the original CSV. If a total differs, first check whether an amount column contains text, whether a filtered view hides rows, or whether the delimiter shifted a value. Keep any corrections traceable to the source.

Save the working file as XLSX

An XLSX workbook can hold your review notes, formulas and additional sheets. Saving that working copy does not improve the underlying source data by itself. Verify the imported values before using those workbook features.

Keep a clear distinction between the untouched download and the reviewed workbook. If you later need an accounting-system CSV, create a separate mapped export and inspect that file too. A workbook that looks right in Excel may still use column names or date representations the destination does not accept.

Use PDF extraction only when you need it

Opening an existing CSV and extracting a PDF are different tasks. A native bank CSV may already give you the rows you need. If only a PDF is available, the linked PDF-to-Excel guide covers extraction and source review.

The public Fulla sample includes both CSV and XLSX files created from the same fictional reference rows. Compare them to practice checking values across formats without uploading a real statement.