Steps to Import Data into Excel
Step 1: Export Data from the Hoopoz Mentions Table
Open the Hoopoz Mentions table in your dashboard.
Click the "Export CSV" button.
The file will be downloaded in CSV format to your device.
Export CSV
Step 2: Import Data into Excel
Open Excel on your computer.
Go to the "Data" tab in the ribbon.
Click "Get Data" (or "Get External Data", depending on your Excel version).
Select "From Text/CSV" from the dropdown menu.
Browse and select the exported CSV file from your device.
Step 3: Set Up the Import:
When prompted, choose "Delimited" as the file type and click "Next".
Select the delimiter “|” used in the CSV file.
Verify the data preview to ensure columns are correctly aligned.
Click "Next".
Choose Delimited
add- |
Step 4: Format Columns (Optional):
Assign the appropriate data format for each column (e.g., General, Text, Date).
Click "Finish".
Choose where to import the data:
Import into an existing worksheet or create a new worksheet.
Click "OK" to complete the import process.
We hope you find this guide helpful! If anything is still unclear, please don’t hesitate to contact Hoopoz Support for further assistance.