Understanding CSV Files

CSV files are plain text files that contain spreadsheet data. They are useful for importing or saving data regardless of the spreadsheet app you are using.

Comments: 6 Responses to “Understanding CSV Files”

    Neil Shelley
    11 months ago

    Any excellent short video for those new to CSV files - something similar for PDF files would be equally useful 😊

    Jasper
    10 months ago

    I found an app on the AppStore, EasyCSV Editor. It opens .csv files but presents them in a spreadsheet format. This means that you can edit a single .csv without creating additional file types; and you can clearly see what you’re doing (ie, the column line up). It also has quite good regex, sorting and summary features. I often work on very large .csvs so it’s saved a lot of time.

    aurelio
    6 months ago

    HI, thank you for your videos ans tutorials. I'm trying to manage my password in safari, exporting on a .csv files, but when I try to import a file in my password manager I get this error "Safari could not import passwords from the CSV file because it is missing column labels". How can I solve?
    thank you

    6 months ago

    aurelio: look at the exported file and make sure your import file has the same exact columns.

    aurelio
    6 months ago

    I export the file, open it in excel, work on it without changing columns and save it as a csv file again but when I try to import in safari I still have the same error I reported above. I even try to do it with numbers, but same result "Safari could not import passwords from the CSV file because it is missing column labels"

    6 months ago

    aurelio: Compare your original CSV to your exported new CSV and see what is going on.

Leave a New Comment Related to "Understanding CSV Files"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)