Bank Statement CSV to Excel Without Type Errors

A bank CSV is already structured data; the remaining job is to import it without changing its meaning. Keep the original file untouched and create a separate XLSX workbook for formulas, notes, and review. Renaming a CSV to .xlsx is not conversion.

Microsoft explains that opening CSV directly uses Excel's current default data settings. A controlled text import gives you more control over dates and leading-zero fields.[7] The following workflow is intended for desktop Excel versions that expose From Text/CSV and Power Query; available commands can differ by platform.

Import the CSV with explicit types

Open a blank workbook. Choose Data → From Text/CSV and select the bank file.[7]
Inspect the preview before loading. Choose the separator actually used in the file: comma, semicolon, or tab. Check a description containing punctuation and an amount containing a decimal separator.
Choose Transform Data when available so you can inspect the column types before loading.
Set account numbers, check numbers, transaction IDs, and references to Text. Keep descriptions as text too.
Set the transaction date to Date, using the source locale. For monetary columns, choose an appropriate numeric type after checking decimal punctuation.
Load the reviewed table into a worksheet and save the workbook as Excel Workbook (.xlsx).

Power Query detects types automatically for unstructured files. Its Change Type → Using Locale command lets you interpret a column using the source region rather than the computer's default.[8] If an earlier automatic Changed Type step already altered an identifier or misread a date, remove that step and set the intended type from the original values.

Worked example: illustrative UK bank export

Assume the bank confirms day/month/year dates and supplies these rows:

Date,Description,Amount,Reference
03/09/2026,Card payment,-42.50,000731
14/09/2026,Client payment,900.00,000732

Use English (United Kingdom) when parsing the Date column. The first row is September 3, not March 9. Preserve 000731 as text. Display dates as yyyy-mm-dd after parsing so the reviewed worksheet is easy to read; changing the display format alone cannot repair a date parsed incorrectly.

The illustrative signed movement is 857.50. Enter an opening balance of 1,000.00 in a separate control cell and compare the calculated closing balance, 1,857.50, with the PDF statement. For this two-row example, with amounts in C2:C3, use =ROUND(1000+SUM(C2:C3),2).

If the bank exports separate positive Credit and Debit columns, create a signed working column with Credit minus Debit. Verify one known deposit and one withdrawal first; do not apply this formula to columns whose debit values are already negative.

Build a reviewable workbook

Keep a Source sheet for imported rows and a Review sheet for categories, exceptions, and totals. Add source filenames and account identifiers as text when combining files. Avoid appending another month until its column names, currency, and sign convention match the first.

Check that amount cells are numeric, dates fall in the expected period, and descriptions have not shifted into neighboring columns. Inspect transactions at page or month boundaries. Review potential duplicates using several fields instead of deleting repeated amounts automatically.

Save the right deliverable

Keep XLSX as the analysis master. Microsoft notes that CSV export saves only the active worksheet and can omit workbook features.[7] If accounting software needs CSV, export a dedicated transaction sheet, then reopen that file and verify its headers, delimiter, dates, and signs.

Already have a valid CSV? No PDF converter is required. If your source is still a PDF, use the free CSV methods guide or open the converter to review its CSV and Excel options. For a shared online workbook, follow the Google Sheets import guide.

Official sources

[7] Microsoft: Import or export text and CSV files.
[8] Microsoft Learn: Data types in Power Query.