Correct German Dates in Excel Power Query Folder Imports
Question details
The user needs to interpret German date and time values consistently when importing files from a folder into Power Query.

- Product
- Microsoft Excel Power Query
- Device & OS
- not provided
- Scenario
- Files created in Germany are combined through the Power Query From Folder import.
- Observed behavior
- Automatic type conversion may use the computer's regional settings and misinterpret German dates, particularly when both the day and month are 12 or less.
Check the original files to confirm that the date values use German formatting and whether they include times. In Excel, open Data > Queries & Connections so you can access the folder query and its sample-file transformation.
Apply the German locale in the folder's sample-file transformation
Use this method to interpret German date and time text consistently across files combined from a folder.
In Excel, select Data > Queries & Connections, then double-click the folder query to open Power Query Editor.
In the Queries pane, open the sample-file query used by the folder import, often named Transform Sample File. Check its Applied Steps for a Changed Type step affecting Call Start Time and Call End Time.
In Applied Steps, remove or edit the incorrect Changed Type step so the affected columns are still in their original text form before the new conversion. Check the combined folder query for an earlier incorrect conversion as well.
Select Call Start Time and Call End Time, then choose Transform > Data Type > Using Locale. Select Date/Time and German (Germany), then confirm. If the source values contain dates only, select Date instead.
Check the preview against known values in the source files, including dates where both the day and month are 12 or less. Select Home > Close & Load, then refresh the query to apply the transformation to the folder files.

Review German date data in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Microsoft Office formats, making it easy to move existing files. It can help you review spreadsheet data, but it does not fix Excel Power Query folder transformations.

Frequently Asked Questions
Why are the day and month swapped in my folder import?
Power Query may automatically convert date text using a locale that expects a different date order. In Power Query Editor, inspect the Changed Type steps and use Transform > Data Type > Using Locale with German (Germany) for German-formatted values.
Where should I apply the locale for every file in the folder?
Apply it in the sample-file query or transformation function used by the folder import, often named Transform Sample File. The combined query uses that transformation for the files it processes.
Can I fix dates by changing the locale after they are already typed?
Not reliably. Remove the step that interpreted the original text incorrectly, then apply Using Locale while the column still contains the original text.
Should I choose Date or Date/Time?
In the Using Locale dialog, choose Date/Time if the source values include times, such as call start and end times. Choose Date if the values contain only dates.




