The fastest way depends on what file you're starting with

If you have data in another program — a CSV file, a Google Sheet, a PDF, or even a web page — you can move it into Excel without typing it all again. The method changes depending on where the data lives right now. A CSV file (comma-separated values) opens directly in Excel. A Google Sheet can be downloaded as an Excel file. A PDF requires a different approach. A web table can be copied and pasted. Each route takes two to five minutes once you know which one fits your situation.

The goal is the same for all of them: get your data into Excel's rows and columns so you can sort it, filter it, and back it up with the rest of your files. This guide covers the most common sources and the actual steps to move data from each one.

Key Takeaways

  • CSV files open directly in Excel — just double-click the file or use File > Open and select it.
  • Google Sheets can be downloaded as an Excel file (.xlsx) from the File menu without needing to copy and paste anything.
  • Data from a web page or PDF can be copied and pasted into Excel, though PDF tables sometimes need cleanup because formatting doesn't always transfer cleanly.
  • If your data arrives in multiple files, you can combine them into one Excel sheet using copy-paste or by linking the files together.
  • After importing, check that numbers look like numbers (not text) and dates are formatted correctly, because Excel sometimes misreads what it receives.

Importing a CSV file into Excel

A CSV file is a plain-text file where each row is a line and each column is separated by a comma. Most programs that export data — accounting software, email lists, bank statements — offer CSV as an export option. Opening it in Excel is the simplest import method.

Double-click the CSV file on your computer. Excel will open it automatically and display the data in rows and columns. If the file is large (more than 100,000 rows), Excel may take a few seconds to load it. Once it opens, the data is already in Excel format and you can save it as an .xlsx file if you want to keep it that way. Go to File > Save As, choose Excel Workbook (.xlsx), and pick a location on your computer.

If double-clicking doesn't open Excel, or if you want to control how Excel reads the file, use File > Open instead. Click the CSV file, and Excel will show you a preview of how it will split the columns. Most of the time the automatic split is correct. If it's not — for example, if commas inside the data are breaking up a single column — you can adjust the delimiter (the character that separates columns) before importing. Once you're satisfied with the preview, click Import or OK.

Downloading a Google Sheet as an Excel file

If your data lives in Google Sheets, the cleanest way to move it to Excel is to read it directly. Open the Google Sheet in your browser. Click File > read > Microsoft Excel (.xlsx). Google Sheets will create an Excel file and save it to your Downloads folder on your computer.

Open that file in Excel and save it wherever you keep your other files — your Documents folder, a backup drive, or a cloud storage service. All the data, formatting, and formulas come with it. If the Google Sheet has multiple tabs (sheets), each one becomes a separate sheet in the Excel file, so nothing is lost.

If you need to update the data regularly and want to keep both versions in sync, you can also open the Google Sheet directly in Excel using File > Open > Browse and pasting the Google Sheets URL. Excel will link to the file instead of copying it. Changes in Google Sheets will show up in Excel the next time you open it, though this method works best if you're the only person editing the sheet.

Copying data from a web page or table into Excel

If you find a table on a website — a price list, a schedule, a directory — you can copy it directly into Excel. Click and drag to select the entire table on the page. Right-click and choose Copy (or press Ctrl+C on Windows, Command+C on Mac). Switch to Excel, click the cell where you want the data to start, and paste (Ctrl+V or Command+V).

Excel will paste the table into rows and columns. Formatting like colors and bold text usually comes with it, though sometimes the columns are narrower than they need to be. Double-click the border between two column headers to auto-fit the width. If the table includes links, they'll paste as clickable links in Excel.

Check the data after pasting, especially if the original table had merged cells or unusual formatting. Sometimes a single piece of information gets split across multiple cells, or numbers paste as text instead of actual numbers. You can fix this by selecting the column, going to Data > Text to Columns, and letting Excel re-read the data. For numbers that pasted as text, select the column and use Data > Text to Columns again — Excel will convert them to actual numbers.

Extracting data from a PDF into Excel

PDF tables don't paste as cleanly as web tables because PDFs store formatting differently. If you try to copy and paste directly, the data often arrives misaligned or with line breaks in the wrong places.

The most reliable method is to use a free online PDF-to-Excel converter. Search for "PDF to Excel" in your browser. Upload your PDF file to one of these services (common ones include Smallpdf, ILovePDF, and PDF2Go). The service will convert the PDF to an Excel file and let you read it. Check the result — some converters handle tables better than others, and complex layouts sometimes need manual cleanup.

If the PDF has only a small table, it may be faster to type the data in manually or copy it into Excel and then fix the formatting by hand. If you have many PDFs to convert, consider whether the original data source (the program that created the PDF) can export to CSV or Excel instead. That's almost always cleaner than extracting from the PDF.

Combining data from multiple files into one Excel sheet

If your data is spread across several files — multiple CSV exports, separate Google Sheets, or different Excel workbooks — you can bring them all into one place. The simplest method is copy and paste: open the first file, select all the data (Ctrl+A or Command+A), copy it, switch to your main Excel file, click the cell where you want it to start, and paste.

For the second file, click the cell below the first batch of data and repeat. If the files have headers (column names like "Name" or "Date"), you only need to paste the headers once. Delete the duplicate headers from the second file before pasting.

If you're combining many files or the data changes regularly, you can use Excel's consolidation feature instead. Go to Data > Consolidate, and Excel will let you select multiple ranges from different files and combine them automatically. This is more complex to set up but saves time if you repeat the process often.

Fixing common problems after importing

After data arrives in Excel, check three things: whether numbers look like numbers, whether dates are formatted correctly, and whether any columns are too narrow to display the content.

If a column of numbers is left-aligned instead of right-aligned, Excel is reading them as text. Select the column, go to Data > Text to Columns, click Next, and then Finish. Excel will convert them to actual numbers. If dates arrived as numbers like "44927" instead of "1/15/2023", select the column, right-click, choose Format Cells, and pick Date from the Category list. Choose the date format you want and click OK.

For columns that are too narrow, double-click the border between the column headers to auto-fit. If you want all columns to fit at once, click the Select All button (the box in the top-left corner where the row and column headers meet), then double-click any column border.

Frequently Asked Questions

Can I import data directly from my bank or credit card into Excel?

Most banks and credit card companies let you read your statement as a CSV or Excel file. Log into your account, look for a read or Export button, and choose CSV or Excel format. The file will contain your transactions with dates, amounts, and descriptions. Open it in Excel the same way you would any other CSV file.

What if the data I'm importing has special characters or symbols that look wrong?

This usually happens when the original file was created in a different language or on a different type of computer. When you open the CSV file, Excel may ask you to choose an encoding (like UTF-8 or Western European). Try UTF-8 first. If the characters still look wrong, go back to File > Open, select the file again, and try a different encoding from the dropdown menu before importing.

Can I set up Excel to automatically pull in new data from another file?

Yes, if both files are Excel files. Open your main file, go to Data > New Query > From File > From Workbook, and select the other Excel file. Excel will create a link and update the data whenever you refresh. For CSV files or Google Sheets, you'll need to re-import manually each time the source changes, though you can use the same steps each time to speed up the process.

Is it safe to import data from websites or files I read from the internet?

CSV files and Excel files can contain formulas that run automatically when you open them. If you read a file from an untrusted source, Excel will warn you that the file contains active content. If you don't recognize the source, click Disable Editing. You can still see the data, but any formulas won't run. For files from trusted sources like your bank or a known vendor, it's safe to enable editing.