How to properly import CSV files to Microsoft Excel
Many of our users also use MS Excel to view the csv file and face similar issues, however this is a general issue and not specific to the botsol app.
Let's see how you can import the data to MS Excel with correct encoding and format.
Open MS Excel, Click File > New and double click Blank WorkBook.

Click the "Data" tab, click the "From Text" icon as shown in screenshot below. It will open a dialogue box to select the file, Select the CSV file you want to import, and click Import.

From step 1 of the Text Import Wizard, select "Delimited" as file type and select UTF-8 encoding "65001 : Unicode (UTF-8)", Click Next



From the next window, you can select if you want to add this data to current sheet or create a new sheet, chose whatever you want.
Now you can see the data is showing correctly, there are no strange characters and all the columns are well formatted.

You might also like:
Navigating Modern Web Scraping: How AI and Expert Services Tackle Complex Data Challenges
The digital world is a goldmine of information, but extracting valuable data has become increasingly complex. Websites are more dynamic, anti-bot measures are more sophisticated, and the sheer volume of data is overwhelming. This blog post delves into the evolving challenges of web scraping and how the integration of Artificial Intelligence (AI) and specialized web scraping services are becoming indispensable for businesses seeking reliable data intelligence.
Unlocking Business Growth: How Advanced Browser Automation and AI are Reshaping Data Intelligence
Data is the new currency, businesses that can efficiently collect, process, and analyze vast amounts of information gain a significant competitive edge. This is where the power of advanced browser automation, combined with intelligent AI capabilities, is revolutionizing how companies approach data intelligence and drive sustainable growth.
How to properly import CSV files to Microsoft Excel
Microsoft Excel is a popular app to open CSV files, sometimes it does not display the csv files data correctly, This is because Excel opens the CSV file using the default windows encoding (Windows-1252), and when the encoding is different it may not display the data correctly.