Convert large amounts of data easily and for free

NextVitz is a site offering useful web services. All services are free. Please use it for data conversion such as EXCEL data editing, WORD writing, programming etc. I think that it will be useful for you if you are a little troubled with format unification, document formatting, etc. We are adding new services sometimes. Also, always improve the quality of existing services.

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

Update information

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.

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 name from URL: I want to extract only TOP pages from a large list of URLs. Or want to extract only educational institutions (ed.jp) from a large number of URLs. Please use this service at such situation. The input URL is analyzed and only the domain part is extracted.

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.


Merge of EXCEL table（Like a left join）: This service generate a merged table from two different formats of EXCEL tables. This is a service like a Left join at SQL. You can specify a Key column for each of the two tables. The table is joined for the rows where the characters in the Key column match.


Reduce multiple replacements to one using a dictionary: 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.


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.


Extraction and counting duplicate rows: 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: 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 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.


Split inside and outside of bracket: Example sentence "Rina Kawaei (Avex)". I want to dividing the Excel cells into “Rina Kawaei” and “Avex”. If you have to divdide only one person data, you can divide manually. But if you have to divide all of AKB members data, you have to do the same things over 100 times. 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 1-byte katakana character to 2-byte.: I want to change one byte character "ｴｲﾍﾞｯｸｽ" to 2 byte character "エイベックス". A lot of data is existing. You think that it is easy to do, because you can use excel functions. However, it is an unexpectedly troublesome conversion when actually trying to do it. This service helps to convert half-width katakana and symbols to full-width collectively.

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.


Convert address format: 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 municipal code from 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.


Generate random Japanese address data: 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.


Generate random US address data: 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.