1. Home
  2. Knowledge Base
  3. General
  4. Open CSV File in Excel

What is a .csv file? CSV stands for Comma Separated Values. A CSV file is a plain text file that stores tables and spreadsheet information. The contents are often a table of text, numbers, or dates. CSV files can be easily imported and exported using WooPOS and Excel.

Double-clicking a CSV file to open it in Excel, you may get one column data like this.

To fix this problem, click “Data”, select column A, then click “Text to Columns”

You can also close the file first. Open Excel, click OPEN from the menu. Select the CSV file. Then select “Delimited” and click NEXT.

Then select “Comma”.

The CSV file should be open with multiple columns.

Was this article helpful?