Scanbill

Scanbill › Guides

Open a camt file and convert it for Excel

Your bank delivers statements and credit notifications as a camt file (XML). Here you open it as a readable table and save it as CSV for Excel. The file is not uploaded.

Updated November 2026

or drag it here

The file is read only in your browser. Nothing is sent or stored.

What is a camt file?

camt is the Swiss format for bank data under ISO 20022. camt.053 is the account statement with all entries; camt.054 is the credit or debit notification with the details of each payment. They are XML files and hard to read as they are.

Tick off paid invoices →

Free, no sign-up. Your data stays in your browser.

How to get the file

In your e-banking, look for a data export or file download, often called “data transfer”, “download account data” or “export”. Choose camt.053 or camt.054 in XML format. Some banks deliver a ZIP file; you can open it here directly.

Tick off paid invoices automatically

If you write your invoices with Scanbill, the same file can tick off your paid invoices automatically, partial payments included.

Tick off paid invoices →

Free, no sign-up. Your data stays in your browser.

Common questions

Is my bank file uploaded?

No. The file is read only in your browser. Scanbill has no server that receives your data.

Which files work?

camt.053 (statement) and camt.054 (credit and debit notification) as XML, also inside a ZIP file, from any Swiss bank.

How do I open the CSV in Excel?

Double-click the file. Columns are separated by semicolons, as Excel expects in Switzerland, and accented letters stay intact.

More guides

Free tools for your invoices

QR-bill, quotes, calculators and camt viewer at a glance, all free.

Hourly rate calculator for the self-employed

From the income you want to your hourly and day rate, with AHV, costs and holidays.

QR-IBAN or IBAN?

The difference simply explained, and which reference goes with which IBAN.

Test your QR-bill before you send it

Scan it with your banking app and check name, IBAN and amount, without paying anything.

Add the QR payment part to your own invoice

Keep your own invoice and just add the QR payment part at the bottom.

Free quote template for Switzerland

Create a quote with items and VAT, then turn it into a QR-bill when the customer accepts.

Swiss VAT calculator

Add or remove Swiss VAT at 8.1 %, 2.6 % or 3.8 %.

Payment reminder template with QR-bill

Payment reminder with a new QR payment slip, plus the rules on fees, late-payment interest and debt collection.

Fill in a Swiss payment slip online and print it

Fill in the QR payment slip online, blank or with an amount, and print it as PDF.

Create many payment slips at once from Excel

From an Excel list to one PDF with a slip per member, tenant or donor.

Invoicing without a subscription

When a subscription to business software pays off, and when free invoices are enough.

Tick off paid invoices automatically

Load the credit file from your e-banking and tick off paid invoices automatically.

Printing a QR-bill: is perforated paper required?

When perforation is needed, when the scissors line is enough, and how to print correctly.

QR-bills for clubs and associations

Collect membership fees with a QR payment slip, with or without an amount.

Swiss QR-bill for donations

A donation slip with no fixed amount, for letters, flyers and websites.

Swiss QR-bill for rent

For private landlords: rent and service charges by QR-bill.

Swiss QR-bill invoice template, without Word or Excel

Online instead of Word or Excel: fill in a form, download a valid PDF.