Excel & CSV Data Checker
Preparing the interface…
GuestSigned inNot signed inGuest accessFree memberSubscriberBusiness memberCurrent stepVisited stepUpcomingDay, month and year orderAutomatic (keep ambiguous values)Month / Day / Year (e.g. USA)Day / Month / Year (e.g. Europe)Input decimal separatorAutomatic (keep ambiguous values)Dot (1.25)Comma (1,25)Input digit-group separatorNo separator / determine from formatComma (1,000)Dot (1.000)Ordinary spaceNonbreaking spaceNarrow spaceApostropheCurved apostropheInput digit groupingGroups of three (default)Indian grouping (12,34,567)Conversion mapping (one “before → after” per line)Enter only verified official spellingsInput time zoneUnspecified (do not infer an offset)Coordinated Universal Time (UTC)Japan (Tokyo)USA (New York)Interpretation of input durationDetermine from hours:minutes:seconds or similarMinutes:secondsSecondsMillisecondsMinutesHoursDecimal placesMinimum decimal placesMaximum decimal placesSignificant digitsMinimum valueMaximum valueDigits in the numeric partInput currency (no exchange-rate conversion)Determine from text (specify for ¥, $ and similar symbols)Japanese yenUS dollarEuroBritish poundSwiss francIndian rupeeChinese yuanKuwaiti dinar{v0} ({v1})Input phone-number country or regionDo not infer the countryJapanUSAUnited KingdomFranceGermanySouth KoreaChinaIndiaAustraliaFixed character countLetter countDigit countSeparatorCharacters per groupSeparatorPrefixSuffixFormat to checkMinimum charactersMaximum charactersDigit countAdditional allowed charactersAbbreviations to keep uppercase (comma separated)Characters to processSeparatorConsecutive blank linesIgnore input letter caseAllowed domains (comma separated)Also process signed URLs after verifying the effect on their meaningTracking parameters to remove (comma separated)Hosts to convert (comma separated)Allowed hosts (comma separated)Allowed schemes (e.g. https, comma separated)Path pattern to check (regular expression)I verified each part and the order of names and addressesSeparator between partsInterpretation of Excel numeric valuesCheck the original Excel number formatInternal date / date-time valueTime of day less than one dayDuration recorded as a number of daysAfter the main format, apply these steps in the listed order. If a step cannot determine a result, the cell returns to its original value.Additional formatting step {v0}Standard formatCustomHow to specifyFormat category for step {v0}Format for step {v0}Input interpretation and additional conditionsEnter one “before → after” mapping per line.Regular expression to matchOutput arrangement (blank for checking only)Move upMove downRemove this formatting stepAdd formatting stepYou can add up to eight formatting steps.Review the imported settings mappingChoose where the source files, sheets and columns apply in the current data. Current settings remain unchanged until you apply the mapping.Items not carried over from previous settingsI reviewed the unmigrated conditions. I will specify the columns myself.Settings source {v0} / {v1} / {v2} columnsSettings source to mapNo columns specified.File to apply toSheet to apply toSource columnCurrent data columnPrevious settings {v0}{v0} columnsDestination for {v0} (column number){v0} column {v1}Check the column number{v0}–{v1} / {v2} columns. Column A = 1, B = 2.Previous 50 columnsNext 50 columnsCancelApply settings with this mappingCould not apply the mapping. Check duplicate columns, column numbers and format settings. Current settings are retained.Apply the same format to other columnsSearch by column name or letterSearch destination columnsPrevious 50 columnsNext 50 columnsSelect visible columnsClear selection{v0} columns selected(no heading){v0} column {v1}{v0} columns selectedApply to selected columnsCancelCopy the format, input interpretation and additional steps for column {v0}. Existing settings in the selected columns will be replaced.Row to showColumn to showExample: A, XFDPrevious four rowsNext four rowsShowOriginal data at row {v0}, column {v1}Previous partNext partCloseYou can only review contents here. The original cell is not edited.(blank)This cell exceeds the display limit. Check its full contents in the original file.Blank.{v0}–{v1} / {v2} charactersCould not display the contents. Close this view and try again.No dataRowColumn {v0}{v0}{v1}(blank)BlankReview full contents at row {v0}, column {v1}: {v2}Original data: rows {v0}–{v1} / columns {v2}–{v3}Processing stoppedOriginal files remain unchanged.Review the settings and run again.Could not verify usage limitsProcessing has not started for safety.Reload the page. If the problem persists, contact the administrator.The total file size exceeds the limitThe total includes all added files.Reduce the files or choose split files.The total row count exceeds the limitHeading rows and hidden Excel sheets are included in the total.Split the files and read them again.The column count exceeds the limitReading stopped. Original files remain unchanged.Choose files with fewer columns.Could not read the CSV separatorsAn unclosed quote or similar problem prevents column positions from being determined.Check the indicated rows in the original software or save the CSV again.Check the column delimiterThe specified delimiter is unavailable.Choose comma, tab, semicolon or vertical bar.The encoding does not match the inputReading stopped without replacing characters.Change Input encoding and read again.Some characters cannot be saved in the selected encodingCharacters have not been replaced with “?” or other substitutes.Change the output encoding to UTF-8.Insufficient free space for the jobIncomplete files have not been saved as completed output.Free up space and run again.Too many Excel components to process at onceSheet and other job data exceed the number the server can safely clean up. Original files remain unchanged.Split files or sheets, or choose processing on this device.Job storage is unavailableThis job needs temporary storage.Use a supported browser or choose server processing.This long value was retainedThe value has not been truncated or changed.Check its location in the original file if needed.Could not determine how to interpret the valueThe original value was retained to avoid changing its meaning.Specify the input interpretation, such as date order, numeric separators or currency.Could not read the value as the specified formatThe original value was retained.Check the column settings and the displayed original value.The original value was retained because rounding would be requiredNo truncation or rounding was performed.Choose a format that preserves every digit.The input contains a nonexistent dateThe date was retained without rolling it into another date.Check the date in the original file.The value does not match the specified formatChecking only was selected, so the value remains unchanged.Check the desired format.Check the format settingsThese settings cannot be processed safely.Review the format examples and field explanations, then set them again.Could not read the column settings fileThe settings format is incorrect or incomplete. Current column settings and original data remain unchanged.Choose the JSON saved with Save column settings or a migration candidate exported from the administration screen.The column settings file is too largeSettings files up to 16 MB can be read. Current column settings and original data remain unchanged.Reduce the specified columns or additional steps, then save the settings again.This regular expression is unavailableSupported syntax is limited to prevent complex processing from becoming stuck.Use a pattern without lookahead, lookbehind or backreferences within the match.The formatted output exceeds the size that can be savedOriginal files remain unchanged.Split the files or review settings that greatly increase character counts.Could not complete processingOriginal files remain unchanged.Run again. If this repeats, give the displayed error code to the administrator.Job cleanup is incompleteSome temporary files could not be deleted. Original files are unaffected.Retry deleting job data. If this repeats, contact the administrator.Only the display of long values is shortenedFormat matching is not decided from this sample display.Full processing checks the original values.The signed URL was retainedChanging characters may invalidate the link.Check the issuer’s specifications and select it for processing only if needed.The scheme does not match the specified schemesThe URL remains unchanged.Check the allowed schemes, such as http and https.The domain is not selected for processingThe destination was not changed to another site.Check the target domain or host.The file count exceeds the limitAll added files are counted.Reduce the files and process them in batches.This file format is unsupportedChoose CSV, TSV or XLSX. Older Excel files (.xls) cannot be read.Save the file again as .xlsx or .csv in the original software.Could not verify file informationProcessing has not started.Check the file name and select it again.The original file changed after readingProcessing stopped to avoid confusing column positions or values.Select the current file again and review the column settings.A required column has no valueValues have not been added to blank or missing cells.Check the original data or clear Check blank cells for this column.Some date or time components needed for formatting are missingMissing days, seconds or other components have not been inferred or added.Choose a format using only components present in the original data.The input time zone is unspecifiedThe time has not been changed by inferring an offset.Specify the time zone under Input interpretation.This format requires additional settingsA required mapping, digit count or other setting is missing.Complete the settings below the selected format.The value is absent from the conversion mappingThe original value was retained without guessing from similar values.Add the required mapping or keep this value unchanged.The value contains characters that cannot be represented correctlyCharacters have not been replaced with substitutes.Check the location in the software that created the original file.Invisible characters change the text directionThe value was retained because its meaning might change.Check whether those characters are needed in the original data.The value contains invisible control charactersThey have not been removed automatically.Review their location and choose a removal format if needed.This complex character sequence was retainedLong sequences of combining characters were excluded from processing.Check the location in the original file.This date is outside the conversion rangeIt was retained without guessing calendar or regional boundaries.Choose a Gregorian year format or check the original date.The date and weekday do not matchNeither the date nor the weekday was changed automatically.Check the date and weekday in the original file.The formula cell was retainedThe formula and its saved calculation result were preserved.Make any required formatting changes in Excel.The protected sheet was retainedProtection has not been removed.An authorized person should review protection in the original software if changes are needed.The cell with character-level formatting was retainedIt was not changed, to preserve colors, bold and other formatting.Review character formatting in the original software if needed.The Excel error value was retainedErrors have not been replaced with zero or blank values.Check calculation results in the original Excel file.The number format was retained because conditional formatting is presentConditional formatting has not been deleted or changed.Check the desired display, including Excel conditional formatting.This representation cannot be reproduced with Excel number formatting aloneThe internal value and original format were retained.Choosing Format as text under Excel output type may allow conversion.Specify whether to interpret this number as a date or timeThis prevents unwanted conversions, such as turning identifiers into dates.Specify date, time or duration under Interpretation of Excel numeric values.The special Excel date value was retainedThe value corresponding to Excel’s February 29, 1900 was not converted into a real date.Check whether this value is intended in the original Excel file.The negative value cannot be converted into a date or timeThe original numeric value was retained.For durations, check the column category and input interpretation.The value was retained because Excel numeric conversion would change its digitsLong identifiers and precise decimals have not been rounded.Save it as text.Changing the Excel data type is requiredNumeric, text and Boolean types have not been changed automatically.Check Excel output type for the column.The formatted text exceeds Excel’s cell limitThe original cell was retained because the result exceeds 32,767 characters.Review settings that increase text length.This cell cannot be changed while preserving its structureThe original cell was retained.Make required changes in the original software.No more Excel styles can be addedThe original cell and style were retained.Use a shared format within each column or remove unnecessary styles in the original Excel file.This Excel file cannot be formatted directlyEncryption, digital signatures and macros are not stripped for saving.Keep the original file and export the required data to an ordinary .xlsx or .csv file.Expanded Excel data exceeds the processing limitUncompressed size and structure also have limits.Split sheets or files for processing.Could not read the Excel package structure correctlyOriginal files remain unchanged.Check that Excel can open the file, then save it again as .xlsx with another name.This Excel structure is unsupportedProcessing stopped without reading external files or definitions.Save it again as an ordinary .xlsx file in the original software.Could not finish writing the Excel fileIncomplete files are excluded from the save list.Check free space and run again.Check the display positionData could not be retrieved at the specified position.Choose the row number or page again.A job is already runningMultiple operations are prevented from starting simultaneously.Wait for completion or cancel before continuing.This job is open in another windowThe job is protected against simultaneous changes. Original files and job data are retained.Close the other tab using this job, then press Open this job again.Could not verify job dataOriginal files remain unchanged.Save the settings, then read the files again.Could not verify the job ownerOther users’ files cannot be accessed. Original job information has not been deleted automatically.Reload using the same browser and account.This job cannot be openedIts saving deadline may have expired or the job may have been deleted.Check the previous jobs list and restart from original files if needed.Could not start server processingServer processing is stopped because readiness or connection could not be verified.Process on this device or give this error code to the administrator.New jobs cannot be accepted right nowQueued jobs or jobs waiting to be saved have reached the limit.Save and delete a previous job, or wait briefly before continuing.The file upload is incompleteReceived data was checked, and processing stopped to avoid formatting mismatched contents.Check the connection and retry uploading the same original files.Settings were updated by another operationNew settings have not been overwritten with older settings.Reopen the job and review the current column settings.Server processing stopped before completionIncomplete files are excluded from the save list. Original files and settings are retained until their deadline.Reopen the job and run again. If this repeats, contact the administrator.These settings or display data exceed the size handled at onceIncomplete settings have not been applied.Split the target files, sheets or columns across separate operations.Could not save the fileThe completed server file is retained until its saving deadline.Check the connection and free space on your device, then save again.Initialization failedCould not prepare the interface. Reload the page.Could not verify the session. Reload the page.Automatic deletion by {v0} / {v1} minutes left to save (until {v2}). Activity does not extend the deadline.The saving deadline has been reached. Server files are being deleted. Select the original files again to start a new job.Error code: {v0}Reading filesUploading files to the serverChecking formats, rows and columnsPreparing column settingsWaiting in the processing queueChecking and formatting valuesPreparing output filesReady to saveStopping safelyProcessingChecking{v0} / {v1} files {v0} rows{v0}{v1} rows{v2} {v3}{v4}Current stepReviewedUpcoming(hidden) / protected{v0}{v1}{v2}{v0} rows × up to {v1} columnsCurrent {v0} previewColumn {v0}Standard formatCustomUnspecifiedShowing {v1} of {v0} columnsPrevious 50 columnsNext 50 columns{v0} columns specifiedColumn {v0} selectedColumn {v0}KeepCheckFormat{v0} patterns This format explicitly performs the specified conversion.{v0}{v1}Blank uses the format’s defaultUpdating the preview…No data.FormattedReviewMatchedKeptBlankRetry previewCould not update the preview. Your settings are retained.LoadedCheck interpretationRead again. Specify the columns you need. To reuse previous settings, review the column mapping before applying them.Check interpretationCould not complete checking with this interpretation. Change it and press Reread again. Original files and previous settings are retained.Save as Excel (.xlsx), retaining the original sheet structure.Output encodingUTF-8 (default)Original encoding ({v0})Line endingsPreserve original line endingsWindows (CRLF)Check whether the server is ready.Stored in private server storage. Work continues after closing this page. Data is automatically deleted within {v0} minutes of storage starting.Using temporary storage on this device. Delete job data after saving.Processing as small files. Closing the page loses the current job.Changed cellsFormat matchesReview / original value retainedUnspecified cells{v0} values were kept unchanged. Review the reasons and save.Processing of the specified columns is complete.{v0} / ready to saveSave with values requiring review retainedSave fileSaving of this file was confirmed. You can save it again.The file has not yet been saved to this device.Output fileReview this locationRow {v0}, column {v1}No values require review.Previous 50 issuesNext 50 issues{v0} issuesWriting to the destination…Writing to the destination: {v0}{v1}Saving complete. {v0}Press here to downloadThe file is ready. The download started. Check the save location on your device. Saving canceled. You can save again.Previous settings applied using the reviewed column mapping.Applied the same format to {v0} columns.Deletion accepted. Job information is retained until cleanup finishes to protect active saving transfers. Wait briefly, then press Delete job data again.Job data deleted. Original files remain unchanged.Stopping safelySaving confirmed.{v0} / example: {v1}Column settings imported using the reviewed mapping.Files are processed on this device. Their contents are not uploaded to the server. Original files remain unchanged.Starting uploads the selected files for server processing. Inputs, results and temporary files are automatically deleted within {v0} minutes of server storage starting. Original files remain unchanged.Delete the current job data before changing the processing location.Total {v0}, {v1} rows, {v2} columnsCSV / Excel (.xlsx), up to {v0} filesThe server needs preparation in the administration screenChoose candidates automatically (UTF-8 / Japanese CSV)Windows-31J (CP932 / Japanese Excel CSV)Check automaticallyComma (,)TabSemicolon (;)Vertical bar (|)This deviceServerA previous job remains on {v0}Upload incompleteConfiguring formatsQueuedReadingProcessingWaiting to saveSaving confirmedCanceledReview neededCleaning upCleanup can be retriedOpen this jobDelete the current job data before opening a previous job.Waiting for job cleanup. Retry with the delete button below.Select the original files again to resume: {v0}. Their contents will be checked before resuming.DateSpecify the original year/month/day order and validate the date. Options including time are also available here. Do not add missing time, seconds or UTC offsets.Year/month/day, two-digit month and dayFour-digit year and two-digit month/dayYear/month/day, variable-width month and dayRemove leading zeros from displayed month/dayYear-month-dayPreserve year/month/day orderYear.month.daySeparate with periodsDate with Japanese year/month/day charactersAdd the Japanese year/month/day charactersEight-digit year/month/daySave as an eight-character stringUS month/day/yearExplicit month/day/year orderUS month-day-yearExplicit month/day/year orderDay/month/year, two-digit month and dayExplicit day/month/year orderDay.month.yearExplicit day/month/year orderDay-month-yearExplicit day/month/year orderEnglish month name, US orderFix the month-name languageEnglish month name, UK orderDay/month/yearAbbreviated English month, hyphensFix capitalization of abbreviated month namesFrench month nameUse French month namesGerman month nameInclude the period after the daySpanish month nameUse language-specific connecting wordsKorean date notationSelect year/month/day wordsChinese date notationSpecify calendar and numeral system separatelyDate with weekdayCalculate weekday from a valid dateDate and 24-hour hours/minutesOnly when input contains a timeDate and 24-hour secondsPreserve secondsUS date and AM/PMConvert to 12-hour notationDay/month/year and secondsSpecify date order and time precisionGregorian and era calendarsSelect Gregorian-to-Japanese-era and Japanese-era-to-Gregorian conversions separately. Validate era periods and preserve time precision. A year alone may not identify an era boundary date.Gregorian date to Japanese era charactersGregorian inputJapanese era characters to Gregorian dateExplicit reverse directionGregorian date to abbreviated Latin eraFix abbreviation and year/month/day orderAbbreviated Latin era to Gregorian dateRegister R as ReiwaGregorian date to two-digit era yearPad era year with zerosTwo-digit era year to Gregorian dateInterpret year zeros numericallyFirst era year as the Japanese first-year characterSelect first-year notationJapanese first-era-year notation to Gregorian dateFirst era year means year 1 of that eraFirst-year character to year 1Change the display conventionYear 1 to first-year characterDate must fall within the eraHeisei date to Gregorian dateValidate Heisei's final dateGregorian date to HeiseiUse the correct era for that dateShowa date to Gregorian dateValidate Showa's final dateGregorian date to ShowaDo not force Showa outside its periodGregorian date/time to Japanese era date/timePreserve hours/minutes/secondsJapanese era date/time to Gregorian date/timeInterpret each input componentGregorian year/month to era year/monthNo era boundary within that monthEra year/month to Gregorian year/monthDo not add a dayGregorian year to era yearOnly when the year has a unique eraEra year to Gregorian yearShow year correspondence onlyGregorian date to Minguo calendarWithin the verified calendar-data periodMinguo date to Gregorian dateSpecify the calendarGregorian date to Thai Buddhist calendarFix the modern period and calendarThai Buddhist date to Gregorian dateSpecify day/month/year and Buddhist calendarYear/month, year and month/daySpecify the year/month, year or month/day type first. Removing information from a date or date/time is a separate explicit extraction. Missing components are not filled in here.Year-monthYear/month typeYear/monthYear/month typeYear.monthYear/month typeSix-digit year/monthPreserve as a stringJapanese year/month, variable widthNo month zero-paddingJapanese year/month, two-digit monthZero-pad the monthMonth/yearMonth/year orderMonth.yearMonth/year orderEnglish month name and yearFull month nameAbbreviated English month and yearAbbreviated month nameFrench month name and yearSpecify the languageYear and abbreviated English monthYear/month orderGregorian year, digits onlyYear typeGregorian year with Japanese characterYear typeMonth/dayMonth/day typeMonth-dayDo not add a yearJapanese month/dayMonth/day input orderFour-digit month/daySave as a stringDay/monthSpecify input and output orderMonth/day with month nameExplicitly exclude year validationTimeKeep clock time separate from elapsed duration. Do not add missing seconds, fractional seconds or time zones. Omitted subsecond/second components must be zero for formatting to be allowed.24-hour, two-digit hours/minutes24-hour notation24-hour, variable-width hourRemove leading zero from hour only24-hour hours/minutes/secondsHours/minutes/seconds inputJapanese hours/minutesPreserve hours/minutesJapanese hours/minutes/secondsPreserve secondsFour-digit hours/minutesString outputSix-digit hours/minutes/secondsString outputHours.minutesDistinguish from decimal hoursHours.minutes.secondsSpecify time interpretation12-hour, trailing AM/PM12-hour notation12-hour, two-digit hourZero-pad the hour12-hour with secondsPreserve seconds12-hour, lowercase am/pmSelect capitalization12-hour, leading AM/PMLeading notationJapanese AM/PMSpecify the languageJapanese AM/PM with secondsPreserve secondsJapanese AM/PM to 24-hour timeAlso validate midnight and noonAM/PM to 24-hour timeAM/PM requiredThree-digit millisecondsSpecify displayed time precisionSix-digit microsecondsNo roundingComma fractional secondsReplace decimal separatorTrim trailing fractional-second zerosSelect precision-display cleanupPreserve time with UTC offsetDo not convert regional time without a dateOmit zero seconds onlyOnly when seconds are zero; preserve and flag nonzero secondsDate and timeChoose date and time together. Preserve precision and UTC offsets; flag information that does not fit the format. Zone conversion requires source and target zones and preserves the same instant.Year-month-day and hours/minutesDo not add secondsYear-month-day and secondsPreserve secondsYear.month.day and secondsSpecify separatorsJapanese date and Japanese timePreserve all componentsJapanese date and 24-hour timeCombine Japanese characters and colonsJapanese date and AM/PM12-hour notationT separator, hours/minutesPreserve unspecified time zoneT separator, secondsDo not invent a time zoneT separator, millisecondsNo roundingT separator, microsecondsSix-digit precisionUTC offset to ZSource must be confirmed UTCZ to UTC offsetPreserve the instantAdd colon to UTC offsetPreserve the offset valueJapan time to UTCExplicitly select offset conversionUTC to Japan timeAsia/Tokyo outputUS month/day/year, seconds and AM/PMFix input year/month/day orderUS month name and hours/minutesMonth name and 12-hour timeUK month name and 24-hour timeDay/month/year and 24-hour timeGerman numeric date and hours/minutesDay/month/yearFrench month name and hours/minutesLanguage-specific connecting wordsKorean date/timeSpecify the languageChinese date/timeSpecify the languageTwelve-digit date/timeOutput as a stringFourteen-digit date/timeOutput as a stringCompact date/time with millisecondsFix each component's widthDate/time for filenamesOutput this cell as a stringDate/time with Japanese weekdayValidate weekday consistencyUTC to New York timeSpecify America/New_York and the time-zone database versionElapsed durationSpecify units and distinguish duration from clock time. Do not convert years or months to fixed seconds. Flag repeating decimals instead of rounding when converting to decimal hours.Total hours with colons and secondsPreserve durations exceeding 24 hoursTotal hours with colons and minutesInput without secondsSplit into days and hoursFixed duration: one day equals 24 hoursTotal hours with Japanese unitsDuration typeDays and colon notationFixed durationSpace-separated Latin unitsPreserve unitsConcatenated Latin unitsNo spacesISO duration, total hoursDuration formatISO duration, days and hoursOne day equals 24 hoursTotal minutes and secondsExplicit total minutes as the first componentInteger total secondsSpecify seconds as the unitTotal seconds to hours/minutes/secondsInput unit is secondsTotal millisecondsPreserve precisionMilliseconds to decimal secondsThree decimal placesDecimal hoursOnly exactly representable finite decimalsDecimal minutesNo roundingDecimal hours to hours/minutesInput unit is hoursExplicit negative durationColumn allows negative valuesAlign fractional-second widthMillisecond notationFixed-width total hoursFour-digit total hours, no truncationIntegers and numbersExplicitly identify numeric columns and use exact decimal values. Preserve leading zeros in identifiers and avoid floating-point precision loss. Specify numeral system, units and decimal separator.Full-width integer to ASCII digitsConvert digits onlyASCII integer to full-width digitsFor text displayOmit leading plusConfirm a positive numeric valueShow plus on positive numbersSpecify sign displayTrim leading numeric zerosNumeric column, not an identifierWhole-valued decimal to integerDecimal fraction is entirely zeroAdd zero before decimal pointKnown decimal syntaxParse decimal commaInput decimal separator is commaTrim trailing decimal pointOnly when this input syntax is allowedUnicode minus to ASCII minusSpecify U+2212 as the minus signArabic-Indic digits to ASCIISpecify arab numeral systemASCII to Arabic-Indic digitsUse arab numeral systemPersian digits to ASCIISpecify arabext numeral systemASCII to Persian digitsUse arabext numeral systemDevanagari digits to ASCIISpecify deva numeral systemASCII to Devanagari digitsUse deva numeral systemThai digits to ASCIISpecify thai numeral systemASCII to Thai digitsUse thai numeral systemAllow integers onlyDo not round decimals to integersAllow numbers within a specified rangeExample range 0–100; configured by the userDecimal displayDo not round. Preserve the original value if it cannot fit the specified precision exactly. Select preservation of trailing zeros when they represent measurement precision.One fixed decimal placeValues that fit exactly into one decimal placeTwo fixed decimal placesTwo fixed placesThree fixed decimal placesThree fixed placesFour fixed decimal placesFour fixed placesSix fixed decimal placesSix fixed placesZero decimal places, integers onlyDo not change nonzero fractionsTrim all trailing zerosColumn does not use precision notationMinimum two, maximum four placesConfigurable precision rangeMinimum one, maximum three placesPreserve zeros up to the minimum widthPreserve input decimal placesDo not drop trailing zeros during parsingDecimal comma, two placesSpecify input and output decimal separatorsDecimal comma, three placesThree fixed placesDecimal comma to periodPreserve two decimal placesLeading zero for values below oneInput decimal separator is periodLeading zero for negative fractionsPreserve minus signDecimal with positive signSpecify two decimal places and signFull-width decimal displayText display, two fixed placesArabic-digit decimal displaySpecify numeral system and decimal separatorCheck decimal-place limitUp to two decimal places; no roundingCheck significant-digit limitExample: up to four significant digits; no roundingDigit groupingSpecify decimal and grouping separators separately. Distinguish space U+0020, NBSP U+00A0 and NNBSP U+202F. Do not substitute characters during encoding conversion.Three-digit comma grouping, integerNumeric columnThree-digit commas and decimal periodPreserve the decimal fractionRemove groupingInput uses comma groupingThree-digit periods and decimal commaSpecify output regionThree-digit ordinary spacesSpace U+0020Three-digit NBSP and decimal commaPreserve NBSPThree-digit NNBSP and decimal commaPreserve NNBSPThree-digit ASCII apostrophesASCII quoteThree-digit right apostrophesU+2019Indian three-digit then two-digit groupsFinal three digits, then two-digit groupsRemove Indian groupingValidate group placement before removalIndian to three-digit groupingPreserve numeric meaningThree-digit to Indian groupingInput uses three-digit groupsArabic grouping separatorsSpecify digits, thousands and decimal separatorsFull-width digits and commasString outputComma to period groupingFix input separator meaningSpace grouping to commasSpecify NNBSP and decimal commaCustom underscore groupingExplicit custom format, distinct from ordinary CSV numbersDo not group four-digit integersStart grouping at five digitsCheck invalid group placementExample with three-digit groupingExponential notationParse exact decimal values. Flag insufficient mantissa precision without rounding. Stop safely if expansion into ordinary notation would produce excessive output.Uppercase EPreserve exponent valueLowercase ePreserve exponent valueShow plus on positive exponentPositive exponent signOmit plus on positive exponentPreserve exponent valueTwo-digit fixed exponentTwo-digit positive exponentTwo-digit signed exponentShow positive and negative signsThree-digit signed exponentThree-digit exponentTrim excess exponent zerosMinimum-width notationNormalize mantissa to one integer digitOne-digit integer partOrdinary integer to scientific notationPreserve valueDecimal to negative exponentPreserve valueScientific notation to ordinary integerPreserve precisionScientific notation to ordinary decimalPreserve precisionEngineering notationExponent is a multiple of threeEngineering to scientific notationNormalize the mantissaAdd trailing mantissa zerosSpecify four decimal placesTrim trailing mantissa zerosSelect precision-display cleanupMantissa with decimal commaRegional decimal separatorMultiplication-symbol notationOutput as a text display formatValidate exponent syntaxInteger exponent; no guessed correctionsNegative-number notationEstablish negative numeric meaning before changing notation. Users explicitly choose whether parentheses, △ or ▲ mean negative values. Preserve signs and decimal precision.Leading ASCII minusInterpret parentheses as negativeLeading Unicode minusUse U+2212Full-width minusUse U+FF0DParenthesized integerParentheses represent a negative valueParenthesized grouped numberThree-digit groupingParenthesized decimalExactly representable in two decimal placesFull-width parenthesesSelect parenthesis widthTrailing minusExplicit trailing signTrailing minus to leading minusInterpret trailing sign as negativeInteger with △Specify △ as negativeInteger with ▲Specify ▲ as negative△ to minusAccounting interpretation▲ to minusAccounting interpretationSpace after minusSpecify sign position and spacingTrim space after minusDistinguish from internal numeric spacesGerman parenthesized negativeSpecify region and decimal precisionFrench negative notationNNBSP groupingLeading zero on negative decimalPreserve minus signFixed-width negative integerFive-digit numeric display widthColumn prohibiting negativesDo not convert to absolute valueAmounts and currenciesEstablish currency from column settings or an explicit input code. Do not infer it from symbols or convert exchange rates. Unit characters such as the Japanese yen character are selectable output formats. Retain the column's currency setting when hiding currency labels.Trailing Japanese yen character, no groupingConfirm JPYTrailing Japanese yen character, groupedConfirm JPYSpace before Japanese yen characterInclude a spaceDecimal amount with trailing yen characterExactly representable in two decimal placesFull-width digits and yen characterFor text displayLeading yen symbolCurrency is JPYLeading full-width yen symbolU+FFE5Leading JPY codeParse Japanese yen character as JPYTrailing JPY codeSpecify code positionJapanese yen character to numeric value onlyColumn fixed to JPY; retain currency in settingsAdd unit to known yen amountInput column explicitly set to JPYNegative amount and yen characterPreserve signParenthesized amount and yen characterSpecify parentheses as negative notationYen symbol to Japanese yen characterExplicit JPY; do not confuse with CNYUS dollar codeCurrency is USDUS dollar symbolExplicit USDUS dollars with Japanese charactersNo currency conversionTrailing euro symbolSpecify currency and regionEuro with NNBSP groupingGrouping separator is NNBSPPound sterling symbolCurrency is GBPSwiss franc codeCurrency is CHFIndian rupee with Indian groupingCurrency is INRChinese yuan code and trailing unitCurrency is CNY; do not change to JPYThree-decimal currency notationSpecify KWD; no roundingRatios and percentagesFix input units to ratio, percent, permille or basis points. Preserve the represented proportion. Do not turn blanks into zero or repeatedly multiply by 100 on reruns.Ratio to percentInput is a ratioPercent to ratioOutput is a ratioAdd percent symbol to numeric percentageInput is a numeric percentageOmit percent symbolFix column unit to percentSpace before percent symbolPreserve meaningDecimal comma and spaceSpecify the regionPercent with two decimal placesNo roundingInteger percentOnly when fraction is zeroTrim trailing percentage zerosSpecify display-precision cleanupFull-width percent displayText displayJapanese percent wordingSpecify display labelRatio to permilleInput is a ratioPermille to ratioParse parts per thousandPercent to permillePreserve the proportionPermille to percentPreserve the proportionRatio to basis points1 bp equals a ratio of 0.0001Basis points to ratioExplicit unitsPercent to basis pointsNo exchange-rate or other calculationsSigned percentShow plus on positive valuesCheck proportion rangeWhen user explicitly specifies 0–100%Postal codesVerify country-specific numbering metadata against official sources when adopting it. Examples describe formats, not actual addresses. Do not infer missing digits, country or address.Japanese seven digits with hyphenThree digits plus four digitsJapanese seven digits onlyPreserve leading zerosAdd Japanese postal symbolDo not duplicate an existing symbolSpace after postal symbolSpecify space positionRemove Japanese postal symbolPreserve digits and separatorsJapanese full-width code to ASCIIOnly specified digits and separatorsPreserve US five-digit ZIPPreserve leading zerosUS nine digits with hyphenSpecify ZIP+4 inputUS ZIP+4 to nine digitsDestination explicitly requires no separatorDetect short US five-digit ZIPDo not invent zero-paddingSpace in Canadian alphanumeric codeValidate country-specific allowed charactersUppercase Canadian lettersFollow postal-code rulesRemove Canadian code spaceExplicit destination formatSpace between UK outward/inward codesUse variable-length country rulesUppercase UK lettersValidate allowed characters and structureGerman five-digit formatNot validation of an actual addressFrench five-digit formatSpecify countryAustralian four-digit formatSpecify countrySpace between Dutch digits and lettersValidate country-specific allowed charactersIndian six-digit formatValidate country-specific PIN conditionsPhone and fax numbersSpecify input country and output style; preserve the main number, country code and extension. Fix the country-definition version. Correct length does not establish existence, subscription or callability.Add hyphens to Japanese mobile numberUse country-specific mobile rulesGroup Japanese landline numberUse area-code metadata to choose positionsGroup Japanese toll-free numberValidate number typeJapanese domestic digits onlyPreserve leading zeroJapanese domestic to international numberInput country is JapanJapanese international to domestic numberOutput country is JapanSpaces in Japanese international numberCountry-specific grouping rulesFull-width phone number to ASCIIOnly digits and specified separatorsParenthesized area code to hyphensConfirm domestic numberNorth American parenthesesSpecify output regionNorth American hyphensSpecify domestic formatNorth American domestic to internationalExplicit input regionUK domestic formatUse country metadataUK international formatInput country is UKFrench domestic to internationalValidate input country and number structure00 dialing prefix to plusSpecify 00 as dialing prefix011 dialing prefix to plusExplicit dialing regionJapanese extension notationPreserve extensionEnglish extension notationPreserve main number's region settingsSpecified format including extensionExplicit destination-specific notationIDs and product codesPreserve IDs as strings. Users can specify length, prefixes and allowed characters; example lengths are not fixed requirements. Pad zeros or change separators only when the ID rules treat the result as identical.Validate exactly eight digitsRegular expression [0-9]{8}Validate exactly ten alphanumeric charactersTen ASCII alphanumeric charactersValidate variable-length digitsExample allows 1–12 digitsSeparator between letters and digitsTwo letters and six digitsRemove code separatorSeparator is decorative under the ID rulesGroup every four digitsPreserve all eight digitsUppercase letter componentID rules treat case as equivalentLowercase letter componentID rules treat case as equivalentLeft zero-pad to six digitsUser specifies fixed width and zero-paddingRight space-pad to fixed widthSix-character width; spaces are display markersComponent-specific zero-paddingSix-digit numeric-component ruleNormalize separator to hyphenFull-width separator to ASCIIFixed prefix formatINV-, four-digit year and four-digit sequenceFixed suffix formatSpecify trailing JPStandard lowercase UUIDValidate UUID structureAdd UUID hyphensExplicit UUID typeWildcard prefixSpecified format INV-*Validate components with regexSpecified format [A-Z]{2}-[0-9]{6}ID allowing Unicode charactersDefine letter/numeric component boundaryDetect excess lengthEight-digit requirement; no truncationFull-width and ASCII alphanumericsSpecify character types and ranges; change width only. Do not remove accents, transliterate or merge visually similar characters. Options can target only one character type.Uppercase letters to ASCII onlyExclude lowercase lettersLowercase letters to ASCII onlyExclude uppercase lettersAll Latin letters to ASCIIPreserve digitsDigits to ASCII onlyPreserve lettersAlphanumerics to ASCIIPreserve symbols and kanaUppercase letters to full width onlyPreserve lowercase lettersLowercase letters to full width onlyPreserve uppercase lettersAll Latin letters to full widthPreserve digitsDigits to full width onlyPreserve lettersAlphanumerics to full widthPreserve symbols and kanaAlphanumerics and parentheses to ASCIISpecify target parenthesesAlphanumerics and parentheses to full widthSpecify target parenthesesDigits and decimal point to ASCIIDecimal-point meaning establishedDigits and decimal point to full widthText displayDigits and minus sign to ASCIISelect full-width minus signDigits and minus sign to full widthText displayAlphanumerics and spaces to ASCIIExplicitly include full-width spacesAlphanumerics and spaces to full widthExplicitly include spacesASCII-only validationDo not change accented e to plain eASCII validation of alphanumeric parts onlyAllow kanji; flag full-width lettersKatakana widthUse the same settings for Japanese fields overseas; do not invent country-specific kana formats. Separate unvoiced, voiced, small-character and symbol targets. Preserve meaning and pronunciation.Unvoiced kana to full widthTarget unvoiced charactersUnvoiced kana to half widthCorresponding half-width charactersVoiced kana to full widthRecognize combining voiced marksVoiced kana to half widthOutput base and voiced markSemi-voiced kana to full widthPreserve semi-voiced markSemi-voiced kana to half widthPreserve semi-voiced markSmall kana to full widthPreserve small-character formSmall kana to half widthDo not replace small kana with regular-size kanaLength mark to full width onlyExplicitly target length mark onlyLength mark to half width onlyPreserve other charactersMiddle dot to full width onlyU+FF65 to middle dotMiddle dot to half width onlyTarget middle dot onlyKana punctuation to full widthHalf-width kana punctuationKana punctuation to half widthDistinct from ASCII comma and periodCorner brackets to full widthTarget brackets onlyCorner brackets to half widthTarget brackets onlyKana and associated symbols to full widthTarget kana, length marks, middle dots and bracketsKana and associated symbols to half widthFlag characters without half-width equivalentsValidate full-width kana fieldFull-width kana and specified allowed symbolsValidate half-width kana fieldHalf-width kana and specified allowed symbolsHiragana and katakanaConvert only defined syllabic-character correspondences. Do not generate kanji readings, readings from Latin letters or vowels for length marks. Width conversions can be combined explicitly.Unvoiced hiragana to katakanaTarget unvoiced charactersUnvoiced katakana to hiraganaConvert corresponding charactersVoiced hiragana to katakanaTarget voiced charactersVoiced katakana to hiraganaTarget voiced charactersSemi-voiced hiragana to katakanaTarget semi-voiced charactersSemi-voiced katakana to hiraganaTarget semi-voiced charactersSmall hiragana to katakanaDo not enlarge charactersSmall katakana to hiraganaDo not enlarge charactersHiragana vu to katakana vuPreserve voiced marks and small formsKatakana vu to hiragana vuSame pronunciationHiragana to half-width kanaCharacters with half-width equivalentsHalf-width kana to hiraganaAlso process voiced marksMixed kana to full-width katakanaPreserve spacesMixed kana to hiraganaPreserve spacesMixed kana to half-width kanaFlag characters without equivalentsConvert kana only, preserve kanjiDo not generate kanji readingsConvert kana only, preserve Latin lettersDo not transliterate Latin lettersValidate hiragana onlySpecify allowed spaces and symbols separatelyValidate katakana onlySpecify permitted widths separatelyAllow hiragana and katakanaDo not infer or fill in pronunciationLetter caseApply only to columns treating case differences as equivalent values. Fix the language and preview length changes. Do not guess correct proper-name spellings.Uppercase all ASCII lettersASCII letters onlyLowercase all ASCII lettersASCII letters onlyUppercase ASCII, preserve other languagesExclude non-ASCII charactersLowercase ASCII, preserve other languagesExclude non-ASCII charactersUppercase Unicode lettersFix language and Unicode versionLowercase Unicode lettersPreserve accentsCapitalize word initialsSpecify word-boundary rulesCapitalize string initial onlyPreserve the restLowercase string initial onlyOnly where equivalence is allowedCapitalize hyphen-separated component initialsSpecify separator rulesUppercase Turkish iTurkish tr language rulesLowercase Turkish IDistinguish from ASCII rulesUppercase German text containing sharp sExplicit output rule using SSLowercase capital sharp SInput contains capital sharp SUppercase GreekHandle final sigmaLowercase GreekHandle word-final rulesUppercase CyrillicDo not convert to Latin lettersUppercase specified prefix onlySpecify component before hyphenLowercase specified suffix onlySpecify component after hyphenCapitalize words with acronym dictionarySpecify dictionary preserving USALeading and trailing whitespaceUsers select target whitespace. Preserve internal cell content and distinguish whitespace inside and outside CSV quotes. Visible symbols represent actual space, tab, LF and CR characters.Remove leading ASCII spaces onlyU+0020 onlyRemove trailing ASCII spaces onlyU+0020 onlyRemove ASCII spaces at both endsPreserve internal ASCII spacesRemove leading full-width spaces onlyU+3000 onlyRemove trailing full-width spaces onlyU+3000 onlyRemove full-width spaces at both endsPreserve internal spacesRemove leading tabs onlyTarget tabs onlyRemove trailing tabs onlyTarget tabs onlyRemove tabs at both endsPreserve internal tabsRemove leading NBSPExplicitly select U+00A0Remove trailing NBSPExplicitly select U+00A0Remove NBSP at both endsPreserve internal numeric groupingRemove leading NNBSPExplicitly select U+202FRemove trailing NNBSPExplicitly select U+202FRemove NNBSP at both endsPreserve internal NNBSPRemove selected mixed whitespace at both endsSelect target character setRemove leading in-cell newlines onlyExplicit LFRemove trailing in-cell newlines onlyExplicit LFValidate no surrounding whitespaceFlag only; do not removeDistinguish invisible boundary charactersDo not assume zero-width characters are ordinary spacesRepeated spaces, tabs and in-cell newlinesChange selected characters and positions only. Operations that may alter meaning or paragraphs are explicit conversions. Configure CSV record newlines and in-cell newlines separately.Repeated ASCII spaces to oneColumn where space count has no meaningRepeated full-width spaces to oneTarget full-width spaces onlyMixed spaces to one ASCII spaceSelect target space typesMixed spaces to one full-width spaceOutput full-width spaceTab to one ASCII spaceCheck whether tabs provide alignmentTab to four ASCII spacesFixed replacement, not tab-stop expansionTab to full-width spaceFixed replacementRepeated tabs to oneColumn where tabs are not meaningful delimitersCRLF to LFPreserve newline countLF to CRLFDo not duplicate existing CRLFCR to LFExplicit standalone CR newlinesMixed newlines to LFPreserve newline positionsNewline to ASCII spaceShow that paragraph boundaries are lostNewline to full-width spaceExplicitly select single-line conversionNewline to specified separatorUser specifies separatorExcess blank lines to oneSpecify retained paragraph-boundary countRemove trailing space on each linePreserve internal line spacesRemove leading space on each lineExplicit removal of indentationNBSP to ordinary spaceColumn does not need nonbreaking semanticsValidate no in-cell newlinesDo not automatically flatten linesHyphens and symbolsSpecify symbols and positions. Length marks, minus signs, range dashes and name apostrophes are not necessarily equivalent. Follow the selected correspondence table; do not indiscriminately change formulas or URLs.Full-width hyphen to ASCIISpecify U+FF0D as separatorNonbreaking hyphen to ordinary hyphenSpecify U+2011 as separatorEn dash to code separatorExclude range notationEm dash to code separatorExplicit separator useHyphen to full widthSpecify outputFull-width parentheses to ASCIITarget parenthesesASCII parentheses to full widthTarget parenthesesFull-width square brackets to ASCIITarget bracketsASCII square brackets to full widthTarget bracketsFull-width colon to ASCIISpecify target positionFull-width semicolon to ASCIICharacter inside the cellFull-width slash to ASCIISeparator useFull-width backslash to ASCIIU+FF3C; distinguish from yen symbolFull-width ampersand to ASCIISpecify notation rulesFull-width at sign to ASCIIRevalidate syntax after conversion for email typeSmart double quotes to ASCIIDistinct from CSV enclosing quotesSmart single quotes to ASCIISpecify quotation useCurved name apostrophe to ASCIIExplicit setting treating the spelling difference as equivalentEllipsis to three periodsShow character-count changeThree periods to ellipsisExplicit setting; do not apply to URLs or similar dataUnicode representationSeparate Unicode normalization from targeted compatibility-character conversions. NFKC/NFKD and superscript changes may alter meaning; apply only to explicitly selected uses. Do not silently remove zero-width or bidirectional controls.Normalize to NFCCompose combining characters; fix normalization versionNormalize to NFDDecompose composed charactersCompatibility-normalize to NFKCColumn treating compatibility differences as equivalentCompatibility-decompose to NFKDChange compatibility and composition differencesNFC in kana range onlyLimit to kana and combining voiced marksNFD in kana range onlyPreserve other scriptsNFC in Hangul range onlyDefined Hangul correspondences onlyNFD in Hangul range onlyPreserve other charactersNormalize combining-mark orderNFD canonical order; do not remove marksCompatibility Latin font to ordinary lettersOnly columns without mathematical distinctionsExpand Latin ligaturesExplicitly treat ligatures as the same spellingRoman numeral compatibility characters to lettersDistinct from conversion to numeric 4Circled digits to ordinary digitsOnly when defined as equivalent codes; check item-number uses carefullySuperscript digits to ordinary digitsProhibit exponent, area and other formula usesSubscript digits to ordinary digitsProhibit chemical-formula or other meaningful usesExpand unit compatibility charactersPreserve the unit itselfCheck NFC conformityFlag status without normalizationCheck NFD conformitySetting requiring decomposed formCheck NFKC conformityDo not perform compatibility conversionDetect bidirectional controlsMake display-order controls visibleBoolean and category valuesUsers select mappings. Do not silently classify unregistered values as false or other. Blank, unknown and not applicable are distinct values. Each pattern registers the described pair together.TRUE/FALSE to JapaneseSelect Boolean mappingJapanese to TRUE/FALSEFix correspondenceBoolean to 1/0System where 1 means true1/0 to BooleanExplicitly define 0 as falseBoolean to English Yes/NoPreserve meaningEnglish Yes/No to JapaneseSpecify case handling separatelyY/N to TRUE/FALSESelect mappingTRUE/FALSE to Y/NSelect mappingOn/Off to BooleanConfirm enabled/disabled meaningJapanese present/absent to BooleanDefine presence/absence as BooleanJapanese possible/impossible to BooleanDefine possibility as BooleanJapanese allow/deny to category codeMeaning comes from user's mappingFrench Boolean notationSpecify display languageGerman Boolean notationSpecify display languageSpanish Boolean notationPreserve accentsChinese Boolean notationExplicit column meaningKorean Boolean notationExplicit column meaningLowercase Boolean notationChange textual notation onlyCustom code/name correspondenceUser-defined dictionaryDetect unknown categoryDo not automatically classify as otherEmail addressesParse address strings without sending mail or checking existence. Preserve local-part case, dots and plus tags. Multiple-address settings change notation within one cell without adding rows or columns.Trim surrounding ASCII spacesUnnecessary outer spaces onlyLowercase domain onlyPreserve local-part UserFull-width at sign to ASCIIUser explicitly selects width repairFull-width domain letters to ASCIIDomain part onlyInternationalized domain to ASCIIFix IDNA method and versionInternationalized domain to UnicodeOnly reversible formsmailto notation to addressOnly when no query other than recipient existsAddress to mailto notationDo not execute as a linkAngle-bracket address to bare addressOnly without a display nameAddress to angle bracketsSpecify output formatNormalize display-name quotesPreserve name and addressMultiple addresses separated by semicolonsParse each address and preserve orderMultiple addresses separated by newlinesProcess within one cellValidate ASCII address syntaxNo delivery guaranteeAllow internationalized local partReceiver support is separate; validate EAI syntaxAccept allowed domains onlyExample allows example.test onlyValidate one address per cellDo not join or deleteValidate plus-tag preservationContract preserves tagValidate local-part case preservationDo not automatically lowercase the whole addressDetect newline inside addressDo not guess how to join invalid fragmentsURLsExplicitly select http-to-https conversion. Rewriting may change the destination; preview it as an explicit conversion without guaranteeing reachability or identical content. Do not access URLs. Even normalization can invalidate signed URLs; explicitly configure whether to include them.http to httpsChange scheme only; preserve host, path, query and fragmenthttps for specified hosts onlyOnly matches in the allowed-host listAdd https to scheme-less inputOnly input explicitly identified as a Web URLProtocol-relative URL to httpsSpecify https as base schemeLowercase schemePreserve path caseLowercase hostPreserve user information and pathTrim surrounding URL spacesDo not apply inside URLInternationalized host to ASCIIFix IDNA method and versionInternationalized host to UnicodeHost onlyOmit default HTTP portURL without signatures or other string dependenciesOmit default HTTPS portURL without signatures or other string dependenciesExplicit default HTTPS portSpecify output formatEmpty path to slashURL without signatures or other string dependenciesAdd trailing slashUser confirms equivalence on this siteRemove trailing slashExplicit site rulesAdd wwwLimit to known host correspondencesRemove wwwLimit to known host correspondencesOld host to new hostUse user's migration correspondence tableRemove tracking queriesSpecify keys to remove; exclude signed URLsRemove fragment identifierShow destination-position changeUppercase percent-encoding hex digitsExclude signed URLs and similar casesDecode unreserved charactersExclude reserved characters and signed URLsValidate allowed schemes and hostsExample allows https onlyValidate custom path formatPath regex /products/[A-Z]{2}-[0-9]{6}Company names, personal names and addressesProvide company/name/address subcategories. Expanding the Japanese company abbreviation is an explicit option. Do not infer name identity or component meaning. Users specify positions, country, interpretation and dictionary. Do not join/split columns or generate new information.ASCII company abbreviation to full Japanese nameTarget leading corporate abbreviationFull-width company abbreviation to full Japanese nameTarget leading corporate abbreviationCorporate Unicode symbol to full Japanese nameExplicit Unicode-symbol meaningExpand trailing corporate abbreviationPreserve trailing positionFull Japanese company type to ASCII abbreviationUser selects abbreviated outputFull Japanese company type to full-width abbreviationSpecify abbreviated outputExpand Japanese limited-company abbreviationPreserve corporate typeJapanese limited-company name to abbreviationSpecify abbreviationExpand defined Japanese LLC abbreviationUser defines abbreviation as that corporate typeSpace between corporate type and company nameEstablished corporate-component boundaryTrim excess space after corporate typePreserve company-name internal spacesDictionary conversion of leading/trailing corporate typeOnly when user's dictionary confirms an alternate name for that companyLtd. to LimitedSpecify abbreviation correspondence for the companyLimited to Ltd.Specify output name for the companyInc. to IncorporatedSpecify abbreviation correspondence for the companyCustom official-company-name dictionaryUser's one-to-one dictionary; do not infer legal namesFull-width name separator to ASCII spaceExplicit family/given-name separatorASCII name separator to full-width spacePreserve boundaryFamily, given formatOnly input with established given/family componentsGiven family formatComponents established by commaPeriod after middle initialExplicitly identify A as an initial; do not abbreviate namesTrim name spaces, preserve curved apostrophesPreserve internal spellingPreserve compound-surname internal spacesSetting that retains de laPreserve name accentsDo not lose accents during ASCII conversionFull-width address-number digits to ASCIISpecify address-number part onlyJapanese block numbers to hyphensDo not infer all address kanji numeralsHyphenated address numbers to Japanese block notationColumn with confirmed block/lot/number componentsMultiline address to single lineExplicit newline-to-space conversionSpecified address separator to newlineExplicitly define slash as address-component separatorUS state name to codeConfirm state field and use mappingUS state code to nameSpecify US country and state fieldCountry within address to specified nameCountry-field mapping; do not apply to free textThe server needs preparation. You can continue processing on your PC.<div id="jin-format-ui"> <main class="jj-shell"> <div class="jj-intro"> <div class="jj-member"></div> <div class="jj-privacy"><i data-lucide="shield-check" aria-hidden="true"></i><span id="jj-privacy-copy">Files are processed on this device. Contents are not uploaded to the server. Original files remain unchanged.</span></div> <nav class="jj-steps" aria-label="Steps"> <div class="jj-step" data-step="1"><span class="jj-step-no">1</span><span><strong>Choose files</strong><small>Selected</small></span></div> <span class="jj-step-line" aria-hidden="true"></span> <div class="jj-step" data-step="2" aria-current="step"><span class="jj-step-no">2</span><span><strong>Review column formats and formatting</strong><small>Current step</small></span></div> <span class="jj-step-line" aria-hidden="true"></span> <div class="jj-step" data-step="3"><span class="jj-step-no">3</span><span><strong>Save</strong><small>Upcoming</small></span></div> </nav> </div> <div class="jj-main"> <div class="jj-mode-area"> <div class="jj-section-label">Processing location</div> <div class="jj-modes" role="group" aria-label="Processing location"> <button class="jj-mode cursor-interaction" type="button" data-mode="pc" aria-pressed="true"><i data-lucide="monitor" aria-hidden="true"></i><span><strong>Process on this device <em>Default</em></strong><small>Process on this device without uploading files</small></span><span class="jj-radio" aria-hidden="true"></span></button> <button class="jj-mode cursor-interaction" type="button" data-mode="server" aria-pressed="false"><i data-lucide="server" aria-hidden="true"></i><span><strong>Process on the server</strong><small>Reduce processing load on this device</small></span><span class="jj-radio" aria-hidden="true"></span></button> </div> </div> <p id="jj-server-deadline" class="jj-server-deadline" hidden></p> <section id="jj-stage-one" aria-label="Choose files"> <div class="jj-drop"><div class="jj-drop-icon"><i data-lucide="file-up" aria-hidden="true"></i></div><h2>Choose files to standardize</h2><p>CSV / Excel (.xlsx), up to 20 files</p><button type="button" id="jj-load" class="jj-button jj-primary cursor-interaction"><i data-lucide="folder-open" aria-hidden="true"></i>Choose files</button><small>Drag files here to add them.</small></div> <details class="jj-more"><summary>Input encoding, delimiter and headings</summary><div class="jj-option-grid"><label>Input encoding<select id="jj-read-encoding"></select></label><label>Column delimiter<select id="jj-read-delimiter"></select></label><label class="jj-checkbox"><input id="jj-read-header" type="checkbox" checked>Use the first row as headings</label></div><p>If text is not read correctly, specify the interpretation here and choose the files again.</p></details><input id="jj-file-input" type="file" accept=".csv,.tsv,.txt,.xlsx" multiple hidden> </section> <section id="jj-stage-two" hidden aria-label="Review column formats and formatting"> <div class="jj-file-switch"><label>File<select id="jj-files"></select></label><label id="jj-sheet-label">Sheet<select id="jj-sheets"></select></label></div><div class="jj-file-strip"><span class="jj-file-symbol"><i data-lucide="file-spreadsheet" aria-hidden="true"></i></span><div><strong id="jj-file-name"></strong><span id="jj-file-info"></span></div><span class="jj-file-tag">Loaded</span><button type="button" class="jj-text-button cursor-interaction" id="jj-change-file">Change files</button></div> <details id="jj-reread-options" class="jj-more"><summary>Change input encoding, delimiter and headings</summary><p>Read the current file again and clear its column settings. Previous settings can be reused after reviewing column mappings.</p><div class="jj-option-grid"><label id="jj-reread-encoding-label">Input encoding<select id="jj-reread-encoding"></select></label><label id="jj-reread-delimiter-label">Column delimiter<select id="jj-reread-delimiter"></select></label><label class="jj-checkbox"><input id="jj-reread-header" type="checkbox">Use the first row as headings</label></div><button type="button" id="jj-reread" class="jj-button">Reread with this interpretation</button></details> <button type="button" id="jj-previous-settings" class="jj-text-button" hidden>Review mappings and reuse previous column settings</button> <div id="jj-analysis-content"> <section class="jj-source-preview" aria-labelledby="jj-source-title"> <div class="jj-source-heading"><h3 id="jj-source-title">Current CSV preview</h3><span>Original data: first four rows / all eight columns</span></div> <div class="jj-source-scroll" role="region" aria-label="Original data table. Scroll horizontally to review all columns."><table class="jj-source-table" id="jj-source-table" aria-labelledby="jj-source-title"></table></div> <div class="jj-source-caption"><span>Select columns using their headings. Press a cell to review its full contents.</span><span id="jj-source-selection" role="status" aria-live="polite"></span></div> </section> <div class="jj-work-heading"><div><h2>Choose the desired format for each column</h2><p>Unspecified columns remain unchanged.</p></div><span class="jj-counter" id="jj-selected-count">5 / 8 columns specified</span></div> <button type="button" id="jj-return-results" class="jj-text-button" hidden>Return to results and saving</button><div class="jj-sample-tools"><span id="jj-config-label">Specify only the columns you need</span><button type="button" id="jj-reset" class="jj-text-button cursor-interaction">Clear all column settings</button></div> <div class="jj-workspace" id="jj-editor-layout"> <aside class="jj-column-panel" aria-label="Column list"> <label class="jj-search"><i data-lucide="search" aria-hidden="true"></i><input id="jj-column-search" type="search" placeholder="Search by column name" aria-label="Search by column name"></label> <div id="jj-columns" class="jj-columns"></div> <div class="jj-column-footer" id="jj-column-footer"></div> </aside> <section class="jj-rule-panel" aria-labelledby="jj-column-title"> <div class="jj-rule-heading"><div><span id="jj-column-letter" class="jj-letter">A</span><h3 id="jj-column-title">Transaction date</h3></div><span id="jj-mode-badge" class="jj-pill">Format</span></div> <button type="button" id="jj-copy-rule" class="jj-text-button">Apply this format to other columns</button><div class="jj-rule-tabs" role="group" aria-label="How to specify a format"><button type="button" data-rulemode="none" class="cursor-interaction" aria-pressed="false">Unspecified</button><button type="button" data-rulemode="preset" class="cursor-interaction" aria-pressed="true">Choose a standard format</button><button type="button" data-rulemode="custom" class="cursor-interaction" aria-pressed="false">Specify a custom format</button></div> <div id="jj-none-panel" hidden><div class="jj-preserve"><i data-lucide="lock-keyhole" aria-hidden="true"></i><h4>Keep this column unchanged</h4><p>Values and leading zeros remain unchanged.<br>Their format is not checked either.</p></div></div> <div id="jj-preset-panel"> <div class="jj-form-row"><label>Format category<select id="jj-category"></select></label><label>Input interpretation<select id="jj-input-format"></select></label></div> <label class="jj-full-label">Desired format <span id="jj-pattern-count">24 patterns</span><select id="jj-pattern"></select></label> <div class="jj-example" aria-label="Selected format example"><div><span>Original representation</span><strong id="jj-example-before">2026/9/3</strong></div><i data-lucide="arrow-right" aria-hidden="true"></i><div><span>Formatted representation</span><strong id="jj-example-after">2026-09-03</strong></div></div> <p class="jj-rule-condition" id="jj-rule-condition">Format only values whose year, month and day order can be determined.</p> <details class="jj-more"><summary class="cursor-interaction">Search other patterns <span>All 28 categories / 600 patterns</span></summary><label class="jj-search"><i data-lucide="search" aria-hidden="true"></i><input id="jj-pattern-search" type="search" placeholder="Examples: yen, AM, Reiwa, company" aria-label="Search formats"></label><div id="jj-pattern-results" class="jj-pattern-results"></div></details> <details class="jj-more" id="jj-advanced"><summary>Input interpretation and additional conditions</summary><div id="jj-options" class="jj-option-grid"></div></details> <label class="jj-checkbox"><input type="checkbox" id="jj-check-only">Check only, without changing values</label> </div> <div id="jj-custom-panel" hidden> <div class="jj-custom-type"><label><input type="radio" name="jj-custom-type" value="wildcard" checked>Wildcard</label><label><input type="radio" name="jj-custom-type" value="regex">Regular expression</label></div> <label class="jj-full-label">Pattern to specify<input id="jj-custom-pattern" value="AB??????" spellcheck="false" aria-describedby="jj-custom-help"></label> <p id="jj-custom-help" class="jj-rule-condition">* matches zero or more characters; ? matches one character. The whole cell is checked.</p> <label class="jj-checkbox"><input type="checkbox" id="jj-custom-transform">Format by rearranging captured parts</label> <label id="jj-template-label" class="jj-full-label" hidden>Output arrangement<input id="jj-custom-template" value="${1}-${2}" spellcheck="false"></label> <div class="jj-custom-note"><i data-lucide="info" aria-hidden="true"></i><span>Specifying a pattern alone checks matching without changing values. Use standard formats to check date validity and similar conditions.</span></div> </div> <details class="jj-more"><summary>Combine additional formatting steps for this column</summary><div id="jj-additional-steps"></div></details><label class="jj-checkbox"><input type="checkbox" id="jj-required">Check blank cells too</label><label class="jj-full-label" id="jj-excel-output-label" hidden>Excel output type<select id="jj-excel-output"><option value="preserve">Preserve data type (default)</option><option value="text">Format as text</option><option value="number">Convert to number (exactly representable values only)</option></select></label> </section> </div> <div class="jj-preview-heading"><h3>Formatting preview</h3><span>Selected column / same rows as the preview above</span></div> <div class="jj-preview" id="jj-preview"></div> <details class="jj-more"><summary>Output settings for the whole file</summary><div id="jj-output-settings" class="jj-option-grid"></div></details><div class="jj-config-tools"><button type="button" id="jj-export-settings" class="jj-text-button">Save column settings</button><button type="button" id="jj-import-settings" class="jj-text-button">Import column settings</button><input id="jj-settings-file" type="file" accept=".json" hidden></div> <div class="jj-bottom-actions"><span><i data-lucide="shield-check" aria-hidden="true"></i>Original files remain unchanged</span><button type="button" class="jj-button jj-primary cursor-interaction" id="jj-run">Check and format all data<i data-lucide="arrow-right" aria-hidden="true"></i></button></div> </div> </section> <section id="jj-stage-three" hidden aria-label="Save"> <div class="jj-result-title"><span class="jj-result-icon"><i data-lucide="check" aria-hidden="true"></i></span><div><h2>Review formatting and save</h2><p>Values that cannot be changed are retained as originally provided.</p></div><span class="jj-pill">Results for all data</span></div> <div class="jj-result-stats" id="jj-result-stats"></div> <div class="jj-review-banner" id="jj-review-banner"></div> <div class="jj-output"><div class="jj-output-heading"><i data-lucide="file-check-2" aria-hidden="true"></i><div><strong id="jj-output-name"></strong><span>CSV / UTF-8 (with BOM)</span></div></div><button type="button" id="jj-save" class="jj-button jj-primary cursor-interaction"><i data-lucide="download" aria-hidden="true"></i>Save file</button></div> <button type="button" id="jj-save-download" class="jj-text-button">Save with a normal browser download</button> <details class="jj-issues" open><summary class="cursor-interaction">Items requiring review</summary><div id="jj-issue-list"></div></details> <p id="jj-save-state" role="status" aria-live="polite"></p><button type="button" id="jj-confirm-save" class="jj-button" hidden>I confirmed saving</button><div class="jj-bottom-actions"><button type="button" id="jj-back" class="jj-button cursor-interaction"><i data-lucide="arrow-left" aria-hidden="true"></i>Return to column settings</button><button type="button" id="jj-report" class="jj-text-button cursor-interaction">Save the issues list</button></div> </section> <div id="jj-progress-panel" class="jj-progress-panel" hidden><div><h2 id="jj-progress-title">Reading</h2><span id="jj-progress-percent"></span></div><progress id="jj-progress" max="100"></progress><p id="jj-progress-detail" role="status" aria-live="polite"></p><button type="button" id="jj-cancel" class="jj-button">Stop processing</button></div><section id="jj-error" class="jj-error" role="alert" tabindex="-1" hidden></section><section id="jj-recovery" class="jj-recovery" hidden></section><div id="jj-notice" class="jj-notice" role="status" aria-live="polite" hidden></div> </div> <div class="jj-cleanup"><button type="button" id="jj-cleanup" class="jj-text-button" hidden>Delete job data and choose other files</button></div> </main> </div>