Kako pretvoriti CSV datoteku u Excel
Charlotte Miller
โก Pametni saลพetak
Importing a CSV file into Excel turns a plain text file of comma separated values into a formatted worksheet. This page explains what a CSV file is, imports one with the Text Import Wizard, handles other delimiters such as the slash, and compares the ways to open a CSV.
A CSV file is one of the most common ways to move data between programs, because almost every application can read and write it. Excel opens a CSV in a few clicks and, with the Text Import Wizard, gives full control over how each column is read.
ล to je CSV datoteka?
CSV stands for Comma Separated Values. It is a plain text file in which every line is one record, and the values inside a record are separated by a comma. Because it holds only text and separators, and no formatting, a CSV can be created and read by databases, web applications, and every spreadsheet program.
The limitation is that a CSV keeps no fonts, colours, formulas, or multiple sheets. It stores the raw data only, which is exactly why it is a reliable format for moving records from one system into Excel, where the formatting and formulas are added afterwards.
Kako uvesti/konvertirati CSV u Excel
U ovom ฤemo vodiฤu uvesti vanjske podatke iz jednostavne CSV datoteke koja sadrลพi plaฤanja korisnika. Moลพete preuzeti CSV datoteku za ovu vjeลพbu.
- Otvorite novu radnu knjigu
- Pritisnite karticu PODACI na vrpci
- Pritisnite gumb Iz teksta
- Dobit ฤete sljedeฤi prozor
- Idite do mape u koju ste preuzeli CSV datoteku
- Odaberite datoteku da.csv
- Kliknite gumb Uvezi
- Dobit ฤete sljedeฤi ฤarobnjak za uvoz tekstualne datoteke
- Pritisnite gumb Dalje
- Odaberite Zarez na ploฤi Razdjelnici
- Pritisnite gumb Dalje
- Pritisnite gumb Zavrลกi
- Pritisnite gumb OK
- Dobit ฤete sljedeฤe podatke
Importing Other Delimiter Separated Files
U nekim sluฤajevima moลพda neฤete dobiti datoteku odvojenu zarezima, to mogu biti kose crte (\), crte (|) ili druge datoteke odvojene graniฤnicima. Pogledajmo kako se s njima nositi.
Ovdje je ogledna datoteka s vrijednostima odvojenim kosom crtom (\) koju moลพete preuzeti.
Preuzmite CSV datoteku odvojenu kosom crtom (\).
- Otvorite novu radnu knjigu
- Pritisnite karticu PODACI na vrpci
- Pritisnite gumb Iz teksta
- Idite do mape u koju ste preuzeli datoteku i uvezite je
- Dobit ฤete sljedeฤi ฤarobnjak za uvoz tekstualne datoteke
- Pritisnite gumb Dalje
- Sada umjesto odabira razdjelnika zareza, odaberite Ostalo i postavite kosu crtu (\) kao razdjelnik na ploฤi Razdjelnici
- Zatim kliknite na gumb Dalje.
- Zatim kliknite gumb Zavrลกi
- Sada uvezite podatke u postojeฤi radni list
Dobit ฤete sljedeฤe podatke
๐ก Savjet: The same wizard handles a Tab, a Semicolon, or a Pipe. Whenever the preview in the wizard shows every value squeezed into one column, the wrong delimiter is selected, so switch to Other and type the correct character.
Open vs Import: Two Ways to Bring a CSV into Excel
A CSV can reach a worksheet in two ways, and the right choice depends on how much control the columns need. The table below compares them.
| naฤin | Kako | Najbolje za |
|---|---|---|
| Open directly | Double click the file, or File then Open | A clean, comma separated file where the default column types are fine |
| ฤarobnjak za uvoz teksta | DATA tab, From Text, then choose the delimiter | A file with an unusual delimiter, or columns that must be set as text or date |
| Power Query (Get Data) | DATA tab, Get Data, From Text/CSV on newer Excel | A file that must be cleaned, filtered, and refreshed repeatedly |
โ ๏ธ Upozorenje: Opening a CSV directly can change the data. A long number such as a phone number or an ID may lose its leading zero, and a value that looks like a date may be converted. Use the Text Import Wizard and set that column to Text to keep the value exactly as it is.
