Alternative solution for displaying accented characters in excel ? UTF-8

reader6886

New Member
Joined
Sep 10, 2020
Messages
25
Office Version
  1. 2019
Platform
  1. Windows
Is there an alternative more easier/convienent solution for excel to dispaly the accented chatacters correctly other than by DATA-GET DATA-FROM TEXT/CSV-IMPORT-FILE ORIGIN-DELIMTER route.
I have CSV files that don't get displayed correctly in excel. I have been told its excel encoding problem ( UTF -8). Any different fix than clicking through above process?
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
any example of the csv file?
The CSV files are produced by a webscraper. Below is a pic.
characters.PNG
 
Upvote 0
Oh sorry. How do I upload a file here(sorry I am new)? Is this ok ?The scraper outputs the CSV file which are set to open with excel. This is a range from one such file. I cannot get hold of writer of the scraper and ask him to rewrite it so that it encodes the output file correctly with UTF-8 or BOM . When the same CSV file is opened with librecalc it gives the option in the beginning for the character set to use but with excel it has to be done with above mentioned process which is bit tedious for lot of files.
Thank you so much for looking into this.

best movies ever.csv
A
44
best movies ever
 
Upvote 0
sorry here it is.

best movies ever.csv
A
1Column1
2title
3The 100 Greatest Movies | Movies | Empirewww.empireonline.com › movies › features › best-mov...
4Hollywood's 100 Favorite Films | Hollywood Reporterwww.hollywoodreporter.com › lists › 100-best-films-ev...
5The top 100 Greatest Films of All Time | Sight & Sound | BFIwww2.bfi.org.uk › greatest-films-all-time
6100 Best Movies of All Time That You Should Watch Immediatelywww.timeout.com › newyork › best-movies-of-all-time
7List of films considered the best - Wikipediaen.wikipedia.org › wiki › List_of_films_considered_the...
8Top Movies - Best Movies of 2019 and All Time - Rotten ...www.rottentomatoes.com › top
9The 50 best movies of all time list, according to critic reviews ...www.businessinsider.com › Media › Entertainment
10TOP 100 BEST MOVIES EVER MADE - IMDbwww.imdb.com › list
11Best Movies Of All Time | Glamour UKwww.glamourmagazine.co.uk › gallery › best-movies-o...
12Top 10 Best Movies of the Last Decade - YouTubewww.youtube.com › watch
13AFI's 100 YEARS…100 MOVIES | American Film Institutewww.afi.com › afis-100-years-100-movies
1490 Must-Watch Movies | Best Movies of All Time - Marie Clairewww.marieclaire.com › culture › movies-to-watch-befo...
15Best Movies of All Time - Metacriticwww.metacritic.com › score › metascore › all › filtered
16IMDb's 50 Greatest Movies of All Time | Mental Flosswww.mentalfloss.com › article › imdbs-50-greatest-mo...
17The 100 best films of the 21st century | Film | The Guardianwww.theguardian.com › film › sep › 100-best-films-movi...
18The 100 greatest movies of all time - The Telegraphwww.telegraph.co.uk › films › best-movies-all-time-10...
19The 15 Best Movies Of All Time, According To IMDB ...screenrant.com › Lists
2030 Best Movies of all Time - Lifehackwww.lifehack.org › articles › lifestyle › 30-best-movies...
21Best Movies of All Time | Greatest Films Ever - Rankerwww.ranker.com › crowdranked-list › the-best-movies-...
2290 Best Movies to Watch – Best Movies of All Timewww.seventeen.com › celebrity › movies-to-watch
23The 50 Best Movies on Netflix Right Now. - The New York Timeswww.nytimes.com › article › best-movies-netflix
24Movies everyone should see - Insiderwww.insider.com › Entertainment
2537 Best Classic Movies of All Time - Old Classic Films Everyonewww.townandcountrymag.com › arts-and-culture › bes...
26The 100 Best Movies of the 2010s | IndieWirewww.indiewire.com › gallery › best-movies-of-2010s-dec...
27Best Movies of All Time: 2020 Edition | WTOPwtop.com › best-movies-of-all-time-2020-edition
28The 100 Best Movies on Amazon Prime (September 2020)www.vulture.com › article › best-movies-amazon-prime
29The 32 Best Thriller Films Ever Made | Esquire's Favourite ...www.esquire.com › film › news › 10-best-thriller-movies
30The Greatest Movies Ever: Amazon.co.uk: Kinn, Gail, Piazza ...www.amazon.co.uk › Greatest-Movies-Ever-Ultimate-R...
31Five 'best' Hollywood movies of all time have been named ...www.mirror.co.uk › Film › Hollywood Reporter
32The best sci-fi movies everyone should watch once | WIRED UKwww.wired.co.uk › article › best-sci-fi-movies-of-all-time
33Best movies of the 2000s: 35 best films of the 2000s, rankedwww.shortlist.com › lists › the-25-greatest-movies-of-th...
34The 100 best American movies of all time | Movies | stltoday.comwww.stltoday.com › entertainment › the-100-best-america...
35The 27 Best Action Movies of All Time - Men's Healthwww.menshealth.com › entertainment › best-action-mo...
36Movie Lists - Rolling Stonewww.rollingstone.com › movies › movie-lists
37Top Rated Films | Top 30 Best Movies of All Time - Times of ...timesofindia.indiatimes.com › ETimes › Movies
38What was the best year in movie history? - The Washington Postwww.washingtonpost.com › style › 2018/12/28 › feature
39Best Kids Movies - 60 Greatest Family Films of All Timewww.goodhousekeeping.com › life › parenting › best-...
40The greatest movies of all time – according to statisticswww.digitalspy.com › movies › greatest-movies-all-time
41The 30 best sci-fi movies of all time | GamesRadar+www.gamesradar.com › best-sci-fi-movies
42Why Heat is the Greatest Heist Movie Ever Made | Far ...www.rogerebert.com › far-flung-correspondents › why...
best movies ever
 
Upvote 0
use googledrive, onedrive, dropbox or any similar service then post here link to the shared csv file
 
Upvote 0
could you do this again but with zipped csv file? or rar?
OneDrive converting csv into the excel but it shouldn't be
sorry for the inconvenience
 
Last edited:
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top