Importing a text file
Accounting systems often export data as .txt or .csv. Excel opens them with Data → Get Data → From Text/CSV (the Text Import Wizard in older versions):
- Choose the format: delimited (tab, semicolon, comma) or fixed width.
- Pick the delimiter — the preview should split the data into columns.
- Set column formats (e.g. Text for codes with leading zeros, Date for dates).
- Choose where to put the data. With Power Query the import can be refreshed when the source file changes.
Templates
- A template is saved as .xltx (with macros — .xltm). A new file based on it does not overwrite the template itself.
- Default workbook template: save a workbook as
Book.xltxin the XLSTART folder — every new workbook will look like it. - To modify a template, open the .xltx file itself (File → Open), make changes and save it as a template.