Article summary
The international format for Lithuanian phone numbers is 370 followed by 8 digits. Learn about Lithuania’s local 8-prefix numbers, fixing Excel scientific notation ‘E’, incorrect country code identification, and number deduplication, and complete number standardization in 7 steps. Includes a complete Before/After comparison table.
The international format for Lithuania phone numbers is370 is followed by an 8-digit number, with the last 8 bits and above6For example, the beginning+370 612 34567。 Local data often omits country codes and writes61234567; Domestic calling formats include the trunk prefix8, writing861234567。 The goal of number cleaning is to unify all variants with spaces, brackets, prefixes 00, 8, and Excel scientific notation as+37061234567。
Quick reference of Lithuania phone number format rules
| Attributes | Rules |
|---|---|
| Country code | 370 (3 people) |
| Mobile number digits (excluding country code) | 8 digits, with the first digit being 6 |
| Full digit count of the phone number | 11 digits (370 8 dun) |
| Standard international format | +370 612 34567 |
| Local format | 612 34567 |
| Local dialing format | 8 612 34567 (8 is the trunk access code) |
| International access prefix | 00(00370 612 34567) |
| License plate range | Numbers start with 6, with the remaining 7 digits assigned by the carrier. Actual numbers are released by operators such as Telia, Bitė, and Tele2 |
Special attention should be paid to:Lithuania does not have a “lead 0”; the domestic trunk prefix is 8。 The prefix 0 (0 138…) for Chinese mobile numbers does not apply in Lithuania. If you see it in Excel061234567These “Lithuanian numbers” starting with 0 are mostly formatting errors caused by automatic system zero filling; when cleaning, the 0 should be removed and 370 added.
Three common writing and conversion methods
1. E.164 International Format (Recommended)+37061234567
WhatsApp, Telegram, CRM, and API usually use this format. When processing, remove all spaces, parentheses, and blanks, keeping only the blanks+、370、6And the following 7-digit number.
2. Local format61234567
Data exported from within Lithuania often requires pre-processing+370。
3. Local dialing format861234567
This is the 8 prefix local phone number. Only if the prefix “starts with 8, followed by 8 digits, and the second digit is 6” can you safely remove 8 and prefix it+370。
A common pitfall: mistaking 861234567 for Chinese numbers
861234567Such strings are often misidentified as China area codes in Excel86The beginning. If processed as a Chinese number, it will be directly marked as “invalid” and discarded because the number is insufficient. In fact, it is a domestic Lithuanian dialing format. The logic for judgment is as follows:
861234567Remove the first position8Later,61234567, exactly 8 digits and starting with 6 → Lithuanian mobile number8612345670After removing the first position, it is6123456709-digit → is not a standard Lithuanian phone number, marked with manual verification
For batch cleaning, it’s recommended to quickly categorize by “Is the second digit 6?” rather than simply matching by country code fields.
Common error formats are compared to before/after comparisons
The following are sample numbers, not real user data:
| Raw Data (Before) | Problem description | Standardized Results (After) |
|---|---|---|
| 61234567 | Country code is missing | +37061234567 |
| +370 612 345 67 | Contains spaces | +37061234567 |
| +370 (612) 34567 | Includes parentheses | +37061234567 |
| +370-612-34567 | Including horizontal lines | +37061234567 |
| 00370 612 34567 | 00 Prefix not unified to one | +37061234567 |
| 37061234567 | Missing number | +37061234567 |
| 861234567 | The local 8 prefix is not recognized | +37061234567 |
| 3.70612E+10 | Excel Scientific Notation | +37061234567 |
| +86 612 345 67 | Country code mismatch | 37061234567 (Depends on context) |
| 37061234567 (two lines appear) | Repeat the number | Only one item remains |
What is Excel Scientific Notation (E)?
Excel automatically switches to scientific notation for pure numbers above 11 digits, so it is missing+The Lithuanian number of the numbers37061234567It will display as3.70612E+10。 Repair methods:
- Set the number column format to
Text; - If the data is already in scientific notation mode, first set text, then use “Column Split,” and finally select “Text” to import;
- Use the formula
=TEXT(A1,"0")Restoring the full numbers.
After cleaning, the full file should be displayed in Excel37061234567Or+37061234567, the E abbreviation no longer appears.
Incorrect country code: Two typical situations
Case 1: A number starting with 86 but actually a Lithuanian number+86 61234567With this format, removing the country code may result in a local Lithuanian number. It is recommended to first check whether the last 8 digits start with 6; if yes, change it to 370; otherwise, it will be treated as an invalid number.
Scenario 2: Starting with 37 (missing one country code)+37No country is assigned to any country; the correct Lithuanian country code is three digits370。 Encounter+37For the initial data, check the number of digits that follow: if the number of digits after completing 370 is exactly 11 digits, then fill in the digits+370; If the last digit is filled incorrectly, mark it as unconfirmable and do not forcibly modify it.
Standardized Cleaning Process (7 Steps)
| Steps | Operation | Input → output |
|---|---|---|
| 1 | Remove spaces, parentheses, lines, dots, and slashes | +370 (612) 34567 → +37061234567 |
| 2 | 00 Prefix unified as | 0037061234567 → +37061234567 |
| 3 | If there is no number, keep the format starting with 370 | 37061234567 → +37061234567 |
| 4 | Recognize the 8 prefix (the second digit is 6 before 8) | 861234567 → 61234567 |
| 5 | Preset to 370 and check according to regular rules^\+3706\d{7}$ | 61234567 → +37061234567 |
| 6 | Check Segment: The first digit after 370 must be 6 | +37051234567 → invalid_mobile_prefix |
| 7 | Deduplicate according to standardized results | 37061234567 Repeat the line → Keep one |
Regular reference for E.164 format^\+3706\d{7}$, used in local format^6\d{7}$。 Numbers that do not meet the criteria are marked asinvalidDo not automatically switch to other formats to avoid accidentally damaging numbers from other countries.
Cleaned CSV Fragment (Example)
| id | raw_number | cleaned_number | status |
|---|---|---|---|
| 1 | +370 612 34567 | +37061234567 | ok |
| 2 | 861234567 | +37061234567 | ok_8prefix_fixed |
| 3 | 3.70612E+10 | +37061234567 | ok_excel_fixed |
| 4 | +37051234567 | +37051234567 | invalid_mobile_prefix |
| 5 | +86 612345678 | +37061234567 | wrong_cc_fixed (manual confirmation required) |
| 6 | +37061234567 | +37061234567 | duplicate_removed |
When determining repetition, it should be based on the cleaned methodcleaned_numberFields should be used for deduplication; you can’t use the original string directly.+370 612 34567、861234567、37061234567At the original level, they look completely different, but after standardization, they are the same number.
Automatically cleanse Lithuanian numbers with AppShai
If you don’t want to manually maintain regular expressions and Excel formulas, AppShai’s number cleaning tool comes with built-in number rules for 220 countries and regions. After importing CSV and selecting Lithuania (370), the system will automatically handle issues like 8 prefix, 00 prefix, missing numbers, Excel scientific notation, duplicate numbers, and outputs a standard format suitable for platforms like WhatsApp and Telegram.
Compliance reminders
Number cleansing is only recommended for data from legitimate sources, such as your own CRM, forms submitted by users, or authorized marketing lists. Do not use tools to bulk collect or scrape strangers’ numbers, nor use cleaned data for harassment or mass messaging. Cleanup ensures the number format is correct; whether you qualify for reach still depends on the data source and platform rules.
Frequently Asked Questions
How many digits are there in Lithuanian phone numbers?
8 digits starting with 6; The full international format is 370 plus 8 digits, totaling 11 digits.
Do you need to add 0 to your phone when calling from Lithuania?
No need. Lithuania does not have a leading 0; the domestic mainline access code is 8. When dialing in from abroad, use 370 directly; dialing locally in Lithuania can be written as 8 6XX XXXXX.
What is the difference between 00370 and 370?
00370 = International access prefix 00 country code 370. Both can handle international calls, but CRM and business APIs usually only recognize 370, so during cleaning, they are uniformly converted to .
Why does the number change to 3.71E 10 after batch import?
Excel automatically converts numbers over 11 digits into scientific notation. Set columns as text and then re-import them, or useTEXTFormula restored.
AppShai (AppShai)It is a globally leading number ecosystem processing platform, deeply integratedGlobal mobile number range coverage, batch number generation, intelligent deduplication, and multi-dimensional comparisonand other core capabilities, providing coverage for global corporate and individual clients220 countries and regionsNumber Checking and verification services.
Currently, the system is compatible with the following mainstream social and business applications, including:
WhatsApp、LINE、Telegram、Viber、Zalo、Signal、Facebook、Messenger、Instagram、Microsoft、Binance、iMessageand more.
We will continue to develop and support more platforms, so stay tuned.
Platform features cover all-dimensional filtering scenarios, supportedEnable filtering, active filtering, interaction filtering, gender filtering, avatar filtering, age filtering, online status filtering, precise tag filtering, online duration filtering, power-on detection filtering, inactive number filtering, mobile device model filteringetc., meeting various business needs from basic to advanced levels.
We provideSelf-service screening mode, agency-operated screening mode, refined layering mode, and customized solution mode, flexibly adapting to the different usage scenarios of individual developers, small and medium-sized teams, and large multinational enterprises.
The core advantage lies inOne-stop integration of global mainstream application ecosystems, providing real-time high-precision screening results, helping you significantly reduce customer acquisition costs and improve global digital operation efficiency.
