If you have downloaded files (Export) from the Easy Form Builder plugin and your website’s language is set to something other than English, you may encounter some issues when trying to view the data in software like Excel. To properly view and manipulate these files in Excel, you need to import them correctly. Follow these steps to ensure a smooth import process:

Step-by-Step Guide to Importing Files into Excel

1. Open Excel:
   • Launch Microsoft Excel on your computer.
2. Start the Import Process:
   • Go to the Data tab on the Excel ribbon.
   • Click on Get Data (or Get External Data depending on your version of Excel).
3. Select the File Type:
   • Choose From Text/CSV if your file is a CSV (Comma-Separated Values) file.
4. Locate Your File:
   • In the file explorer window that appears, navigate to the location where you saved the downloaded file from Easy Form Builder.
   • Select the file and click Import.
5. Adjust File Origin Settings:
   • In the Text Import Wizard, select the appropriate file origin. This setting determines how Excel interprets special characters.
   • For non-English sites, you may need to choose a different encoding such as Unicode (UTF-8) or the specific encoding relevant to your language.
6. Specify Delimiters:
   • In the next step of the wizard, specify the delimiter that separates your data fields. For CSV files, this is usually a comma.
   • Preview the data to ensure it appears correctly.
7. Format Columns:
   • Excel will display a preview of how the data will look in a table.
   • You can format columns as needed (e.g., Text, Date, General).
8. Finish and Load:
   • Click Finish to complete the import process.
   • Choose whether to load the data directly to a new worksheet or to the existing one.
9. Adjust and Save:
   • Once imported, you might need to adjust column widths, formats, and other settings to suit your needs.
   • Save your Excel file to ensure all changes are kept.

Additional Tips

• Check Language Settings: Ensure your Excel language settings match or can handle the language of your downloaded file to avoid character display issues.
• Data Cleaning: After importing, you might need to clean up the data if there are any formatting issues or unexpected characters.
• Use Excel Functions: Utilize Excel’s powerful data manipulation functions to analyze and visualize your imported data.

By following these steps, you can efficiently import and work with files downloaded from the Easy Form Builder plugin, ensuring that the data is displayed correctly regardless of the original website language.