Excel Convert .DAT to Excel

aeqquus

aeqquus

Joined
Jul 22, 2018
Messages
5
Reaction score
4
It depends on the format of the .dat file. Dot Dat could be created from many apps and be in many formats. Use your text editor (notepad.exe) to view file if possible. If a fixed length text record, you'll need to know the format (columns) of the record and import to Excel as Fixed Length. If the file is a CSV (merely named as .dat) you could import as delimited record.

If the file is proprietary to some software but in some binary form you're probably out of look. If it happens to be in a random length format common to some software, predominantly a form of Basic, then you'll need to know the columns, data types, and lengths. Then you could potentially write a VB program to output to text.

Hope this helps.

T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert multiple .dat files into one pdf without losing color of their graphs 0
Excel Microsoft Excel Hang 0
Excel What does E represent in Microsoft Excel?? 1
Import from Notepad delimited text 7
Excel Convert word into numbers and back 4
Excel Write a formula in excel where 1 = .05, 2 = .75, 3 = .30 etc. 4
Excel Inverse Fft 0
Convert .dat to video file 3

Top