Home>

For further work with the file, it would be more convenient for me if it were in .csv format and not in .numbers. Is there a way to convert a .numbers file to csv without losing or changing the data?

@insolor Apple Excel

Эникейщик2022-01-14 12:43:45

Depends on what kind of format such .numbers is

insolor2022-01-14 12:34:01
  • Answer # 1

    It looks like you can use the libraries numbers-parserandpandas. There's even an example here:

    # python3 -m pip install
    numbers-parser
    from numbers_parser import Document
    import pandas as pd
    doc= Document("simple.numbers")
    sheets= doc.sheets()
    tables= sheets[0].tables()
    data= tables[0].rows(values_only=True)
    df= pd.DataFrame(data, columns=["A", "B", "C"])
    

    And then export tocsv:

    df.to_csv('filename.csv')
    
  • Answer # 2

    It looks like you can use the libraries numbers-parserandpandas. There's even an example here:

    # python3 -m pip install
    numbers-parser
    from numbers_parser import Document
    import pandas as pd
    doc= Document("simple.numbers")
    sheets= doc.sheets()
    tables= sheets[0].tables()
    data= tables[0].rows(values_only=True)
    df= pd.DataFrame(data, columns=["A", "B", "C"])
    

    And then export tocsv:

    df.to_csv('filename.csv')