How to Create a Database from an Excel Spreadsheet

Method 1 of 2:

Using Microsoft Access

  1. How to Create a Database from an Excel Spreadsheet Picture 1
    Open Microsoft Access. It's the red app with an A. Doing so opens the Access template page.
    1. Access is designed for use with Excel and comes bundled with Excel in Microsoft Office Professional and is only available for Windows.
  2. How to Create a Database from an Excel Spreadsheet Picture 2
    Click Blank database. This option is in the upper-left side of the window.
    1. If you want to use a different template for your Access database, select the template that you want instead.
  3. How to Create a Database from an Excel Spreadsheet Picture 3
    Click Create when prompted. This option is in the bottom-right corner of the pop-up window. Your Access database will open.
  4. How to Create a Database from an Excel Spreadsheet Picture 4
    Click the External Data tab. It's in the menu bar at the top of the Access window.
  5. How to Create a Database from an Excel Spreadsheet Picture 5
    Click Saved Imports. You'll find this in the far-left side of the External Data toolbar. A drop-down menu will appear.
  6. How to Create a Database from an Excel Spreadsheet Picture 6
    Select File. It's in the drop-down menu. Selecting this option prompts a pop-out menu.
  7. How to Create a Database from an Excel Spreadsheet Picture 7
    Click Excel. This option is in the pop-out menu. Clicking it prompts the import window to open.
  8. How to Create a Database from an Excel Spreadsheet Picture 8
    Click Browse. It's in the upper-right part of the window.
  9. How to Create a Database from an Excel Spreadsheet Picture 9
    Select an Excel spreadsheet. Go to the folder in which your Excel spreadsheet is located, then click the Excel spreadsheet which you want to open.
  10. How to Create a Database from an Excel Spreadsheet Picture 10
    Click Open. It's in the bottom-right corner of the window.
  11. How to Create a Database from an Excel Spreadsheet Picture 11
    Specify how to transfer to the data. Click the radio button to the left of one of the following:
    1. Import the source data into a new table in the current database - Choose this option if you created a new database with no tables or if you want to add a new table to an existing database. By creating a new table you can edit the information in Access.
    2. Append a copy of the records to the table - Choose this option if you are using an existing database and want to add the data to one of the tables in the database. By appending an existing table, you can edit the information in Access.
    3. Link to the data source by creating a linked table - Choose this option to create a hyperlink in the database, which will open the Excel database in Excel. With this method, you cannot edit the information in Access.
  12. How to Create a Database from an Excel Spreadsheet Picture 12
    Click OK. You'll find this at the bottom of the window.
  13. How to Create a Database from an Excel Spreadsheet Picture 13
    Select a sheet. At the top of the window, click the name of the sheet that you want to import from your selected Excel document.
    1. By default, Excel creates workbooks with three spreadsheets labeled "Sheet 1," "Sheet 2," and "Sheet 3." You can only transfer one sheet at a time; if you have information on all three sheets, you must complete the transfer with one sheet and then go back to the "External Data" tab and repeat all the steps for each remaining sheet.
    2. You can delete, add, and edit the names of these sheets in Excel, and whatever changes you make will appear in the Access database.
  14. How to Create a Database from an Excel Spreadsheet Picture 14
    Click Next. It's in the bottom-right corner of the window.
  15. How to Create a Database from an Excel Spreadsheet Picture 15
    Enable column headings. Check the "First Row Contains Column Headings" box if your Excel sheet has its own column headings in the top row (e.g., the A row).
    1. Uncheck the box if you want Access to create the column headings.
  16. How to Create a Database from an Excel Spreadsheet Picture 16
    Click Next.
  17. How to Create a Database from an Excel Spreadsheet Picture 17
    Edit your spreadsheet's columns and fields if needed. If you want to import all the fields from the spreadsheet without change, skip this step:
    1. To edit a field, click the column header you want to change, then edit the name of the field, the data type, and/or whether or not it is indexed.
    2. If you don't want to import a field, check the "Do Not Import Field (Skip)" box.
  18. How to Create a Database from an Excel Spreadsheet Picture 18
    Click Next.
  19. How to Create a Database from an Excel Spreadsheet Picture 19
    Set the primary key for the database. For best results, leave the default setting here as-is to let Access set the key.
    1. You can also set your own key by checking "Choose my own primary key" and entering it in the field next to that option, or you can select "No primary key" (not recommended).
  20. How to Create a Database from an Excel Spreadsheet Picture 20
    Click Next.
  21. How to Create a Database from an Excel Spreadsheet Picture 21
    Add a name. Type a name for the sheet into the "Import to Table" field.
    1. Skip this step to leave the database set to its default name.
  22. How to Create a Database from an Excel Spreadsheet Picture 22
    Click Finish. This option is in the lower-right side of the window.
  23. How to Create a Database from an Excel Spreadsheet Picture 23
    Click Close. It's in the bottom-right corner of the window. This will close the import window and create your database.
    1. You can first check the "Save import steps" box if you want to ensure that Access will remember your settings for this database.
Method 2 of 2:

Using Third-Party Database Software

  1. How to Create a Database from an Excel Spreadsheet Picture 24
    Open your Excel document. Double-click the Excel document which you want to convert into a database.
    1. If you haven't yet created your document, open Excel, click Blank workbook, and create your document before proceeding.
  2. How to Create a Database from an Excel Spreadsheet Picture 25
    Click File. It's in the menu bar that's either at the top of the Excel window (Windows) or at the top of the screen (Mac).
  3. How to Create a Database from an Excel Spreadsheet Picture 26
    Click Save As. You'll find this option in the File menu.
  4. How to Create a Database from an Excel Spreadsheet Picture 27
    Double-click This PC. It's in the middle of the page.
    1. Skip this step on a Mac.
  5. How to Create a Database from an Excel Spreadsheet Picture 28
    Select a file format. Click the "Save as type" (Windows) or "File Format" (Mac) drop-down box, then select one of the following:
    1. If you're using a computer-based database application, click a .CSV (comma separated values) format.
    2. If you're using a Web-based database application, click an .XML format.
      1. If your Excel document doesn't have any XML data in it, you won't be able to choose XML.
  6. How to Create a Database from an Excel Spreadsheet Picture 29
    Click Save. It's at the bottom of the window. This will save your document using your selected preferences.
  7. How to Create a Database from an Excel Spreadsheet Picture 30
    Create a new database in your database application. This process will vary depending on the application that you're using, but you'll usually open the application, click New (or File > New), and follow any on-screen instructions.
  8. How to Create a Database from an Excel Spreadsheet Picture 31
    Locate the Import… button. It's often found by clicking the File option, but your database application may vary.
  9. How to Create a Database from an Excel Spreadsheet Picture 32
    Select your Excel file. Locate and double-click the file you exported from Excel.
  10. How to Create a Database from an Excel Spreadsheet Picture 33
    Follow the database app's prompts to import the data.
  11. How to Create a Database from an Excel Spreadsheet Picture 34
    Save the database. You can usually open the "Save" menu by pressing Ctrl+S (Windows) or Command+S (Mac).
5 ★ | 1 Vote

May be interested

  • How to Create a Form in a SpreadsheetHow to Create a Form in a Spreadsheet
    this wikihow teaches you how to create a form in a microsoft excel document. a spreadsheet form allows you to enter quickly large amounts of data into a table or list of cells. if you want to create a form with which other people can...
  • How to Make a SpreadsheetHow to Make a Spreadsheet
    this wikihow teaches you how to create a data spreadsheet, which is a document that uses columns and rows to organize data. commonly used spreadsheet programs include microsoft excel, apple numbers, and google sheets. open microsoft excel....
  • How to send email from Excel spreadsheet with VBA scriptHow to send email from Excel spreadsheet with VBA script
    sending emails from microsoft excel requires only a few simple scripts. add this function to a spreadsheet and you can really make the most of all features in excel.
  • Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016
    if you have read the article about microsoft word, you must have grasped some basic knowledge about text alignment. let's refer to the article on formatting spreadsheet data in excel 2016 in this article!
  • Add a checkbox to the Excel spreadsheetAdd a checkbox to the Excel spreadsheet
    if you are compiling a spreadsheet for yourself, you simply need to leave a blank box for this purpose. to select it, just type x (or any other character). then, use the formula with the function = isblank () to make the contents of that cell affect the rest of the spreadsheet.
  • How to display 0 in front of a number in ExcelHow to display 0 in front of a number in Excel
    usually when we enter a sequence of numbers in excel that has a leading zero, it will disappear. so how to display 0 in the series in excel?
  • Guide to full Excel 2016 (Part 7): Format spreadsheet dataGuide to full Excel 2016 (Part 7): Format spreadsheet data
    if you have seen the article about microsoft word, then you also have some basic knowledge about text alignment. please refer to the article of formatting spreadsheet data in excel 2016 in this article!
  • Instructions on how to create Hyperlink in ExcelInstructions on how to create Hyperlink in Excel
    excel's hyperlink is responsible for inserting web page links in excel content. when people create spreadsheets and insert access links in excel content, we can access the website quickly.
  • Instructions for inserting an image into an Excel spreadsheetInstructions for inserting an image into an Excel spreadsheet
    insert images into excel spreadsheets to illustrate how easy it is to understand or know the unit owner or company ... steps to insert an image into an excel spreadsheet are not too difficult.
  • Test your understanding of ExcelTest your understanding of Excel
    in the article below, network administrator will send you more useful information about excel software through the following quiz. let's see how much you know about excel.