How to Open CSV Files on a Mac

Save

The acronym CSV stands for "comma separated values." Much like the name implies, a CSV file contains spreadsheet information in which the information in each row is separated by a comma. The rows are separated from one another by creating a new line at the beginning of each entry. CSV files can be used to transmit information between different spreadsheet editing programs, or they can be edited using a simple text editing program.

Open with a Spreadsheet Program

  • Open a spreadsheet program on your Mac computer. Any spreadsheet program can be used to open CSV files, including Microsoft Excel and Open Office.

  • Click "File" and choose "Open." Change the file settings such that all files are displayed, including CSV files.

  • Navigate to the directory that contains your CSV file and open the file. The information in the CSV file will be imported into your spreadsheet program.

  • Edit the file as desired. When you are finished you can save the file in your program's proprietary format or you can save it as another CSV file that can be read on any computer. If you save as a CSV file, you won't be able to save any formatting that you have applied in your spreadsheet program.

Open with a Text Editor

  • Open a text editing program on your Mac. Mac OS X comes with the TextEdit program included.

  • Click "File" and choose "Open." Navigate to the directory that contains your CSV file and open the file. The data in the file will be displayed with commas separating each column and each line representing a new entry.

  • Edit the file as desired. Be sure to maintain the correct number of comma-separated entries in each field in order to preserve the integrity of your data.

References

  • Photo Credit Jupiterimages/BananaStock/Getty Images
Promoted By Zergnet

Comments

You May Also Like

  • How to Read Excel Office Files on Mac

    The Mac operating system, OS X, is easy to learn and use. Because software on the Mac is made by Mac, the...

  • How to Edit CSV File Format on a Mac

    While the comma-separated values (CSV) extension may be unfamiliar to many, it is simply a format for data storage, like a spreadsheet....

  • How to Convert a CSV File to Mac

    Most database, word processing and spreadsheet programs provide the option to save a document in another format for compatibility across platforms and...

  • How to Open a CSV File With VBA

    A Comma Separated Value (CSV) file is a plain text file that has a single record on each line. Each line is...

  • How to Edit CSV File Formats

    CSV, also known as “Comma-separated values,” is a type of file format that can be opened by programs such as Microsoft Office...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!