View original (French)

Export balance sky accounting to excel (xls)

p collet -  
 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 answers

  1. 5385corine
     
    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
    5
    1. fatimaroc
       
      Thank you, it's very useful.
      0
  2. SORO léonce
     
    The balance extracts are in crf format. What should I do?
    1
  3. kaya
     
    Hello,

    to export the CIEL Compta balance, there is a solution, there may be others!
    Valid up to version 11
    Top menu bar
    Utilities
    Export
    Export balance
    Select DBF
    Be sure to note the path

    Open this DBF file with Excel

    Does it work?
    1
    1. sa10el
       
      Thank you, it's the best solution.
      0
      1. Compta2002 > sa10el
         
        It works easily
        thank you so much
        0
    2. CP
       
      It works, thank you very much.
      0
  4. Inco
     
    Hello

    and how to do for a big book?

    thank you
    1
  6. G.David Posted messages 790 Status Member 203
     
    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
    0
  7. G.David Posted messages 790 Status Member 203
     
    Look to see if you can save them as CSV; this type of file is a standard. Excel has no problem opening them.
    Best regards
    G. David
    --
    Respect is not owed; it is earned.
    0
    1. léonce soro
       
      Actually, Ciel is a software that produces balance sheets (in accounting). After editing, the extraction of the statement is in a strange format: with the extension: crf. Which interpreter can I use to read my extract???????????
      0
  8. Ludo du 28
     
    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.
    0
  9. elecrtbol
     
    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.
    0
  10. benchmarek
     
    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.
    0
  11. vooschr
     
    it is necessary to export in dbase III format or higher.
    this format can be opened with excel.
    0
  12. jouayria1 Posted messages 37 Status Member 7
     
    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
    0
  13. Ln gestion
     
    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!!
    0
  14. Daranc
     
    Have you tried this thing where you put the number one in a distant cell (outside your range of numbers), copy that cell, select all your range, and then --> special paste
    check multiply?
    0