If using my free ICS to CSV converter service, which reads one or multiple ics calendar file(s), converts them in comma separated files and offers such CSV files for download, you might also want to know how to open the downloaded csv file in EXCEL.
This is how to proceed…
Step 1. You start EXCEL and call ‘File > Import…
Step 2. EXCEL will prompt the text import wizard. Select there ‘CSV file’:
Step 3. Locate your CSV file and click on ‘Get Data’:
Step 4. Define the delimiter and the text qualifier. Per default my free ICS to CSV converter uses ‘tab’ as delimiter and double quotes as text qualifier.
Step 5. Check the ‘Data preview’ as offered in the ‘Text Import Wizard’. Verify that the data comes in separate columns as expected.
Step 6. Select a sheet and a cell for EXCEL to put the imported data:
Congrats. Your csv file is not imported in EXCEL :-)