Lists - Create a list from an Excel file Tutorial

In this video, you will learn how to create a list from an Excel file using Microsoft Lists.
The video covers the steps to import raw data from an Excel workbook and turn it into a list.
You will start by opening the Excel file and using the "format as table" feature.
Then, you will upload the pre-formatted file in Microsoft Lists and select the tables you are interested in.
After making any necessary corrections to the data type, you will name your list and personalize it with a color and icon.
This tutorial will help you efficiently create lists from Excel files, enhancing your organization and data management.

  • 1:42
  • 2778 views

Objectifs :

This document aims to guide users through the process of creating a list in Microsoft Lists using data imported from an Excel workbook. It outlines the necessary steps, options available, and tips for ensuring a successful import.

Chapitres :

  1. Introduction to Microsoft Lists
    Microsoft Lists is a powerful tool that allows users to organize and manage information effectively. This guide will walk you through the steps to create a new list from an Excel workbook, enabling you to leverage existing data for better organization.
  2. Creating a New List from Excel
    To start creating a list from an Excel workbook, follow these steps: 1. **Access Microsoft Lists**: Begin at the Microsoft Lists home page. 2. **Initiate List Creation**: Click on the 'New list' button. 3. **Select Import Option**: Choose 'From Excel' to import your data.
  3. Preparing Your Excel Workbook
    Before importing your data, ensure that your Excel workbook is properly formatted: - **Open Your Excel File**: Launch the Excel file you wish to use. - **Format as Table**: Select the data you want to import and click on the 'Format as Table' button. This step is crucial as it prepares your data for import. - **Close Excel**: After formatting, you can close the Excel file and return to Microsoft Lists.
  4. Uploading Your Data
    Once back in Microsoft Lists: 1. **Locate Your File**: Click on 'From Excel' and find your pre-formatted file either on your device or in OneDrive. 2. **Upload the File**: Select the file to upload it into Microsoft Lists. 3. **Select Tables**: If your Excel workbook contains multiple tables, choose the ones you want to import.
  5. Finalizing Your List
    After selecting your data, ensure the following: - **Check Data Types**: Review the data types for each column and make any necessary corrections. - **Name Your List**: Enter a name for your list, as this is a mandatory field. - **Add a Description**: Optionally, you can include a description for your list. - **Personalize Your List**: Choose a color and an icon to customize your list's appearance. - **Specify Storage Location**: By default, your list will be stored in 'My lists', but you can also link it to an existing SharePoint site if preferred.
  6. Conclusion
    Creating a list from an Excel workbook in Microsoft Lists is a straightforward process that enhances your ability to manage data effectively. By following the outlined steps, you can ensure a smooth import and create a personalized list that meets your organizational needs.

FAQ :

How do I create a list from an Excel workbook in Microsoft Lists?

To create a list from an Excel workbook, start by clicking on 'New list' in Microsoft Lists, then select 'From Excel'. Import your data by using the 'Format as Table' feature in Excel, and upload the pre-formatted file.

What should I do if my Excel workbook contains multiple tables?

If your Excel workbook contains several tables, you can select the specific tables you are interested in during the import process in Microsoft Lists.

Is it mandatory to add a description when naming my list?

No, adding a description is optional when naming your list in Microsoft Lists.

Can I store my list in a SharePoint site?

Yes, you can link your list to an existing SharePoint site instead of using the default location, 'My lists'.

What is the 'Format as Table' feature in Excel?

The 'Format as Table' feature in Excel allows you to convert a range of data into a structured table format, which enhances data management and analysis.

Quelques cas d'usages :

Project Management

Use Microsoft Lists to track project tasks and deadlines by importing task data from an Excel workbook. This allows for better organization and visibility of project progress.

Inventory Tracking

Import inventory data from an Excel workbook into Microsoft Lists to manage stock levels and product details efficiently. This can help streamline inventory management processes.

Event Planning

Create a list for event planning by importing guest lists and schedules from Excel. This helps in organizing event details and ensuring all aspects are covered.

Customer Relationship Management

Utilize Microsoft Lists to manage customer information by importing data from an Excel workbook. This can improve customer tracking and relationship management.

Data Analysis

Import data sets from Excel into Microsoft Lists for collaborative analysis. This allows teams to work together on data insights and decision-making.

Glossaire :

Microsoft Lists

A Microsoft 365 app that helps users track information and organize work. It allows users to create, share, and manage lists of data.

Excel workbook

A file created by Microsoft Excel that contains one or more worksheets, where data can be organized in rows and columns.

Format as Table

A feature in Excel that allows users to convert a range of data into a table format, making it easier to manage and analyze data.

Data type

The classification of data that tells the program how to interpret the data, such as text, number, date, etc.

SharePoint

A web-based collaboration platform that integrates with Microsoft Office, allowing users to store, organize, share, and access information from any device.

résultat(s)
00:00:04
click on "New list" to create a
00:00:07
list from an Excel workbook.
00:00:10
You have several options.
00:00:11
Click "from Excel" in Microsoft Lists.
00:00:14
You can import raw data from an Excel
00:00:17
workbook and turn it into a list
00:00:20
to successfully import this data,
00:00:22
use the format as table feature in Excel.
00:00:26
First start by opening the
00:00:28
Excel file in question.
00:00:30
Select your sheet data,
00:00:31
then use the format as table button.
00:00:36
You can now close the Excel
00:00:38
file and go back to Lists . After
00:00:41
clicking "from Excel" in list.
00:00:43
Locate your file under
00:00:45
your device or OneDrive.
00:00:47
You are now uploading the
00:00:49
pre formatted file in Lists.
00:00:51
If your Excel workbook
00:00:53
contains several tables,
00:00:54
select the ones you are interested in.
00:00:57
Then double check the
00:00:58
data type for each column.
00:01:03
If needed, make the necessary corrections.
00:01:11
Now you must name your list
00:01:13
as this is a mandatory field.
00:01:16
You may also add a description knowing
00:01:19
that this time this field is optional.
00:01:22
You will then choose a color and an
00:01:24
icon to personalize your list and
00:01:26
then specify where it will be stored.
00:01:29
"My lists" is the default location,
00:01:31
but if you prefer you may link it
00:01:34
to an existing SharePoint site.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
clique em "Nova lista" para criar um
00:00:07
lista de um livro do Excel.
00:00:10
Tem várias opções.
00:00:11
Clique em "from Excel" nas Listas da Microsoft.
00:00:14
Pode importar dados brutos de um Excel
00:00:17
livro de trabalho e transformá-lo em uma lista
00:00:20
para importar com sucesso estes dados,
00:00:22
utilize o formato como função de tabela no Excel.
00:00:26
Primeiro começar por abrir o
00:00:28
Excel arquivo em questão.
00:00:30
Selecione os dados da sua folha,
00:00:31
em seguida, use o formato como botão de mesa.
00:00:36
Agora pode fechar o Excel
00:00:38
arquivar e voltar para listas . Depois
00:00:41
clicando em "do Excel" na lista.
00:00:43
Localize o seu arquivo em
00:00:45
o seu dispositivo ou OneDrive.
00:00:47
Está agora a enviar o
00:00:49
ficheiro pré-formatado em Listas.
00:00:51
Se o seu livro excel
00:00:53
contém várias tabelas,
00:00:54
selecione os que lhe interessam.
00:00:57
Em seguida, verificar duas vezes o
00:00:58
tipo de dados para cada coluna.
00:01:03
Se necessário, faça as correções necessárias.
00:01:11
Agora deve nomear a sua lista
00:01:13
como este é um campo obrigatório.
00:01:16
Você também pode adicionar uma descrição sabendo
00:01:19
que desta vez este campo é opcional.
00:01:22
Em seguida, você vai escolher uma cor e um
00:01:24
ícone para personalizar a sua lista e
00:01:26
em seguida, especificar onde será armazenado.
00:01:29
"As minhas listas" é a localização padrão,
00:01:31
mas se preferir, pode ligá-lo
00:01:34
para um site sharePoint existente.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
haga clic en "Nueva lista" para crear un
00:00:07
de un libro de Excel.
00:00:10
Tienes varias opciones.
00:00:11
Haga clic en "desde Excel" en Microsoft Lists.
00:00:14
Puede importar datos sin procesar desde un Excel
00:00:17
libro y consérelo en una lista
00:00:20
para importar correctamente estos datos,
00:00:22
utilice el formato como característica de tabla en Excel.
00:00:26
Primero comience abriendo el
00:00:28
Archivo Excel en cuestión.
00:00:30
Seleccione los datos de su hoja,
00:00:31
a continuación, utilice el botón Formato como tabla.
00:00:36
Ahora puede cerrar el Excel
00:00:38
y volver a Listas . Después
00:00:41
haciendo clic en "desde Excel" en la lista.
00:00:43
Localice su archivo en
00:00:45
su dispositivo o OneDrive.
00:00:47
Ahora está cargando el
00:00:49
archivo preformateado en Listas.
00:00:51
Si el libro de Excel
00:00:53
contiene varias tablas,
00:00:54
seleccione los que le interesan.
00:00:57
A continuación, verifique dos veces el
00:00:58
tipo de datos para cada columna.
00:01:03
Si es necesario, haga las correcciones necesarias.
00:01:11
Ahora debes nombrar tu lista
00:01:13
ya que este es un campo obligatorio.
00:01:16
También puede agregar una descripción sabiendo
00:01:19
que esta vez este campo es opcional.
00:01:22
A continuación, elegirá un color y un
00:01:24
para personalizar su lista y
00:01:26
a continuación, especifique dónde se almacenará.
00:01:29
"Mis listas" es la ubicación predeterminada,
00:01:31
pero si lo prefieres puedes enlazarlo
00:01:34
a un sitio de SharePoint existente.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
clicca su "Nuova lista" per creare un
00:00:07
da una cartella di lavoro di Excel.
00:00:10
Hai diverse opzioni.
00:00:11
Fai clic su "da Excel" in Microsoft Lists.
00:00:14
È possibile importare dati non elaborati da un Excel
00:00:17
cartella di lavoro e trasformarla in un elenco
00:00:20
per importare correttamente questi dati,
00:00:22
utilizzare la funzionalità Formato come tabella in Excel.
00:00:26
Per prima cosa inizia aprendo il
00:00:28
File Excel in questione.
00:00:30
Seleziona i dati del tuo foglio,
00:00:31
quindi utilizzare il pulsante Formato come tabella.
00:00:36
È ora possibile chiudere Excel
00:00:38
e tornare a Elenchi . Dopo
00:00:41
facendo clic su "da Excel" nell'elenco.
00:00:43
Individua il tuo file in
00:00:45
il dispositivo o OneDrive.
00:00:47
Ora stai caricando il
00:00:49
file preformattato in Elenchi.
00:00:51
Se la cartella di lavoro di Excel
00:00:53
contiene diverse tabelle,
00:00:54
seleziona quelli che ti interessano.
00:00:57
Quindi ricontrollare il
00:00:58
tipo di dati per ogni colonna.
00:01:03
Se necessario, apportare le correzioni necessarie.
00:01:11
Ora devi nominare la tua lista
00:01:13
in quanto si tratta di un campo obbligatorio.
00:01:16
Puoi anche aggiungere una descrizione conoscendo
00:01:19
che questa volta questo campo è facoltativo.
00:01:22
Sceglierai quindi un colore e un
00:01:24
per personalizzare l'elenco e
00:01:26
quindi specificare dove verrà memorizzato.
00:01:29
"Le mie liste" è la posizione predefinita,
00:01:31
ma se preferisci puoi linkarlo
00:01:34
a un sito di SharePoint esistente.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
Klicken Sie auf "Neue Liste", um eine
00:00:07
Liste aus einer Excel-Arbeitsmappe.
00:00:10
Sie haben mehrere Möglichkeiten.
00:00:11
Klicken Sie in Microsoft Lists auf "aus Excel".
00:00:14
Sie können Rohdaten aus Excel importieren
00:00:17
Arbeitsmappe und Umwandlung in eine Liste
00:00:20
um diese Daten erfolgreich zu importieren,
00:00:22
Verwenden Sie das Format als Tabellenfeature in Excel.
00:00:26
Beginnen Sie zunächst mit dem Öffnen der
00:00:28
Excel-Datei in Frage.
00:00:30
Wählen Sie Ihre Blattdaten aus,
00:00:31
Verwenden Sie dann die Schaltfläche Format als Tabelle.
00:00:36
Sie können jetzt die Excel schließen
00:00:38
und gehen Sie zurück zu Listen . Nach
00:00:41
Klicken Sie in der Liste auf "aus Excel".
00:00:43
Suchen Sie Ihre Datei unter
00:00:45
Ihr Gerät oder OneDrive.
00:00:47
Sie laden jetzt die
00:00:49
vorformatierte Datei in Listen.
00:00:51
Wenn Ihre Excel-Arbeitsmappe
00:00:53
enthält mehrere Tabellen,
00:00:54
Wählen Sie diejenigen aus, an denen Sie interessiert sind.
00:00:57
Dann überprüfen Sie die
00:00:58
Datentyp für jede Spalte.
00:01:03
Nehmen Sie bei Bedarf die erforderlichen Korrekturen vor.
00:01:11
Jetzt müssen Sie Ihre Liste benennen
00:01:13
da dies ein Pflichtfeld ist.
00:01:16
Sie können auch eine Beschreibung hinzufügen, die
00:01:19
dass dieses Feld diesmal optional ist.
00:01:22
Sie wählen dann eine Farbe und eine
00:01:24
Symbol, um Ihre Liste zu personalisieren und
00:01:26
Geben Sie dann an, wo es gespeichert werden soll.
00:01:29
"Meine Listen" ist der Standardspeicherort,
00:01:31
aber wenn Sie es vorziehen, können Sie es verlinken
00:01:34
auf eine vorhandene SharePoint-Website.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
按兩下「新清單」以創建
00:00:07
從 Excel 工作簿中列出。
00:00:10
您有幾個選項。
00:00:11
點擊微軟清單中的"Excel"。
00:00:14
您可以從 Excel 匯入原始資料
00:00:17
工作簿，並把它變成一個清單
00:00:20
成功導入此數據，
00:00:22
在 Excel 中將該格式用作表功能。
00:00:26
首先打開
00:00:28
有問題的Excel檔。
00:00:30
選擇您的表數據，
00:00:31
然後使用該格式作為表按鈕。
00:00:36
您現在可以關閉 Excel
00:00:38
檔，並返回到清單。後
00:00:41
按兩下清單中的「來自 Excel」。
00:00:43
將檔定位在下
00:00:45
您的設備或 OneDrive。
00:00:47
您現在正在上傳
00:00:49
清單中的預格式化檔。
00:00:51
如果您的 Excel 工作簿
00:00:53
包含幾張表格，
00:00:54
選擇您感興趣的。
00:00:57
然後仔細檢查
00:00:58
每個列的數據類型。
00:01:03
如有必要，進行必要的更正。
00:01:11
現在，您必須命名您的清單
00:01:13
因為這是一個強制性的欄位。
00:01:16
您也可以添加一個說明知道
00:01:19
這一次這個欄位是可選的。
00:01:22
然後，您將選擇顏色和
00:01:24
圖示個性化您的清單和
00:01:26
然後指定存儲位置。
00:01:29
"我的清單"是預設位置，
00:01:31
但如果你願意， 你可以連結它
00:01:34
到現有的共享點網站。

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
klik op "Nieuwe lijst" om een
00:00:07
lijst uit een Excel-werkmap.
00:00:10
Je hebt verschillende opties.
00:00:11
Klik op 'uit Excel' in Microsoft-lijsten.
00:00:14
U kunt onbewerkte gegevens importeren uit een Excel
00:00:17
werkmap en maak er een lijst van
00:00:20
om deze gegevens met succes te importeren,
00:00:22
gebruik de indeling als tabelfunctie in Excel.
00:00:26
Begin eerst met het openen van de
00:00:28
Excel-bestand in kwestie.
00:00:30
Selecteer uw bladgegevens,
00:00:31
gebruik dan de opmaak als tabelknop.
00:00:36
U kunt nu de Excel-
00:00:38
bestand en ga terug naar Lijsten . Na
00:00:41
klikken op "uit Excel" in de lijst.
00:00:43
Zoek uw bestand onder
00:00:45
uw apparaat of OneDrive.
00:00:47
U uploadt nu de
00:00:49
vooraf opgemaakt bestand in Lijsten.
00:00:51
Als uw Excel-werkmap
00:00:53
bevat verschillende tabellen,
00:00:54
selecteer degene waarin u geïnteresseerd bent.
00:00:57
Controleer vervolgens nogmaals de
00:00:58
gegevenstype voor elke kolom.
00:01:03
Breng indien nodig de nodige correcties aan.
00:01:11
Nu moet je je lijst een naam geven.
00:01:13
omdat dit een verplicht veld is.
00:01:16
U kunt ook een beschrijving toevoegen
00:01:19
dat dit veld deze keer optioneel is.
00:01:22
U kiest dan een kleur en een
00:01:24
om uw lijst te personaliseren en
00:01:26
geef vervolgens op waar het wordt opgeslagen.
00:01:29
"Mijn lijsten" is de standaardlocatie,
00:01:31
maar als u wilt, kunt u het koppelen
00:01:34
naar een bestaande SharePoint-site.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
nhấp vào "Danh sách mới" để tạo
00:00:07
danh sách từ sổ làm việc Excel.
00:00:10
Bạn có nhiều lựa chọn.
00:00:11
Nhấp vào "từ Excel" trong Danh sách Microsoft.
00:00:14
Bạn có thể nhập dữ liệu thô từ Excel
00:00:17
sổ làm việc và biến nó thành danh sách
00:00:20
để nhập thành công dữ liệu này,
00:00:22
sử dụng định dạng làm tính năng bảng trong Excel.
00:00:26
Đầu tiên bắt đầu bằng cách mở
00:00:28
Tệp Excel được đề cập.
00:00:30
Chọn dữ liệu trang tính của bạn,
00:00:31
sau đó sử dụng định dạng làm nút bảng.
00:00:36
Bây giờ bạn có thể đóng Excel
00:00:38
tệp và quay lại Danh sách . Sau
00:00:41
bấm vào "từ Excel" trong danh sách.
00:00:43
Định vị tệp của bạn dưới
00:00:45
thiết bị của bạn hoặc OneDrive.
00:00:47
Bây giờ bạn đang tải lên
00:00:49
Tệp được định dạng trước trong Danh sách.
00:00:51
Nếu sổ làm việc Excel của bạn
00:00:53
chứa một số bảng,
00:00:54
Chọn những cái bạn quan tâm.
00:00:57
Sau đó kiểm tra kỹ
00:00:58
loại dữ liệu cho từng cột.
00:01:03
Nếu cần thiết, hãy thực hiện các sửa chữa cần thiết.
00:01:11
Bây giờ bạn phải đặt tên cho danh sách của bạn
00:01:13
Vì đây là một lĩnh vực bắt buộc.
00:01:16
Bạn cũng có thể thêm một mô tả biết
00:01:19
Lần này trường này là tùy chọn.
00:01:22
Sau đó, bạn sẽ chọn một màu sắc và một
00:01:24
biểu tượng để cá nhân hóa danh sách của bạn và
00:01:26
sau đó chỉ định nơi nó sẽ được lưu trữ.
00:01:29
"Danh sách của tôi" là vị trí mặc định,
00:01:31
Nhưng nếu bạn thích, bạn có thể liên kết nó
00:01:34
đến site SharePoint hiện có.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
klik pada "Daftar baru" untuk membuat
00:00:07
daftar dari buku kerja Excel.
00:00:10
Anda memiliki beberapa pilihan.
00:00:11
Klik "dari Excel" di Daftar Microsoft.
00:00:14
Anda bisa mengimpor data mentah dari Excel
00:00:17
buku kerja dan mengubahnya menjadi daftar
00:00:20
untuk berhasil mengimpor data ini,
00:00:22
gunakan format sebagai fitur tabel di Excel.
00:00:26
Pertama mulai dengan membuka
00:00:28
File Excel yang dimaksud.
00:00:30
Pilih data lembar Anda,
00:00:31
kemudian gunakan format sebagai tombol tabel.
00:00:36
Anda sekarang dapat menutup Excel
00:00:38
file dan kembali ke Daftar. Sesudah
00:00:41
mengklik "dari Excel" dalam daftar.
00:00:43
Temukan file Anda di bawah ini
00:00:45
perangkat anda atau OneDrive.
00:00:47
Anda sekarang meng-upload
00:00:49
berkas yang diformat sebelumnya dalam Daftar.
00:00:51
Jika buku kerja Excel Anda
00:00:53
berisi beberapa tabel,
00:00:54
Pilih yang Anda minati.
00:00:57
Kemudian periksa kembali
00:00:58
tipe data untuk setiap kolom.
00:01:03
Jika diperlukan, lakukan koreksi yang diperlukan.
00:01:11
Sekarang Anda harus memberi nama daftar Anda
00:01:13
Karena ini adalah bidang wajib.
00:01:16
Anda juga dapat menambahkan deskripsi yang mengetahui
00:01:19
bahwa kali ini bidang ini opsional.
00:01:22
Anda kemudian akan memilih warna dan
00:01:24
ikon untuk mempersonalisasi daftar Anda dan
00:01:26
kemudian tentukan di mana ia akan disimpan.
00:01:29
"Daftar saya" adalah lokasi default,
00:01:31
Tetapi jika Anda lebih suka, Anda dapat menghubungkannya
00:01:34
ke situs SharePoint yang sudah ada.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
[新しいリスト] をクリックして、
00:00:07
Excel ブックのリストを参照してください。
00:00:10
いくつかのオプションがあります。
00:00:11
マイクロソフトのリストで "Excel から" をクリックします。
00:00:14
Excel から生データをインポートできます。
00:00:17
ブックを作成し、リストに変換する
00:00:20
このデータを正常にインポートするには、
00:00:22
Excel の表の機能として形式を使用します。
00:00:26
最初の開始は、
00:00:28
問題の Excel ファイル。
00:00:30
シートデータを選択し、
00:00:31
その後、テーブルボタンとしてフォーマットを使用します。
00:00:36
これで Excel を閉じることができる
00:00:38
ファイルを開き、リストに戻ります。後
00:00:41
リストの 「Excel から」をクリックします。
00:00:43
下のファイルを探す
00:00:45
デバイスまたは OneDrive を使用します。
00:00:47
これでアップロードされます。
00:00:49
リスト内のプリフォーマットされたファイル。
00:00:51
Excel ブックの場合
00:00:53
には複数のテーブルが含まれています。
00:00:54
興味のあるものを選択してください。
00:00:57
その後、ダブルチェック
00:00:58
各列のデータ型。
00:01:03
必要に応じて、必要な修正を行います。
00:01:11
今、あなたはあなたのリストに名前を付ける必要があります
00:01:13
これは必須フィールドです。
00:01:16
また、説明を追加することもできます
00:01:19
この時間はこのフィールドはオプションです。
00:01:22
その後、色と
00:01:24
あなたのリストをパーソナライズするアイコンと
00:01:26
その後、格納場所を指定します。
00:01:29
「マイ リスト」はデフォルトの場所です。
00:01:31
しかし、あなたがそれをリンクすることができます
00:01:34
既存の SharePoint サイトに移動します。

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
انقر على "قائمة جديدة" لإنشاء
00:00:07
قائمة من مصنف Excel.
00:00:10
لديك العديد من الخيارات.
00:00:11
انقر فوق "من Excel" في قوائم Microsoft.
00:00:14
يمكنك استيراد البيانات الأولية من Excel
00:00:17
المصنف وتحويله إلى قائمة
00:00:20
لاستيراد هذه البيانات بنجاح،
00:00:22
استخدام التنسيق كميزة جدول في Excel.
00:00:26
البداية الأولى بفتح
00:00:28
ملف Excel المعني.
00:00:30
حدد بيانات الورقة،
00:00:31
ثم استخدم التنسيق كزر جدول.
00:00:36
يمكنك الآن إغلاق Excel
00:00:38
ملف والعودة إلى قوائم . بعد
00:00:41
النقر على "من Excel" في القائمة.
00:00:43
تحديد موقع الملف تحت
00:00:45
جهازك أو أندريف.
00:00:47
أنت الآن تحميل
00:00:49
ملف منسق مسبقا في القوائم.
00:00:51
إذا كان مصنف Excel
00:00:53
يحتوي على عدة جداول،
00:00:54
حدد تلك التي كنت مهتما.
00:00:57
ثم تحقق مرتين من
00:00:58
نوع البيانات لكل عمود.
00:01:03
إذا لزم الأمر، قم بإجراء التصحيحات اللازمة.
00:01:11
الآن يجب عليك تسمية قائمتك
00:01:13
لأن هذا حقل إلزامي.
00:01:16
يمكنك أيضا إضافة وصف مع العلم
00:01:19
أن هذا الحقل اختياري هذه المرة.
00:01:22
ثم سوف تختار لون و
00:01:24
لتخصيص القائمة و
00:01:26
ثم حدد المكان الذي سيتم تخزينه فيه.
00:01:29
"قوائمي" هو الموقع الافتراضي،
00:01:31
ولكن إذا كنت تفضل يمكنك ربطه
00:01:34
إلى موقع SharePoint موجود.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
oluşturmak için "Yeni liste"ye tıklayın
00:00:07
excel çalışma kitabından liste.
00:00:10
Birkaç seçeneğiniz var.
00:00:11
Microsoft Listelerinde "Excel'den" öğesini tıklatın.
00:00:14
Excel'den ham veri alabilirsiniz
00:00:17
çalışma kitabı ve listeye dönüştürme
00:00:20
bu verileri başarıyla almak için,
00:00:22
Excel'de tablo olarak biçim özelliğini kullanın.
00:00:26
İlk olarak
00:00:28
Söz konusu Excel dosyası.
00:00:30
Sayfa verilerinizi seçin,
00:00:31
ardından tablo olarak biçimlendir düğmesini kullanın.
00:00:36
Artık Excel'i kapatabilirsiniz
00:00:38
dosyasına gidin ve Listeler 'e geri dönün. Sonra
00:00:41
listesinde "Excel'den" i tıklatarak.
00:00:43
Dosyanızı
00:00:45
cihazınızı veya OneDrive'ı seçin.
00:00:47
Şimdi
00:00:49
listeler'de önceden biçimlendirilmiş dosya.
00:00:51
Excel çalışma kitabınız
00:00:53
birkaç tablo içerir,
00:00:54
ilgilendiğinizi seçin.
00:00:57
Ardından,
00:00:58
her sütun için veri türü.
00:01:03
Gerekirse, gerekli düzeltmeleri yapın.
00:01:11
Şimdi listenizi adlandırmalısınız
00:01:13
bu zorunlu bir alan olduğu için.
00:01:16
Ayrıca,
00:01:19
bu kez bu alan isteğe bağlıdır.
00:01:22
Daha sonra bir renk ve
00:01:24
simgesini kullanarak listenizi kişiselleştirin ve
00:01:26
ardından nerede saklanacağını belirtin.
00:01:29
"Listelerim" varsayılan konumdur,
00:01:31
ama isterseniz bağlayabilirsiniz
00:01:34
varolan bir SharePoint sitesine.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
"새 목록"을 클릭하여
00:00:07
Excel 통합 문서의 목록입니다.
00:00:10
몇 가지 옵션이 있습니다.
00:00:11
마이크로 소프트 목록에서 "엑셀에서"를 클릭합니다.
00:00:14
Excel에서 원시 데이터를 가져올 수 있습니다.
00:00:17
통합 문서 및 목록으로 전환
00:00:20
이 데이터를 성공적으로 가져오기 위해
00:00:22
Excel에서 형식을 테이블 피쳐로 사용합니다.
00:00:26
먼저 시작하여
00:00:28
문제의 Excel 파일.
00:00:30
시트 데이터를 선택하고,
00:00:31
그런 다음 형식을 테이블 버튼으로 사용합니다.
00:00:36
이제 Excel을 닫을 수 있습니다.
00:00:38
파일을 사용하여 목록으로 돌아갑니다. 후
00:00:41
목록에서 "Excel에서"를 클릭합니다.
00:00:43
아래 파일 찾기
00:00:45
장치 또는 원드라이브.
00:00:47
이제
00:00:49
목록에서 미리 포맷된 파일입니다.
00:00:51
Excel 통합 문서인 경우
00:00:53
여러 테이블이 포함되어 있습니다.
00:00:54
관심 있는 것을 선택합니다.
00:00:57
그런 다음 다시 확인하십시오.
00:00:58
각 열에 대한 데이터 형식입니다.
00:01:03
필요한 경우 필요한 수정을 하십시오.
00:01:11
이제 목록의 이름을 지정해야 합니다.
00:01:13
이것은 필수 필드입니다.
00:01:16
알고 있는 설명을 추가할 수도 있습니다.
00:01:19
이번에는 이 필드가 선택 사항입니다.
00:01:22
그런 다음 색상을 선택하고
00:01:24
목록을 개인화하고
00:01:26
그런 다음 저장할 위치를 지정합니다.
00:01:29
"내 목록"은 기본 위치이며,
00:01:31
당신이 선호하는 경우 당신은 그것을 연결할 수 있습니다
00:01:34
기존 SharePoint 사이트에 있습니다.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
单击"新建列表"以创建一个
00:00:07
列表从 Excel 工作簿。
00:00:10
您有几种选择。
00:00:11
单击 Microsoft 列表中的"from Excel"。
00:00:14
您可以从 Excel 导入原始数据
00:00:17
工作簿并将其转换为列表
00:00:20
要成功导入此数据，
00:00:22
在Excel中使用格式作为表格功能。
00:00:26
首先打开
00:00:28
有问题的 Excel 文件。
00:00:30
选择您的工作表数据，
00:00:31
，然后使用"格式为表格"按钮。
00:00:36
您现在可以关闭 Excel
00:00:38
文件，然后返回列表 。后
00:00:41
单击列表中的"从 Excel"。
00:00:43
在
00:00:45
你的设备或 OneDrive。
00:00:47
您现在正在上传
00:00:49
列表中预先格式化的文件。
00:00:51
如果您的 Excel 工作簿
00:00:53
包含多个表，
00:00:54
选择您感兴趣的那些。
00:00:57
然后仔细检查
00:00:58
每列的数据类型。
00:01:03
如果需要，请进行必要的更正。
00:01:11
现在，您必须命名您的列表
00:01:13
因为这是必填字段。
00:01:16
您也可以添加描述，知道
00:01:19
这次此字段是可选的。
00:01:22
然后，您将选择一种颜色和
00:01:24
图标来个性化您的列表和
00:01:26
然后指定其存储位置。
00:01:29
"我的列表"是默认位置，
00:01:31
但如果你愿意，你可以链接它
00:01:34
到现有 SharePoint 网站。

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
faceți clic pe "Listă nouă" pentru a crea o
00:00:07
listă dintr-un registru de lucru Excel.
00:00:10
Aveți mai multe opțiuni.
00:00:11
Faceți clic pe "din Excel" în Listele Microsoft.
00:00:14
Puteți importa date brute dintr-un Excel
00:00:17
registru de lucru și transformarea acestuia într-o listă
00:00:20
pentru a importa cu succes aceste date,
00:00:22
utilizați formatul ca caracteristică de tabel în Excel.
00:00:26
Mai întâi începeți prin deschiderea
00:00:28
Fișier Excel în cauză.
00:00:30
Selectați datele foii,
00:00:31
apoi utilizați formatul ca buton de tabel.
00:00:36
Acum puteți închide Excel
00:00:38
fișier și du-te înapoi la liste . După
00:00:41
făcând clic pe "din Excel" în listă.
00:00:43
Găsiți fișierul sub
00:00:45
dispozitivul sau OneDrive.
00:00:47
Sunteți acum încărcarea
00:00:49
fișier pre formatat în Liste.
00:00:51
Dacă registrul de lucru Excel
00:00:53
conține mai multe tabele,
00:00:54
selectați-le pe cele care vă interesează.
00:00:57
Apoi verificați de două ori
00:00:58
tip de date pentru fiecare coloană.
00:01:03
Dacă este necesar, faceți corecțiile necesare.
00:01:11
Acum trebuie să vă denumiți lista
00:01:13
deoarece acesta este un domeniu obligatoriu.
00:01:16
De asemenea, puteți adăuga o descriere știind
00:01:19
că de data aceasta acest câmp este opțional.
00:01:22
Veți alege apoi o culoare și o
00:01:24
pictograma pentru a personaliza lista și
00:01:26
apoi specificați unde va fi stocat.
00:01:29
"Listele mele" este locația implicită,
00:01:31
dar dacă preferați s-ar putea să-l link-ul
00:01:34
la un site SharePoint existent.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
clique em "Nova lista" para criar um
00:00:07
lista de uma pasta de trabalho Excel.
00:00:10
Você tem várias opções.
00:00:11
Clique em "do Excel" em Listas da Microsoft.
00:00:14
Você pode importar dados brutos de um Excel
00:00:17
livro de trabalho e transformá-lo em uma lista
00:00:20
para importar com sucesso esses dados,
00:00:22
usar o formato como recurso de tabela no Excel.
00:00:26
Primeira partida abrindo o
00:00:28
Arquivo Excel em questão.
00:00:30
Selecione os dados da folha,
00:00:31
em seguida, use o formato como botão de tabela.
00:00:36
Agora você pode fechar o Excel
00:00:38
arquivo e voltar para Listas . Depois
00:00:41
clicando em "do Excel" na lista.
00:00:43
Localize seu arquivo em
00:00:45
seu dispositivo ou OneDrive.
00:00:47
Agora você está carregando o
00:00:49
arquivo pré-formatado em Listas.
00:00:51
Se sua carteira de trabalho Excel
00:00:53
contém várias tabelas,
00:00:54
selecione os que você está interessado.
00:00:57
Em seguida, verifique duas vezes o
00:00:58
tipo de dados para cada coluna.
00:01:03
Se necessário, faça as correções necessárias.
00:01:11
Agora você deve nomear sua lista
00:01:13
pois este é um campo obrigatório.
00:01:16
Você também pode adicionar uma descrição sabendo
00:01:19
que desta vez este campo é opcional.
00:01:22
Em seguida, você vai escolher uma cor e um
00:01:24
ícone para personalizar sua lista e
00:01:26
em seguida, especifique onde ele será armazenado.
00:01:29
"Minhas listas" é o local padrão,
00:01:31
mas se você preferir que você pode vinculá-lo
00:01:34
para um site SharePoint existente.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
нажмите на "Новый список", чтобы создать
00:00:07
из книги Excel.
00:00:10
У вас есть несколько вариантов.
00:00:11
Нажмите «из Excel» в списках Майкрософт.
00:00:14
Можно импортировать необработанные данные из Excel
00:00:17
книгу и превратите ее в список
00:00:20
для успешного импорта этих данных,
00:00:22
используйте функцию формата таблицы в Excel.
00:00:26
Сначала начните с открытия
00:00:28
Рассматриваемый файл Excel.
00:00:30
Выберите данные листа,
00:00:31
затем используйте кнопку Формат как таблица.
00:00:36
Теперь можно закрыть Excel
00:00:38
и вернитесь в Списки . После
00:00:41
нажатие кнопки "из Excel" в списке.
00:00:43
Найдите файл в разделе
00:00:45
вашего устройства или OneDrive.
00:00:47
Теперь вы загружаете
00:00:49
предварительно отформатированный файл в списках.
00:00:51
Если книга Excel
00:00:53
содержит несколько таблиц,
00:00:54
выберите те, которые вас интересуют.
00:00:57
Затем дважды проверьте
00:00:58
тип данных для каждого столбца.
00:01:03
При необходимости внесите необходимые исправления.
00:01:11
Теперь вы должны назвать свой список
00:01:13
так как это обязательное поле.
00:01:16
Вы также можете добавить описание, зная
00:01:19
что на этот раз это поле является необязательным.
00:01:22
Затем вы выберете цвет и
00:01:24
для персонализации списка и
00:01:26
затем укажите, где он будет храниться.
00:01:29
"Мои списки" - это местоположение по умолчанию,
00:01:31
Но при желании вы можете связать его
00:01:34
на существующий сайт SharePoint.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
คลิกที่ "รายการใหม่" เพื่อสร้าง
00:00:07
รายการจากเวิร์กบุ๊ก Excel
00:00:10
คุณมีหลายตัวเลือก
00:00:11
คลิก "จาก Excel" ในรายการ Microsoft
00:00:14
คุณสามารถนําเข้าข้อมูลดิบจาก Excel
00:00:17
เวิร์กบุ๊กและเปลี่ยนเป็นรายการ
00:00:20
เพื่อนําเข้าข้อมูลนี้สําเร็จ
00:00:22
ใช้รูปแบบเป็นฟีเจอร์ตารางใน Excel
00:00:26
เริ่มต้นด้วยการเปิด
00:00:28
ไฟล์ Excel ที่เป็นปัญหา
00:00:30
เลือกข้อมูลในแผ่นงานของคุณ
00:00:31
จากนั้นใช้ปุ่มรูปแบบเป็นตาราง
00:00:36
ขณะนี้คุณสามารถปิด Excel ได้แล้ว
00:00:38
และกลับไปที่ รายการ หลัง
00:00:41
คลิก "จาก Excel" ในรายการ
00:00:43
ค้นหาไฟล์ของคุณภายใต้
00:00:45
อุปกรณ์ของคุณหรือ OneDrive
00:00:47
ขณะนี้คุณกําลังอัปโหลด
00:00:49
แฟ้มที่จัดรูปแบบไว้ล่วงหน้าในรายการ
00:00:51
ถ้าเวิร์กบุ๊ก Excel ของคุณ
00:00:53
มีหลายตาราง
00:00:54
เลือกคนที่คุณสนใจ
00:00:57
จากนั้นตรวจสอบอีกครั้ง
00:00:58
ชนิดข้อมูลสําหรับแต่ละคอลัมน์
00:01:03
หากจําเป็นให้ทําการแก้ไขที่จําเป็น
00:01:11
ตอนนี้คุณต้องตั้งชื่อรายการของคุณ
00:01:13
เนื่องจากเป็นฟิลด์บังคับ
00:01:16
คุณยังสามารถเพิ่มคําอธิบายที่รู้
00:01:19
ว่าเวลานี้ฟิลด์นี้ไม่จําเป็นต้องระบุ
00:01:22
จากนั้นคุณจะเลือกสีและ
00:01:24
ไอคอนเพื่อปรับรายการของคุณให้เป็นแบบส่วนตัวและ
00:01:26
จากนั้นระบุตําแหน่งที่จะจัดเก็บ
00:01:29
"รายการของฉัน" เป็นตําแหน่งที่ตั้งเริ่มต้น
00:01:31
แต่ถ้าคุณต้องการคุณอาจเชื่อมโยงมัน
00:01:34
ไปยังไซต์ SharePoint ที่มีอยู่

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:04
kliknite na "Nova lista" da biste kreirali
00:00:07
iz Excel radne sveske.
00:00:10
Imate nekoliko opcija.
00:00:11
Kliknite na dugme "iz programa Excel" u programu Microsoft Liste.
00:00:14
Možete da uvezete neobrađene podatke iz programa Excel
00:00:17
radnu svesku i pretvori je u listu
00:00:20
da biste uspešno uvezli ove podatke,
00:00:22
koristite format kao funkciju tabele u programu Excel.
00:00:26
Prvi početak otvaranjem
00:00:28
Dati Excel fajl.
00:00:30
Izaberite podatke lista,
00:00:31
zatim koristite oblikovanje kao dugme tabele.
00:00:36
Sada možete da zatvorite Excel
00:00:38
datoteku i vratite se na liste . Posle
00:00:41
kliknite na dugme "iz programa Excel" na listi.
00:00:43
Pronađite datoteku ispod
00:00:45
uređaj ili OneDrive.
00:00:47
Sada otpremate
00:00:49
unapred oblikovanu datoteku u listama.
00:00:51
Ako excel radna sveska
00:00:53
sadrži nekoliko tabela,
00:00:54
izaberite one koje vas zanimaju.
00:00:57
Zatim dvaput proverite
00:00:58
tip podataka za svaku kolonu.
00:01:03
Ako je potrebno, izvršite neophodne ispravke.
00:01:11
Sada moraš da imenuješ svoju listu
00:01:13
pošto je ovo obavezno polje.
00:01:16
Takođe možete dodati opis znajući
00:01:19
da je ovog puta ovo polje opcionalno.
00:01:22
Tada ćete odabrati boju i
00:01:24
ikonu za personalizaciju liste i
00:01:26
zatim navedite gde će biti uskladišten.
00:01:29
"Moje liste" su podrazumevana lokacija,
00:01:31
ali ako želite možete ga povezati
00:01:34
na postojeću SharePoint lokaciju.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:02
Począwszy od strony głównej listy Microsoft,
00:00:04
kliknij „Nowa lista”, aby utworzyć
00:00:07
lista ze skoroszytu programu Excel.
00:00:10
Masz kilka opcji.
00:00:11
Kliknij „z Excela” na listach Microsoft.
00:00:14
Możesz importować surowe dane z programu Excel
00:00:17
skoroszyt i zamień go w listę
00:00:20
aby pomyślnie zaimportować te dane,
00:00:22
użyj formatu jako funkcji tabeli w programie Excel.
00:00:26
Najpierw zacznij od otwarcia
00:00:28
Plik Excel, o którym mowa.
00:00:30
Wybierz dane arkusza,
00:00:31
następnie użyj przycisku Format jako tabela.
00:00:36
Możesz teraz zamknąć program Excel
00:00:38
plik i wróć do listy. Po
00:00:41
klikając „z Excela” na liście.
00:00:43
Znajdź swój plik pod
00:00:45
urządzenia lub usługi OneDrive.
00:00:47
Przesyłasz teraz
00:00:49
wstępnie sformatowany plik w Listach.
00:00:51
Jeśli skoroszyt programu Excel
00:00:53
zawiera kilka tabel,
00:00:54
Wybierz te, które Cię interesują.
00:00:57
Następnie sprawdź dwukrotnie
00:00:58
typ danych dla każdej kolumny.
00:01:03
W razie potrzeby wprowadź niezbędne poprawki.
00:01:11
Teraz musisz nazwać swoją listę
00:01:13
ponieważ jest to pole obowiązkowe.
00:01:16
Możesz także dodać opis wiedząc
00:01:19
że tym razem pole to jest opcjonalne.
00:01:22
Następnie wybierzesz kolor i
00:01:24
ikona, aby spersonalizować listę i
00:01:26
następnie określ, gdzie będzie przechowywany.
00:01:29
„Moje listy” to domyślna lokalizacja,
00:01:31
ale jeśli wolisz, możesz go połączyć
00:01:34
do istniejącej witryny programu SharePoint.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:02
A Microsoft List kezdőlapjáról kezdve,
00:00:04
kattintson az „Új lista” gombra a létrehozásához
00:00:07
lista egy Excel munkafüzetből.
00:00:10
Számos lehetősége van.
00:00:11
Kattintson az „Excelből” gombra a Microsoft listákban.
00:00:14
Nyers adatokat importálhat egy Excelből
00:00:17
munkafüzet, és alakítsa listává
00:00:20
az adatok sikeres importálásához,
00:00:22
használja a formátumot táblázatként az Excel programban.
00:00:26
Először kezdje megnyitva a
00:00:28
A kérdéses Excel fájl.
00:00:30
Válassza ki a lap adatait,
00:00:31
majd használja a formátumot táblázatként gombot.
00:00:36
Most bezárhatja az Excelt
00:00:38
fájl, és menjen vissza a Listákhoz. utána
00:00:41
kattintson az „Excelből” gombra a listában.
00:00:43
Keresse meg fájlját az alatt
00:00:45
készülékét vagy OneDrive-ot.
00:00:47
Most feltölti a
00:00:49
előre formázott fájl a Listákban.
00:00:51
Ha az Excel-munkafüzet
00:00:53
több táblázatot tartalmaz,
00:00:54
válassza ki azokat, amelyek érdekelnek.
00:00:57
Ezután ellenőrizze még egyszer a
00:00:58
adattípus az egyes oszlopokhoz.
00:01:03
Szükség esetén végezze el a szükséges javításokat.
00:01:11
Most meg kell neveznie a listáját
00:01:13
mivel ez kötelező mező.
00:01:16
Leírást is adhat hozzá tudással
00:01:19
hogy ezúttal ez a mező nem kötelező.
00:01:22
Ezután kiválaszt egy színt és
00:01:24
ikon a lista személyre szabásához és
00:01:26
majd adja meg, hol tárolják.
00:01:29
Az „Saját listák” az alapértelmezett hely,
00:01:31
de ha úgy tetszik, összekapcsolhatja
00:01:34
egy meglévő SharePoint-webhelyre.

No elements match your search in this video....
Do another search or back to content !

 

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

RELATED COURSES This tutorial is part of the following courses

3364 Views

Microsoft Lists Video Training - Create Smart Lists

Learn about Microsoft Lists, the latest app in the Microsoft 365 solution, which allows you to create smart lists to track and collect infor...

ALL COURSES

An Error Has Occurred

Impossible de sauvegarder votre progression. Veuillez recharger la page, vous connecter, et essayer de nouveau. Si le problème persiste, merci de contacter un administrateur.

Close

Reminder

Show

/

Join Live Training Session