Excel VBA Script to convert VCF file with multiple entries to CSV file
...If this doesn't work for you, please email me the VCF file and I'll modify the code to support your specific VCF format.
To use, simply download and open the Excel file (xlsm), Enable Macros if prompted, and then select the VCF file you wish to import. Once complete, Excel will create and save new file titled VCFExport.csv that can also be saved in Excel format.
Helps translate SAV / CSV data into usable Excel data
You have been struggling with SPSS databases when you needed to use excel?
Well, this file (or the VBA module attached to it) will help you: you paste your CVS file format into one sheet, and the bulky strings will all your values will gently be split into one value per column by a custom excel function,
The function takes into account that some values might be strings with comas that should not be split into different variables.