Report when exported in CSV File and opend in excel ,shows data in improper

[Former Member]

HI ,

I am running the report and then exporting the same into CSV and Excel .

The Exported excel file runs well but in CSV ,the data which is supposed to be these in the last 5 cells

are squeezed in first 3 cells.

Can anyone please assist me why is this happening .

Thanks

Alok

[Former Member · Accepted solution]

Have you tried opening the CSV file using Notepad rather than Excel? Excel will format the CSV file and often does so in an inappropriate way for your requirements.

[Former Member · Accepted solution]

Hi McGonnell ,

The CSV file when opened in notepad contains all the data but , i need the csv file to be in proper format when opened in

excel.

Can you please suggest me some way , how can i do that .

Thanks

ALOK

[Former Member · Accepted solution]

You need to open the data in Excel in a specific way. Rather than just opening the file in Excel by double clicking on it, open up a new, blank spreadsheet in Excel. Then go to Data > Get External Data > From Text. You should get an Import Wizard window. Click Next then put a tick into each of the relevant boxes in the Delimiters section. Then click Finish and it should work.

I have assumed you are using Excel 2007.

[Former Member · Accepted solution]

Thanks a ton Buddy .

You solve my problem , i will surely award you points.