I want excel template for import

Discussions about iCompta on macOS
Post Reply
palmjae
Posts: 3
Joined: 07 August 2023, 17:20

I want excel template for import

Post by palmjae »

I want excel template to import. I want to put "Name" , "Status" , "Date" , "Amount"
Can you send me a template to my email tawan33.tni@gmail.com ?

Thanks!
User avatar
Angeman
Administrateur
Posts: 2303
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: I want excel template for import

Post by Angeman »

You can't import an Excel file directly, first you need to open it with Excel and save as "CSV". You can then import the CSV file in iCompta.
palmjae
Posts: 3
Joined: 07 August 2023, 17:20

Re: I want excel template for import

Post by palmjae »

yes. I mean CSV file. Can you send the template to me?
User avatar
Angeman
Administrateur
Posts: 2303
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: I want excel template for import

Post by Angeman »

There is no template needed, iCompta will ask you to map the columns from your CSV file to the fields in iCompta when you import.
palmjae
Posts: 3
Joined: 07 August 2023, 17:20

Re: I want excel template for import

Post by palmjae »

It shows like this. what should I do? I want to separate it.
Attachments
Screen Shot 2566-08-08 at 14.03.13.png
Screen Shot 2566-08-08 at 14.03.13.png (312.24 KiB) Viewed 9835 times
Screen Shot 2566-08-08 at 14.03.04.png
Screen Shot 2566-08-08 at 14.03.04.png (48 KiB) Viewed 9835 times
User avatar
Angeman
Administrateur
Posts: 2303
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: I want excel template for import

Post by Angeman »

You need to change the "CSV separator" field to "Comma" in the import settings.
Post Reply