If a CSV file looks cluttered when you open it, with a whole row sitting in a single cell and the values separated by visible commas, your spreadsheet tool has not split the file on its commas. This can happen with a file you downloaded from Hunter, and with a file you are preparing to import into Hunter.
If you are here because an import into Hunter failed with an error about an invalid columns count, this is the fix you need. Re-exporting the file on its own will not resolve it.
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 are importing this file into Hunter, save it again before uploading. Splitting the data into columns only changes what is open in Excel or Google Sheets. The original CSV file on your computer has not changed. In Excel, use File > Save As and choose CSV UTF-8 (Comma delimited) (.csv). In Google Sheets, use File > Download > Comma-separated values (.csv). Upload the file you have just saved.
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
If your data is already in separate columns and the import still fails, see How to fix CSV import errors in Hunter for the other causes.