DBF Converter is a program for converting (including batch) data in the DBF (Data Base File) format into files of various formats for viewing in standard text and spreadsheet editors. The application is shareware, allowing you to convert the first 50 lines of a DBF file as an introduction to the capabilities.

The DBF Converter program is designed to work in all versions of Windows OS, starting from Win 95 and up to the latest version of Win 10 (full support for 32 and 64 bit bits). The Russian language is not supported by the application (only a few control buttons have translation).

Features of DBF Converter

DBF Converter is a highly specialized software product without any frills. The main task of the program is to convert DBF files (one of the most common formats for storing data in a DBMS) into formats that can be opened in text and spreadsheet editors that are more accessible to ordinary users.

The DBF Converter application allows you to convert DBF data into files of the following formats:

• XLS and XLSX - spreadsheets for Microsoft Excel, LibreOffice Calc, OpenOffice Calc and others.
• CSV and TSV are text files for presented tabular data.
• RTF are meta-tagged text files that also allow you to display tabular data.
• XML and HTML are the most popular file formats based on their respective markup languages.
• SQL and SDF - database files of MySQL, Microsoft SQL Server Compact, SQL Server, Oracle, etc.
• PRG is a file format used in computer-aided design programs (various CAD) to represent input tabular data.
• And also into specialized DBF formats for subsequent use in Clipper, DB2K, VFP, FoxPro and others.

One of the features of DBF Converter is its ease of use. To convert DBF files, the user just needs to follow a few simple steps:

• Specify the location of the DBF file (or group of files).
• Specify the folder to save the results.
• Select the file saving format.
• Set (if necessary) additional conversion options: skipping empty records, sorting data, and others.
• Convert by clicking on the appropriate button.

The program also supports control via the Windows console (command line). A list of commands for the console can be found in help (F1).

Options for opening dbf using excel
There are several of them. Note that the dbf format comes in several modifications: dBase II; dBase III; dBase IV; foxpro and several others.
What else can affect the accurate opening of dbf files? This types of documents. And here excel takes a leading place among other programs, and for its ability to open any type of document in dbf format.
The opening part is unique to this format, but saving requires additional explanation.
One way to open a dbf file This is to use the window through which we open the file, in the file menu. This is a fairly simple method, and even without special knowledge you can safely use it.
Step one - open excel, go to “file”, then “open” in the drop-down menu.

Further "open" in the drop-down menu.

Thus, we see a familiar window for opening the desired file. We find the file we are interested in, and at the bottom right we put the files dBase, also known as dbf; if the file is still poorly visible, we put “all files”. In this mode, you will definitely find the file you need in the folder where it should be.
Having selected the file, click "open".

As a result, we will get our dbf file on sheet1 already opened in the excel file.

You can open the file by double-clicking on the file itself.
However, this is possible if you make certain settings in Excel. And so with the left mouse button we double-click on the file that we want to open in dbf format.

As a result of this action, we will receive a message in which the program will tell us that the result is negative when opening in this way, and will offer its own options for opening the file.

This is either searching for a solution to the problem on the Internet, or selecting the desired program from the proposed list. We activate the program by clicking on “ok” using the proposed list of programs. It is possible that the dbf file may have already been opened by another program. And we need to run the file in Excel, then we use the right mouse button, hovering the cursor over the dbf file, and in the menu we look for “open with”, find this tab, click on it and get the proposed range of programs. We look for Excel and click on the program shortcut.

And if we don’t see the excel program, then click properties, find the “general” shortcut and in the application settings click on “change”, select excel accordingly.

And so we looked at several options for how to open a dbf file in Excel.
It should be noted that when working with any of the described methods, you see a file opening window. If Excel is in the list of programs, then click on it. Otherwise, we are looking for “review”,

We activate it and do the manipulations already described above. However, a situation may arise when we activate the “open with” window and see the Explorer window.
In this case, you should go to the folder where the Microsoft Office program is located and look for Excel in it. It's usually easy to find. Changes can only be due to versions of Excel itself. Path C: Program Files Microsoft Office office # and for different versions we supply instead of the # icon the number of the office you have installed. We got into our directory, we see an excel file there. exe.

We point the mouse at this file and activate it. We will be taken to the already familiar selection list, and here Excel will certainly be visible.

As a result, we will get an open dbf format in Excel.

To further open files in the dbf format, by simply clicking on it with the mouse, check the box in the list of suggestions “always use this program to open these files.”
Click “ok” and the next time, by double-clicking on the file with the mouse, you will automatically get the dbf excel file opened.
As you can see, everything is quite simple and is clearly shown in the pictures.

DBF Converter is a universal solution to all your DBF format conversion needs. Whenever you need to extract data from a DBF file to CSV, XLS, XLSX, SQL or plain text, the software delivers a straightforward way to do this with minimum efforts. DOWNLOAD for FREE

3-Steps conversion

Working with DBF Converter is easy. You specify a DBF file or a folder with DBF files you want to convert, select fields and filter out records you need. Then it"s just a matter of one click for DBF Converter to turn source files into the format of your choice.

Powerful data filtering

Data filtering in DBF Converter is visual. This means the program takes a sample of records in the DBF file and allows you to apply custom filter rules and masks and instantly see the sample changes according to your choice.

Batch conversion for multiple DBF files

When you have dozens of those DBFs, converting them could be tricky. But thanks to DBF Converter there"s no difference whether you need to process one file or a hundred. The program accepts a folder containing your source DBF files and converts them all one by one. And thanks to the low-level access to the data the conversion remains fast and accurate.

Key Features

• Convert DBF to XLSX
• Convert DBF to XML
• Convert DBF to TXT
• Convert DBF to SDF
• Convert DBF to HTML
• Command line support

Try DBF Converter now for free While the price for DBF Converter is extremely affordable, you can also try it for free at any time. Download the free trial and evaluate the vast capabilities of DBF Converter now!

Download DBF Converter FREE

DBF Converter runs on all versions of Windows from 95 through XP, Vista, Windows 7/8/10 (32/64 bit).
Registered users will receive all future versions and upgrades free, as well as virtually unlimited technical support.

Buy Now!

Attention residents of the Chelyabinsk region!

TFOMS of the Chelyabinsk region reminds that if you change the details of your identity document, as well as when receiving a new passport, you need to contact your medical insurance organization (its contact details are indicated in the compulsory medical insurance policy) within one month from the day these changes occurred.

ATTENTION!!! If the reporting period of the converted file is from January 2019 (inclusive), then you need to convert in the XDConverter7 program. If the reporting period of the converted file is from November to December 2018 (inclusive), then you need to convert in the XDConverter6 program. If the reporting period of the converted file is from July to October 2018 (inclusive), then you need to convert in the XDConverter5 program. If the reporting period of the converted file is from June 2017 to June 2018 (inclusive), then you need to convert in the XDConverter4 program. If the reporting period of the converted file is from January 2015 to May 2017 (inclusive), then you need to convert in the XDConverter3 program. If the reporting period of the converted file is from April 2014 to December 2014 (inclusive), then you need to use the XDConverter2 program for conversion. If the reporting period of the converted file is up to March 2014 (inclusive), then you need to convert in the XDConverter program. XDConvert uses a reference package named usl_pack_*.rar. For XDConvert2, a reference package named usl_pack2_*.rar is used. XDConvert3 uses a reference package named usl_pack3_*.zip. XDConvert4 uses a reference package named usl_pack4_*.zip. XDConvert5 uses a reference package named usl_pack5_*.zip. For XDConvert6, a reference package called usl_pack6_*.zip is used.

A package of reference books for the operation of the converter can be downloaded from the website, section "Technical support - Directories - USL_PACK reference package for the XDConverter program".

In the XDConverter program, you need to go to the "Download directories" menu, then select the downloaded file of the form usl_pack_yymmdd.rar (yymmdd - year\month\day) and click the "Open" button. The directories will be downloaded.

Converting XML->DBF manually

1. Go to the Tools-Settings menu, check that the path to the data file is correct and click OK.
2. In the menu, select Convert - XML ​​to Native.
3. In the window that opens, in the Input file section, specify the path to the data file (zip archive).
4. In the Output file section, check the Name and, if necessary, specify the path.
5. Click the Process button. Below in the log window the progress of the conversion is displayed.

Converting from DBF to XML manually

For manual conversion mode, you need to go to the "Convert - Native to XML" menu. Next, select the required Native file and click the "Open" button. The source/receiver selection window appears. You must indicate where the file is being sent from and to. From health care facilities to the Compulsory Medical Insurance Fund or health care organization (or from health care institution to health care facility, if the program is installed in the health care organization). Next, click the “OK” button. The conversion will begin and upon completion a report on the result will be issued.

Command Line Launch Options

"XDConverter.exe 1 2 3 4", where

1 - Name of the converted file (indicating the path)

2 - Directory for the created file

3 - Source (M,T,S)

4 - Receiver (M,T,S)

3, 4 - only for DBF->XML\ conversion

Converter starter (for single installation and start-up)

1. Install and run StartConvert.
2. In the menu, select the reporting period of the personal file. accounting.
3. The program will automatically launch the desired converter (XDConverter, XDConverter2, XDConverter3).
4. Next, convert as usual.

XDConverter7

XDConverter6

XDConverter5

XDConverter4

DBF is a database file, the ability to work with which was previously integrated into the Microsoft Office environment. Access and Excel applications worked with the format, later Access was removed from the package and became a separate program, and in Excel, since 2007, DataBaseFile support has been significantly limited.

If it is not possible to open a DBF file directly in Excel, you must first convert it.

However, DBF, although considered by many to be an outdated format, is still widely used in specialized programs in business, design, and engineering. Wherever it is necessary to work with large amounts of information, their structuring and processing, and executing queries. For example, the 1C Enterprise software package is entirely based on database management. And given that a lot of office documentation and data is processed in Excel, the issue of integrated work with these formats is relevant and in demand.

Excel problems when working with DBF

Excel 2003 had the ability to open and edit DBF, as well as save XLS documents in this format:

1. Select "File" from the menu bar.
2. Next, click “Save As”.
3. Select “*.dbf” from the drop-down list.

IMPORTANT. Since 2007, you can open and view the database format in Excel, but you cannot make changes or save .xls documents in it. Standard program tools no longer provide this option.

However, there are special add-ons for the application that add such a function to it. Programmers post their developments online on various forums, and you can find different options. The most popular add-on, called XslToDBF, can be downloaded from the developer’s website http://basile-m.narod.ru/xlstodbf/download.html. The download is free, but if you wish, you can support the project by transferring any amount to your wallet or card.

Installation and use:

1. Download the archive from the above site.
2. Extract XlsToDBF.xla from it and save it on your computer.
   
3. In Excel, go to the menu with the Microsoft icon on the left, “Options”.
   
4. Under Excel Options, select Add-ins.
5. In the Manage/Excel Add-ins row, click Go.
   
6. Click Browse and locate the saved XlsToDBF.xla.
   
7. The entry “XLS -> DBF” should appear in the list of add-ons with the check box checked. Check if it is not there.
8. Now you can save .xls to .dbf format. From the same site you can download detailed instructions for use. The main thing is to prepare tabular data correctly.
9. Once the table is ready, select any filled cell and press Alt and F
10. In the macro window that opens, type XlsToDBF in the field, case is not important.
    
11. Click Run.
12. If you have prepared and formatted the data correctly, the database file will also be saved in the folder where the source XLS is located.

If you don't want to change anything in Office and don't trust add-ins and third-party applications, then you can suggest a more time-consuming way to convert an XLS file to DBF:

1. Purchase and install Microsoft Access.
2. In Excel, prepare and save the document.
   
3. Click the "Open" button in MS Access and select the file.
   
4. Now you need to configure the import correctly.
   
5. Select the sheet to start with. If there are several of them, you still have to do one at a time.
   
6. If the table has a header row, check the appropriate box.
   
7. Next, you can change the table name.
   
8. Now click on "External Data".
   
9. Click the “Export”, “Advanced” button.
   
10. Select dBase File.
    
11. Provide a name and save location.

This method does not always work successfully; errors often occur in data processing and subsequent saving. And it is very long and inconvenient.

Conversion

In order not to suffer with office programs yourself, many applications have been created that allow you to transfer data from one format to another. Firstly, almost all powerful DBMS programs offer the ability to export to XLS and load from it. Secondly, there are small utilities that specialize in conversion. Here are some of them:

In all of these programs, conversion boils down to opening the source file and then running the "Convert" or "Export" command.

There are also free online conversion services. On such sites you are asked to send (download) the source file, click “Convert”, after which a link to the converted document will appear. To what extent you can trust such services, the decision is individual, at your own peril and risk.

Thus, you can open the DBF in Excel, but if its version is 2007 or newer, then you won’t be able to do anything more with it, just look. There are special add-ons or programs for editing and saving in XLS, as well as for converting in the opposite direction. If you have experience converting and working with DBF in different applications, share your tips in the comments.