Export Oracle table into Excel Using SQLPlus Spool command

The following code exports data from dba_tables table into .CSV file

After the table export into .CSV file, if we open the file with Excel we can see each table column data into separate columns in excel.

set term off
set echo off
set underline off
set colsep ,
set linesize 100
set pagesize 0
set lines 1000 pages 1000
set trimspool on
set feedback off
set heading on
set newpage 0
set headsep off

spool h:\tmp\table_export_into_file.csv
-- Exporing the table dba_tables into csv file
select owner, table_name, tablespace_name
from dba_tables
where rownum <=10;

spool off

Output looks like as follows