If the CSV file you downloaded from Hunter looks cluttered, with all entries grouped in a single cell and separated by commas, it means the delimiters are not properly configured in your spreadsheet tool.
Follow these steps to format the file and display the data in separate columns:
For Excel
Open the CSV file in Excel.
Go to the Data tab.
Click on Text to Columns.
Choose Delimited and click Next.
Select Comma as your delimiter and click Next.
Preview your data in the Data Preview section.
Click Finish to apply the changes.
Your data will now appear in separate columns.
For Google Sheets
Open the CSV file in Google Sheets.
Select the column containing your data (usually the first column).
Go to the menu and click Data > Split text to columns.
Click the small dropdown under Separator and select Comma.
The data will automatically split into separate columns based on the commas.
If you need more detailed guidance, you can refer to official resources for Excel and Google Sheets:
Google Sheets Guide: Splitting Text into Columns in Sheets