Export balance sky accounting to excel (xls)
p collet
-
fatimaroc -
fatimaroc -
I would like to export a balance created in the Ciel accounting software to Excel in xls format so that I can then perform additional calculations like ratios in Excel. I can transfer the Ciel balance to Excel in text format, but I'm not satisfied with that since it's text that cannot be used for further processing. Do you have a solution? Thank you very much for your responses.
13 réponses
Hello,
To export a balance from Ciel to Excel:
- Use the balance export utility (txt or dbf)
- Open the exported file
- Select all the text and copy it
- Paste it into Excel
- Select column A
- Click on Data, convert, and follow the instructions and you will get it in table form.
Corine
To export a balance from Ciel to Excel:
- Use the balance export utility (txt or dbf)
- Open the exported file
- Select all the text and copy it
- Paste it into Excel
- Select column A
- Click on Data, convert, and follow the instructions and you will get it in table form.
Corine
fatimaroc
Thank you, it's very useful.
The CIEL file is not directly openable by Excel?
If it's a table
check what export filters are available in CIEL
and which files Excel can open. If you can use numerical data, your problem will be solved
otherwise, you'll need to convert your data onto a column outside the table
if in A2 you have -1255 in text format and so on in the column
in Z2 you type CNUM(A2), however, if your numbers are like df1256
you will first need to split the text to retrieve the numeric value
Z2 =CNUM(RIGHT(A2;LEN(A2)-2))
hoping that you don't have any convoluted systems with letters all over the place
Best regards
G.David
--
Respect is not a given
it is earned
If it's a table
check what export filters are available in CIEL
and which files Excel can open. If you can use numerical data, your problem will be solved
otherwise, you'll need to convert your data onto a column outside the table
if in A2 you have -1255 in text format and so on in the column
in Z2 you type CNUM(A2), however, if your numbers are like df1256
you will first need to split the text to retrieve the numeric value
Z2 =CNUM(RIGHT(A2;LEN(A2)-2))
hoping that you don't have any convoluted systems with letters all over the place
Best regards
G.David
--
Respect is not a given
it is earned
Hello to you!!!
I had the same problem as you, which is to transfer a balance from Ciel Accounting 2006 to Excel 2007, and the DBF format can indeed be opened with Excel and moreover, it can be used!!! My goal was to use certain accounts in order to perform a profitability threshold calculation.
Thank you for your help, and if I can assist you with IT, let me know, I will try to do my best to be helpful in your research.
Thanks again and maybe see you next time!!!
Ludo.
I had the same problem as you, which is to transfer a balance from Ciel Accounting 2006 to Excel 2007, and the DBF format can indeed be opened with Excel and moreover, it can be used!!! My goal was to use certain accounts in order to perform a profitability threshold calculation.
Thank you for your help, and if I can assist you with IT, let me know, I will try to do my best to be helpful in your research.
Thanks again and maybe see you next time!!!
Ludo.
Hello,
Is it possible to extract all the information from Ciel? Can we dump the data table(s)?
Thank you for your contributions
Best regards.
Is it possible to extract all the information from Ciel? Can we dump the data table(s)?
Thank you for your contributions
Best regards.
Once you have exported the sky balance to text format, you have already taken the big step. You can now process your data in Excel even though it's in text format. The procedure is simple: save the file in text format on the desktop and open the Excel workbook. In the Excel workbook's file menu, click on "Open" new file; in the dialog box that will open, choose the desktop location and click on your text file after you mention in the dialog box "All Files". And there you go, Excel will automatically convert the data stored in text format into Excel.
On the sky accounting
Proceed as follows
Go to
- list of entries
- click on the first line then right-click select all
- Office
- export to Excel
- follow the instructions
There you go, it works for me
Proceed as follows
Go to
- list of entries
- click on the first line then right-click select all
- Office
- export to Excel
- follow the instructions
There you go, it works for me
State CIEL. Excel table with usable figures! You just need to remove the thousand separator spaces.
I finally found this solution!!! How to retrieve a usable Excel table from a Ciel statement.
- I create a Ciel accounting statement, which I save as "File" "Excel (text type)".
- Then I open this Excel file. (in which all numbers above 1000 are in text format, making calculations impossible).
- I select the ranges of numbers to convert, go to "Edit / Replace". I put a space in the "find" box, and nothing in "replace". Then "replace all".
Then the numbers align in my column normally, and they are considered usable numbers in calculations and formulas!!
I finally found this solution!!! How to retrieve a usable Excel table from a Ciel statement.
- I create a Ciel accounting statement, which I save as "File" "Excel (text type)".
- Then I open this Excel file. (in which all numbers above 1000 are in text format, making calculations impossible).
- I select the ranges of numbers to convert, go to "Edit / Replace". I put a space in the "find" box, and nothing in "replace". Then "replace all".
Then the numbers align in my column normally, and they are considered usable numbers in calculations and formulas!!