Funcognito — Explore and learn anything, you got this!

4.1 Getting data in from anywhere

Checked against Microsoft's Excel for Windows keyboard references, August 2026

తెలుగులో చదవండి

What you'll be able to do

Bring data in from a CSV file, a web page or a system export without damaging it. Leading zeros kept, dates right, strange symbols avoided — and connected, so that next month's file needs no repeat work.

Before you start

Download the messy data workbook. Export any sheet of it as CSV, so that you have a raw file to practise importing.

The work

  1. Same either way: never open a CSV by double-clicking it when the data matters. Opening it raw lets Excel guess. Leading zeros disappear from phone numbers, long ID numbers turn into scientific notation, and day-month dates from Indian systems flip round. The guesses save ten seconds and cost an afternoon.
  2. No documented keyboard shortcut for this — use the menu: import it instead. Go to Data → Get Data → From Text/CSV, pick the file, and read the preview carefully. Check the separator it guessed, which may be a comma, a semicolon or a tab. Check the encoding, which is the rule for turning bytes into letters. If the ₹ sign or people's names come out as strings of odd symbols, the encoding is wrong. Switch to UTF-8 and watch the text come right. Check the column types. Transform Data opens the query editor for fixes, and Load brings the data in.
  3. Same either way: set the fragile columns yourself, in that preview or in the editor. Phone numbers and ID numbers go in as text, so the zeros survive. Dates go in with the source's day order declared. That one minute is the whole difference between an import and a repair job.
  4. No documented keyboard shortcut for this — use the menu: to take a table from a web page, go to Data → Get Data → From Web. Paste the page's address, and pick the table from the list Excel finds. When the page's numbers change, yours are one refresh away.
  5. No documented keyboard shortcut for this — use the menu: a whole folder of files can come in at once. Go to Data → Get Data → From File → From Folder. Every monthly CSV in that folder combines into one table. Next month's file joins by being saved there. The shaping module works this fully.
  6. Same either way: understand what you have built. It is a connection, not a paste. The query remembers the source, the encoding, the types and the steps. CtrlAltF5 refreshes everything from the sources again. A paste is a photocopy that starts ageing as soon as it lands, and connections are why this route exists.
  7. Same either way: audit any import in thirty seconds. Compare the row count against the source. Check one phone number for its leading zero. Check one date against the way the source wrote it. Check that one ₹ sign came through. Four glances catch most disasters.

Try it

Import your practice CSV properly, with the preview read, the phone column set to text and the dates declared. Change a number in the CSV, save it, refresh in Excel, and watch the change come through. Then run the four-glance audit.

Check yourself

It drops leading zeros from phone numbers, turns long ID numbers into scientific notation, and misreads day-month dates. A fourth is the odd symbols where ₹ and people's names should be.

The encoding guess. The file is UTF-8 and is being read as something else. Change the encoding dropdown in the preview and the text comes right at once.

Memory. The source, the types and the cleaning steps are recorded, so next month is one refresh with CtrlAltF5 instead of doing the work again. A paste is a snapshot that starts ageing at once.

From Folder. The query combines every file in the folder, so a new month joins by being saved into it, and a refresh does the rest.

Go deeper

We haven't checked most of these for screen reader use yet.

Back to Getting data in from anywhere: work through the checklist