how to open a pipe delimited csv file in excel using java

1
votes

I have a CSV file that has Pipe delimited, But when i open it using excel the whole data in the csv file gets into a single cell. without changing the pipe separated to comma separated. The CSV file should properly get the values and display in co responding cell

1
excelcsv
How exactly does Java fit in the equation? - kumesana
All the data in the csv file gets into a single cell of the excel. Like Name| Phone NO Sivan|12345 Easwer|98765 the whole thing gets into a single cell, but it sholud come in proper row and column in excel - Gynoid
can you share snapshot of the csv file in the question? - Vinay Prajapati

1 Answers

0
votes

You must choose delimiter while opening the file. Default delimiter is tabs. But check your excel settings and add comma and any other symbol as delimiter. There could be some issue with your csv file as well.

For now follow these steps:

  1. Click on Data menu on top.

enter image description here

  1. Click on From Text / CSV button:

enter image description here

  1. Now explore your file and open it. enter image description here

  2. Now choose delimiter of your choice and preview data and load it. enter image description here

Basically you can analyze your csv here for any issues as well.

Cheers!