Click
here
for our latest updates. Click
here
for our FAQ.
Personal
Products
Services
Branches
Search
Contact us
Become a member
Login
Allia
Business
Products
Services
Branches
Contact us
Search
Become a member
Login
Allia
Caisse
Who we are
Social Involvement
Branches
Contact us
Become a member
Search
Login
Allia
Français
Caisse Alliance
Online services
Allia
Login
Payment Stream
Login
Credit Card - Personal
Collabria
Login
Credit Card - Business
Login
Caisse Alliance
Search
Login
Online services
Allia
Login
Payment Stream
Login
Credit Card - Personal
Collabria
Login
Credit Card - Business
Login
Online services
Allia
Login
Payment Stream
Login
Credit Card - Personal
Login
Credit Card - Business
Login
Personal
Products
Services
Branches
Search
Contact us
Become a member
Login
Allia
Business
Products
Services
Branches
Contact us
Search
Become a member
Login
Allia
Caisse
Who we are
Social Involvement
Branches
Contact us
Become a member
Search
Login
Allia
Personal
Products
Services
Branches
Search
Contact us
Become a member
Login
Allia
Business
Products
Services
Branches
Contact us
Search
Become a member
Login
Allia
Caisse
Who we are
Social Involvement
Branches
Contact us
Become a member
Search
Login
Allia
Blog
Career
Interest Rates
FAQ
Students
Communications
Solutions
Market Conduct Code
Deposit Insurance
888 404-2246
Book an appointment
Interest Rates
Français
Fermer
Search
Microsoft Excel – detailed procedure
Personal
Account
Fraud / Security
Mobile Services
Bill payment
ATM
Cheques
Retirement and succession
Other Subjects
Debit Card
Business
Merchant solutions
Online Electronic Slips and Templates
Account
Collabria Credit Card
Debit Card
Allia
About Allia
Signing in to Allia
Doing your online banking with Allia
Debit card
ATM
Businesses
Other ways to access my finances
Information sources
Identification tablet
Caisse
How Cooperatives Work
Privilège COOP
Privilège COOP Gift Card
Financing for your local shopping
Microsoft Excel – Procédure détaillée
Microsoft Excel 2003, detailed procedure:
Open CSV file containing your statement.
Type *.* for file name and click ‘Enter’ to display all files.
Click on ‘Import’ to activate the Import Wizard.
The data type must be set at ‘Delimited’.
Click on ‘Next’.
The field delimiter must be the comma.
The text qualifier must be the quotation marks.
Click on ‘Finish’.
It is not necessary to change the format of the columns.
Click on ‘Next’.
Select all the data (from Columns A to N) and click on ‘Copy’.
Open the template.
Place your cursor just after the last line in Column A.
Click on ‘Paste’.
Save the template.
Microsoft Excel 2007, detailed procedure:
Open CSV file containing your statement.
Click on the ‘Data’ tab in the menu.
Click on ‘Get External Data’, then on ‘From Text’. Select the CSV statement, then click on ‘Import’.
Once the Text Import Wizard window opens, select ‘Delimited’ as the original data type.
Click on ‘Next’.
The delimiter must be a comma.
The text qualifier must be a quotation mark.
Click on ‘Finish’, then click on ‘OK’.
Back
Skip to content
Open toolbar
Accessibility Tools
Accessibility Tools
Grayscale
Grayscale
High Contrast
High Contrast
Negative Contrast
Negative Contrast
Light Background
Light Background
Reset
Reset
Help
Help