English | Japanese (日本語) | Spanish (español) | Portuguese (Português)

Create and convert large amounts of character data for free

Doing a lot of simple tasks over and over again can be frustrating. Excel macros and programming would make it easier, but I don't have the time and skills to create one. We have released a service that can be used conveniently at such times. All of them are services created and used when the administrator of this site was in trouble. Please use it when you need to process a large amount of data such as data editing or writing in Excel. All services are free.

Menu: Web analytics; Date・Character analysis; Address; Update information

Web analytics

It is a service that inputs the URL and automatically extracts information from the target WEB page. Just like a little scraping.


Extract link and URL in WEB page: I want to extract all the link information on the homepage. Of course, I want to give the title of the link as well as the URL. Please use this service at such situation. Extracts all the link information in the URL page and lists the link title and the link destination URL.


Extract domain names and TOP page paths from a large number of URLs: Work to extract only the path of the TOP page from a huge URL list. Work to extract only educational institutions (ed.jp) from a huge number of URLs. In such a case, please use this service. Parse the input URL and extract only the domain part, or break it down by domain and extract it.

Date・Character analysis

What do you do when you have to regularly decompose and combine large amounts of data? It's often too much data to do manually. Can you use Excel function? Or can you make a macro? Both are time consuming and cumbersome. We have released a web service that can be used in such cases.


Join two table data with common KEY value: Specify a common KEY column for two tables with different formats, and join (merge) the tables using the characters in the KEY column. A service that performs SQL "LEFT JOIN" on the Web. Easily create merge joins without hard coding in Excel or SQL.


The job to replace 100 times is now 1 times! Replace strings with original multiple transformation rules: For example, when replacing Japan with JPN, or when replacing the United States with USA. If you do it with Excel or a text editor, you need to replace it about 200 times. With this service, 200 operations can be reduced to just one.


Show line breaks and tab characters! Visualization of special character codes: It is often the case that IF (letter A = letter B) is written in the IF statement of a program or Excel. And, although the letters A and B look exactly the same, but the IF sentence does not react for some reason. Why doesn't it react? Have you ever had the experience that it contained invisible line feed codes or had different blank character codes? In this service, invisible code is visualized so that differences can be found quickly. You can also visualize character codes in spaces that are difficult to identify with a text editor.


Show only duplicates! Extraction of identical lines and display of duplicate counts: There are often cases when you want to extract only duplicate rows from a table, or want to delete duplicate rows. This service searches for duplicates in multiple rows of data and performs operations such as counting the number of duplicates and marking and extracting.


Date format conversion. Japanese calendar can be converted to Western calendar: The date of the list created by Mr. A is in the format of "May 2, Reiwa 2". When submitting to users, it must be in the format of "2020.05.02". A lot of data is existing! What should I do? Please use this service at such situations. Year, month and day is automatically extracted from the text and the fluctuation of the notation is adjusted in a batch. Conversion from the Western calendar to the Japanese calendar and from the Japanese calendar to the Western calendar is also possible.


Insert blank lines regularly and in large numbers between lines: Got a customer list! You have to insert a blank line between each line to populate the system. The list is too large to be inserted manually. Please use this service at such situation. Insert one or two blank lines between all lines.


Separate and extract characters inside and outside parentheses: Example sentence "Shohei Otani (Angels)". I want to dividing the Excel cells into “Shohei Otani” and “Angels”. If you have to divdide only one person data, you can divide manually. However, if you have to do it more than 100 times, your heart will break. Please use this service when such situation. The parentheses in the list are automatically detected, and the cells inside and outside the parentheses are output separately.


Separate characters with freely specified characters (SPLIT): Have you ever found it difficult to SPLIT a string in Excel? In order to solve that problem, it is a service that divides character strings at once with specified characters. It is not limited to one character such as a comma or hyphen, but can be divided by any character up to 10 bytes. You can get the same result as using SPLIT method with VBA or C #.


Convert 2-byte hiragana and katakana to alphabet.: When entering Japanese hiragana or katakana into a computer, the pronunciation of the word is entered in romaji and then converted. It's a little difficult even for Japanese people. This service displays alphabets for keyboard input above hiragana and katakana characters.


Convert 1-byte katakana and alphabet to 2-byte.: Half-width and full-width characters are unique to Japanese culture and are troublesome. There is also a web page that can only be entered in full-width characters, and I don't understand the reason. In such a case, you can batch convert half-width characters to full-width characters with the service on this page.

Address

This is a free service about address data. We have a service that divide a large number of addresses into cities, streets, and addresses. Also a service that randomly generates addresses too.


Get latitude and longitude instantly from up to 100 addresses: A scene to find latitude and longitude from a large number of addresses. If you use this service in such a case, you can get the coordinates of multiple addresses at once. You don't have to search for coordinates for each address, you can solve the problem in an instant.


Unify differences in Japanese address notation such as chome and hyphen: Address formats are often different, aren't they? For example, it is written as "3-chome 5-banchi 4-ban," or "3-5-4". Or it may start from prefecture name or it may start from ward name. This service automatically corrects address notation and converts it to a specified format at once. Large amounts of data can be converted in an instant.


Split address by city name, town name, street number, etc.: When posting "3-5-5 Kiyosumi, Koto-ku, Tokyo" to Excel, do you want to divide cells by "prefecture", "city", "town name", "chome", etc.? If you have a small amount of data, you can do it manually. However, it is heartbreaking when it is a large amount of data. Please use this service at such situation. This service analyzes the entered address and divides the Excel cell.


Get a 5-digit local government code from the entered address: Parse the entered address and get the 5-digit Japanese municipality code. Please use if you need to code a large number of addresses.


Up to 1,000 data! Generate a large number of random Japanese addresses: I want to use a large amount of Japanese address data for system testing! However, I am afraid that personal information will be leaked, so I cannot use real customer data. What should I do? Please use this service at such time. This service automatically generates a large amount of fake address data from Japanese postal code data.


Covers 50 states! Generate a large number of random US addresses: Not a Japanese address! I need a lot of American address data for system testing! However, I am afraid that personal information will be leaked, so I cannot use real customer data. What should I do? Please use this service at such time. This service automatically generates a large amount of fake address data from American real zip code, state and city name.

Update information

Feb. 17, 2023: Released a new service "Convert 2-byte hiragana and katakana to alphabet".
Jan. 20, 2023: Released a new service "Get the latitude and longitude of a large number of addresses at once".
Jan. 01, 2023: Added Spanish and Portuguese pages.
Dec. 31, 2022: The option of "Convert half-width katakana/alphabet to full-width" service has been added to "Convert 1-byte katakana and alphabet to 2-byte".
Jun. 11, 2021: Improved so that the extraction result of "Extract link and URL in web page" service is always an absolute path.
Nov. 17, 2020: Generate random US address data was released.
Sep. 27, 2020: Reduce multiple replacements to one using a dictionary was released.
Sep. 23, 2020: Separate characters with freely specified characters (SPLIT) was released.
Jun. 28, 2020: Get municipal code from address was released.
May. 09, 2020: Extract link and URL in WEB page was released.
May. 07, 2020: Extraction and counting duplicate rows was released.
May. 06, 2020: The site has been renewed.
Apr. 01, 2019: Corresponds to the Japanese new era "Reiwa".
Mar. 20, 2019: Merge of EXCEL table was released.
Mar. 02, 2019: Extraction of link and URL in WEB page was released.
Nov. 18, 2017: Generate random address data service was released.
Nov. 13, 2017: Address analysys service was released.