If your data has ID numbers like 00123 , Excel may convert this to 123 . To fix this, use Method 1 , and in the transformation screen, set the data type of that column to "Text".
Credit card numbers or long ID numbers might appear as download comma delimited file to excel
After importing the data, you should save the file in the modern Excel format to preserve formulas and formatting. If your data has ID numbers like 00123
A Comma Separated Values (CSV) file is a plain text file that stores tabular data (numbers and text) in plain text. Each line of the file is a data record, and each record consists of one or more fields, separated by commas. Because it is plain text, it is highly portable between different systems, such as database exports, banking reports, and CRM software. Method 1: The Best Practice Approach (Data > Get Data) A Comma Separated Values (CSV) file is a
For simple CSV files, you can open the file directly with Excel. Locate the downloaded .csv file in your file explorer. Right-click the file and select > Excel .
A preview dialog box will appear. Excel typically detects the delimiter (comma) and data type automatically. Click to import the data into a new worksheet. Method 2: The Direct "Open With" Method
Excel will automatically attempt to open the file and separate columns based on commas.