Skip to content
Import Export PowerTool app iconImport Export PowerToolExport

Text File Import and Export for Microsoft Dynamics 365 Business Central

Spreadsheet-based import tools tie data migration to a spreadsheet program and to one sheet per table, and spreadsheets can change values or add characters when a file is saved. Import Export PowerTool reads and writes plain text files, so Excel is not required. This is a completely free app from Insight Works for Business Central.

How Text file import and export works in Import Export PowerTool

  1. Export data from Business Central with Import Export PowerTool, or build a text file from another system.
  2. Open and edit the file in a text editor, or in a spreadsheet if you prefer.
  3. Save it as text with the right encoding and line endings.
  4. Import the file with Import Export PowerTool.
Video thumbnail: Import items, item journals, and sales history with Import Export PowerTool
Import items, item journals, and sales history with Import Export PowerTool For partners and administrators who need to bring opening balances, serial numbers, and history into Business Central from another system. Transcript and details →

Key capabilities

Text editor friendly

Exported files open in any text editor, so data can be searched, compared, and edited without special software.

One file, many tables

Each table in the file is marked by its table ID, so a multi-table migration is one file rather than a workbook of sheets.

Spreadsheet when you want one

A file can still be prepared in Excel. When Excel adds quote characters on save, the import option to remove quotes strips them.

Encoding and line endings

The import lets you choose the text encoding. Files need correct line terminators, which a text editor that shows non-printing characters makes easy to check.

Details that matter on the floor

Saving from a spreadsheet

Opening and saving a file in Excel produces correct line terminators, but can add stray quotes. Use the remove quotes option on import.

Older systems

A file exported from a legacy system as plain text can be shaped into the import format without a spreadsheet.

Who uses Text file import and export

Developers

Edit migration files in the text tools they already use.

Data migration specialists

Reshape legacy exports into the import format.

Business Central consultants

Hand clients one readable file instead of a workbook per table.

Questions about Text file import and export

Do I need Excel to import data with Import Export PowerTool?

No. Import Export PowerTool works with plain text files that any text editor can open. Excel can be used to prepare a file if you want.

Why do quotes appear in my import file?

Excel can add quote characters when it saves a file. The import option to remove quotes strips them during the import.

What causes an import to read lines incorrectly?

Usually missing or wrong line terminators. Check the file in a text editor that shows non-printing characters.

Import Export PowerTool app icon

Part of Import Export PowerTool

Import, export, update, and delete Business Central data in bulk, for data migration and ongoing data management.

Have a question about Text file import and export?

Send us a note and the Import Export PowerTool team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions