Read CSV and Excel files in Visual Studio - CSV viewer / editor

What should I do to show CSV or Excel file content in cells (columns) in Microsoft Visual Studio ? How can I view CSV file's content in the same way as in Excel ?

Hi,

To view or edit CSV files in Microsoft Visual Studio, you have to install some Excel viewer extenstion. You can use the following one, which is free:

Click on the extension icon in the left pane, to see the available extensions and search for "excel viewer":



Open the extension and click on Install:



After the extension is installed, you need to open the folder with your CSV files. Click on File > Open Folder. When the folder is opened and files are listed in the column, click on the file with right mouse button and select Open With:



Then, in the search box, click on CSV editor:



You should see the CSV file's content. Excel Viewer extension uses comma as a default CSV separator, so you may need to change it to semicolon. You can change it in Settings >Extensions > Excel Viewer > Separator: