The basic steps for copying data into Excel

Copying and pasting into Excel works the same way as copying and pasting anywhere else on your computer — select what you want, copy it, click where you want it to go, and paste. The difference is that Excel treats the data differently depending on where it came from and what format it's in.

To copy data from another program: highlight the text or numbers you want, press Ctrl+C (or Cmd+C on Mac), click the cell in Excel where you want the data to start, and press Ctrl+V (or Cmd+V). Excel will paste the data into that cell and the ones next to it or below it, depending on the shape of what you copied.

If you're copying from another Excel file, the process is identical. Select the cells you need, copy them, switch to your destination file, click the cell where you want the data to begin, and paste.

Key Takeaways

  • Data from websites, emails, and other programs pastes into Excel automatically, but it may not land in the columns you expect if the original source used spaces or tabs to separate information.
  • Excel's Paste Special menu (Ctrl+Shift+V) lets you paste only the numbers or text without the formatting, colors, or formulas from the original source.
  • If pasted data lands in the wrong columns, use the Text to Columns feature under the Data menu to split it into separate cells based on spaces, commas, or other separators.
  • Copying from a website table usually works smoothly, but copying from a PDF or image requires you to type or use a different method because Excel cannot read those formats directly.

When data pastes into the wrong columns

Sometimes when you paste data into Excel, everything lands in a single column even though it should be spread across multiple columns. This happens because the original source used spaces, tabs, or commas to separate the information, but Excel doesn't automatically recognize those separators.

To fix this, select the column that contains all the data, go to the Data menu at the top, and click Text to Columns. A dialog box will open asking what character separates your data — choose Space, Tab, Comma, or Other depending on what you see in your data. Click Next, and Excel will show you a preview of how it will split the data. Click Finish, and the data will move into separate columns.

If you're not sure what separator was used, click the Data menu, choose Text to Columns, and check the preview window. You'll see when ready whether Space, Tab, or Comma is the right choice.

Pasting without formatting, colors, or formulas

When you paste data from another Excel file or from a website, Excel copies the formatting along with the numbers — colors, bold text, borders, and anything else that was in the original. If you want only the raw data without any of that styling, use Paste Special instead of regular paste.

After you copy your data, click the cell where you want it to go, then press Ctrl+Shift+V (or Cmd+Shift+V on Mac). A dialog box will open with several options. Click the Values radio button to paste only the numbers or text, leaving behind all the colors and formatting. If you want the text and numbers but also want to keep some formatting like bold or italics, click Formulas instead.

Paste Special is also useful when you copy a formula from one cell and want to paste only the result — the number it calculated — rather than the formula itself. Select Values, and Excel will paste just the answer.

Copying data from websites and tables

Copying a table from a website into Excel usually works smoothly. Highlight the table on the website, copy it, click a cell in Excel, and paste. Excel will automatically put each column of the table into a separate column in your spreadsheet.

If the website table has a header row (column names at the top), Excel will paste that too, which is helpful because you'll know what each column contains. If the table has merged cells or unusual formatting, the paste may not be perfect — you might need to clean it up by hand or use Text to Columns to separate data that landed in the wrong place.

Be aware that if you copy from a website and paste into Excel, you're getting a snapshot of that data at that moment. If the website updates, your Excel file won't update automatically — you would need to copy and paste again.

Copying from PDFs and images

Excel cannot read text directly from a PDF file or an image file like a JPG or PNG. If you try to copy from a PDF, you may get garbled text or nothing at all. If you need data from a PDF, you have a few options.

If the PDF is a table, you can try copying it anyway — sometimes it works, especially if the PDF was created from a spreadsheet. Paste it into Excel and see what happens. If it doesn't work or looks wrong, you'll need to type the data by hand or use a different method.

For images that contain tables or data, you cannot copy directly. You would need to either type the information into Excel yourself or use a separate tool designed to read text from images (sometimes called OCR, or optical character recognition). Some versions of Excel have a built-in feature to insert data from a picture, but it's not available in all versions.

Pasting large amounts of data

If you're copying thousands of rows of data, Excel can handle it, but the paste may take a few seconds. Don't click anything while Excel is pasting — wait until the paste is complete and the screen stops moving.

If you're copying data from a database or a large export file, the data might be in a format like CSV (comma-separated values) or TSV (tab-separated values). Instead of copying and pasting, you can open these files directly in Excel. Go to File, click Open, and find the file on your computer. Excel will open it and ask you which separator character to use — usually Comma or Tab. Choose the right one and click OK, and the data will load into your spreadsheet automatically.

Opening a CSV or TSV file this way is often faster and more reliable than copying and pasting, especially if the file is very large.

Fixing common paste problems

If pasted data looks like a jumbled mess, the most common cause is that the original source used a separator (like a comma or tab) that Excel didn't recognize. Use Text to Columns to fix it, as described above.

If numbers paste as text instead of numbers, they'll be left-aligned in their cells instead of right-aligned, and you won't be able to do math with them. To fix this, select the cells, go to the Data menu, click Text to Columns, and click Finish without changing anything. This tells Excel to convert the text to numbers. Alternatively, select the cells, go to the Home menu, click the small arrow next to Paste, and choose Paste Special, then Values.

If you paste and nothing appears, check that you actually copied something — press Ctrl+C again on the source data, then try pasting again. If you still see nothing, the source material may not be copyable (some websites and PDFs prevent copying for security reasons).

Frequently Asked Questions

Can I paste data from my phone into Excel?

If you're using Excel on your phone or tablet, you can copy and paste the same way as on a computer. If you want to move data from your phone to Excel on your computer, you'll need to email it to yourself, use cloud storage like OneDrive, or type it in manually. Excel on your phone and Excel on your computer can sync if you save to OneDrive.

What if the pasted data has extra spaces or line breaks?

Use Find and Replace to clean it up. Press Ctrl+H, type a space in the Find field, leave the Replace field empty, and click Replace All. This removes extra spaces. For line breaks, type ^n in the Find field (this is the code for a line break in Excel) and replace it with nothing. You may need to do this a few times to get all the unwanted spaces and breaks.

Can I paste data and have Excel automatically create a chart?

No, you need to paste the data first, then create the chart separately. Once the data is in Excel, select it, go to the Insert menu, and click Chart. Excel will show you different chart types to choose from. This gives you more control over how the chart looks than if Excel created it automatically.

Does pasting data use a lot of computer memory?

Pasting a few thousand rows uses very little memory. If you're pasting hundreds of thousands of rows, your computer may slow down, but most computers can handle it. If Excel becomes very slow, close other programs to free up memory, or break the data into smaller chunks and paste them separately.

What's the difference between copying and cutting?

Copying (Ctrl+C) leaves the original data where it is and puts a copy in the new location. Cutting (Ctrl+X) removes the data from the original location and moves it to the new one. Use cutting when you want to move data from one place to another; use copying when you want to keep the original and make a duplicate.