Stop Excel Transformations of Imported Data (2 Simple Tips)

Download Project Files
Author: | Edits: don

Prevent Excel from changing data that you import, including long numbers, text that looks like dates but is not a date, and more.

I'll show you 2 ways to keep your data safe, including a way to have granular control over how the data and is imported, column-by-column.

Resources

Import CSV Files (Microsoft Resource)

TeachExcel Online Courses

Download the Project Files

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use

Excel Version: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365
Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use

Question? Ask it in our Excel Forum

Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Print Only Specific Parts of a Worksheet in Excel
Tutorial: In Excel you can select parts of a worksheet to print while ignoring all of the other data...
Basic Web Query in Excel - Import Data from the Web into Excel
Macro: Import data from the web into Excel with this macro. This is a basic web query macro that ...
Import a Worksheet from One Workbook to Another in Excel
Tutorial: In Excel, you can quickly copy an entire worksheet from one workbook to another workbook.Â...
Stop Excel from Changing Numbers to Dates or Anything Else
Tutorial: How to stop Excel from automatically changing numbers into anything other than what you ty...
Performing Calculations in Excel - Order of Operations Explained
Tutorial: In this tutorial I am going to cover how to perform calculations in Excel. Calculations in...
Filter Data to Show the Bottom 10 Percent of a Data Set in Excel - AutoFilter
Macro: This free Excel macro filters a data set to display the bottom 10 percent of the data set ...
Tutorial Details
Excel Version: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365
Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course