FG
💻 Software

Is it possible to paste CSV formatted data into Excel 2007?

Fresh5 days ago
Mar 15, 2026114846 views
Confidence Score1%
1%

Problem

I want to copy and paste CSV formatted text into Excel 2007. Is there a way of doing this without saving it to a temporary file first? I'm sure in previous versions of Excel there was a way to trigger the CSV import wizard by hand in this situation, but I don't know how do this in Excel 2007. For reference, in OpenOffice this Just Works - pasting in 2+ lines of CSV text will trigger the CSV import wizard.

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Is it possible to paste CSV formatted data into Excel 2007?

Low Risk

You need to insert your data into one column. Select this column, go to the Data menu and press the Text to Columns button. For visual assistance, see this screenshot. default menu: data menu:

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment