Skip to content
NewAI dashboards.See how →
Open MammothTry free
Free · Runs in your browser

TXT to Excel converter

Turn a text file into an Excel spreadsheet. Tabs, pipes and lined-up columns are split for you, and your file never leaves your browser.

Works with
TXTTSVDATXLSX
Opens inExcelGoogle Sheets

Drop a text file here

TXT, TSV, DAT or CSV, up to 100 MB. It stays on your computer.

  • No sign-up
  • Nothing uploaded
  • Columns found for you
  • Arla Foods logo
  • Bacardi logo
  • British American Tobacco logo
  • Everest Detection logo
  • Golden Acre logo
  • Handlangers logo
  • Inspired Learning Group logo
  • Kantar logo
  • MUFG logo
  • NielsenIQ logo
  • PTI Digital logo
  • RethinkFirst logo
  • Starbucks logo
  • The Specialist Works logo
What you get

A spreadsheet from any text export.

  • Your file stays on your computer

    The Excel file is built in your browser. Nothing is sent to Mammoth or anyone else.

  • Lined-up reports split into columns

    A column starts where every line has a gap of two or more spaces, so a name like Ana Costa stays in one cell.

  • Borders and dashed lines left out

    Output copied from a database console keeps its rows. The +----+ lines and | borders around them are dropped.

How it works

How to convert TXT to Excel

The first line gives the column names. Each column is typed once, as numbers, dates or text, and the header row is bold and frozen.

  1. 1

    Add your text file

    Drop a .txt, .tsv or .dat file on the box, choose one, or paste the text in.

  2. 2

    Check the columns

    A preview shows the sheet. Change how the columns are split if you need to.

  3. 3

    Download

    Save the .xlsx and open it in Excel, Google Sheets or Numbers.

Your options

Other ways to do it

Excel can split a text file into columns itself. It asks you to set most of it by hand.

  • Excel's From Text/CSV

    A file you refresh often

    • Finds the columns for youPartly
    • Keeps leading zerosPartly
    • Drops dashed rule linesNo
    • Refreshes when the file changesYes

  • Excel's Text to Columns

    Text already pasted in a sheet

    • Finds the columns for youNo
    • Keeps leading zerosPartly
    • Drops dashed rule linesNo
    • Refreshes when the file changesNo
  • This page

    This converter

    A clean .xlsx in one step

    • Finds the columns for youYes
    • Keeps leading zerosYes
    • Drops dashed rule linesYes
    • Refreshes when the file changesNo
In Excel itself

How to import a text file into Excel

Data > From Text/CSV reads a .txt file and lets you choose how it is split. For text already in a sheet, Data > Text to Columns does the same for one column.

Need a CSV instead? The TXT to CSV converter reads the same files and writes a CSV.

  1. 1

    Open a blank workbook and go to Data > From Text/CSV.

  2. 2

    Pick your .txt file and select Import. A preview shows the columns Excel found.

  3. 3

    Set Delimiter to the character between your values, or to --Fixed Width-- if the columns are lined up with spaces.

  4. 4

    If a column holds codes with leading zeros, set Data Type Detection to Do not detect data types.

  5. 5

    Select Load to put the data on a new sheet.

Your file stays private

The converter runs inside this page. Your text file is read and turned into a spreadsheet on your computer, and nothing is sent to Mammoth. That makes it safe for exports with customer or payroll data in them.

How we handle your data

Once the page has loaded, it works with your internet switched off.

Every month

Getting the same report every week?

Mammoth can take it from there. Put each week's file in a folder as CSV and the rows are added to one table, ready to download as Excel.

Try Mammoth free

Weekly reports

Week 43stock-w43.csv
Week 44stock-w44.csv
Week 45stock-w45.csv
DriveDropboxOneDriveSFTP
All weeksUp to date
Oct 21Lisbon1,284
Oct 21Porto962
Oct 28Lisbon1,310
Oct 28Porto1,005
Nov 04Lisbon1,198

Illustration. Every new file in the folder is added to the same table.

Questions

TXT to Excel questions

Is my text file uploaded anywhere?
No. The page reads the file and builds the Excel file inside your browser. Once the page has loaded, it works with your internet switched off.
How are the columns found?
From the first 200 lines. A tab, pipe, comma or semicolon that splits every line the same way is the separator. If the lines are lined up with spaces, a column starts wherever every line has a gap of two or more spaces. You can pick another split from the menu.
Can it read output copied from a database console?
Yes. The +----+ border lines, the outer | borders and a closing (3 rows) line are left out, so the sheet holds only the header and the rows.
Are numbers and dates real numbers and dates in Excel?
Yes. A column where every value is a number becomes numbers, and 1,200.00 in a lined-up report counts as one. A column where every value is a date like 2026-11-09 becomes Excel dates. Codes with a leading zero, like 00071, stay text.
My file has no header line. What then?
Switch off First line is the header. The columns are named column_1, column_2 and so on, and the first line is kept as a row.
How many rows can it convert?
An Excel sheet holds 1,048,576 rows, header included. A bigger file gets the first 1,048,575 rows and the page tells you. Files can be up to 100 MB.
Will accents come through?
Yes. The file is read as UTF-8, as UTF-16 when it starts with a byte-order mark, and as Windows-1252 otherwise, so a file saved by Notepad on Windows reads correctly.
Is it free?
Yes, with no account and no email.

More free tools

Free toolTXT to CSVTurn a text file into a CSV.Take a lookFree toolCSV to ExcelTurn a CSV into an Excel file, zeros kept.Take a lookFree toolMerge Excel filesCombine several workbooks into one.Take a look