Export CSV about adaclscanner HOT 1 CLOSED

Hi,

I know the struggle with importing in Excel and have had the same problem.

It is really annoying when Excel doesn't do it right sometimes when click on a file or open it directly.

Make sure your language settings in Office have comma as the default separator.

But this is already solved.

I can just double-click the file or open it within Excel and it just works.

Why?

• The data is kept within quotation mark, so Excel understands it.
• It should be comma since it is a (Comma Separated Values) file.
• You are not doing it right.

This is the correct way to import a CSV-file to Excel.

1. Open Excel
2. New File
3. Tab "Data" -> From Text/CSV
4. Select CSV file
5. Click Load
6. Done!

Or with PowerShell
import-csv -Path "managedpriv_MANAGEDPRIV_adAclOutput20220806_104856.csv" | Export-Excel -Path .\MyExcelFile.xlsx

from adaclscanner.