File Query allows you to work with the largest data files
faster and easier than a database
Quickly view, query, analyze and modify files of ANY size, in seconds
Don't waste your time going through complicated import processes that other tools use. On most files, File Query can figure the layout for you, automatically.
After opening this file, File Query knows that it is delimited with pipes, has a header, is not quoted, uses Windows (CRLF) line endings, and has around 1,000 lines.
All with no input from the user.
Ever received a file that didn't match the supposed layout or spec?
With just a few clicks, you can generate a report against all fields in the file, giving you the information to know if the file really looks like it's supposed to; and if not, where the issues are.
The sooner you can find the issues, the less time you waste on fixing them one-by-one.
Once you have found an issue with a file, how do you fix it?
Whether it's changing bad values in a multi-GB file, adding/removing/re-ordering fields, or splitting large files into smaller ones, File Query makes these changes, and many more, quick and easy.
While File Query is extermely simple to use for most tasks, it doesn't limit you to what is built in. Every function you run generates a query that you can modify and extend, and these queries run on top of a full programming language (C#).
Either by writing them yourself, or by having us help, you can easily extend the functionality of the tool almost limitlessly. And once you write a query, just save it in the tool, and it's like having the functionality built right in.
In the past, I had to use Excel to structure data, and then import it into Access. Then it would be sorted and prepped to be loaded to Oracle for querying. With File Query, those days are gone!
Kingsley Odiase
Production Support Analyst, Blue Cross Blue Shield
OMG File Query is the bomb! (Do kids still use that term these days?) It is such a productivity boost, and handles super large files that our other tools just choke on... woo hoo!!!
Joanne Gryniewicz
Payor Product Manager, HealthEdge
File Query is very easy to learn and to navigate. It allows easy reporting access to data that I previously had to ask a developer to get, and makes the data validation and QC process much easier.
Lucia Corbett
Sr. Business Systems Analyst, Epsilon
It's great knowing that there is an actual person answering all of my questions. I've never had a problem that you guys haven't been able to solve, and you always respond quickly.
Chris Ryan
Sr. Systems Engineer, Jacobs Technology
Businesses from all over the world are using File Query