Why is my CSV file not working?

Why is my CSV file not opening properly in Excel?

CSV (comma delimited) will not open correctly and the data within will be displayed incorrectly. This is due to regional Excel settings that have default list separator options where files will either be read with a comma separator or semicolon separator.

How do I fix a CSV file?

Open an CSV file using the Text Import Wizard1Make sure the data type is set to Delimited. Click Next.2Set the delimiter to Comma (only), and deselect Tab. Click Next.3For each column, set the data format to Text, instead of General. To do this quickly, you can select all the columns at once.

How do I fix a CSV file error in Excel?

Resolution1Open the CSV in Notepad. (Don't use Excel to open the CSV file because the quotation marks may not be visible in Excel).2On the Edit menu, select Replace. In the Find what box, type ", leave the Replace with box blank, and then select Replace All. ... 3Save the file, and then import it to Office 365.

How do I activate a CSV file?

If you already have Microsoft Excel installed, just double-click a CSV file to open it in Excel. After double-clicking the file, you may see a prompt asking which program you want to open it with. Select Microsoft Excel. If you are already in Microsoft Excel, you can choose File > Open and select the CSV file.