bring .tps files into excel
 

I have many .tps files that I need to open up in excel. Does anyone know a
good way to convert .tps files to text or something to open in excel? thank
you!

bring .tps files into excel
 

What is it?
http://www.fileinfo.net/extension/tps

Knox wrote:

I have many .tps files that I need to open up in excel. Does anyone know a
good way to convert .tps files to text or something to open in excel? thank
you!

bring .tps files into excel
 

It is the clarion database file, a database of traffic counts

"Bob I" wrote:

What is it?
http://www.fileinfo.net/extension/tps

Knox wrote:

I have many .tps files that I need to open up in excel. Does anyone know a
good way to convert .tps files to text or something to open in excel? thank
you!

bring .tps files into excel
 

What does it look like if you open it with Notepad.exe? Is it really a
comma delimited file?

Knox wrote:

It is the clarion database file, a database of traffic counts

"Bob I" wrote:


What is it?
http://www.fileinfo.net/extension/tps

Knox wrote:


I have many .tps files that I need to open up in excel. Does anyone know a
good way to convert .tps files to text or something to open in excel? thank
you!

bring .tps files into excel
 

no, it is just a bunch of symbols and stuff, it can't read it properly

"Bob I" wrote:

What does it look like if you open it with Notepad.exe? Is it really a
comma delimited file?

Knox wrote:

It is the clarion database file, a database of traffic counts

"Bob I" wrote:


What is it?
http://www.fileinfo.net/extension/tps

Knox wrote:


I have many .tps files that I need to open up in excel. Does anyone know a
good way to convert .tps files to text or something to open in excel? thank
you!

bring .tps files into excel
 

You may need to open it in Clarion and do an Export then.

Knox wrote:

no, it is just a bunch of symbols and stuff, it can't read it properly

"Bob I" wrote:


What does it look like if you open it with Notepad.exe? Is it really a
comma delimited file?

Knox wrote:


It is the clarion database file, a database of traffic counts

"Bob I" wrote:



What is it?
http://www.fileinfo.net/extension/tps

Knox wrote:



I have many .tps files that I need to open up in excel. Does anyone know a
good way to convert .tps files to text or something to open in excel? thank
you!

bring .tps files into excel
 

As Bob I suggested, probably the easiest route is to use Clarion to export to
a comma separated values (.csv) file or to a raw .txt file. You can then
read either into Excel pretty much directly. You can also open either of
those types with Notepad to see how they're laid out.

Remember that .csv doesn't necessarily always mean "comma" separated values,
other characters frequently used in those types of files are the [Tab]
character, the pipe ( | ), and the semi-colon (;). Or Clarion may output to
a fixed field length text file - which Excel can import once you figure out
how long the fields are.

"Knox" wrote:

no, it is just a bunch of symbols and stuff, it can't read it properly

"Bob I" wrote:

What does it look like if you open it with Notepad.exe? Is it really a
comma delimited file?

Knox wrote:

It is the clarion database file, a database of traffic counts

"Bob I" wrote:


What is it?
http://www.fileinfo.net/extension/tps

Knox wrote:


I have many .tps files that I need to open up in excel. Does anyone know a
good way to convert .tps files to text or something to open in excel? thank
you!