How to get EXCEL from CSV-file automated, without "manuell Import data" ?

How to get EXCEL from CSV-file automated, without "manuell Import data" ?
asdf13Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Fabrice LambertConsultingCommented:
Hi,

Can you be more precise about what you want to do ?

Excel is perfectly able to read CSV files, just double click on the file icon from your file browser (but I assume this isn't your desired results).
Else, did you look at the code produced by the macro recorder ?
asdf13Author Commented:
If i open csv file with XLS, i get a layout like attached file Shows  (comma separated, not in XLS colums )
CSV-open-with-EXCEL.PNG
Fabrice LambertConsultingCommented:
How do you open it ?
Ensure Business Longevity with As-A-Service

Using the as-a-service approach for your business model allows you to grow your revenue stream with new practice areas, without forcing you to part ways with existing clients just because they don’t fit the mold of your new service offerings.

asdf13Author Commented:
open with EXCEL ....
Save CSV file under EXCEL did not put CSV data in columns (no effect, same as before)  

If i open new EXCEL and do "Import data from Text" from CSV file , CSV-data will be put in EXCEl columns, as wanted.
But i want to avoid these manuell steps . ..
Bill PrewIT / Software Engineering ConsultantCommented:
Please upload an example of the actual CSV file that is not opening properly in Excel.


»bp
asdf13Author Commented:
example CSV attached : CSV_EXAMPL2.CSV
CSV_EXAMPL2.CSV
Bill PrewIT / Software Engineering ConsultantCommented:
The problem with that file is all the extra repeat double quotes.  I cleaned them up just removing the duplicates (see second file below) and it opens fine in Excel, parsing into columns.  You need to correct the source of the file, or write a small script to remove the extra double quotes before opening in Excel.

***** ORIGINAL FILE *****
"PARENT DIRECTORY,""OBJECT NAME"",""ALLOCATED SIZE (BYTES)"",""OBJECT OWNER"",""DATETIME OBJECT LAST USED"""
"/QOpenSys/QIBM/ProdData/C++Compiler/bin/n,""QPZA_QSI678235770WDS0007R03M00510100520000"",41943040            ,""QSYS      "",""2018-11-17-19.24.23.000000"""
"/QOpenSys/QIBM/ProdData/C++Compiler/bin/n,""xlCentry"",41943040            ,""QSYS      "",""2018-11-17-19.24.23.000000"""
"/QOpenSys/QIBM/ProdData/C++Compiler/bin/n_1,""xlCentry"",25165824            ,""QSYS      "",""2018-11-17-19.24.23.000000"""
"/QOpenSys/QIBM/ProdData/C++Compiler/bin/n_2,""xlCentry"",27262976            ,""QSYS      "",""2018-11-17-19.24.23.000000"""
"/QOpenSys/QIBM/ProdData/InfoprintServer/Transforms/pcl2afp,""pcl6"",7864320             ,""QDFTOWN   "",""2018-06-13-07.50.06.000000"""
"/QOpenSys/QIBM/ProdData/InfoprintServer/Transforms/ps2afp/Resource/CIDFont,""AdobeMingStd-Light"",13631488            ,""QDFTOWN   "",""2018-06-13-07.50.06.000000"""
"/QOpenSys/QIBM/ProdData/InfoprintServer/Transforms/ps2afp/Resource/CIDFont,""AdobeMyungjoStd-Medium"",11534336            ,""QDFTOWN   "",""2018-06-13-07.50.06.000000"""
"/QOpenSys/QIBM/ProdData/InfoprintServer/Transforms/ps2afp/Resource/CIDFont,""AdobeSongStd-Light"",19922944            ,""QDFTOWN   "",""2018-06-13-07.50.06.000000"""
"/QOpenSys/QIBM/ProdData/InfoprintServer/Transforms/ps2afp/Resource/CIDFont,""KozGoPro-Medium"",5767168             ,""QDFTOWN   "",""2018-06-13-07.50.06.000000"""
"/QOpenSys/QIBM/ProdData/InfoprintServer/Transforms/ps2afp/Resource/CIDFont,""KozMinProVI-Regular"",10485760            ,""QDFTOWN   "",""2018-06-13-07.50.06.000000"""

Open in new window

***** CORRECTED FILE *****
"PARENT DIRECTORY,"OBJECT NAME","ALLOCATED SIZE (BYTES)","OBJECT OWNER","DATETIME OBJECT LAST USED"
"/QOpenSys/QIBM/ProdData/C++Compiler/bin/n,"QPZA_QSI678235770WDS0007R03M00510100520000",41943040            ,"QSYS      ","2018-11-17-19.24.23.000000"
"/QOpenSys/QIBM/ProdData/C++Compiler/bin/n,"xlCentry",41943040            ,"QSYS      ","2018-11-17-19.24.23.000000"
"/QOpenSys/QIBM/ProdData/C++Compiler/bin/n_1,"xlCentry",25165824            ,"QSYS      ","2018-11-17-19.24.23.000000"
"/QOpenSys/QIBM/ProdData/C++Compiler/bin/n_2,"xlCentry",27262976            ,"QSYS      ","2018-11-17-19.24.23.000000"
"/QOpenSys/QIBM/ProdData/InfoprintServer/Transforms/pcl2afp,"pcl6",7864320             ,"QDFTOWN   ","2018-06-13-07.50.06.000000"
"/QOpenSys/QIBM/ProdData/InfoprintServer/Transforms/ps2afp/Resource/CIDFont,"AdobeMingStd-Light",13631488            ,"QDFTOWN   ","2018-06-13-07.50.06.000000"
"/QOpenSys/QIBM/ProdData/InfoprintServer/Transforms/ps2afp/Resource/CIDFont,"AdobeMyungjoStd-Medium",11534336            ,"QDFTOWN   ","2018-06-13-07.50.06.000000"
"/QOpenSys/QIBM/ProdData/InfoprintServer/Transforms/ps2afp/Resource/CIDFont,"AdobeSongStd-Light",19922944            ,"QDFTOWN   ","2018-06-13-07.50.06.000000"
"/QOpenSys/QIBM/ProdData/InfoprintServer/Transforms/ps2afp/Resource/CIDFont,"KozGoPro-Medium",5767168             ,"QDFTOWN   ","2018-06-13-07.50.06.000000"
"/QOpenSys/QIBM/ProdData/InfoprintServer/Transforms/ps2afp/Resource/CIDFont,"KozMinProVI-Regular",10485760            ,"QDFTOWN   ","2018-06-13-07.50.06.000000"

Open in new window


»bp

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
asdf13Author Commented:
thanks both for supporting !
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.