Karl -
You came here for advice. That was smart. You're off to a good start. 🤓
------------------------------
Geoff Sykes, RPT
Los Angeles CA
------------------------------
Original Message:
Sent: 08-23-2025 10:43
From: Karl Roeder
Subject: Calling all Excel experts
Thank you gentlemen,
After a few stumbles I now have useful data to review. If I keep this up, in another 10 years or so I'll be able to understand what all the smart people are arguing about ;>)
------------------------------
Karl Roeder
Pompano Beach FL
Original Message:
Sent: 08-22-2025 11:21
From: Geoff Sykes
Subject: Calling all Excel experts
From a Google search. -- I've had to do this a couple of times and these directions are pretty standard. The very important step that is not mentioned is how to create your CSV or text file. Pretty much either one works fine but CSV would be first choice. When you do the export from your original Excel file you must make sure it is comma delimited, although the Wizard will give you several different choices. As long as it's delimited with a character you are not using anywhere in the actual Excel sheet it should be fine. If it's not delimited for the export everything will wind up in one column. After the import inspect the results carefully.
Have fun -
AI Overview
To import comma separated data (CSV) into Excel, navigate to the Data tab, select Get External Data (or Get & Transform Data depending on your Excel version), choose From Text/CSV (or From Text), and then locate and select your CSV file. Excel's Text Import Wizard will guide you through the process, prompting you to select the delimiter (comma) and data format.
Here's a more detailed breakdown:
Open Excel and navigate to the Data tab: Start with a blank Excel workbook.
Locate the 'Get External Data' or 'Get & Transform Data' group: This group might be labeled differently depending on your Excel version (e.g., "Get External Data" in older versions, "Get & Transform Data" in newer versions).
Select "From Text/CSV" (or "From Text"): This option allows you to import data from text or CSV files.
Browse and select your CSV file: Locate the CSV file on your computer and select it.
Follow the Text Import Wizard: Excel will launch the Text Import Wizard, which guides you through the process of importing the data.
Choose the delimiter: In the wizard, you'll need to specify that your data is delimited by commas.
Specify data format: Choose the appropriate data format (e.g., General, Text) for each column.
Click Finish: After making your selections, click Finish to import the data into your Excel worksheet.
Choose where to load the data: You'll be prompted to select where you want the data to be placed in your worksheet (e.g., a new worksheet, an existing worksheet).
------------------------------
Geoff Sykes, RPT
Los Angeles CA
Original Message:
Sent: 08-20-2025 11:24
From: Karl Roeder
Subject: Calling all Excel experts
Greetings, learned colleagues, I' the proud owner of a new KMD device and I am trying to export a CSV file to Excel. When I do all of the information goes to a single Cel on the worksheet. Is there an easy way I can separate the information so it appears in the appropriate columns? All this 21st-century stuff is very confusing to a person who spent 40 years working on 19th century technology.
------------------------------
Karl Roeder
Pompano Beach FL
------------------------------