cancel
Showing results for 
Search instead for 
Did you mean: 
mgrant1001
Occasional Member - Level 1

Export Expense report as CSV with all columns wrapped in quotes

Is there a way to extract the report as a csv with all columns wrapted in quotes rather than just he column whose content contains a comma?

1 REPLY 1
MSTEEN
Routine Member - Level 1

Hello, mgrant1001.

 

A CVS file is when the data is separated by commas. This type of file is used when there is a lot of rows/data in the report.  You will convert the data to Excel by using selecting the first column of the spreadsheet. Then DATA > Text to Columns > Delimited > Coma (,) as the separator > finished.  Excel will separate the data into columns.

 

Does the above help you?

Maria Steen