Convert Excel sheet having shivaji fonts to csv having google unicode utf-8 encoding

0 votes
I want to convert an Excel document that uses Shivaji fonts to a CSV file using Google's Unicode UTF-8 encoding.

I tried every approach, but I was unsuccessful because when I saved the file as a CSV, it displayed? I require the following symbols: à ¤Âà ¤•à ¤Ÿà ¤¾.

This file has to be imported into MySQL. Can someone please help me with this?
Sep 24, 2022 in Others by Kithuzzz
• 38,010 points
756 views

1 answer to this question.

0 votes
I take it that you mean "Shivaji font" to refer to Devanagari characters. I believe that you have been converted incorrectly twice.

I mimicked it by incorrectly converting to ààà—à%C2%8Dà2àà and then incorrectly converting that to â€" â€" 2, which closely resembles what you have. The file was twice transformed from utf8 to latin1 while it was moved around. Determine the specifics of the actions you made. At any point, if you can get a dump, do so. The hexadecimal Devanagari characters appear as E0A4yy, where yy is in the range of 80 to B1.
answered Sep 25, 2022 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer

How to fix corrupted imported online excel in google sheet?

Issue and workaround: In the built-in functions for ...READ MORE

answered Nov 26, 2022 in Others by narikkadan
• 63,420 points
253 views
0 votes
1 answer

Excel to CSV with UTF8 encoding

Use of Google Spreadsheet is a straightforward ...READ MORE

answered Dec 23, 2022 in Others by narikkadan
• 63,420 points
535 views
+1 vote
1 answer

Excel or Google formula to count occurrences of an 8-digit number within a text string

To match an eight-digit number, you may ...READ MORE

answered Dec 24, 2022 in Others by narikkadan
• 63,420 points
605 views
0 votes
1 answer

Google Spreadsheet/ Excel - how to find matching values in column A, having necessary values in column M

Try this: =COUNTIF($M$2:$M$5;A2) If the product is present in ...READ MORE

answered Feb 10, 2023 in Others by narikkadan
• 63,420 points
233 views
0 votes
1 answer

Python, mysqldb and unicode

What you get is a bytestring. You ...READ MORE

answered Aug 1, 2019 in Python by SDeb
• 13,300 points
1,421 views
0 votes
1 answer

Online Excel Web-based Platform

You can use any of the following ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
• 63,420 points
321 views
0 votes
1 answer

Online MYSQL editor as an Excel-like spreadsheet

That depends on who are those users, ...READ MORE

answered Oct 8, 2022 in Others by narikkadan
• 63,420 points
727 views
0 votes
1 answer

Convert Excel's "41014" date to actual date in PHP or JavaScript

PHPExcel Date handling code: public static function ExcelToPHP($dateValue ...READ MORE

answered Oct 24, 2022 in Others by narikkadan
• 63,420 points
3,272 views
0 votes
1 answer

Convert csv- or Excel-file (xlsx) to kml with custom markers

With some help from the community, I ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 63,420 points
852 views
0 votes
1 answer

Convert text to number in Google Sheets & Excel

Try: =INDEX(IF(REGEXMATCH(A1:A4&""; "M"); REGEXEXTRACT(A1:A4; "\d+.\d+|\d+")*1000000; IF(REGEXMATCH(A1:A4&""; "k"); ...READ MORE

answered Oct 15, 2022 in Others by narikkadan
• 63,420 points
944 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP