Solve date format problems with CSV import in Excel
21.8 هزار بار بازدید -
2 سال پیش
-
#msexcel
#msexcel #datacleaning #efficiency365
Importing dates from CSVs can be tricky. If the input date format and the PC date format does not match, days and months get swapped. Half the dates will remain text.
Here you can see two solutions for this problem: one using Excel native feature - Text import wizard and second - a modern solution - using Power Query.
Contents
---------------
00:00 Introduction
00:26 Problem
02:47 Root cause
03:12 Solution1
05:13 Best solution - Power Query
The first solution will work with any version of Excel. Second solution requires Power Query which is available with newer versions, including Office 365 version.
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
https://s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms
Udemy Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://hi.switchy.io/22B1
Excel to Power BI - https://swiy.io/pivotsh
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog
LinkedIn : LinkedIn: nitinparanjape
Twitter : Twitter: drnitinp
Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)
Importing dates from CSVs can be tricky. If the input date format and the PC date format does not match, days and months get swapped. Half the dates will remain text.
Here you can see two solutions for this problem: one using Excel native feature - Text import wizard and second - a modern solution - using Power Query.
Contents
---------------
00:00 Introduction
00:26 Problem
02:47 Root cause
03:12 Solution1
05:13 Best solution - Power Query
The first solution will work with any version of Excel. Second solution requires Power Query which is available with newer versions, including Office 365 version.
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
https://s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms
Udemy Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://hi.switchy.io/22B1
Excel to Power BI - https://swiy.io/pivotsh
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog
LinkedIn : LinkedIn: nitinparanjape
Twitter : Twitter: drnitinp
Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)
2 سال پیش
در تاریخ 1401/08/01 منتشر شده
است.
21,836
بـار بازدید شده