Get the Data Into a Spreadsheet

Why this matters

This is the step that quietly defeats beginners. You download a CSV, open it, and everything is jammed into column A separated by commas, or the dates read as 45291 instead of March 5th, or a European file uses semicolons and nothing lines up. If the data lands wrong here, every formula and chart you build afterward is garbage, and you will not know why. Doing the import properly once - and knowing the two or three things that go wrong - means you can trust everything downstream. We use Google Sheets because it is free, runs in a browser, and pastes cleanly into AI chats, but the same moves work in Excel.

Demo

Here is the reliable path in Google Sheets. Go to sheets.google.com, click the blank 'plus' to make a new sheet. Then File > Import > Upload, drag in your CSV. A dialog appears - the key setting is 'Separator type.' Leave it on 'Detect automatically' first; if your columns end up all in column A, redo the import and manually pick 'Comma' (or 'Semicolon' for many European files). Choose 'Replace current sheet' and click Import data. Your data should now fill columns A, B, C with one record per row. Three checks before you trust it. Check one: click the last row of data and confirm the row number roughly matches the record count you expected - if your CSV had 500 orders you should see about 501 rows (500 plus the header). Check two: look at any date column - if it shows something like 45291 instead of 2024-03-05, select the column, then Format > Number > Date. Check three: freeze the header so it stays visible while you scroll - click row 1, then View > Freeze > 1 row; the header row now has a thin line under it and stays put. If you have no file and only a web link to a Google Sheet someone shared, use File > Make a copy so you have your own editable version. Do not skip the freeze - once you are scrolling through 500 rows, a floating header is the difference between knowing column D is 'Revenue' and guessing.

Try it yourself

1. Import your dataset into a new Google Sheet via File > Import > Upload and confirm the columns split correctly into A, B, C rather than jamming into column A.
2. Scroll to the last row and check the row count matches roughly what you expected (records plus one header row); write the number down.
3. Fix any date column that shows a number like 45291 using Format > Number > Date, and confirm at least one date now reads as a real date.
4. Freeze the header row with View > Freeze > 1 row and scroll down to confirm the column names stay visible.

References

• Google Sheets Help - Import data sets and spreadsheets
• Google Sheets Help - Freeze or merge rows and columns