An Easier Way to Open CSV Files in Excel

Spreadsheets and graphs on a desk
xfgiro/istock

You’ve likely encountered many comma-separated value (CSV) files over the years. These can often be the bane of an Excel users’ existence, as Excel tries to be “helpful” in such a way that often becomes “anti-help”. In this article I’ll show you an alternative to the traditional File, Open command that will enable you to assert far more control over handling CSV files in Excel.

You should find this approach eliminates most, if not all, of your frustrations related to viewing and editing such files in Microsoft Excel. A typical comma-separated value file is shown in Figure 1. If we use the Notepad app in Windows to view the file, we can see that each field is separated by a comma. This serves as a universal format that many software programs rely on for importing and/or exporting data.

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

Replies

Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.