CSV Files Encoding Batch Converter
At GAS LAB, we plan and develop automation tools and AI tools that require no programming knowledge and can be used immediately.
Have you ever experienced "garbled text" when downloading CSV files?
The main cause of garbled text is the difference in character codes such as "UTF-8" and "Shift-JIS" in CSV files.
For example, a common case is when a file created on a Windows computer is opened on a Mac.
The character code of a file created on Windows is "Shift-JIS", while the default character code on Mac is "UTF-8", causing the file to be garbled when opened.
When such garbled text occurs, it is possible to open the file without causing garbled text by checking the character code of the CSV file and specifying the appropriate character code.
However, if this phenomenon occurs not only in one CSV file but in multiple files, it would be quite a hassle to change the character code one by one.
So this time at GAS LAB, we have developed a tool that can convert the character code of CSV files in bulk.
CSV Files Encoding Batch Converter
This tool is a tool that can convert the character code of CSV files.
It can convert the character codes of multiple CSV files in bulk.
In case of garbled text in CSV files due to character code settings, it is possible to easily eliminate garbled text with less labor.
Character codes can be freely selected from two types: "UTF-8" and "Shift-JIS".
Also, this tool converts the character code after duplicating the CSV file, so the original file remains intact. Therefore, you can rest assured even if you need the original file.
In addition, this tool is a Google Sheets format tool using a program of "Google Apps Script (GAS)".
Therefore, there is no need to install the tool on your computer.
Since it does not depend on the OS of the computer (Windows, Mac, etc.), anyone can use it if they have an environment where Google Sheets can be used.
Those who often exchange CSV files in business, etc., may often have scenes where garbled text occurs due to character codes.
In such cases, having this tool is very convenient, so please feel free to use it.
This tool can be used for free! Please feel free to use it.
(If this tool can be of any help to you, your support such as "follow" and "share" would be greatly encouraging!)
Three Points of CSV Files Encoding Batch Converter
We introduce the features of the developed "CSV Files Encoding Batch Converter" organized into three points. We hope it will be helpful for understanding the specifications of this tool.
For detailed specifications of the tool, please see the following article.
How to Use the CSV Files Encoding Batch Converter
1. Batch Convert the Character Encoding of Multiple CSV Files
- This tool can batch convert the character encoding of multiple specified CSV files. You can select from two types of character encoding: 'UTF-8' and 'Shift-JIS'.
- While leaving the original file untouched, it generates a duplicated file with converted character encoding.
- You can also specify the folder in Google Drive where the converted files will be stored.
2. No Need for Installation Because It’s in 'Google Sheets Format'!
- This tool is a 'Google Sheets Format' tool with an automation program implemented by Google Apps Script (GAS).
- There is no need to install anything, and it can be used regardless of your PC’s OS (Mac, Windows, etc.).
- Also, it can be used at any time as long as you have access to the internet.
3. Simple Operation of Input and Clicks! Even Beginners Can Easily Use It!
- The operation of this tool is simple.
- Since it can be operated by just input and clicks, anyone with experience using spreadsheet software like Excel can easily use it.
How to Use the CSV Files Encoding Batch Converter
1.Copy the purchased tool (in Google Spreadsheet format)
2.Upload the CSV you want to convert to Google Drive
3.List the URLs of the CSVs on the conversion list sheet
4.Execute "Batch Conversion" from the "Menu"
5.The batch conversion of the character code is complete!
Notes on Using This Tool
- A Google account is required to use this tool.
- We cannot be held responsible for any problems arising from the use of this tool. Please test and understand the usage in advance and use it.
- This tool has a time limit for processing (about 6 minutes). Please note that in case of exceeding the processing time, data acquisition/output may not be completed.
- The copyright of the tool and program belongs to GAS LAB. Unauthorized copying, resale, distribution, sharing and copying of the source code are strictly prohibited.
- This tool initiates an “authentication and permission process” at the time of the first use. Please proceed with authentication and permission referring to the following article.
Q&A
Q. How can I ask about how to use the CSV Files Encoding Batch Converter?
A. Since this tool is a free tool, we do not provide support. Please understand this in advance.